Search results for query: *

I'm trying to write VBA code behind the onClick event that is the same as having a user click on a different button. Lets say I have button1 that adds 1+2, and I have button2 that does something else, but it requires button one to have been clicked already. I would copy the code behind the...

I have a button on a from that I have not been able to find the code behind it's OnClick event. Is there a way to write code that is the same as clicking on the button?

I have a couple of questions here and not sure where to post them all so I'm going to start in this forum. I am trying to code an asp page that will be accessing information from an access database. In the past I've had problems getting the right configuration so that I could insert data from...

Thanks it works now.

When I submit with the following code: IF request.form ("Message")="True" THEN strPatSSN=request.form("patSSN") 'patients social security number '10 strPatFN=request.form("patFName") 'patients first name strPatLN=request.form("patLName") 'patients last name strPatIns=request.form("patIns")...

I'm trying to run a for loop from 1 to x, where x is the last row in the workbook. How would I go about retreiving the number of the last row with data? Thanks

First off, let me appolagize for posting in the wrong forum, I wasn't sure where to post. I'm looking for a URL of a site that has news of new worms/viruses/etc, as well as new Windows patches.

Thanks for the help, exactly what I was looking for. The 93010 is a column name, I forgot to put it in brackets.

I am getting a #error in my report from the following code: =IIf([PPO/HMO]="PPO",[Text84]=Avg(93010)*0.4,[Text84]=Avg(93010)*0.6) The code is in the control source for a text box on the report. I am trying to set the value of the text box (Text84) to 40% or 60% depending on the...

I am trying to write an if statement to test the value of a check box (Billed). Here is the code: If Me.CDG_Billed_ Then 'if CDG_Billed? (Please note that the column name is CDG Billed?) ... But this does not seem to catch the value of the check box. I've also tried If Me.Billes =...

I solved the problem. In Access I went to the form view, and clicked edit select form. Then I went to view properties. The old name was in the order by, or filter field.

I changed a column name in a table and now, when I open a form it open the "Enter Parameter Value" window. I have gone through the form and have updated all the references to the old column name. Is there a way I can find out where in the form the old name is being referenced? Thanks

I don't necessarily want to go back to the first record. I have the .MoveNext if there to go back to the origional record. The problem is that after the .MovePrevious I don't seem to be reading that data.

Here is my code: With rstClone .MovePrevious numPrevTotRec = Me.Total_Reimbursement .MoveNext End With Is there something that I need to do after the .MovePrevious command so that the Me.Total_Reimbursement is reading the new (previous) record.

That is exactly what I was looking for. Thanks, I marked the post as helpful/expert post.

In Access 2000, I have a form with a subform that is in Datasheet layout. Is there a way to retrieve a value that is on the first or previous row of the subform? The code will be written in the subform.

Here is my code: Private Sub Primary_Pymt_LostFocus() Dim sBillingFee As String Dim sClaimType As String 'Contains the Claim type Dim aQueryResults(0 To 10) As String Dim iPatientSSNum As Integer sBillingFee = Primary_Pymt * 0.065 iPatientSSNum = PatientSS#...

What I want to do is find the claim_type and payment_amount for the patient. If the claim is of a certain type I want to divide the payment in half and put that value into a field on the form. I'm just trying to figure out how to code the sql statement.

What should I use for select queries then? Thanks all for the help.

When I do that it says that the RunSQL action requires an arguement consisting on a sql statement.