Search results

The Citrix server has a 64 bit copy of Access installed.

Now it says: Can't find project or library

That code is exactly what I sent and have.

Hi All My version of Access is 32 bit. When certain users try to access it using a Citrix server they get this error: Your Microsoft Access database or project contains a missing or broken reference to the file 'MSCOMCTL.OCX' VERSION 2.2. When they click OK this msg comes up: Compile error...

Sorry that was a faux pas, I meant BeforeUpdate.

Micron, I did mention the reason why, I'm not doing the validation in the BeforeUpdate event. Is the reason that, I mentioned valid?

I see what your saying in your code Paul. But, the code: If ValDonorFrm() = 0 Then Exit Sub Else Exit Sub End If Is simply meant to call the code like a sub and do everything needed for the validation in that code and that's it. How would it be coded so that it simple calls...

Yes, that is correct there is no return value even as you have both said it does something. I did not get that that is what Paul was saying. Thanks!:o

I appreciate your assistance Paul and don't want to be argumentative but when, I leave the fields empty and click the button a msgbox opens with the name of the control that is blank says that it must be filled in and put the cursor in the offending control. :o

The code that calls the function is in the on Click event of a button that prints the information in the main form. But this code checks to see if all required field have been filed in. Normally, this code would be put into the After Update event of a form but since I have subforms that come...

Hi VBA Masters, I have the following code that I adopted from the web. It is cool because the loop checks any control whose tag is set to 'v'. It returns the name of the offending control and puts the focus on it so the user can fill it in. The issue that I have is the call to the function...

I have used currentuser() and it evaluates correctly but, I need a table based implementation.

I have code used to give access to a button in my application. What, I want to do is improve it and make it more flexible to update. Specifically, a new users is needed but since I coded it (see below), I have to wait until the end of the day to make the change. Is there a table based method...

Here is what I'm going to test. Forms!Donor_Intake_Form.[GiftAllocations_subform]!ProposalNum.SetFocus Also, it looks like this was commented on in the forum. https://access-programmers.co.uk/forums/showthread.php?t=21322

Minty, You have given me an idea. After the user completes the payment method, I can code so that the user is put into the sub form via vba code. The balance is easy once in the sub form the After update event takes over to ensure that the data is not blank. Super!:)

But what about the issue of the sub forms. If a user does not even enter them the values will be empty and since the form never gets focus the event trigger will never fire to validate. Any suggestion on how prevent that from happening?:o

Hi Form Masters, I have a form (see attached) that does not validate all sections. For example, there are three sub-forms placed on top of each other. The radio buttons un-hide each of the sub-form (Gift Allocation, Associated Credits, and Notification) when selected and hides the others. As, I...

Posting solution to this issue in case anyone else has a similar experience. The tables in this project are back end sql server R2. When, I linked the table in Access, I mistakenly selected the wrong column as the PK. In the scenario that, I described, I was adding records manually that did not...

No it was not so now it works. Issue #1 still pending can a label be refreshed. As in : Me.lblRecCnt.refreshe I don't thing this method is associated with this control. Any other way?:eek:

Issue #2 row source is a query: SELECT DISTINCT tblEgateDone.Description, tblEgateDone.Complete FROM tblEgateDone; Please see screen shot. I added code: DoCmd.GoToRecord, , acLast DoCmd.GoToRecord, , acFirst There was not change.