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.

...to the Access driver and Access database in the Inetpub directory where the database is saved strProvider = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\wwwroot\Tutorial\TinaDB.mdb;" 'Creates an instance of an Active Server component set objConn =...

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.

...String 'Contains the Claim type Dim aQueryResults(0 To 10) As String Dim iPatientSSNum As Integer sBillingFee = Primary_Pymt * 0.065 iPatientSSNum = PatientSS# Me.Billing_Svc_Fee1.Value = sBillingFee Me.Net_to_CDG1 = Primary_Pymt - sBillingFee...

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.