Recent content by fakiane

how do I make a standard module

I'm currently making a stock control database, within the 'Supplier' table I have the days that they can deliver, eg, Monday, Friday etc, which is in text format. Is there any way I can make another field in the table which is date/time format that corresponds to the next available delivery...

its coming up with random numbers

i tried this but it comes up with #name? =DLookUp([Price],[Stock],"[Price]='" & [cboBox] & "'products") is the code I used, 'products' is what I re-named the combo box

i'm trying to use dlookup to look up the price of a product based on a combo box selection. here's the expression I have so far but it doesn't seem to be working =DLookUp("[Price]","[Stock]","[Product Name]=" & Str([combo12]))

I am trying to use a button in my form so that when it is clicked, outlook will come up and the form will be sent to the supplier. I want this so that when the button is clicked on, the email address that is already typed on the form will be used when emailing. How do you do this? Microsoft...

I already have all that in my database, but how is that going to help me save information inputted into the forms into the tables?

I'm making a stock control database and want the information from the supplier and products forms to be saved into the corresponding tables using a button. Any idea on how to do it please??