Search results

Problem with a DLookUp. I am currently working in MS Access 2007 and I attached the following code to a unbound text box which is located on a tab control =DLookUp("[ProdSpecAdr]","t_Suppliers","[pk_SUP_id] =" & [Forms]![f_DE_CPN]![fk_SUP_id]) Everything was working great till I placed this...

this was a great help thx!!

Okay will do thanks again wow you are up late....go to bed sleepy head

My boss has a table with tons of fields on it, he designed it this way because it was easier to add data to one place, but now the table keeps crashing, does ms 2k have a limit to the number of fields in a table?? Thanks in advance.

I Can not thank you enough My phone has been ringing off the hook to get this fix, I was so nervous I forgot to add the statement dim stLinkCriteria as string Thanks again, Don't know what I'd do without this site....perhaps get a job at Walmart like every other american...

Hmmmm I'm still getting the and it is showing up on this line stLinkCriteria = "[NoID]=" & Me![txtNoID] please don't give up me

when I tried to delete the option explicit the data base shut down the system is asking me to declare "Dim stDocName as String =" I'm really new how do I do this??

D'oh Danger Danger boys and girls I just found out what happens when removing the option explicit. It's not pretty. Hoping someone will take a look at what I have currenlty and help me fix it to work in my new world called OPTION EXPLICIT!! I have a button on a form that generates reports...

Yes When I installed the new code I added option explicit What is the danger of removing option explicit??

Compile Error: Variable not defined yesterday I went out to the MS site to install the coding to disable the wheel function on the mouse. After padding myself on the back, cus it worked, I called it a day and went home. Today I came in to run a report and to my suprise I'm getting the compile...

Filter with Wildcard "*" This works great if you're looking for any part of the field, how would you do this if you had the first part of the field for example; Search all zipcode starting with 017*??

yes I did, I ended up creating a table i.e., tblActiveYN fld Yes/No fld -01/0 and then I made a combo box, still was not able to get the form to default to "yes" thanks for your reply

I figured it out I had the Query set to grouping, once I removed that, I was back in business

I have a main form which allows users to set a search for records in a subform (embedded in Main form) how do I allow them to make changes within the subform based on their result?

Very nice!!

D'oh!! Sorry, I think I put this in the wrong Forum!!

What is my problem, I can't get this to work, I have list box that I want set on yes and when I do this in the on open forms I get all kinds of problems?? can anyone send me in the right direction??

Thanks Keith, I'm so not good a vb, I'm going to try to accomplish this by using a Macro....I'm taking the easy-way-out Have a wonderful and safe wknd

I have a button when you click it, it runs a append query to change all true check boxes back to false my problem is after it runs the append query the user see a long error message, then to see the check boxes change .....you have to go back and click the button again.....not very pretty here...

This is awesome...