Search results for query: *

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

I try to design without spaces also but my subform name ended up with spaces when generated through the wizard. Thanks for sticking with me till we got resolution. I gave you a star for your efforts & help! I wouldn't have figured it out on my own! Thanks a bunch!! :D

This is the code you supplied: [subformname]![control].Enabled = False When used exactly as typed, leaving in the brackets & only changing to my names, it worked!!! Thank you!!! I think my problem was a combination of the incorrect use of . and/or ! and using Forms!. Also I used the brackets...

That didn't work for me. I have the main form active and am trying to make a field on the subform to be not enabled. This code is in an onMouseClick area of the main form. I get the message: Microsoft Access can't find the form 'SubFormName' referred to in macro expression or Visual Basic...

Thanks! I gave up! I did find how to reference a subform in the following manor: Forms!MainFormName!SubFormName.SetFocus I never could get the control to set enabled = false on the subform. I tried: Forms!MainFormName!SubFormName.Control.Enabled = False At any rate. I gave up & went a...

jpstroud, Thank you for your response. I had inconsistancies between the name & control source on the text boxes as seen in the properties. I was using the control source name as the control name where I should have been using the name. I made them consistant and it works! Now my next problem...