Search Result

OK. I have 2 tables with identical fields. One is called 'External Dies' and the other is 'Internal Dies'. Although the fields in the tables are identical, they have different relationships to another form, 'Product Codes'. The Internal has a one to one relationship to its 'Product Code', where as the External has a one to many relationship as it can be used with many Product Codes. Because of this, I assume I need a separate table for each. I would...

I have an Access 2010 database with 2.1 million records. There are several fields in one of my tables that were created as text, but I need to change them to dates. When I attempt to change the data type, I get the error message, "There isn't enough disk space or memory."

I found Microsoft instructions to increase the MaxLocksPerFile (http://support.microso ft.com/kb/286153), but I am not very tech savvy and am having...

I have an orders admin database that is currently only accessed by two Sales Administrators. I have been asked to allow read only access to the DB for the actual sales force. Would it be better to create a new FE for them to access, or is there anyway that I can secure the existing file by user? I don't want to hard code in usernames.

I have a form the records a process that we require to be authorized by a manager.

We want to check this authorization by a password. I was thinking a good way to do this is have a hidden, unbound text box lookup the proper password for the EID of the manager that entered their EID on the form. I was thinking have a VBA event that runs on exit from the control in which the manager enters their EID. Then, a simple if function that compares...

*above I meant to say 'search form, from'
I am wondering if it is possible to open a search form from another form (onclick of any record in a text box), pre-filtering the data in the search to relate to the originally clicked record... ie.
At the moment I am implementing a code library, the two main forms are frm001_CodeSear ch which enables the user to filter what code they can see. The second is frm002_Categori es which consists of categories...

I have exported some data from Access to Excel (2010) and once exported to access the data is in a different order from when it was in the query. The data is all under the correct headers but each column is randomly ordered. The query is in the following order (by fieldnames) CompanyName, CompanyAddress, TownCity, Postcode, ContactNumber1, WebsiteAddress, VATNumber, CompanyContact and CompanyType. The export comes out in this order (by header names)...

I am exporting some data from Access to Excel, I have used this code before and it worked perfectly. I have 2 tables which I am trying to export, contacts and company details. When clicking export on the contacts form, it works perfectly whereas clicking on the company export button does not work. It is using the exact same code and so I do not see what could be making one work and the other not... does anyone have any ideas? Or suggestions as to...

It seems Access 2010 is associating an 'input mask' or field type with a combo box when a form is opened, even though there is no Format setting on the control.

I have a form which has been running OK for years in Access 2003; it adds an item selected from an inventory listing to either an existing Sales Order or Purchase Order. For historic reasons Purchase orders are alphanumeric and Sales orders are numeric (long integer). The...