Search results

T-Riffic ! This works nicely. Thanks!

What is a good way to let the user know that he/she hasn't filled in all the required fields on a form. The default message comes up and says something like, "you can't go to the next record" but this doesn't tell them why. Out of about 20 fields on my form, 8 of them are required. If the...

Thank you for your reply - I'll pursue this although I must admit this is a bit over my head. Is this really the way Access intended continuous forms to scroll? Scrolling everything off - after each new entry seems so awkward. None of the other M/S products behave this way. If anyone can...

I'm having a problem with scrolling on a continuous form. With my header and footer, I end up being able to fit 13 records on the screen before its necessary to scroll. When beginning data entry on the 14th record, instead of scrolling just the 1st record off the top, all 13 records scroll off...

That's the ticket. Works great !!! Much Thanks.

Setting the "Data Entry" property to Yes certainly brought up the form in a data entry mode, but now I've lost the ability to access any of the previous records - its as if the only viewable record is the one being entered - in fact on the navigation bar it says record 1 of 1 when there are 500...

Ok for a great group like you this is gonna be a piece of cake... I am calling up a data entry form from a menu and would simply like the form to open ready for data entry. The form defaults by displaying the first record - I want it to automatically go to the end of the table. Thanks in...

I'm interested in automatically filling some records in a very simple table with the following fields: date, facility, part type, quantity. There are 5 facilities and 7 part types possible. Therefore, each day I need to enter 35 records (quantities of each of the 7 part types for each of the...

I have a very simple table and would like to have a form that will fill in 35 records at a time. The table consists of the follow fields Date, Facility, Part Type, Quantity There are 5 facilities to choose from and each is capable of making the same 7 types of parts. Each day I want to...

Hi Jon, This sure did the trick but - gee how did the property get changed just by installing the db on another computer? Makes me wonder what other properties will just "change". I appreciate your input. Thanks for the very rapid response.

I have an Active X Calander that looks great on one computer with Sunday thru Saturday displayed across the top in standard format. When I run the db on another computer the days are displayed beginning with Monday on the left and ending with Sunday on the right. Is there some system setting...

I'd like to set up a form and query in such a way that the user can have options for how the query is performed. I'll provide a little bit of detail.... The db involves analyzing quality of manufactured parts. Each part is described by zones - or areas of the part. These zones are assigned...

When you look thru the code, I'd recommend the Edit/Find tool to make sure you get rid of all references to the macro. Cheers

Please see the following. I adapted the code for my db & it worked great ! http://www.mvps.org/access/modules/mdl0035.htm

Now run a second query to provide unique results.

I would set up the shipping table with a "shipfrom" field and a "shipto" field. You can set up your form with combo boxes to select your responses from a list. The combo boxes could both be based on the same table maybe called locations. Then you could run an append query to add the values in...

You may also try a trim operation on the text to be sure there are no hidden spaces.

If you want to set a value for the combo box in an event procedure, you could use something like this: Dim strComboValue As String strComboValue = "Your choice here" [forms]![yourform]![comboboxname] = strComboValue If the combo box contains numeric or date data, be sure to dimension your...

You can definately amend a query. There must be a small difference between your amended query and the new one.

I set my form up on a temporary table that contained a field for the message I wanted to display (or not display). When conditions were such that I wanted the message to be invisible, I set a string equal to a space " " and then did an update query for the table so that field was blank for that...