Search results

What code are you using?

I am not sure if you can call VBA code from scheduler, but you can call MACROS. 1/ Change the name of Sub AutoUsageBilling() to Function AutoUsageBilling() 2/ Create a MACRO Call it AutoRun 3/ First line of the macro will be RunCode 4/ Set the code to be run to Function AutoUsageBilling()...

Set the RowSource of the list box to the query SQL source Does the button that 'fires' the query change the code of the query? If so then if you have the SQL string assign it to the rowsource of the listbox. Else: 'CODE ON FORM set qdfTemp = currentdb.querydef("QueryName")...

Test the underlying source for data. ie if data coming from a query test the query for records. If null then do not send else send report HTH

Presume that the code is changing the criteria in a query and then outputting the report? If so then test the query for records and if record count is 0 then loop else output. HTH

I find that creating HTML is easier by placing the fields into one textbox in a report and then outputting the report as a text file calling it in your case test.html NOTE: When creating the report, remove the label associated with the textbox then in the textbox paste the following into the...

try snapshot or send it to a pdf writer (search forums for info) HTH

Before getting too involved a few questions (as ever!). Is this db being built to track the physical lots if so are you going to be keeping the serial numbers of the lots etc? What output are you looking for and how is the database going to be controlled ie by forms or data straight into the...

Due to the different payment schedules, would suggest that as part of the routine that records the customer paying their bill, that you then move the relevant records from the main table into a paid table. This can then be exported on a weekly or monthly basis as a csv / excel file. This will...

Create a copy of the report and in the page setup of the report change the printer on the Page tab (Acc97) and select specific printer. Not pretty but simple!

Create a table / query with the list of results that you want. Use this to force the data in a query. eg. list of available categories (tblAvail) and list of things you are summing (tblInfo) Use SELECT ..... FROM tblAvail LEFT JOIN tblInfo ON {whatever you link} In the design view of the...

Post your query code and will see

nz([FieldName],Default Value) so for yours would have: nz([MyFiled],0) HTH

At work we run lots of db's automaticaly. Use .bat file to launch Access and suggest that you use the macro launch switch /X followed by macro name. In the macro get it to run the VBA code using the RunCode command. NOTE: for RunCode, it calls a function NOT a sub. Reason for using /X rather...

I think not, though someone might prove me wrong. The first attempt that I did was the combining of the 2 queries but as you said it creates an error

This code populates a table with all files ending in mdb. Amend to suit your purpose. Without changing things you will need to create a table called "Found"with a text field called FileName. You will also need to create a delete query called delFound which deletes all records in table Found...

I think that Yes/No field is stored as Boolean where Yes = -1. Try viewing the data in a query where you add 0 to the Yes/No field.

Try this: Function Compact_DB() 'SET PATH Path = "C:\MyFiles\dev\" 'COMPACT CHOSEN DATABASE, TO TEMPORARY DATABASE NAME DBEngine.CompactDatabase Path & "MyDatabase.mdb", Path & "Spare1.mdb" 'DELETE OLD DATABASE Kill Path & "MyDatabase.mdb" 'RENAME TEMPORARY DATABASE TO ORIGINAL NAME...

If this is a one off then I would have thought double clicking on the append query to run it and then type in your dates would be the easiest. If this is something that will be happening on a regular basis then I would suggest that you create a table called "My_Dates"with 2 columns being...

Check in the table to see if Allow Zero Length has been set to No. If it has then change it to Yes. If that doesn't solve it then am not sure apart from using the If Isnull(me.txt1) then me.txt1="" end if. HTH