Search results

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...

If you look at your strSQL string it says INSERT. That's why you are getting a new row. What you need to do is identify the 1st choice as the initial insert. THEN, get the ID for that row and use it in subsequent updates. I'd also include the current user in the update so that you can easily...

I was disconnected over the holiday.... I guess, since there was nothing more after MBB's post that you are now all squared away...?

This is a simple straight forward approach.... If you want to share the data across the LAN, then -create 2 new databases -import all tables from existing database into one of the new dbs. -import everything else into the other db. Put the data .mdb on the file server -Link the tables from the...

No.. Table A id, Color Table B tblA.id, tblC.id Table C id, Item A 1, Red 2, Green 3, Blue C 1, Hat 2, Shoes 3, Shirt B 1,1 1,2 1,3 If Table B is the "junction" table then you could have one row from A that...

this should get you there...