Recent content by BobMcClellan

Kevin, I tried to open it but it came up as unrecognized database format. IF you saved it in 2010 can you save it as a 2007 and resend. thanks. ..bob

sorry Kevin, Your description of your problem is all over the place. Having a hard time trying to figure out what you are trying to do. you can't say... Me.txtOld = Table Medewerkers Field Wachtwoord. you can open a recordset with a where clause that points at one row in your table and check the...

It looks like.... if it's telling you that ... cannot find the reference from "Gebruiker". and you are using... If Me.txtOld = Forms!Gebruiker!Wachtwoord Try.... Forms!Gebruiker.form.Wachtwoord hth, ..bob

did a quick google search.... looks like this will get you there. http://www.techrepublic.com/blog/msoffice/automatically-close-all-the-open-forms-and-reports-in-an-access-database/1662 hth, ..bob

John, Are you using code to make the screen changes. If so, echo will cure this. I have been working with Access since 2.0. I do not have one app that has the problem you are describing. Most of our workstations are running Access 2007. Some still have 2003. We have maybe 7-10 using 2010...

I usually use something like.... Forms![Your Form].form.Filter = "" Forms![Your Form].form.FilterOn = false hth, ..bob

Thanks, I guess I need to step back and re-evaluate what the best approach may be. I appreciate the reply. ..bob

Thanks for pointing out the obvious James but... not looking to re-invent the wheel.

Change this : GCriteria = cbosearchfield.Value & " LIKE '*" & txtsearchstring & "*'" to this: GCriteria = "[" & cbosearchfield.Value & "]" & " LIKE '*" & txtsearchstring & "*'" and your combo should have lab_num;lab_description hth, ..bob

Has anyone built any integration between Access (OR SQL) and Quickbooks or any other Accounting Software? I have an .ADP application using an SQL 2005 backend that I'd like to add ACCOUNTING support to. If anyone has any advice or can point me in the right direction it would be much...

please post the sql from the query.

Before your code... put this... Application.Echo False after your code.. put this... Application.Echo True hth, ..bob

If you are on the form... and you want to update the existing row.... simply use RowID = me.rowID IF you do a new insert... and want to get the new rowID that was created when you did the insert then, immediately after the insert do something like... RowID = getRowID() In other words, create a...

If [Subs Paid], Term, and [Scout Details] are all tables and you are not joining them, you are using a Cartisean Join. This returns all possible combination's for the included tables. I imagine you need something like From [Subs Paid] as sp inner join [Term] as t on sp.TermId = t.TermId...

Hello Alexius, .. couple things... 1st, Never use rowID = rs.RecordCount. You are just asking for trouble. If rows are deleted, The Max(rowID) will not equal the recordcount. 2nd.. with regard to the SQL You have .. strSQL = "UPDATE tblScenario SET scenarioPlatform = " & RTrim(plat) & " WHERE...