Search:

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

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    230

    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...
  2. Replies
    5
    Views
    288

    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
  3. Replies
    5
    Views
    288

    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...
  4. Replies
    5
    Views
    288

    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...
  5. Replies
    3
    Views
    534

    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...
  6. Replies
    3
    Views
    534

    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 & "#" & _
    ...
  7. Replies
    3
    Views
    289

    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...
  8. Replies
    3
    Views
    289

    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
  9. Replies
    3
    Views
    289

    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...
  10. Replies
    2
    Views
    221

    thank you, that worked perfect

    thank you, that worked perfect
  11. Replies
    2
    Views
    221

    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...
  12. Replies
    0
    Views
    212

    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...
  13. Replies
    2
    Views
    668

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

    Thank you Wendell... that was it... up and running again
  14. Replies
    2
    Views
    668

    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...
  15. this was a huge help... thank you

    this was a huge help... thank you
  16. 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 ...


    ...
  17. Replies
    1
    Views
    1,840

    Multiple criteria in dsum

    I am looking for a little guidance using multiple "OR" statements in a Dsum in access 2007. I tried many variations of the below but can't get passed an invalid use of null error or a compile error....
  18. Replies
    1
    Views
    694

    dlookup not finding records

    All, I have a form that on the on update event of a dropdown list performs a dlookup of a record and populates the rest of the form. The code works great for most of the records but there are...
  19. Replies
    5
    Views
    3,675

    Yes i specifically go into the design view of the...

    Yes i specifically go into the design view of the form and look at for example the "On CLick" Event for a button. The vba is actually missing. It happens only on this database, i have four other...
  20. Replies
    5
    Views
    3,675

    Code disappears in Office Access 2007

    Hi,

    I am battleing something that is truly strange to me. I have a database that was developed in ACCESS 97 and converted to 2003 and again to 2007. Since converting to 2007, every few days the...
  21. Hi, Our employer just refreshed all of our...

    Hi,

    Our employer just refreshed all of our computers and with this refresh installed a fresh version of office 2007. Previous access databases are now extremely painful to get into with all of...
  22. Replies
    11
    Views
    1,624

    Hans, Now I feel really stupid. Sorry to have...

    Hans,

    Now I feel really stupid. Sorry to have taken your time on this. I appreciate the help though.

    Thanks
    Kevin
  23. Replies
    11
    Views
    1,624

    I really appreciate everyone looking at this. ...

    I really appreciate everyone looking at this. The one record that should pull is for the line:

    "vInPut430TarsMon = Nz(DSum("[Input 430 TARs]", "tbl_Inputs_Outputs", "[badge number] = '" & 503843...
  24. Replies
    11
    Views
    1,624

    For now hold shift key when opening. The form...

    For now hold shift key when opening. The form called "frm_Report_Criteria" opens the parameters for the report "rpt_Op_Log_2". If you select 11/21/2009, 400, 401, and 503843 in the drop downs...
  25. Replies
    11
    Views
    1,624

    Thank You Hans For now hold shift key when...

    Thank You Hans

    For now hold shift key when opening. The form called "frm_Report_Criteria" opens the parameters for the report "rpt_Op_Log_2". If you select 11/21/2009, 400, 401, and 503843 in...
Results 1 to 25 of 191
Page 1 of 8 1 2 3 4