Search results

Hi I am trying to display the users name (domain name) on a form. All I can get to work is the currentuser() but this displays the access name Admin for all users. I need to record who is adding records to the database which is shared access over the network. I have also tried...

Thank-you it works.

Hi thank-you for your reply. I find this works until I get to a text box which is dependant upon the value in another text box, therefore it is locked. Is it possible to skip just this text box. I have tried using If statements but get myself in a muddle with the For and Next statements lining up.

Thank-you, I think I was being a little stupid, and had just been looking at it far too long.

Hi I have used the code quoted above and it works perfected until it gets to a text box which is dependant on one of the other controls. Is there a way I can skip this text box only. The text box is called tbLotQty. I have tried using If statements but the can't get the For Each and Next...

I currently have a button on a form which exports an access query to excel and saves it to the current users directory. The code is shown below. DoCmd.OutputTo acOutputQuery, "NonObsoleteBOM4XL", acFormatXLS, Environ("USERPROFILE") + "\My Documents\CurrentBOM.xls" I would like the filename...

I have a form which is built on a query looking up a record by the primary key. It then displays the record in the form. There is a save and close button which send an email to our administrator leting them know the changes have been made. I would like the email to include the item that has been...

I have a form with a mixtue of controls on, Combo Boxes looking up different tables, text boxes controlled by what is selected in the combo box and plain text boxes. All controls are unbound. I used a button to run code which inserts the values entered/selected into a table. I would like the...

Thanks the code below works perfectly. If Len(Text2 & vbNullString) > 0 Then DoCmd.RunSQL "Insert into suppliers(supplier_id,supplier_name) Values (Text1.Value,Text2.Value);" End If If Len(Text1 & vbNullString) > 0 Then DoCmd.RunSQL "Insert into suppliers(supplier_id,supplier_name) Values...

I will try and explain this a best possible hopefully it will make sense. I have a form with 4 text boxes, text1, text2 text3 and text4 I have a button which adds the values in these text boxes to a table. It adds text1 and text2 as a row , then text1 and text3 and finially then text1 and text4...