Recent content by Nowell

Hi, you would probably need to add you own navigation buttons. If you use the command button wizard and select record navigation, then go to next record: it will add code like this: DoCmd.GoToRecord , , acNext modify this code to do store the value before it goes to the next record, like...

Hi, i have a few web jobs, that were set up by the DBA that worked here before I did and they have just stopped running and I have no idea why. The error I get is: Executed as user: dbo. SQL Web Assistant: Could not establish a local connection to SQL Server. [SQLSTATE 42000] (Error 16804)...

tell you what give me your exact code stating all form and text box names, then I will be able to help more

Hello again did you get the second form to open on the correct record using the code I gave you in the previous thread?

Hi, why wont your company support the use of access, it would solvew their problems. Just seems a bit silly to me.

Hi, Can you re-design it by putting a table inbetween the many to many relationship?

Hi Katherine, I don't think you can reuse numbers in an autonumber scenario, unless you truncate the table which would delete all the data. I would suggest not using the autonumber field for referencing in this way.

Hi, I think really you have a problem in your table design, cos now you have a many to many relationship between the two tables. You should not have a many to many relationship in a database design.

Hi, Sorry firstly it should be Dim ID as Integer what is this? EnquiryID = EnquiryID tblCallb = tblCallb What error did you get?

Hello all! Does anyone know what clustering is? Whether it is better than log shipping? And how difficult is it to set up? Thanks

Thanks chaps

Hi, Here is the SQL you require: SELECT Table1.*, Table2.* FROM Table1 INNER JOIN Table2 ON Table1.empNo = Table2.EmpNo WHERE (((Table1.AbsStart) Between Table2.DeptStart And Now())); Hope this is what you want

Hi, I think the easiest way would be to create two front ends one for sales and one for marketing. Then you can have different functionality for each front end.

Hi, Do you have a unique customer id? If so you want something like: Dim ID as int ID = txtCustID Docmd.OpenForm "form2",,CustID = ID Obviously with the correct names: txtCustID = the text box on your first form that holds the customer ID form2 = the name of your second form Nowell

Hi, The sid is a binary field how do I view the sid so I can change it to the value on the source server. Thanks for the assistance so far guys