Search results

Do you have to have a macro set up to use the openargs i think this has just fried my brain

Sorry but what is the "OpenArgs" i have not come across that yet

Can you use this code to copy 2 parts of information over, if so could you please tell me the changes i need to make, Or is it completely different code. The new information is another text box named Ref Thanks in advance

Excellent thanks very much for your help the first one worked a treat.

runtime error i now getrun-time error 2450 microsoft access can`t findthe form `supplierDetails` referred to in a macro expression or visual basic code

ok im am not sure if this is in the right place but it seems to be a form problem. i have a form that has a textbox(text1) which is used to enter a supplier name, the user then presses enter and another form opens up with all the supplier details.ok. the code i have to do this is on the...

stumped i have been fiddling about with this for weeks now and cant get the right info into form 2. In form1(supplier select) i have a text box(text1) that is unbound and is used to type the supplier name required. Once the name is typed into this text box and the enter key is pressed then...

Unsure I can get form1 to open by selecting it from the menu then when i type a name into form1 and press enter it opens up form2 but it doesn`t display the information into the boxes for the particular Supplier/Customer from my table. I think i understand the code(me.etc) you have written but...

Nearly There The idea in the query is what i want but there is a few changes that i need which i cant seem to figure out. When i run the query it opens a form with Enter Parameter Value in the top bar but i want it to open up a form i have designed. Then once i enter the name and press enter it...

I have a table with customers details(Address Etc) but there is too many for me to use a combo or list box so i would like to use a text box. Here lies my problem. What i need is to be able to enter into a text box on form1 the first few letters of the customer ID no and this will open a hidden...

To Answer trucktime, the Workfile number will not be stored anywhere for any length of time. I only want to use it so the picking note can be printed and once picked the workfile no will be entered into the system to bring the form onto the screen so details can be changed if needed and the...

I have searched what feels like every thread in thisforum but still cant seem to find anything that meets my requirements so here goes i have a form that will be printed called picking note.i want a number to be automatically displayed on form entry which cannot be changed and doesnt have to...

I have menus for different users but they contain some of the same forms. the code i use at the moment is select case keycode case vbkeyescape keycode = 0 docmd.close docmd.openform"main menu" end select this is in the onkeydown event of the form and works ok to open the main menu and close...

is the code similar for using letters to open a new form or is it completely different. The reason being that in some forms that display data the users may have to open another form from within that form and they want to use the first letters of the form name that they want to open.

Although i understand that it would be easier to use a command button, i asked all my users what they would like and nearly all of them wanted(because they found it easier) to use the keyboard all the time. Basically i have a form for entering customer orders(form1)when they get to the customer...

I`ve read about the where statement in help but cant make any sense of it atall.(maybe me being thick). the other problem is that im not using a button to open the second form, when i get to the text box for the customer id and type in a customer id and press enter i would first like form2to...

unsolved I have tried using the form wizard to solve my problem but i dont get the screen that asks about a subform or linked form. both forms will use data from the same table(Table1), the first form(form1)will have a customer name text box and when a customers name is entered into a text box...

I have a form which i use for data entry(Form1), i also have another form(form2) i would like to open and be autofilled with the details from a table(table1) when i enter a customer id into a text box on form1. I need the code for this and also which event procedure to enter it into.

Got it working thanks for all your help.

The key behavior is set to default