Search results

hi, i've got a text box in a form and i want this textbox to generate a value from a table that the form it is on is not assigned to. i've been told to use DLookup and have read the 'bible', looked at help and still don't know what i'm doing. i want it to show the most recent addition to a field...

no sorry, the code i have is: Private Sub Mini_ID_Click() Dim varX As Variant varX = DLookup("[Mini ID]", "tblcar", "[Mini ID] = 1") End Sub the code i posted on the original topic does genrate a syntax error, the code above is the actual code i've got and this doesn't generate an error...

hi, i've got a text box in a form and i want this textbox to generate a value from a table that the form it is on is not assigned to. i've been told to use DLookup and have read the 'bible', looked at help and still don't know what i'm doing. i want it to show the most recent addition to a...

can somebody please explain to me what code i will need to use or how to use Dlookup as the other form will be closed. i may be asking stupid questions...but i really have not got a clue. sorry!

is there some code that i can put behind a text box on a form that automatically makes it the same as text entered or generated in another text box on a different form? this way there will be no need for it to be entered more than once and so can guarantee data validation. if you could help...

hi...i have 3 tables. in each one is a field called ID - for the first table it is referred to as ID1, for the second ID2 and the third ID3 (unsurprisingly). however, is there a way to write either a bit of code or something that automatically makes ID2 and ID3 equal to whatever the autonumber...

Can someone please tell me how i can create a button that launches Outlook Express with the address of my company (minimarket_uk@yahoo.com) already in the bar that the recipient's address should be in? Any help wouold be hugely appreciated.

you are my saviour...praise be to you. no really, i appreciate your help...thanks loads.

right...thanks. i now know how to build an event, but there seems to be a problem with the code. i keep getting the "runtime error 13" message and a pointer pointing at the second line of code...any solutions? i'd be made up if you could sort this out for me...help...PLEASE!

i posted a topic on how to open one form whilst closing another not long ago. i received an answer saying: Put this code on the OnClick event of the Command Button... DoCmd.OpenForm "Nameofformyouwanttoopen" DoCmd.Close, acForm, "Nameofformyouwanttoclose" The problem is, I'm not sure where...

thank you, thank you, thank you.

can anybody help me? i need to create a button for a form that closes that form and opens another at the same time...kinda like a 'submit' button that takes you to the next page where you can fill in more tables. there'e no wizard for opening and closing forms at the same time but i've looked...

i've created a form with an OLE object in it, namely a link to Microsoft Office, containing lenghty prose that i did not feel was suitable for a text box. however, when using the form, i know of no way that inserts a scroll bar to let me read all of the text entered. short of making the box as...

can somebody tell me how i can set up a form, the data from which is entered into a table, but then deleted from the form. an example of what i want is a system that asks for details and then when 'submit' is clicked, these details are added to the table and cleared from the form. this way...