Recent content by tlc1974

John I think I would like to use a vbscript so it is automated please can you share your version? Thank you!

Thank you and I will split the database. With the database always being upgraded what is the easiest way to update on each pc with them all having their own front end?

No it is just one database that they all access.

I have created a combo box which will open another form based on the criteria selected in the combo box. I have multiple users wanting to access this form but when the 2nd user opens the form a combo box error appears. I am assuming this is because the other user has opened the same form the...

Thank you for taking the time to look and I will implement the changes. It has been a few years since I touched a database so need to refresh my knowledge.

I have stripped it down to the 2 tables and 1 form including sample data. Thank you again.

My projects are co-ops and the query only has the staff table behind it. The combo box is looking at the co-op table SELECT [Coop].[CoopID], [Coop].[Coop] FROM Coop but the control source is coopid from the staff table which is why I am confused it is not working. Thank you for all your help.

Thank you for all your help.

I have a table with a list of projects the primary key being an autonumber. I have another form to record time using the name of the project and time. The combo box is being used with ID number in both tables so the project name is viewable on the form for ease of allocating time against it. The...

I have added a close button onto the form which gets rid of the error message but an extra blank record is being added into the table now.

I have just changed the ID to not required in the table so that message no longer appears but I now get you can't save the record at this time error. Is there a way to disable that message?

Thank you so much for replying. I used the wizard to set the combo box up storing the information in the data entry table. I have an ID autonumber as the primary key for the combo box associated with a name. The name is viewable on the form and the autonumber is being stored in the data entry...

I have created a form with a combo box that looks up information from another table. The form automatically goes to a new record when opened as I am using just for data entry. When trying to close the form I get an error as no information has been entered into the combo box field. How can I get...

I am trying to export an amount to be paid for example 5.16 the export is to a text file and the field will need to show as 000000000516 Thanks for the replies.

Hi All, I need to export a currency field to include the pence but without the decimal place, is this possible? It also needs to be 11 characters wide. I have tried a number of formats and can get the decimal point removed but I am not getting the pence displayed. :banghead: Thanks in advance.