Search results

One of my users is requesting that I provide information from the last record entered. The user is saying that he might be away from the program for an extended amout of time and that when he returns that a serial number of the previous entry will remind him where he is in the product entry...

Ouch! that was pretty obvious. I just changed it to an IIF, that seems to work better anyway. Thanks for your help. GGuy

I need a little help with an if statement. I am trying to show that a product is accepted or rejected if it falls within a tolerance ([tol]) range. If I take " AND >= -([Tol])" out of the statement then the if statement works. If [Tol] was .01 then accepted would be from -0.01 to 0.01. What do...

I am a newbie and I must say, I do not know enough about how combo boxes work. When this form is used a lab worker will have a weight in front of them. Therefore, they have the serial number that is typed on the weight and they will know the company that brought in the weight. The thing I did...

That's it! Thanks Drevlin

I am using Dlookup on a form to find a weight value (like 1 gram) in a table called standard. The field in standard that contains the weights is call denom_actl. Every record in standard has a unique serial number (serial_no). On the form I am using an unbound box called serial to enter the...

Having a problem on a new form created from a new table. I have only created two fields in the table then created a form. Added a command button on the form to close it. When I enter data and click the close button I get the following error; The expression On Click you entered as the event...

I am Having a problem getting specific record information to appear on a form that is bound to a query. The application creates an account number for a series of tests that a specific agency is requesting. These tests may be done all at once or over a period of weeks. I have a form that...

I have a form based on a query that adds a new record to a table called test_no. The query uses test_no to determine the last record ID and increments it by one for each new record. Then the user is required to enter an agency ID. The agency ID is joined in the query to the agency ID field on...

I already had a button that would close the form without a print but it still will not save the record. I tried creating a new form through the wizard but it would not save the record either. The funny part is that if I don't put a save command in the "on click" I don't get any error messages...

I have a form that is bound to a table. The form contain a command button to print a license from the fields entered on the form. The print works but the record does not save to the table. I have checked the form properties and add, change, delete and data entry are "yes". I have put a...

Okay, I'm rather new to Access and a little confused as to where to add the Openform statement. It would seem from the brevity of your response that I should add it to the OnOpen of the test form. Some how that doesn't seem right to me. So, if I were going from one form to another, I figure...

I have a list box in a form that allows the user to pick an ID number. The companys name, address, city ect. are shown once a choice is made. A command button is available to accept the choice and open a switch board. The switch board has several choices of tests and more than one test may need...

If you are in a form and using a command button to print a report this might help. For each field that you want to bring over from the form, add the following line in the OnOpen event of the report; [MyField]=[Forms]![formname]![fieldname] Where [MyField] is the name of the given to each...

I am still looking at the VB code option that you suggested but I did modified the tab cycle. That modification does make the tab work as I wanted it to but it points out another problem. When i click the save button, I want it to save the record, close the form and open another form. I have...

I have an entry form that has two command buttons. One is save and the other is close. Both of these button work correctly, when I hit save and come back into the form it is ready for a new record, when I hit close and come back into the form it still shows the same record # as when I started...

Hey, thanks, the requery function worked great but I still need a little help getting the agency ID to not allow an entry when the entry does not match an agency ID in the Agency table. I figure I will need to add another function, like an if statement, in the after update and if the entry is...

In a form I have a field called agency ID. When the user enters this agency ID I want the name, address, city, state and zip to appear below the agency ID in read only format. The agency ID field on the form is bound to a table called standards. The table with the agency name, address, city...

Hey, thanks, I know the first choice is better and I understand why but I think, at least for now, I will use the second choice. I've added it and it works well. Thanks again, GGuy

Closing always saves current record The auto numbering works great but when I get out of the form the new record is automatically saved. In most cases I want it to save the record but right now I just want to look at the record and make sure the next number in the sequence is appearing in the...