Search results for query: *

Wondering if anyone can help me. I have the following tables in a Database [b]STOCK[b] [OrderNo] - (Primary Key) [StyleNo] [b]RECEIVING_DETAIL[b] [ReceivingDetailId] - (Primary Key) [ReceivingId] - (Header details Table) [OrderNo] - (Combobox lookup to stock table) [StyleNo] - (Combobox...

OOpppsss, just got smacked in the head by that tree!! I have figured it out. I broke the cardinal rule in my naming conventions. My field in the table is called StyleNo while my field in the form is called Style_No. My apologies if I have wasted anyones time For those interested, the correct...

I am creating a database to maintain stock volumes in a warehouse. In my Database I have a Table called Stock. Within this table I have two fields [OrderNo} which is a number field and is also the primary key and a second field called [StyleNo} which is a text field. In one or the forms in...

Jerry, Yes, this is what I was afraid of!! THanks for your assistance in any case

Jerry, Thanks for the tip however my problem is that the Despatch Date held in the Order Header Field relates to many entries in in the Order Details Table. What we have found is that if one order is not despatched to one of the multiple stores we cannot change its despatch date alone as it...

I have finally completed a database the has taken me 3 months to develop and refine. One of the people using the database has just brought a problem to my attention which will see me having to rewrite the whole thing. Basically the problem is this; A field "Despatch Date" appears in...

I am using Access in Office XP, one of the reports I use, prints on a dot-matrix printer. I am having a problem in that I do not have the ability to choose a custom page size and none of the available options match the paper size requirement. Is there anyway I can get access to allow me to...

To anyone that can help, my eternal gratitude!! I am wishing to print labels for freight going to clients. I have a Table which has client name and address details and a despatch table which contains the date, client no and no of items. I have created a query which combines the information into...

I have been having a similar problem and have accepted that RTF will have none of the nice formatting. Thanks for the tip on Snapshot View. Now for a curly one, my clients don't use MS Access, what programs is the file format Snapshot View compatible with?

It is possible. It can be a little time consuming to set up but the results are worthwhile. I compile shipment details for 42 stores a day and send a manifest via email to 3 recipients at each store, each day. It took abt 2 hours to set up but now what once took an hour a day is as simple as...