Search:

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

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    306

    CAC logon security

    Is it at all possible for Access to utilize the CAC card reader to authenticate a user's logon credentials? If so can someone point me in the right direction to research this?

    Thank you
  2. it is in fact stored as a date field... I fooled...

    it is in fact stored as a date field... I fooled around with that idea awhile back but could not make it work consistently because when retrieving those records based on that key I used a form to...
  3. I do it thru an update query: SQL version is:...

    I do it thru an update query:

    SQL version is:
    UPDATE RATES SET RATES.RateID = RATES!RateName & RATES!RateVersion & " " & RATES!Code
    WHERE (((RATES.RateID) Is Null));


    RateID = a text string...
  4. ACCESS 2007 Is there a way to check Computer Date format in VBA

    Hi, I am trying to correct a database issue that usually appears after a windows update gets pushed out to users: My situation is that in ACCESS I am establishing a Rate ID key field which...
  5. Replies
    2
    Views
    763

    that did it thank you

    that did it thank you
  6. Replies
    2
    Views
    763

    Setting record source on subform

    Hi,I have a main form/subform situation where I am using two combo boxes on the main form to establish query parameters, in which once selected the second combo box triggers a "make Table" query...
  7. Replies
    1
    Views
    324

    DLOOKUP returning time instead of date

    Hello all, I am really confused with a reult I get in a DLOOKUP function:Both vContCompDateMod and vContCompDatePiin are declared as DatesI get a valid answer for vContCompDateMod = Forms![supmod ->...
  8. Number of characters in a cell in the query design grid

    I have a query as the source of a report which I developed using the design grid... in one of the fields I have the following code :Process Point: IIf([Cams_Change_Data1]![STATUS_CODE]="D" Or...
  9. Replies
    1
    Views
    750

    Nonmatching records in different tables

    Hi all, I have two tables (table A and table B), containing records that reference each other using a "KEY" field... there is a one to many relationship from table A to table B... there is supposed...
  10. Replies
    5
    Views
    819

    work upgrading soon to 2010

    Hi all, looking for some down and dirty proffessional advise... our company wants to upgrade from office 2007 to office 2010... we have many access databases in a Front End/Back End set up in a multi...
  11. Replies
    5
    Views
    768

    I have now tried the second option in your reply...

    I have now tried the second option in your reply Wendell... I believe at this point all is lost... Thank you for your help
  12. Replies
    5
    Views
    768

    Thank you Wendell, I tried the first part of your...

    Thank you Wendell, I tried the first part of your response and got an error every time it tried to import any forms from the backup... error stated it could not find first record or there were no...
  13. Replies
    5
    Views
    768

    file missing all VBA

    I was opening a file on our network when the desktop I was using seemed to breifly loose connection to the network server the file was located on... long story short it closed by itself and when I...
  14. Replies
    3
    Views
    1,190

    Thank you both... learning a lot, especially how...

    Thank you both... learning a lot, especially how to spell... turns out after reading your replies I went back to the table where where the update is supposed to occur and I realized that I left the...
  15. Replies
    3
    Views
    1,190

    Record not updatable

    Hi all,

    I am trying to execute the following :

    mySQL = "UPDATE Cams_Piin_Data1 " & _
    "SET Cams_Piin_Data1.GOVT_EXEC_DATE = #" & vGovExeDate & "#" & _
    ...
  16. Replies
    3
    Views
    627

    Wendll, that is exactly what I am looking for...

    Wendll,

    that is exactly what I am looking for thank you... if one or more of the detail records show a "yes" in the field then the whole report has to be labelled different than if none of the...
  17. Replies
    3
    Views
    627

    Is this even possible... 2 hours searching google...

    Is this even possible... 2 hours searching google and I cannot find any place where a specific control within a report header is referenced from the detail section or vice versa
  18. Replies
    3
    Views
    627

    Access 2007 Report Header

    All,

    is it at all possible to set the visible property to a label or txt box in a report header based on criteria in a txt box in the detail section of the report ?

    Example:

    The detail...
  19. Replies
    2
    Views
    526

    thank you, that worked perfect

    thank you, that worked perfect
  20. Replies
    2
    Views
    526

    report grouping Access 2007

    I am trying to group records in a report that need to be grouped on a record ID that contains "-" in the ID... to elaborate a record ID contains some numbers and letters followed by a "-" and then...
  21. Replies
    0
    Views
    391

    Office 2007 Access Graphs

    I have been able to generate simple bar graphs within access using access table data, but I need to take it one step further and plot a line on top of the Bars. Currently my chart show fiscal year...
  22. Replies
    2
    Views
    1,122

    Thank you Wendell... that was it... up and...

    Thank you Wendell... that was it... up and running again
  23. Replies
    2
    Views
    1,122

    docmd.open form not working

    Hi,
    I am confused as to why the docmd.open form command is not working in the below code:
    Dim MsgNewProc, Style, TITLE, ResponseNEwPRoc, MyStringNewProc

    MsgNewProc = "Do you need to create a...
  24. this was a huge help... thank you

    this was a huge help... thank you
  25. VBA "IF Then statement" syntax for word 2007

    Hi all, at a loss for the correct syntax to see if a connected access database field equals a specific value... using variotions of the following but nothing is working:


    some code ...


    ...
Results 1 to 25 of 200
Page 1 of 8 1 2 3 4