Search results

you were right i was missing 3 little letters at the end of my code END :confused: :D now i can go home!!

Okay when i fail to select a Location from a drop down i get a msgbox "Select Location" i then select a location and run the export to excel all works fine.... the second time the location is in so the error msgbox doesn't appear the export happens but the code doesnt run properly... here is...

No seems to be fine falls back down to noraml levels ......but i cant seem to re-create the error anymore either. the etc etc etc code is just a excel macro that runs in the active window it just formats some cells in the sheet. Will keep experimenting with diffrent arrangements

The code breaks before the excel formating begins, but only the second time it runs, im thinking access is passing a default value the frist time it runs and works fine but the second time access starts looking for an object defintion and i havent set it in the code.

Where do you want to call this from and what will it achive? Do you want a function to be performed IF there are records in table 1, feild 1 that match the variable? Are you putting the variable into a textbox on a form?

SELECT [table1].field1, FROM [table1] WHERE [table1].field1])=[variable?]));

Where are these Null values coming from? Are you using forms? If so on the afterupdate of a field use if isnull(yourfield) then me.yourfield = 0 end if this will stop any nulls. Or set the field validation rule to IS NOT NULL For your exisitng null vaules you can manually change them to 0...

You might have to create a new field as Access can't apply autonumbers to an existing field that has existing data values easily.

In design veiw on the table, click into the data type field, in the drop list AUTONUMBER is a data type. Hey presto!

From a form i have a command button that gives an excel out put of a 3 querys onto 3 tabs of an excel file. It then opens the file and formats the data slightly. This works fine. Once then if i try the same thing again it give an error. If i close the db re-open and try again it works but only...

Create an update qry that updates all the NULL values to 0 and run this. This will resolve any existing nulls to Zero. Change the default value of the field to Zero. You can then either make sure that people can't enter null vaules in your forms or set this as a validation rule for the feild...

Yep , im pulling a filtered set of data from a server table to a local table. This local table is the source for the form, so that the user is filtering less information on the form itself (some speed issues for networks in some sites). Deleting the table seems to be a neater solution as some...

I have a complex Form with subform. The subform is based on a qry which pulls data from a temptbl. I want to be able to re-create the temptbl and then requery the subform. Access wont allow me to delete the old temp table as its locked in use on the subform. Is there some way of disconnecting...

Thanks Fitted it in to avoid any errors runs away fine. Always more than one way to skin a cat :D Thanks for the help

Yep gives error object not found, will try and find the code for checking for objects in the forum. Thanks for your help ken

Would that code run if the table wasn't created? Maybe i need to test for its existance frist then if true delete it. Know how to check if an object exisits?

I have a wizard that allows users to easy import excel data into the database but on occation a bad record in the excel file will cause the database to create a Sheet1$_ImportErrors table with 1 record in it. Is there anyway to Delete these tables automatically? Many thanks Sam

No Worries i have got it working I just created a function to call the Find Record rs from a text box on the subform that stores the rawid when the pop form is open and resets to null after the function runs. Thanks for your help and comments Rich and Pat. Just gotta work out how to get the...

Sorry Rich you lost me there, im guessing you are calling find on 2 forms or something?? I have 1 Main Form = (mainform) 1 sub form = (subform) 1 Pop-up form (popform) And a bunch of fields on the SubForm, im guessing we can call RawID and another lets say raw2ID if we need 2. So from the...

Im running it from the pop-up form. Should i be storing the raw ID before requery and then runnin the code using that ID to jump to the correct record?