Search results

Hello, My problem is that somehow the PK of my [Orders] table got turned off allowing records with duplicate IDs. To get rid of the duplicates, I did the following: 1. create a new, test database. 2. copy the [Orders] table to it. 3. create a new field, [Delete] in the [Orders] table 4. write...

Hi, I have a form/subform for Orders & Order Details. The Order Details has a auto numbering / primary key called [IDItem]. In the underlying query of the report, I specify that [Idtem] sorted in ascending (Chronological) sequence but on the report they come up in reverse sequence i.e. last...

Hi, I would like to be able to open a customer form without starting MS Access. Is there a way to make a form an executable module? John

Hello, I would like to have a query where I could select just one customer or, by hitting enter, select all. For example, [Enter Customer ID or Hit Enter to display all customers]

Hi, I need to make a new table from an existing table. Each field in the output table must have a leading and trailing quote. I tried to surround the quotes with quotes (" " ") Acess says it's invalid. For example: NewOutput: " '' " & [CustTable]![FirstName] & " " ". This does not...

Since installing Access 2003, I get this warning when I open a database: "This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?" Can I eliminate this warning? Thank you, John

Hi, I am using Access 2003 / Windows 2000. When I try to import a file, it says I need a WIN.ini file. Can I get around this? Thank you, John

Hi, I have an Access 2002 database. I used to be able to run the "Compact" utility but a few months ago it "Table 'TempMSysAccessObjects' already exits" The result being that I couldn't complete the repair. Any ideas on how to fix the problem? Thank you, John Tamaro

Hi, I want to be able to document the objects in my database. For example, how can I get a list of queries or reports? I would like to create a table with these objects. John

After typing in alpha data, how can I convert it AFTER losing focus. Do I have to set an input mask? I need to know the code. Thank you, John

Hi, In a subform, where several records are displayed, I would like to change the background color for the current control in the current record. I tried the following: ---On Enter--- Private Sub Job_Enter() ActiveControl.BackColor = Yellow End Sub ---On Exit--- Private Sub...

Hello, Can anyone tell me what the difference is in the SQL generated in a query and putting that same code in a form? This is the SQL from the query: SELECT Employees.ID FROM Employees; This is what I put in the form: Private Sub Text1_Click() Dim SS SS = "SELECT...