Search results

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.

Hi, Does anyone know how to remove the arrows that appear next to custom drop down menus? Thanks in advance

Thanks for that - I have just tried that and as I have my own delete button with code behind it I can get the form to delete the record and stay on the same record but the recordcount field I have doesn't update and when I move through the records I eventually come to one that has all fileds...

The form has a field which on current of the form counts the number of records and displays this instead of using the access form counter and navigation.

Requery I need to requery as the form has number of records displayed etc.

I have a form containing hundreds of records and if I delete record number 50 I don't want to return to the first record on the form. Does anyone know how I can force the form to stay not go to the first record. Thanks in advance.