I want to append records to tableB only when the key field in tableA does not match the key field in tableB

Newbie question: exactly which characters may be used in names of a) tables, forms, reports,...? b) mdb file names? TQ Becky

Hi I need to print a record for an individual student. I have created a report that contains the same information as my form. I want to create a button on...

Hello. I'm hoping that someone can help me. I have 2 subforms on separate tabs. Based on a user's input on subform 1, I would like a combo box on subform...

Hey. A month ago I purchased a machine and got an Office 2003 Basic Edition. Last week I purchased Access 2003. How could I obtain the above-referenced...

If at all practical, stay away from hard coding report names and titles into labels on your form or into the field names of the underlying table. Businesses...

I am using the education template and I am trying to find out what a combo box is. I need a field on a table that can be added to. I have a student that...

I have two tables of customer information in Access which contain data that I would like to merge into 1 new table labeled (2009 master mailer). The parent...

A2K Say a combo RowSource query has 5 columns, with the last four visible in the drop down list (column width of 0" for column 1). The bound column is...

Hi all, I am trying to calculate two fields. I have six fields in query window... ID, PAY_CODE_1, PAY_CODE_1HOUR, PAY_CODE_2, PAY_CODE_2HOUR PAY_CODE_1 and...

The following expression results in an error telling me that I may have entered an operand without an operator. What ami I missing? Iif ( = “Annual�,...

I am a student. I created a report with AutoFormat Technic theme. I was not supposed to change the font color of the report title. However, it did change....

when entering an e-mail address on my form, Access 2000 changes it so that it links to a webpage. How can I replace the "http://" with "mailto:" after update?

Hi. I'm getting this "Microsoft Access can't start because there's no license for it on this machine", when trying to start Access 97. Is there some kind of...

I've just "moved up" to Office 2007 from Office XP. How can I get rid of the annoying Access startup page, "Getting Started with Microsoft Office Access", or...

Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...

I am getting the error above in a multiuser access 97 database, when users are adding or deleting records. I have the form set so that a user can only see...

I'm trying to use a button on a main form to change the sort order of a sub- subform.When I execute the following, I get runtime error 2465:...

Hi, I'm trying to create a engineering database whereby there will be hyperlinks to engineering documents. I'm trying to create a query whereby I can search...

I am trying to create a system to track consignments. I am stuck on creating a form that will generate 2 lines of data entry fields when a unique value is...