Search results

Where are you having trouble? Is the query not returning the values? Are you getting an error? I want to help.

There are a couple ways to solve this: The best way is to create a Lookup Table and link it with you current data (Thus replacing the passing of 1 2 3 ... with Michigan Georgia ...) To quickly solve your issue you could also use a private Function. Place this function on the Class Module of...

Here are the properties: 0: Autoincrement 1: Default 2: Description 3: Nullable -> Setting this to True makes the field required/False makes the field not required 4: Fixed Length 5: Seed 6: Increment 7: Jet OLEDB:Column Validation Text 8: Jet OLEDB:Column Validation Rule 9: Jet OLEDB:IISAM...

Sub SQLgen() On Error GoTo Err_SQLgen ' SQL Generation routine SQLQuerysubform.SourceObject = "Query1subform" SQLbase = "SELECT tbldst.dst_user, tbldst.dst_task_id, tbldst.dst_date FROM tbldst" Dim iLp As Integer For iLp = 1 To 4 If Me.Controls("Combo" &...

Does this answer your question? Sub SQLgen() On Error GoTo Err_SQLgen ' SQL Generation routine SQLQuerysubform.SourceObject = "Query1subform" SQLbase = "SELECT tbldst.dst_user, tbldst.dst_task_id, tbldst.dst_date FROM tbldst" Dim iLp As Integer For iLp = 1 To 4...

I do not know what you base this on, but I have used many different types of variables (Boolean, String, and Numbers). The Filter property is a string value, but think of it more as the Where/Having clause in an SQL statement. The same rules apply.

1. Set the Forms Filter property to only display the record. Example [ID Field Name]=ID# 2. Create a RecordSet Object and Set the forms RecordSet Propery equal to the RecordSet Object. 3. Create a Form to select the ID# and use the Docmd.OpenForm function setting the [Where] options...

Create Table tblMagicEightBall Field ------ MSG Text(100) --> I just choose this set it to what works for you Add phrases and then call the function below. Public Function MagicEightBall() As String Dim rst As New ADODB.Recordset Dim iMsg As Long Dim iUpper As Long Dim...

Somewhere in the database there is a link between the GUID and what type of file it is. Most likely the system is not using a translator on the name itself, but has a table that looks possibly something like this: Table ------------------- [GUIDID Field] [File Type or Original File Name]...

According to www.wikipedia.org

Why even use SendKeys? You have the Docmd.RunCommand available to you: DoCmd.RunCommand acCmdCompactDatabase DoCmd.RunCommand acCmdRepairDatabase

What are you using for the Provider?

is there a manual page break object in your report? Does the detail section's Force New Page property set to something besides "None"?

ThisCheckBox: Iif(DateAdd("yyyy", [TrainingDate], [NumYears]) <= Date(), "Out of Compliace", "In Compliace")

Use "Group By" to group the ID's under a single Claim #. You may need to change your report layout.

This link might help: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=27640&highlight=Autonumber Also you can do this from the Form on the control (Option Group) after update or Changed Event.

How is it not working properly? How does the caption get changed? (Running of a different procedure) Does the Caption change when it is suppose to?

See this post for a start http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=27640&highlight=Autonumber

Use Print instead of Write

How do you have the Tables Stuctured? If you have a "Training" table that is a list of Different Training the solution is a simple calc. tblTraining TrainingID -> Unique ID TrainingName -> External Name of the Training CertLength -> Length of time the certification is good for in years (This...