Recent content by SheaLee

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