Search results

What are you trying to do? Provide data? Pull data? Make a chart?

If the unique field, named CustomerID, is in a table named tblCustomer and the field with the value in question is named StreetName then... 'BEGIN CODE Dim strStreetName as String strStreetName = DLookUp("StreetName", "tblCustomer", "CustomerID =" & Me.CustomerID If Len(strStreetName) > 0...

This code will start Access, open your database, and run your query. We can work from here... NOTE: You must first set a reference to the Access Object library. Go to any code window in your workbook, then Tools>>References, then click the checkbox for Access (8.0, 9.0, 10.0) 'BEGIN CODE...

email me at farcuss@hotmail.com

Dim ctl as Control If Me.NewRecord Then For Each ctl in Me.Controls ctl.BackColor = 16777215 Next Else For Each ctl in Me.Controls ctl.BackColor = 9868950 Next End If

Working on something for you... Feel free to email at farcuss@hotmail.com.

Set the other check boxes.Enabled = False. In the OnClick event of the main checkbox, check for it's value and then set all other checkboxes.Enabled = True.

You can either add a reference to DAO OR you can just use: Dim rs As Recordset

MS Project uses OLE automation the same as the whole Microsoft family. If you set a reference to Project in your database, you can control Project from within Access as well as retrieve data from and supply data to project files. Email if you need more specifics.

Search the forums for Audit Trail sample. There is a good one available, but I can't remember where.

Use the query as a recordset and loop through the resulting recordset capturing the field each time. Dim rs as DAO.Recordset Dim i as Integer Dim iRecordCount as Integer Dim strString as String Set rs = CurrentDb.OpenRecordset("qryName") iRecordCount = rs.RecordCount For i = 0 to iRecordCount...

See if this works for you...

I'm guessing you have a reference to ItemNumber somewhere in your sub form (Child/Master fields) or macro(s). It is looking for records that match the one in the main form. Because there are no records that match the ItemNumber being provided from the Main form, the error occurs. Do you have...

Add a task or reminder to Outlook from Access Feel free to email if you have trouble.

Set the control source of the option box = to a fieldname in the underlying table or query. You should have a text or numeric field in your table that would store the answer to the question in the option box. Make that field the control source of the option box.

forgot to activate my account. feel free to email me. farcuss@hotmail.com

2 points and then we can move on to email if you like... 1) Break up name into LastName, FirstName. You'll thank me later. 2) Don't STORE calculated numbers in tables. You can always calculate the numbers on forms or reports, but it is considered bad practice to store them. Feel free to...

in the On_Open event for the form enter: Page2.SetFocus 'where Page2 is the NAME of the page you would like to see.

I am automating the creation of a spreadsheet using data from my db. The data "merge" works beautifully when I run the code for the first time. If I attempt to run the code a second time within the same session, I get two different errors. Errors: 1) #1004 - Method 'Cells' of object...

The control source of the unbound text box you want to fill should be: =[tblPartsUsed Subform].Form!Total