Search results

Hello Everyone, My database center's on a unique identifier in a table called tblSDAC. This unique identifier is located as foreign keys in 3 other tables. to ensure data integrity I need to update all these tables simultaneously when I enter a new record in my data entry form. I have...

I have a table labeled tblcatalogs. There is a num field that tracks the accession numbers of a collection of artifacts. duplicate artifacts are given a decimal place. I.E. item # 10 has two duplicate items labeled 10.01 and 10.02 For items with over 9 duplicates I am having a...

Hopefully this is an easy one. I have created labels using a report. I have formatted the labels to display all records in thist way SDI-8216-2007-28 STP 6 Level:0-0cm Chipped Stone\Debitage\Metavolcanic Qty: 1 WT: 3.5 g The Problem happens when one of these fields is not present. If STP and...

Hello everybody, I have a select query that I created to use as a subform in my database. I created a select query to select the primary key from one table (tbl CA Sites) to gather records from another table (tblSite Components) Since I have created my query I have split the database into a...

Hello Everyone, This is a weird problem and I dont exactly know where to correctly post it. I have a command button on a form that links to a word document on the server. The form is part of a front end database with forms linking to information on the back-end which is also on the server...

Simple question but one I cannot answer. How do I add a sub report to a report. Thanks

Hello all, I have created a report in Access and have exported the document to word for editing. However, I need to complete a mail merge in word to see all of my entries. I have created a macro of the mail merge but need to know how to run the macro automatically when the Word document is...

I have a one-many relationship between tblSDAC Accession and tblCA Sites tblSDAC Accession contains SDAC Accession while tblCA Sites Contains SDAC Accession [and] CA Site number I would like to create a report where SDAC accession is shown once and all CA Site numbers are represented together...

Hello All, I have a word template that has been used by my company for the last 5 years. The template would be useful now if I can figure out a way to export a user defined query in Access to this word file. However, when I use the mail merge function I can define the fields I would like...