Search results

My form has two fields that do not allow duplicates. When I go to save a record if either field is a duplicate the message comes up "can't go to specific record". I need a clearer message than that to tell users who are even more novice than I am that they have entered a duplicate in one or...

A form I have been using now won't let me add a new record. I have entered over 100 records with the form no problem so I'm not sure were this error is coming from. One field(named AccessionID) on the form requires a unique number. When I type in a number I know is unique it comes back and...

Posted this earlier but go no response so am trying again. I am trying to print a report that prints 4 records on a page. The paper I have is prescored for 4 cards in 1 vertical column on a page. I can create a report and get 4 records vertically on a page no problem but how do I get them...

I am trying to print custom labels that are on an 8x12" page. The labels are 3"hx5w" with 4 to a page, 1 column. I can't seem to customize a label correctly. I don't see an option to indicate how many labels on a page when I try to customize a stock label. In my page setup I do have it set...

I have a query using a date field to return records for date range. In the date field I am using the "between - and" critieria. It works fine except when I use the current date for my beginning and ending dates. The report returns errors in the date range with no other data. I am getting...

Hi - I had originally posted my question under reports but with the help I got for part of it I think I should have posted under queries. I am trying to create a query that would show me the first and last ID# and Lname of new records added during the day. It was suggested to try ">Date ( )...

Hi - I know what I want to do but don't know where to begin. I have only one table that I need to get information from. After a user enters new records for the day I want them to be able to open a form that shows the day's (or session's??) first new record ID and the last new record ID...

When I enter a new record's data on a form I would like the ID# I had entered for the last record to show up - so I know which ID# to use next. I want to see the last ID# entered everytime I use this form. Can someone tell me how to accomplish this? (Also I can't use autonumber in the ID...

I am very new to Access so would appreciate help with this. Each record I have has an unique ID number. When I enter a new record I would like the form to show the last ID used so user knows what ID to use next. As a safety I would like field to not allow any duplication of ID numbers. I...

I'll try to explain my problem again - hopefully a little clearer. I have an invoice created in the report format based on a query of two tables. The first table is client names. The second table is amounts due. I have a form for the name table that I input the client basic info. The second...

I'm a real novice with access & help would be appreciated. I created a report from a query of two tables. When I run the report if I have one client with two records (therefore two reports) it prints the address on the first with all the details correctly but on the second it only prints the...