General

Trap some multiple occurrences of specific values in specific
I tried the before insert on the form but that didn't work either. Set up an experiment to determine what was going on and realized (belatedly) that the query looking for records of course needs actual saved records. So putting the test for duplicate records wouldn't alert me until I was on my third record. I h... 1 Jul 2008 22:36

NUMBER DOES NOT EXIST
I am using a combo box to search a table for a particular number (table field name is EmployeeNumber) If the number I type into the combo box doesn't exist, how do I get Acess to give me a message that says something like "That Number does not exist"? Is is a setting of the EmployeeNumber field in the table? ... 3 Jul 2008 20:44

Coding an External Query into a Query
I have a table of service engineers that I'm matching up against a table of telephone calls for generating a monthly report. I'm using an outer join so that I can report all of the engineers, even if they have zero calls (thanks Piet Linden for the advice) Table_Enginner Table_Calls Engineer_ID ... 2 Jul 2008 00:39

nothing much
hello everyone...........it's me.... 1 Jul 2008 22:36

credit card numbers
"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf(a)gmail.com> ????????? 1d3f6d19-7b37-4a79-bf47-637b4a64e786(a)d26g2000prg.googlegroups.com ???... SQL Server can! It's called a BigInt. I'm of the understanding that Integers only go up to 2.1 billion.. thus 9 characters. So.. if you t... 1 Jul 2008 22:36

adding new record
I imported about 30 records to a blank database from Excel. I continued adding more records to the available blank rows of which there were about 15. I have more records to enter, but no more blank rows. How do I create more blank records to continue entering data? The last row says NEW in the first column ... 9 Jul 2008 19:54

Access 2007 - RunTime Problem Setting ...
Hi, I have a curent version of Access Runtime SP2 running on a Win2003 server configured to terminal services. So running a standard version of Access is not possible. Two questions: 1 Access Oprions Trust Center - How do I set the "Trusted Locations" folder the application. 2. Access Oprions Advanced - H... 1 Jul 2008 21:35

2 different images at same position according to a criteria
I am having a report where I have to insert an image according to a certain criteria, (somewhat similar doubt like the 1 with the 1 image); like two divisions have two diff images, so according to the division chosen by the user the image should appear...So how do i bind the textbox for 2 images?? ... 1 Jul 2008 22:36

Exporting the Design View Structure into Excel
Is there anyway I can export the Design View/Data Structure (that shows the Field Name, Data Type and Description) onto an excel sheet? I tried copying and pasting, but that didn't work. There is the documenter, but that report has a lot of information that I don't need. Thanks, Fred ... 2 Jul 2008 11:54

Family relationships but not family tree
My database is a sixty five year history of nursing home residents - most of whom are unrelated. But there are siblings, spouses, nieces, mother-in-laws, children and grandchildren, etc. Anyone have any ideas of how to organize the data so that the names & relationships could be displayed on a form/report but w... 2 Jul 2008 08:48