Search results

Thanks Rob Thanks so much for your help. Everything seems to be working great. You've been a major stress reducer!! Maggie

I'm making progress but ... I used the undo code to validate the uniqueness of one field - works fine. I wanted to use it on another field but get "data type mismatch in criteria". I copied the code from the first field and pasted it to the next field's event procedure. The only change was...

Thanks for the help but still having a problem. I entered the code in the control of the AccessionID field on my form as a BeforeUpdate event as follows: Private Sub ID__BeforeUpdate(Cancel As Integer) If Not IsNull(DLookup("AccessionID", "Booklist", "AccessionID=" & Me!Control)) Then Cancel =...

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

DCX - thanks for your suggestion. I've tried that and for some reason on each card the fields on each card get a little more off progressively. This is going to be about the best I can do I think though. Thanks again. Mag

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

Thanks all so much for your help. Jon the example was great. (I see a couple of others downloaded it also). I am fairly new to Access and this project is a case of volunteering to put together a simple little database for a library that has grown into something way past me - but I'm trying...

Thanks for your help - a little more please. TheDate() criteria worked and listed all the records for today. Is it possible to list only the beginning ID and ending record ID for the day? I just want to show the range of IDs entered for the current date not every record ID. Is that possible...

Keith Thanks for your help. The between expression was just what I needed for part of my problem. For the other part I see that what I need is more help with a query. I have posted a revised question in that forum. Mag

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

From what I understand autonumbering isn't always the most reliable. I can't have any skipped numbers. Each item logged in must have a unique number in chronological order. So back to my original question I am trying to find out how to have the last record ID show up on the form as reference...

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