Search results

Typically you have to move to the end of a recordset in order to get an accurate number. http://www.fontstuff.com/mailbag/qaccess04.htm

Search for cascading combobox. Also check: http://www.fontstuff.com/access/acctut10.htm

Well, you can put the code in several different places. Why don't you put it on the click event of the "finish" button right before you close the form. You would need to modify it slighty, as follows: 'Define your variables dim rs as recordset, strClientID as string 'Set the variable rs to be...

Well, what you'd want to do is first save the pk of the record you want to go back to when you click "Finished". Then you'd requery the Client form, and search for that pk again, then move to that record. What I would do is open the addedit form as a popup, so code will be suspended until you...

You should probably post this in the tables forum, but here's my take: Rooms: RoomID, type, facilities, floor, price Customers: CustomerID, first name, last name, address, city, county, post code, telephone number Bookings: BookingsID, RoomID, CustomerID, date of arrival, date of departure...

Is it possible that the switchboard opens the form as a Read Only, or somethign liek that? Can you post the code for both the button that opens the form and the button that moves to a new record?

That method assumes you want the command to run every time you enter data into the text box. Or, you can set the command button's "Default" property to Yes. Doing this means that when the user press's enter, its the same as clicking on this button. Typically you'd do this for an "OK" button.

Well, as far as the case select statement goes, it sounds like [CurrMedicaid] is a yes/no field. Try changing from an integer to a string and setting it to "Yes", "No", or "Like *" Your strFilter looks ok. What is the error message?

Also, check out the "Access and SQL" tutorials parts 1-6 on this site.

Its best just to avoid spaces all together when you name things.

Remove the underscores in your query, since your form and your control don't have them. Change the criteria to [Forms]![Daily Report Form]![Daily Report Date].

The text box is the control. Is the name of the field and the name of the text box different? If not, I would change them as I suggested. If that doesn't work, post the db and i'll take a look.

It worked because you need to add quotes around the data to search for if it is text. Since FullName1 must be a text field, when you specify criteria for it you need to add quotes. So you would need to say FullName1 = "Geroge" NOT FullName1 = George With numbers, you don't need quotes. With...

Also, make sure you're using the name of the control on your form in the query, NOT the name of your field. If you go into the properties of your control, you can see the name. By default, Access names the controls the same as your fields, but it is usually good practice to change the to avoid...

That works, thank you!

You definatley no not need an update query. An update query is used to change data in a table. This should work... what data type is the field you are trying to filter by? If it is text, are you using quotes?

Let me make sure I understand what you're doing: You have a form with some unbound controls and a button. The button launches a report. You want to type values into those controls, and have the report be filtered by the values you type into the controls. If you've followed my suggestion above...

Hello all, I don't like the look of Combo boxes on forms, especially on Continuous forms made to look like a spreadsheet. I think the arrow is distracting, and since you cannot change its color frequently looks bad. My plan was to use two controls - a text box, and a combo box. I would have the...

Try referencing the controls on your form in your query. For example, if you had a control called txtMaterials on a form called frmInvoice, you would put the following in the criteria section of the Materials field on your query: Like Forms!frmInvoice!txtMaterials

If Isnull(dat1) Then StraightTimeLookup = 0 Else StraightTimeLookup = DLookup("[StraightTime]", "StraightTime", _ "[User] = '" & UName & _ "' AND [Date] = #" & dat1 & "#") End If