Search:

Is this a bug in Access ?

When you open a database with the database window hidden (or the navigation pane in an accdb database), if two forms are open and you close Access with the close button...

See VBA Tips & Tricks: Create Database with ADO / ADO Create Database for code how to create your table.
You'll have to create the table and each field. Access can't assume anything.

Can't you do a DCount on the table or query with the same where condition as in the sql statement ?
Something like this :

NumberOfRecords = DCount("*","MyTableOrQuery","WhereStatement")
If...

Have a look at the procedure at Export data from Excel to Access (ADO) using VBA in Microsoft Excel

According to this thread Error communicating with the OLE server or ActiveX Control in Forms Coding in a Microsoft discussion group, several people solve this problem by copying the form, delete the...

Vicky,

Have a look at this post from Hans. You should do something similar.

Nancy,

Please post in English so that everyone can follow the thread.

I found two problems in your database:
- the subform contains a subset of the whole table.
- the subform is sorted...

Are you saying that the conditional formating is not working or that the AlternateColor field is not correct ?
Maybe you can attach a stripped down version of your DB, so we can see what you have.

No, you can't use conditional formating to change the backcolor of the detail section.
What you can do is create a textbox as great as the detail section, put it behind all the other textboxes and...

You have to set the conditional formating for each field on the form individually.

You have to click on the little arrow (see attachment) beside the paint pot to change the color.
...

Nancy,

I have been searching a little and I think I have to change my mind. Look at the attached mdb and see if you can do something with it.
I wrote a function to add a Boolean field to the...

Hi Nancy,

I think this is not possible in a continuous form or in datasheet view. With some VBA, you could achieve this in a report.

Are you sure about the query names ?
In your first post you mention qryOrigRUGItems and now qryEditRUGitems

Would'nt it be something like this :

UPDATE cr_SampleDataSet_HeaderInfo SET LoginID = '<loginvalue>', NetworkLogin= '<loginvalue>', ReturnedFromField='Yes' WHERE someIDfield IN (Select...

Open the form in design view. Select the form. In the property window, look for the property "Filter On Load" in the tab Data. If it is set to yes, change it to No. Save the form.

Add thes two lines to the code :
strDealer = ""
strDataID = ""



...
Do While Not rs.EOF
strUsername = rs!User
strDealer = ""

Al,

In the 64bit version of Windows 7 you have two Program Files directories. One for the 32bit applications (ProgramFiles(x86)) and one for the 64bit applications (Program Files).
...

In the On Open event of the form, put the following code:


If Me.Recordset.RecordCount = 0 Then
MsgBox "There is no data"
Cancel = True
End If

No problem Silverback. As long as you haven't lose anything.

I've tested your code and I have no problem. Can you post a stripped version of your DB where the error occur ?

In the format property you can enter 4 formats separated by a semicolon. the fist is for the case the field is positive, the second if the field is negative, the third if the field is 0 and the forth...

See if the function TotalField2 in the Module1 if the attached DB do what you want.

[attachment=86924:db7.zip]

I've moved this thread to Beta Software

Things have changed, you can change your display name now.
See this post

Things have changed, you can change your display name now.
See this post