Search results

Perfect! Thanks so much!

Hi, What's the best way to set things up so that users can change the value of a constant? I currently have stuff in my code like but that means that whenever my users decide to change their goal, they have to call me, I have to edit the code, and re-distribute new copies of the front-end...

Yes, I am running the form's on_current event: PS-- About indenting, I will definitely take a look at the add-in. Meanwhile, my code looks nicely indented when I copy it into this post, but when I preview the post the indenting is gone....

OH... now I see that you have quite possibly added the indenting for me!!! How embarrassing! Well.... thanks!

Hmm, what do you mean, "without any indenting"? When I view it, there is indenting to clarify the if-then statements. It looks pretty readable to me (but then again, I wrote it....) What would you have me do to make it more readable?

Hi, Any idea why my logerror function is intermittently logging err.description = {blank} and err.num=0, see stuff in bold near end of code below. I can't figure out why it would even get to the error handler without having an error number and description. Any ideas?

I don't see why that should keep you from splitting your db into fe and be. The table would be in the backend and simultaneous use by a number of users should not be a problem. I have many very dynamic, very multi-user applications set up this way. If you don't do this, Access will most likely...

Hi, Form A contains Subforms B and C. All three forms are linked on a field, "ItemNo". Now, I enter "123" into the ItemNo field on Form A. ItemNo "123" doesn't yet exist in the underlying recordsets for subforms B and C. On subform B, the "123" now shows up in the ItemNo field, as I...

Thanks, rural guy! Of course I though of that out as soon as I sent off the post....

Hi, I am trying to pass a value from form A to form B via openargs. This is in response to a "notinlist" event on form A. I am opening form B with the openargs set to the "NewData" parameter generated by the notinlist event on form A. Then, in the OnOpen event for form B, I set a field's...

Thanks, I started this assuming that I would have to write VBA code (which I know how to do, no problem there); I just wanted to make sure I wasn't missing anything.

Hi, I have a large application where I need to generate a table in which the values of several fields in record 2 depend on record 1, values in record 3 depend on record 2, etc. Of course this is very easy to do in Excel, but for the size and complexity of my application, Excel really will not...

Yes, split your db front-ends and backends, and give each user their own copy of the front-end.

Yes of course I can do this. But that means I have to maintain two sets of the same code, and that's what I was hoping to avoid.

I have some reports I need to run automatically every morning. The same reports can be run manually by clicking some buttons on a form. I was hoping I could, via vb, remotely manipulate the form. There are certainly other ways I can do this, but it seems like, for ease of maintenance, it would...

Bobby1st, can you please post the exact command that you tried to use? Wiz47, Filecopy the backend is now the method that I'm using. Thanks.

Setting the stdgo_click event to public works great. Thanks! I think the separate function thing would work, too, but just setting the click event to public seems easier. BTW, my work-around, which also seems to work, is to set the focus to the stdgo button and then use sendkeys "{ENTER}"

I would like to be able to manipulate a form in a remote database. I want to set a bunch of controls on the form to the correct paramaters and then click a button on the form which runs a report. HEre's what I have so far. Everything works except for the !stdgo_click, which is intended to...

Unfortunately I have found the .ldb files to be notoriously unreliable for this. In a production environment, it's impractical to maintain user names for every hourly worker on the manufacturing floor. So I have multiple users logged in with the same name. In addition, we're running on terminal...

And, I should've added, by "periodically" I mean once a day or so.