Search results

Hi, Thanks for your help. I did look there but I found only one or two very short articles that were very limited anf therefore not very helpful. Thanks. Mike

Try adding the combobox value to the query supporting the form as a criterion for the field it represents. You do this by right-clicking the criterion part of the QBE grid and selecting build and following the instructions. Then on the form do a requery on the after update event of the combobox.

Hi, Does anyone know how I can get a document that will summarize all I would need to know to use transactions effectively with forms? Thanks, Mike

You could set up, using the form wizard, a column form. Thus you will be able to see a number of records at the same time on the form. Then add a button and use it to call up another form containing the parent of the selected child. The command button wizard will help you through it. When...

It looks like you have a database design issue. You must be trying to add a child without having already added the potential parent. Orpans are not allowed in Access.

You usually go the other way. Selecting a parent record automatically brings up it's child records. I don't even think it is possible to go the other way unless the subform is not filtered. Is this what you want to do?

It sounds like the form is corrupt.

First, refresh the form before closing it. Perhaps a Me.Refresh in the form's close event. Second, create a W2 (or employer table) table with a dual key; the userid and the W2 (or employer) ID. This way the user can have more than one W2 ( or employer).

Rich, Thanks for your reply. The "select entire field" option has been checked in the keyboard section of the options dialogue box. If I tab around the form, the entire field is highlighted; this may be the result of this setting. But when I set the focus using the code, the entire field is...

Hi, I have a form containing a text box. People enter data to it and then tab out of it. I check it and if there is no problem the program does other things. If there is a problem, I alert the user with a message box and return focus to the original text box. I want the entire contents of...

Hi Pat, Do you have any ideas about how to isolate the bad record? I have a back-end database that may be corrupt but I'm not sure. I tried using DTS in SQL Server thinking that SQL Server would refuse to import a bad record. I finally figured out that the records that DTS had errors with...

I'm not sure what you are driving at but one of the great advantages of relational database engines like Access is that you do not need to store the same data twice. The other is that it looks like your customers table is the parent table of the one that records what your customers have. In...

Where clause = WHERE Date is Between Now() and Now() - 60

Thanks for all of your suggestions. From now on I will use one text box that can grow and shrink as needed. I can assemble the formula for it as I assemble a SQL statement that is based on the contents of specified fields.

Limit the combo box selections to specialists who have cases or do a DLookup first to the appropriate table to see if the specialist has any cases. If yes, run report. If not, alert the user and exit the sub. The first is more user friendly. Second, instead of the radio buttons in a frame...

One more comment: The behavior I referred to in my previous reply caused one more gotcha. I had put a line on the report to show the user where to fold the document so that the complete address shows through the envelope's window. Guess what! When the text box in the address area grows, this...

Use the following code on the click event of the button: DoCmd.OpenReport("Report Name", , "Client = " & QUOTES & Me!ClientID & QUOTES "QUOTES" is a constant which you will have to create in a module making it equal to """" Use of this constant will only be necessary if the ClientID is a...

It is a method of the DoCmd object. It looks like: DoCmd.OpenReport("Report Name", Style, Criteria) Look it up in Access help to get all the correct parameters.

Hi, I decided to use the formula in one can-shrink/can-grow text box. It works quite well. But I find that when the text box appears on the report - due to having data to display - it pushes all of the controls below it down by the amount of its height. I guess there is no way around this...

Thanks Pat. Now I am able to better format format reports. I did bump into one more difficulty regarding these two properties. If I have two fields one above the other where one or both could be empty, the shrink does not work. The reason I have this issue is because we are using the...