Search results for query: *

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

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

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

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

Hello, I have designed an invoice report that needs to pick up a random and unique invoice number. say starting at 1000. This number needs to remain in the report permanently. (i.e. even after re-opening the report). Does each record belonging to the invoice need to be updated with the...

Hi, I have a form that I would like to only fill in the info at hand and leave the other fields blank. The problem is summing up all the fields returns blank unless I enter zero in the blank field. Is there a way around this? Much appreciate it.

Hello, I have designed an invoice report that needs to pick up a random and unique invoice number. This number needs to remain in the report permanently. (i.e. even after re-opening the report). Any help would be much appreciated.

Hi, I have designed an ACCESS 2002 (MS OFFICE XP PRO) database. What is the best way to share this DB with other users for data entry (3 users)? Should I look at a server or shared folder on a PC? Any assistance is much appreciated. Zed

Hello Everyone, I just installed a win2k server and noticed XP clients need approx. 2 minutes to log in while win2k clients can quickly get in usually within 10 secs. The DNS setting on the NIC is pointing to the server as well as an alternate address. Also, the drive mappings become...

I have 2 servers (Win2k & NT4). Need 20 users (Win2k & XP) to join new domain on win2k server and retain local profile from the user's PC. When I join the new domain, a new profile is created, the old one is what I need. Is there a way to use the old local profile when the user connects to...

Hi, I converted a color image to grayscale and when printing to my Color printer, the image comes out green. Is there a reset color settings to default somewhere in Photoshop. Thank You Zed

Need assistance please: I just noticed that I am unable to modify, delete, or add records in a form. The message is "Data is Read only." Thanks

Need help: I have 2 tables : ORDERS & PURCHASES and need to calculate the difference between items purchased and ordered. Both tables contain fields (STYLE and COLOR). I need to extract records from the PURCHASES table that are not in the ORDERS table ie. combination of style and color not...