I pretty much a novice to this but have you tried calling the file in a different way. Is it necessary to have double \\ after each word. For instance you have: "E:\\CleaningTool\\TEST FILE.xls" have you tried just using one \ as opposed to two. Can you try...
Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thank you so much for your time and advice.
I kept tweaking the last thing you said to do and
it WORKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
You;re not going to believe what I...
This close __.
Well I did what you said by having the query be the record source for the form2. and form2 is completed. When I enter the parameter, the form opens in data entry form ready for a new record.
In your Table, in Design Mode, you should be able to go to "Default Value" and you can type in a general pattern for that field; for example: EX-4000. If you know the beginning of each field will start with EX-4000 then you can type "EX-4000" in the "Default Value"...
Actually I have a MainForm I created but I didn't use the Switchboard Wizard. My version sucks; it wasn't installed properly and now no one knows where the original software is to reinstall it. Anyway which form did you want me to activate?
I'm use to using Access 2.0 too but my main form...
I did that because it gave me a window to enter in the serial number but on my first form that's where I asked the user for the serial number. If I put it in the query that means I don't even need the first form. That's all the first form does is ask for user input. But if in the query there...
First it gave an error message "Object required". I had some type of Redcordset still in there so I commented that out. So the second Form opens up perfectly but it still opens up at the 1st Record.
Hey this sounds like it will work.
I will attempt to carry it out.
Let me make sure I got this right:
Make a query that will have same fields as Form2.
Set Record Source to that query in Form2.
then allow user to enter serial number then it should
appear in second form.
I have 2 forms:
1) is a user input Text box
2) is the display of the record user inputs by Serial Number
So I bring uo the first form so the user can type in the Serial Number s/he wants to lookup/search on. When the user clicks the button, it should open up the second form where...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.