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...

Is there a way to delete this thread?? We found the error. It was a missing record in a table. Not sure why it would have errored out this way, being that it was all left joins - so if the record was missing, it shouldn't have mattered... Oh well... Thanks for trying to help!! ~Carie

This is all being done in the design view, not the SQL view, so I wouldn't have messed up any of the parens. After playing with it, I think it's corruption in one of the tables. This query worked fine a few days ago and I haven't changed anything on it. It's suddenly giving me this error...

The wierd thing is, is that I have a duplicate query of this one that has some criteria. When I run that query, it works just fine. My first test was to remove the criteria for all fields on this duplicate query - when I did and ran it, it got the same error. Then, I tried just removing 1 set...

Here's the SQL. I've been through the query and cannot see an altered or missing field. Maybe it's in one of the source queries. But I would think that the query would tell me where it didn't find the field... SELECT [201_EFFECTIVE_Date_OpenClaims].[Final Status]...

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...

Awesome!! The field was hidden. Someone must of inadvertantly selected the column then right clicked and selected "hide column" or something. Thanks!

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...

I was just given the exact wording of the error. Any clue of how to keep this from happening? Your changes could not be saved to 'xxxxx.xls' because of a sharing violation. Excel has created a temporary file with your changes preserved, called 'C950E100'. You can save the temporary file as...

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...

I actually did this as a two step process. The table I imported to is identical to the final table that I update - and is how I thought I'd catch the errors. I did get the import errors for some fields for the initial import and was able to identify them as you noted above. What I don't get...

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...

Just found a possible culprit in the MS Knowledge Base (Article ID 302911). It could be due to User Custom Views - although I haven't had a chance to test it out yet. http://support.microsoft.com/default.aspx?scid=kb;en-us;302911

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 was thinking the same thing! :-) I want ByteMyzers job!!