Search results

Ok will do. Thanks for your help Matt

It highlights this line in debug mode: Set rs1 = db1.OpenRecordset(SQL, dbOpenSnapshot) Tried the Dmax function and get the following error: Improper use of Null

Hi dcx693, I seem to be getting the following errer after trying this out: Too few parameters. Expected 1 Any ideas? How would i use the DMax function in this code. I take it that i use it instead of the SQL to get the max number from the quotes table. Matt

Ok, the test bit worked fine, now heres where i am trying to get it to work: [code] Set db1 = CurrentDb() SQL = _ "SELECT MAX(Serial) AS maxSerialNo " & _ " FROM

Thanks dcx693 i will give that a try. Matt

DAO Query problem, please help anyone! Why does Access through up an "item not found in this collection" error when i run this? When i remove the Max() it works. I need to get the Max Serial number out of the Quotes table. Private Sub Command0_Click() Dim db1 As DAO.Database Dim rs1 As...

Oh :( i have been down this road in great detail. Beware of the following pitfuls: You cannot run Access 97 dbs on the runtime component that comes with Access 2003. (If you wanted to ) You will need to download and install the Access 2000 runtime which is availabe as a free download from...

Is there any way to echo back an SQL query written in VBA to check/test the result set?

Thanks Rich, Well spotted, but that was a typo on my behalf, it is actually is named as "Dato" which is Danish for Date. Sorry about that everyone. Matt

The way this is set up, using the autonumber would not really be the best way. A quote can be created against the same customer on the same day, the serial number will then allow each quote to have a unique ID. The system has several searches where you can pull out records for the same...

I am having a problem with a certain part of some VBA. The code should update the serial number by one when a new record is loaded, after looking to see where abouts the numbering is, i.e. if 0 then next number would be 1, if 6 next number to be inserted would be 7 etc etc... Here's the code...

You would of thought that but i checked on the tilbud form and the control name is correct CustomerNo

Form filter help reqd This is really starting to bug me, i just can't seem to get the following filter to work. Everytime i run the code which opens the form i get a parameter query box appear with the customer number in it and the curser waiting for an input. When i enter the customer number...

Thankyou for your time and wisdom on this. This is now working for me. thanks again Matt :)

How would i write the record sets out: Would they be: cName = rs1![newcust].[Name] or cName = rs1!newcust.Name thanks Matt

Thanks. Didn't release each object had to be enclosed in brackets. Mucho gracious Matt

Can anyone see a problem with this sql syntax: SQL = "SELECT [newcust.CUST_REF], [newcust.SUB], [newcust.ADDR1], [newcust.ADDR2], " & _ " [newcust.ADDR3], [newcust.ADDR4], [newcust.PC], [newcust.country], [newcust.REP], " & _ " [newcust.ISE_CODE], [custgen.MFTR_CAT] , [newcust.CUR_CODE]...

Thanks Rich, That works just fine Matt

Ok Thanks. Matt

Is it possible to create alternate coloured section detail back colors in a continuous form. Say, one line dark grey the other light grey and so on... If it can't be done in the section background detail, is there an alternative way of doing this? cheers Matt