Search results for query: *

Thanks John! I'm sort of new to the UNION qry. Can you help me with it? I have a style table (see 1st part of my example record 1:...), do I create a new table to host the merged records? How is the UNION qry set up? Much appreciated!!

Yes. Zed

Hi, I have a form with: record 1: Style 1 | Color1 | Color2 | Size1 | Size2 record 2: Style 2 | Color1 | Color2 | Size1 | Size2 I need to generate a table as follows: ID 0001 | Style 1 | Color1 | Size1 ID 0002 | Style 1 | Color1 | Size2 ID 0003 | Style 1 | Color2 | Size1 ID 0004 | Style 1 |...

I am inserting photos into a database by linking to the .BMP image in another directory. The database increases substantially in size. The idea is to link high resolution photos so that a catalogue can be printed. Each photo is 5"x4" 200 dpi. I have visited www.ammara.com/dbpix/access.html...

Hi Everyone, I have developed an Access 2002 database with both front and back ends; nothing too complicated just tables, append tables and many reports. We are setting up a small office with a server and workstations. Should I look into SQL or SQL Express? The total number of users would be...

Thanks for the replies: I am using edit + paste and the field is a drop down look- up values from the "Accounts" table. In the meantime, by process of elimination, I managed to find the offending field -->"Terms" - a text field. When I remove the field from the form, the contents of the...

Hi Guys, I am trying to copy and paste a record. When I paste it, one field does not work (stays blank). There are no error messages. Thanks Zed

Hi TheAceMan1: Sorry about the vagueness... figured it out : <=[field1] or is null Thanks for the response. Cheers!

Hi adwanoy, Check your primary key fields. Make sure all qry links are in order. Zed

I believe you are correct, the board is acting up. Call the manufacturer.

Have you tried other media players? If they all produce the same results and all drivers are up-to-date, then there is a problem on the laptop motherboard. I would call DELL. Good luck.

Yes, always contact owner of images and get permission IN WRITING! Cheers!

I have a form and need to validate a field that is NZ. ex. [field1]=10 [field2]=blank [field2] validation rule required: <=[field1] Does not work since field2 is blank, only if I enter "0". error msg: " Object doesn't contain the automation object 'field1' " Any help will be much...

Thanks Herman!

I have a split database with the front end using a form with 2 sub-forms. When I change an entry in the form, the database shuts down and asks for a backup name. I have around 10 backups right now. I ran a compact and repair from the tools menu. Is there any other command I can run to fix this...

Try downloading the latest patches for both Photoshop and Bridge. Also, you may want to allocate scratch disk file to a secondary drive. Zed

Thanks Guys, I just remembered that on every record there is an order form number, therefore I can use this # and append say "A" to get the invoice # xxxxxx-A Cheers! Zed

Need to somehow append a randomly generated unique invoice# to a field in all records that match qry. Thanks Zed

I have many records that will need the same invoice# stored permanently. Once the invoice is printed, I need to reduce my inventory database level by the quantities in the invoice. Any ideas? Zed

Thanks Pampers! It's working. Cheers, Zed