Recent content by sales@scantechintl.com

Hi, I haven't yet tried your suggestion but I was able to work out two solutions. #1. after creating the [Dup] table, I modified it so that the IDorder was a PK. That then allowed me to check the delete flag in the [Order] table in a form. #2. The other way to do it, which was much faster, was...

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...

Your right. I reset the sort fields and it works. Thank you.

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...

That's what I was afraid of. Thank you for the reply

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...

Security Warning Hi Pat, Thank you for your response. I set the macros security setting to low and that works. If I had to, how do I get the latest Jet version? John

Security Warning Holy Cow! All I wanted was a simple Name & Address DB. Your answer was mind boggling. Thank You John

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 imported the Jet Compact Utility. It gave an error message and didn't fix the problem. I finally created a new MDB and imported everything (see previous message) Thank you for trying. John

You're right. Before creating a new MDB, I compiled the DB first. There were two(minor) errors. I then imported the objects, running the Compact utility after import each object to make sure nothing was corrupt. Thank you very much for your tip. 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