Search:

Type: Posts; User: Francois; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.11 seconds.

  1. Thread: On Load Event

    by Francois
    Replies
    2
    Views
    464

    Is this a bug in Access ? When you open a...

    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...
  2. Replies
    6
    Views
    511

    See VBA Tips & Tricks: Create Database with ADO /...

    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.
  3. Replies
    2
    Views
    525

    Can't you do a DCount on the table or query with...

    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...
  4. Replies
    6
    Views
    511

    Have a look at the procedure at Export data from...

    Have a look at the procedure at Export data from Excel to Access (ADO) using VBA in Microsoft Excel
  5. Replies
    1
    Views
    3,491

    According to this thread Error communicating with...

    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...
  6. Replies
    16
    Views
    1,260

    Vicky, Have a look at this post from Hans...

    Vicky,

    Have a look at this post from Hans. You should do something similar.
  7. Replies
    23
    Views
    1,214

    Nancy, Please post in English so that everyone...

    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...
  8. Replies
    23
    Views
    1,214

    Are you saying that the conditional formating is...

    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.
  9. Replies
    23
    Views
    1,214

    No, you can't use conditional formating to change...

    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...
  10. Replies
    23
    Views
    1,214

    You have to set the conditional formating for...

    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.
    ...
  11. Replies
    23
    Views
    1,214

    Nancy, I have been searching a little and I...

    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...
  12. Replies
    23
    Views
    1,214

    Hi Nancy, I think this is not possible in a...

    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.
  13. Are you sure about the query names ? In your...

    Are you sure about the query names ?
    In your first post you mention qryOrigRUGItems and now qryEditRUGitems
  14. Would'nt it be something like this : UPDATE...

    Would'nt it be something like this :

    UPDATE cr_SampleDataSet_HeaderInfo SET LoginID = '<loginvalue>', NetworkLogin= '<loginvalue>', ReturnedFromField='Yes' WHERE someIDfield IN (Select...
  15. Replies
    1
    Views
    364

    Open the form in design view. Select the form. In...

    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.
  16. Replies
    15
    Views
    922

    Add thes two lines to the code : strDealer...

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



    ...
    Do While Not rs.EOF
    strUsername = rs!User
    strDealer = ""
  17. Al, In the 64bit version of Windows 7 you have...

    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).
    ...
  18. Replies
    5
    Views
    424

    In the On Open event of the form, put the...

    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
  19. Thread: Lost VB?

    by Francois
    Replies
    10
    Views
    603

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

    No problem Silverback. As long as you haven't lose anything.
  20. I've tested your code and I have no problem. Can...

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

    In the format property you can enter 4 formats...

    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...
  22. Thread: VBA Query

    by Francois
    Replies
    8
    Views
    606

    See if the function TotalField2 in the Module1 if...

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

    [attachment=86924:db7.zip]
  23. I've moved this thread to Beta Software

    I've moved this thread to Beta Software
  24. Thread: Name Change

    by Francois
    Replies
    14
    Views
    1,540

    Things have changed, you can change your display...

    Things have changed, you can change your display name now.
    See this post
  25. Replies
    3
    Views
    542

    Things have changed, you can change your display...

    Things have changed, you can change your display name now.
    See this post
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4