Search results for query: *

You can use the On_Open event to set the following code: Dim rst as Recordset Dim intHighest, NextNum as Integer Set rst = CurrentDb.OpenRecordset("SELECT * FROM qrySAAutoNumber") intHighest = rst!RecordID 'this assumes the output from the query is called RecordID NextNum = intHighest + 1...

You can either move the function to the location shown in the list or untick the entry as it exists and browse for the new location to enter into the list - this usually happens with Windows version that have \system32 Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

Yes you can import customer data - look at the table structure in Sage and be very careful with entry parameters. Total orders values need to be carefully constructed as you acnnot have negative values (Credits) and the Customer entry must already exist prior to any attempt at import. The Sage...

Use the query to build your forms. This way you can combine any number of tables and manipulate the data in many different ways. With the table you are stuck with the existing format and content. Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

You need to apply "Grouping" on the Employee ID Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

If your now make your queries you can base the construction of each form on the relevant query. Example: If you make a query that lists all the customer details then the form will have all of the details from the query and will be in the order selected by the query. Frank J Hill FHS Services...

You would need to purchase the ODBC connection files from Sage at a cost of £1500 per annum, these would give you write access to the tables within the application. The only other way to do this without shelling out a load of cash is to write the transfer data to .csv files and then use the...

Have a look at the DateDiff function - it gives lots of information in the help files and will do exactly what you want. Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

lets say: Textbox in report footer is called RepJobSum TextBox in Page Footer is called PagJobSum In the On_Format of the Report Footer enter the code: Me.PagJobSum = Me.RepJobSum Leave the Control source blank (unbound) Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

lets say: Textbox in report footer is called RepJobSum TextBox in Page Footer is called PagJobSum In the On_Format of the Report Footer enter the code: Me.PagJobSum = Me.RepJobSum Leave the Control source blank (unbound) Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

If the Grand Total you are after is the final total that will appear at the end of the report, then you can reference that value from the report footer to a page footer entry. This would be done by using Report_Format and coding the explicit fields. Frank J Hill FHS Services Ltd...

This is an old argument! If a cell is empty is could be that it is NULL meaning that nothing exists or that the calculation has not been done or did not yield a result or is a zero length string. Anyway...... If the field is a NULL you can use the Nz() function that converts it to zero...

Where you are using the validation have code that goes back to the tabctl similar to: If IsLoaded("frmClient") Then Me.lstClients = forms!frmClient!txtID Me.TabCtl51.Value = 2 ElseIf IsLoaded("frmSearcher") Then Me.lstClients = forms!frmSearcher!lstAddress...

Would it not be simpler to have a discrete instruction for each checkbox. In reality it doesn't matter if they check 1 or all 1 will download 2 will print 3 will email Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

I can't see anything that would delete a record but this seems a bit verbose just to save a record, I would be tempted to use: DoCmd.RunCommand acCmdSaveRecord MsgBox "Record has been saved!" Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

In the start up you must have an instruction to load the switchboard form in Display Form: leave this blank..... Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

Quick is nearly always pained! Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

Does it appear when you use F11?? Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

This is from an actual application icon: "C:\Program Files\OfficeXP\Office10\MSACCESS.EXE" /wrkgrp C:\BookingManager\BMngrSEC.mdw C:\BookingManager\BMngr2000.mdb Application exe (space) /wrkgrp (space) application Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk

You have described exactly what you should do where is your problem?? Frank J Hill FHS Services Ltd. frank@fhsservices.co.uk