Search results for query: *

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...

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.

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 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

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.

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#...

I am running a sql statement: DoCmd.RunSQL ("Select Claim_Type,Primary_Pymt from Tests where PatientSS#=" & Form![PatientSS#]) When I run the statement I get a "Run-time error '3075' Syntax error in date in query expression 'PatientSS#=123456789'. Why would I get this error...

I'm trying to write a sql statement. What I am trying to do is run a query when a field loses focus on a form. This field is in a subform. In my sql below, PatientSS# is the name of a TextBox. DoCmd.RunSQL ("Select Claim_Type,Primary_Pymt from Tests where PatientSS#=" & PatientSS#)...

In VB if I want to get a value from a table I just do a regular SLQ statement correct? So the syntax would be??? SELECT PaymentType From CustomerTable where CustomerID = 1234 How would this look in Access VB, and how would I access this value? What I want to do is have a field...

This is my first time coding in VB in Access. I'm trying to write code so that (in a form) when a text box (lets say box_1) loses focus, another text box (box_2) is automatically populated with the value of Box_1 * .065. I would also like to know how to populate a text box that is in a...