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

Thanks Statsman, a whole number for the first entry is not a problem. but I do question how the format will print in a form or report; will 12 print as 12.00 and will 12.10 print as 12.1?

Interesting Idea Mike but no because the sort in the text field is still off when placed in a report or form

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

That worked perfectly thank you

The code works well, even when I change the drive map name from I:\ to the server location //SERVER/Archcenter Is there another way to code opening an MS Word Document that I can try to see if the error persists. Thanks for your help

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

Thank you for the response to the lack of thinking. Enjoy the Day

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

Go into the query design and under the criteria for your date field you need a user date response type in Between [Start Date] And [End Date]. For isolating CO-HA you can enter the following into the Criteria for the table that houses that information Like "CO-HA"

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