Search results

Sorry I should of added this to the previous post.

I have a table that has an autonumber as a primary key. Is there a way for that autonumber to only be assigned after all the fields are filled in first? The problem I am having is users enter in one field (which causes the autonumber to be assigned) and than close the form without filling in...

The problem is once users enter data in the first field the record is created in the table. Therefore the number is assigned even if they close the form and enter no more data. I need to know if there is a way for the number to be assigned only after all requiered fields are entered.

There are several other required fields on the form.

A problem has arose with a database that is in use by many people. There is a form where users go to enter data about a record, they than press a button once all data is entered that takes them to another form where they get the IRR Num (this is what equipment is tagged with in shop, it is the...

On a form users enter records into I have created a close button and placed it on the form. The problem is that when a duplicate number is entered in the primary key field and the close button I have created is used, no error message of a duplicate record is given. The form just closes and the...

Thank you all for your help. The Date() solves the problem for records that are entered in the future but it does nothing for the ones that have already been entered. If nothing else at least it will work for the future...Thank you. As for the: Format([Orig Date],"mm/dd/yyyy") I am a...

You are right, I am using the Now() function. How do I change it to that smalldatetime that you suggested?? The weird thing is that I went back and checked dates in the beginning(when the db was first used) and it works for like the first month of dates. For example, I typed 11/29/01 for the...

I have a report to find the date range. This report is based off of a query. The criteria is set in the date field of the query and has: Between[Enter a starting date:] And [Enter an ending date: ]. The problem is the date range displayed is not accurate. If you type in 8/10/02 for the...

I have a field in a database that was originally specified to be a text field, EmployeeID. Now the users want them to enter only their clock num, (originally it was last name and clock num). I cannot just convert the field to number because it will lose existing data. Is there any code I...

When I try to convert a database from Access 2000 to Access 97 I get an error that says "The size of a field is too long" and it will not convert the database. What does this error mean??

Thanks, I should of known that because I have done it before.

In the past when I have a checkbox on a form and it is checked, it also shows as a check on the report. However, the last checkbox I created puts a -1 on the report if it is checked. Any suggestions as to why this happened?

I have been asked to make a change to a report in an already existing database. This report is based off of a query and only shows records that do not have a value for a Date Closed field. This all works correctly. However, some records are marked void along the way (by checking a box titled...

I have a text field that now needs to be altered to only accept numbers. I know I can use a series of 9's in an input mask so the field will only accept numbers. The problem is the number entered will not always be the same length, soem could be on digit some could be two, some three and so...

Thank you Thank you for the suggestions. I added that little bit of code and it seems to work fine but I am going to test it thoroughly today. Thanks again, Laura

The data in the field is not typos, for example one has 24" (representing inches). One has two quantities listed with the work and separating them. (This should not be happening but it already has many times). I am not quite sure what you mean by your last reply. Could you or someone else...

Hope I can explain this as clearly as possible...... When I designed a database, the users first specified what fields they wanted and whether they'd be numeric, text, etc. There were five fields made text and one memo field. I thought this odd at first because one of the fields they made...

no luck Ok...I must be doing something wrong. There is a combo box on a form already that I used the wizard to create with the values I needed. The report is based off a query that had [Enter the disposition: ] in the criteria box in the disposition field. I changed this to say...

I have a report based off of a query. When a user opens the report it asks them to type in a certain piece of data so that the report displays only the records with that data. The problem is the code has to be typed in perfectly in order for the record to appear in the report (the data is...