Recent content by DahMurf

THANK YOU THANK YOU THANK YOU! Cleaning up the code worked! I was beating my head against the desk! Now I can go home! [2thumbsup]

I have this in a query and it results in almost 4,000 records from Table1 SELECT * FROM Table1 LEFT JOIN Table2 ON Table1.RunIndex = Table2.RunIndex WHERE (((Right([Table1.RunIndex],6))="070108") AND ((Table2.RunIndex) is null)); I then tried to put this SQL into the VB behind my form...

Excellent! This is exactly what I needed! I integrated it into my code & it works great! Thank you so much! [sunshine]

I have a spreadsheet (Format Reports.xls) that when it opens kicks off a macro. The macro then opens a different spreadsheet file, does formatting, closes the file, moves on to open other files to do the same type of formatting. This is an excerpt of my macro code in "ThisWorkbook" of file...

I've added to the frm_impound on On Current Event Me!combo_class.Requery It works perfectly even in continious form! Thanks a bunch! Debbie [ponytails2]

I have a form with fields and a combobox based on two tables. The fields I'm working with from tbl_impound that are displayed on form frm_impound: Vehicle Date Time Class I also have a table tbl_class_op with fields Vehicle Date Time Class On form frm_impound I have a combo box for the...

I have a database that will be running on a private "home" network. The backend will be on the C shared drive of the primary computer. (The primary computer is serving as the network drive) The primary computer as well as two secondary computers will run the frontend. The frontends will...

Thanks a bunch MoLaker! I guess we were posting at the same time!!! [thumbsup] Deb [gorgeous]

NEVERMIND!!!!!!!!! Here's two ways that work! (There's a reason why I ask for examples!!! I'm usually just missing something small!) DoCmd.TransferDatabase acLink, "Microsoft Access", _ "c:/aa_share/ecta/Test_Development_be.mdb", _ acTable, "tbl_membership", "tbl_membership"...

Thanks! That helped to a point. I'm still not getting it correct tho. I saw that I could do the link in a Macro so I tried it just to see if I could make it work and of course it did. When I go back to my code I can't get it to work. This is what I have coded: Dim bePath As String...

I want to link my frontend to my backend tables using VB. I want to do this when I open the database and then drop the link when I close the database. I am only using Access 2000 for both the frontend & backend. I've seen a lot of posts saying you should do this & I've seen several with...

Nope! Big DUH on me! hehehe That worked great! Thanks so much! I was looking too hard!

I have a Main Form which has a subform within it. They both open visible. I have a combobox named type on the main form. I have a combobox named class on the subform that through a query uses the type combobox selection to limit what is displayed in the class combobox. When the type value is...

We got to a final resolution in this thread. Two answers, one in the middle and one at the bottom of the thread. http://www.tek-tips.com/viewthread.cfm?qid=941073&page=1

We got to a final answer at the bottom of this thread: http://www.tek-tips.com/viewthread.cfm?qid=941073&page=1