Search results

I'm using Access 2003. I have a report that uses a form to collect parameters before generating the report. Here's the VBA code in the report's Open event: When the DoCmd.Maximize command fires, the report does indeed maximize; however, the Switchboard form also displays in the top left...

I am using MS Access 2003. I have a report in which the highest-level detail band contains a nested Access subreport, inside which is a numeric field in the detail band of the subreport. I would like to generate totals of all of these numeric values through the entire report, to be reported in...

Hi, Bob, I must be doing something wrong, because when I add your code to the After Update event, I get the following error: I tried this code in the After Update for the field, then the record. Same error both times. Thanks. Wayne

I'm using Access 2003. I'm trying to make a combo box refresh in a given form after making changes to the cb from another form (while the original is open). So here's the sequence: 1. User opens main form containing cb control. 2. User adds or changes an entry in the table feeding the cb...

Not sure how that will help me. I'll give a few more details. Form frmLoading (see attached) currently displays the calculated field "Amount USD" by pro-rating the "Actual Amount" on the parent record (or the "Estimated Amount" if no "Actual Amount") by the Tonnes on the current record...

I'm using Access 2003. This might be a bonehead question, but is it possible to use a multi-table query for a form's Record Source and still be able to update records in one of the tables? I have the following query as the Record Source for a form: SELECT tblLoading.LoadingID...

You make a good point. Actually, I have it coded so that if the user selects anything from the combobox controls, I disable the textbox until they first blank out the combobox. So I think I'm OK there. Thanks for the reminder. I'm gonna take another look at my code to ensure that these cases...

This works great! And I appreciate your pointing out why the .Text property is so important. (I prefer to understand how the code works.) Thanks! Have a great day! Wayne

I'm using Access 2003. Is there a way to detect whether a user has begun typing in a textbox? Or whether, after typing something into it, they have erased what they have typed? I have a Search form with a criteria value of type text that the user enters into a textbox. I also have other...

Works great. And it's short and to the point. Thanks.

Worked great! Thanks. Wayne

I'm using Access 2003. Sorry if this is a dumb question, but is there VBA code to detect whether a given form is already open? (I've googled for a while, but I can't seem to find the answer.) Thanks. Wayne

This worked. Actually, based on your suggestion, I just added the following command to the After Update event and it fixed all: DoCmd.GoToRecord , , acNext Thanks for the help! Wayne

Thanks! That worked. I think I understand the first two parts of the format string (pos number format; neg number format). But what do the last two pieces represent (;;"0.0")? Wayne

I'm using Access 2003. In a form I have a textbox control that displays numbers in Standard format with three decimal places. I'd like to be able to display them with a negative number format (displaying parentheses rather than the negative sign): Unfortunately, I cannot seem to get it to...

Hi, Michael, I think I understand what you're saying, but still not quite sure how to implement. My form is actually a subform that's nested two levels deep. Because the subform needs to talk to the parent forms, I need to requery both the parent and grandparent forms whenever a row is...

I'm using Access 2003. In a form's AfterUpdate event, I want to know whether the row that was just updated was a new record. I've tried testing the .NewRecord property, but that doesn't work. (Apparently, by the time we're in the AfterUpdate event, it's no longer considered a new record.) Is...

Beautiful. It works! Thanks for your help. Wayne

I'm using Access 2003. I'd like to prevent users from entering a duplicate Claim Number in a field. (That is, if the entered Claim Number is already in the table, block it and throw an error message.) I know I can prevent that by creating a table index on that field with No Duplicates...

Actually, I started out with a Recalc, but some of the dependent calc fields were not updating correctly, so I had to resort to a full Requery.