I have a small Excel file that contains information I want to place on a label.
I thought I could use Word's MailMerge>Labels. I set up the fields I want to get from Excel on the label.
I also included common text that describes the data that Excel leaves behind. i.e. "Contents of this...
OK, thanks.
tblJob
JobNum (text,primary)
Description (text)
QuantityID (numeric, Foreign to QuantityID in tblQuantity)
SizeID (numeric, Foreign to SizeID in tblSize)
PagesPanelsID (numeric, Foreign to PagesPanelID in tblPagesPanel)
FoldsID (numeric, Foreign to FoldsID in tblFolds)
NumOfColorsID...
Oh, geeze, sorry, but you are dealing with a rank amateur.
I doubt that you are wrong. Bad design usually runs in all my databases. :-)
Sorry, but I am not certain what you mean by table structures, or for that matter how to post them.
I work at an Advertising Agency in the print production dept. Production get prices and prints brochures, postcards, catalogues yahda, yahda, yahda.
A job is opened describing the task. The job number is unique. The specifications for the job is used to provide a price.
Example job 00025 is...
Tried to find this in a search.
Every time I modify a table it adds the new table to the relationship view. At this point, while I only have 4 main tables and 8 look up tables, with all the modifications I made, I can no longer see the original relationships.
Is there any way to set Access so...
Reply to tedmillerx: Thanks, I tried and thought I did select link as the property. However it all seems to embed.
I thought it would ask me the path where the images lived. It never did.
What I am trying to do is produce a report showing stock photo usage/licensing for a particular client...
I am hoping someone came up with an answer to bigben's question. I am trying to do the same exact thing. There is no joy with reading the MS Access help or even going to the MS site.
Having to scroll one page per image does not work either, as my report would turn into a forty page monster...
I have made a database in Access that keeps track of photographs that we have licensed for our client. One of the fields in the tblPhoto table is OLE and that is where I place thumbnail sized jpg's (2 to 5 kb's in size)
I save the images in a folder called "Images", however, when I...
I want to e-mail specifications for a job to various vendors. They will bid the price to those specifications.
I want to keep the names of each vendor secret from the other vendor's in the list for that particular job, so I send the specifications using the bcc box for the addresses.
This...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.