Search results for query: *

I have a 20 user split database that is experiencing a problem with a line of code that previously worked well. The line appeared to be working, but since more users have been added it is triggering this error message when the form is opened: Run-time error '2448': You can't assign a value to...

Hello, I have a Access 2003 form that I've added some error handling code to the Form Before Update event that prevents the user from leaving required fields empty. The trouble is, when the user tries to exit Access while leaving a required field empty they receive two messages: The first =...

I have a database with 5 tables - there are no parent-child relationships between the tables, they all contain pieces of the same record. Each table has 10-20 fields. Is it better in terms of performance & understandability to keep them this way, or is there a better alternative? I could...

Hi there, On my form, I've got a text box "Other Services" which is a Memo field in my table. I would like the text box to display a vertical scroll bar so that the user can simply click on that to read through the displayed Memo field, rather than clicking inside the text box and using...

Is it possible to have multiple users in the same database updating the same form concurrently? What if the form uses auto-numbering? If this produces any type of error, is it possible to have a notify window pop-up if another user is already in the form?

I have a form that auto-populates 10 fields using a Dlookup in the got focus event of each field. The dlookup searches the "DNM TEST Form Query" query based on two criteria: Sales Order # and SKU. This works perfectly, but... the end user would also like 5 of the fields to autopopulate when...

Hello, I am new to Access and am having difficulty with a Dlookup function. I have a form that I wish to autopopulate 10 fields with data based on two criteria which are also fields on the form. The user would enter the two criteria in the form and the ten fields autopopulate. To achieve...