Search results

I have docmd.runcommand AcCmdSaveRecord in the "on exit" event of a subform. If I change data, it doesn't save the record, if I don't change data, it complains that saverecord isn't available right now. I can understand the second scenario, but why does it refuse to save the data when I do...

I'm terribly sorry to bother on what seems like a very simple matter, but I've just given up on MicroSofts documentation. I just want to execute the Shift+enter type of save-record command (also available from the "Records" menu at the top) when a field loses focus. This would need to be part...

Using Access 2k in form design view, I sometimes get a blank, white section in place of a subform. Sometimes if I toggle back and forth a few times between design & form views, the subform may finally appear in detail. I've applied all updates to office 2k and can't seem to figure out why the...

Calculated Data Never? What if you wanted to run a report based on invoice totals and such? I would have thought that between the two, storage space is generally less costly in time and money than processing. But you say one should never store a datum in a table that is a function of two...

I'm looking to copy the data within the form I simply want to copy the qty*price to a field in the underlying table when the unbound, or formula bound control, has changed in response to a qty or price change. so I change qty from 2 to 4, let us say. The calculated control "extended price"...

If I put a calculated control on my form, I don't seem to have any way of pushing its changes to a field when those changes happen. Access can be downright infuriating at times. I've spent days just putting together a simple invoicing application. My form is not based on a query like the...

Incidentally, Gblack.. I don't know your user level, but I wanted to clarify that the DoCmd.Maxize is not actually in the field itself for "on activate", but rather written into the module (VB code) that underlies it. You may already know this, but just wanted to make sure.

Me too. DoCmd.Maximize did work but... I'm surprised that the DoCmd.Maximize didn't work when placed in your "on activate" code. In any case, it would seem to me that this may not be a great solution anyway, as it is a rather slow and ungraceful process of re- maximizing the previous forms...

I'm running a re-installed (after the problem began), fully updated version of Access from Office 2000 on a fully updated version of XP tablet (which I believe is xp pro adapted). If I open Access, and then open any .mdb at all, then close Access, I find the msaccess.exe remains in the tasklist...

A much simpler way to put it... The greater goal is to: 1) copy a value from a textbox in form1 2) press a button to open form2 3) GoTo the "new" record 4) set the "CustomerID" field to the value copied above in form1 That's it, except that it has to happen in code, not a macro. Preferably...

Yes, and yes Naturally the greater goal is slightly more complicated, but I'm trying to understand how to reference fields when assigning a value to them in VB code within Access. So yes, there is a button on the form which, when pressed, I would like to assign the number, say, "7" to the...

Re: my question below If this question doesn't make sense or is in the wrong location please advise.

If, for example, I wanted to click a button and have its event code (not macro) assign the value "7" to the "customer number" field of the current record how would I do this? I've tried using the syntax created in the expression builder, but to no avail. I'm using Access 2000. Thanks.