Search results for query: *

Hi! I just need a simple solution for a Calc Script but not sure how exactly to write the syntax. I need to create these exports, so I can create a simple import for yearly data that replaces a monthly process, as it is getting quite lengthy to import and calc for each month. I want to export...

I'm running a make table query that I've run just fine over the last year. All of a sudden, it's running and then giving me a "No Current Record" error. I've tested all of the queries that build this query and they all work fine giving me the expected answer. There is no coding behind this...

I'm working on a form where I have 2 different Text boxes on one line. I want the text box length of the 1st one to grow & shrink to the contents. I then want a second text box to bump up against the 1st. Right now they are static at the point in the form I place them. How do I make my 2nd...

Wasn't sure if this should be in the table or query forum... Anyway, we have a field that is a valid field and in the main table of our database. Users can view the contents of this field in the forms. But when we open the table or try to view the field in an adhoc query, it doesn't appear...

Everything worked just fine until this afternoon... No changes have been made to the frontend database where this form resides in over a month... All of a sudden, when a user clicks on a button to open a data entry form the following appears: "There was a problem retrieving printer...

We've been having an issue with a shared workbook where users will be entering data & saving the changes. Every once in awhile, the user will get an error message saying that the file is no longer shared and they are prompted to save a backup version. This is frustrating as the user has to...

I'm stuck!! I have a form that takes a long time to open becuase it is running several queries for the subforms on it. I don't need to form to load the subforms & queries supporting those subforms until the user makes a choice as to what vendor they want to see the detail for. I know there...

I've got these three folders in the Temporary Internet folder that contains these strange .gif files. I'm thinking that they are spyware of some sort, but I am unable to delete them. The file name is very long and it won't let me copy it either, so I can paste it here - so I'm going to attempt...

Is there a maximum allowed size for a record? And if there is, what is that size? I have a large table that if the user was to attempt enter data into every field, it returns the "record too large" error when you get to the last 10 fields of the record - and won't allow any data entry into...

When running an update query, is there a way to return what fields weren't updated when you receive a Type Conversion Error? I have a huge excel spreadsheet that is the source of the information that has been imported into an existing table. It'll take me forever to identify the fields that...

I can't seem to find where other people may be having this problem... We have an Excel file that we are sharing between 6 or so users. The users know that they need to save periodically in order to refresh their open view of the workbook to show the changes of other users. For some reason...

I may be dreaming... But is there a way to run one query, or one simple piece of VB code that updates each field in each record if it has an empty string for the whole table? I want to update them all to null so I know that the queries that I have created that look for null are working...

I'm running code to pull records from a table if it matches a key and a date. My code errors out if there are no records found. I can't figure out how to catch the No Match, so if it is true then it skips to the next section. It was first giving me Error 1004 (I didn't have the MoveNext or If...

I've been searching for an answer, but nothing I have found works for me... The problem I'm having is that I have an Excel Workbook Template that I use to populate data into from Access. If Excel is not running (or there are no other workbooks open) it opens fine and works correctly. However...

I'm trying to use the data valadation in Excel, where I want the lists to be different based on the value returned in cell B40. I have named the lists "PRE_TREATMENT_OPT" and "POST_TREATMENT_OPT". Below is the statement that I wrote, that is erroring out on me...

I just did a clean install of Windows 2000 on my computer (I re-did the partition and re-formatted). Prior to my install, I backed up all of my important files and software downloads onto DVD+Rs using Roxio 6.0. I have both a DVD player and recorder. When I first installed Windows 2000, I got...

I am using DateDiff to find the number of months. But I need to see how many months are in each year that a contract is valid - Here's an example of the results we're looking for: A contract starts on 6/1/03 and ends on 6/30/05. How many months in '03, how many months in '04, how many months...

Is there a way to make a field move up if the field above it is null? I'm creating a report with Addresses and it is set up the following: Name Addr1 Addr2 Addr3 City, State Zip For example if Addr2 and Addr3 is null, I need the City line to move up. If Addr3 is null, I just need the City...

This is too bizarre and I can't figure out why this is happening. I'm running the below code on a form. When this was first built and on a previous version of my database it worked just fine. I have made NO changes to the queries, tables or anything that was related to this form. Is there a...

I'm running some code to create a new record in a table based on values in another table/form. When the user clicks the button to open the form, I'm running the below code to create the new record. The new record is being created, however, the values are not populating into the two fields I've...