Recent content by TGHockett

RO -- Since I have had problems with the security setup for Acc2k (mostly due to lack of tech detail knowledge on my part), I created a workaround situation as follows... its very clumsy but it works: 1: Created a table with username/department/userlevel. Userlevel alternative values were...

Chris --- am curious why you say one has to use VBA to pass the values from one form to another form. I am using Acc2k and have accomplished this via macro using the setvalue action-- careful consideration is that the macro doesn't close the first form until the 2nd form values have been set...

BTW I am using Acc2k -- I don't know if this fix will work in earlier versions. I suggest for your future posts you include which version of Access you are using. TGH

Doug -- I had a similar problem a while back and it relates to the data type setup for your table (not the form). If you set the field size to "single" (e.g., vs. Long Integer) it will fix the problem -- but not sure it there are better solutions. HTH... TGH

Still interested to see if anyone else has any other ideas ... TGH

Zunan -- Being very new to VBA, I couldn't quite follow all your suggestions, but after looking at it again today, it sounds very similar to one of the suggestions from MSN that I tried and it worked fine for a while, but then locked up on me. Admittedly it was not identical to yours via VBA...

My basic Q is: is this problem discussed on a separate thread relevent to Acc2k? I ask because the app I am working on is with a company going thru a mega-downsize iniative, and hence both of my alpha/beta users not only have a 15" screen or smaller (vs. my office pc with 17" and my home office...

Thanks Guys for the feedback ... will tryout Zunan's ideas on Monday. Rich -- the article you pointed to re the bookmark bug is for Acc97 and before right? I thought I read somewhere here that MS fixed it in Acc2k? Am I wrong? Would MS let the combo wizard create bad code? (dumb question...

Thanks for asking the "hard" VBA questions so I don't have to always look to be the dunce And thanks Jack for the "easy" answer! TGH

As many of you are probably aware, I have been much challenged to come up with a "simple" combo box to move to a selected record on the same form, so I tried again with the combobox wizard today, which works ok for a while, then eventually (after 3-7 correct selections) crashes. Anyway, the...

Hi Rich ... thanks for jumping in, but I did try the workaround you suggested, but that opens the form on top of the parent, so that does little good. As mentioned before the form/subform I tried added worked perfectly before adding it to the unbound parent form... all of this would be moot of...

Following the suggestion in MS article Q209537,I created an unbound form to hold a combobox and a two page/tab control form/subform. The good news is that the combobox works very well to move to a desired record, but I am getting the following error when a repaintobject action is run from an...

If I am correct that you want to display on a form a control's value on another open form, add brackets around the "form" as in : =[forms]![frmEmpInfo(1)]![SSN] HTH

Just wanted to let you know, Pat, that your idea worked just fine, though a bit tedious, as you knew it would be. For people with this type of problem in the future, a couple of things I learned: 1: The Open/current events fired off just as Acc2k docs said -- the last nested subform (tab...

I am using Acc2k and have had no problem by setting the List Row property in the format section for the combobox to the number of rows to display ... let us know if this helps. TGH