Search:

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

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    67

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

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

    Thank you Wendell... that was it... up and running again
  3. Replies
    2
    Views
    367

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

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


    ...
  6. Replies
    1
    Views
    1,683

    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....
  7. Replies
    1
    Views
    641

    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...
  8. Replies
    5
    Views
    3,433

    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...
  9. Replies
    5
    Views
    3,433

    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...
  10. 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...
  11. Replies
    11
    Views
    1,325

    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
  12. Replies
    11
    Views
    1,325

    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...
  13. Replies
    11
    Views
    1,325

    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...
  14. Replies
    11
    Views
    1,325

    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...
  15. Replies
    11
    Views
    1,325

    Thank You very much for the input. I no...

    Thank You very much for the input.

    I no longer get any syntax errors. However in this case I do not get the right result either. For testing purposes, the table this dsum hits has three...
  16. Replies
    11
    Views
    1,325

    Hi all, Not having much luck here. Trying to...

    Hi all,

    Not having much luck here. Trying to dsum using:

    vInPut430TarsSun = Nz(DSum("[Input 430 TARs]", "tbl_Inputs_Outputs", "[badge number] = '" & Forms![frm_Report_Criteria]![vEmployee] &...
  17. Replies
    13
    Views
    770

    List boxes in Microsoft Access do *not* have a...

    List boxes in Microsoft Access do *not* have a TextAlign property. They are left-aligned by default.

    You'd need Windows API functions to change that; Stephen Lebans has a sample database with the...
  18. Replies
    13
    Views
    770

    HANS, Sorry, I did a search in the ACCESS...

    HANS,

    Sorry, I did a search in the ACCESS topic but it must have brought up the Excel. This is an Access question. My bad. Still possible?
  19. Replies
    13
    Views
    770

    Hans, I can't be in the same place you are...

    Hans,
    I can't be in the same place you are unless it is a difference in versions. I am using Office 2003 SP 3. I can see everything else you are showing in your screen shot except textalign.
  20. Replies
    13
    Views
    770

    In the Visual Basic Editor, open the userform....

    In the Visual Basic Editor, open the userform.
    Click on the list box to select it.
    In the Properties pane, set the TextAlign property to 3 - fmTextAlignRight.


    My properties for that list box...
  21. Replies
    13
    Views
    770

    Is it also possible to right justify data in a...

    Is it also possible to right justify data in a list box? I have a query populating a list box with one field shoing standard numbers. (i.e. 123,456,789 with no decimals). However it is left...
  22. Replies
    2
    Views
    871

    It is hard to read, but I think you have a...

    It is hard to read, but I think you have a problem with apostrophes in the WHERE portion. It should be:

    , "[PIIN_CODE] = '" & Forms![supmod -> Mod]![PIIN_CODE] & "' And [CLIN] = '" & Me![CLIN] &...
  23. Replies
    2
    Views
    871

    Hi all, I am looking for a little syntax...

    Hi all,

    I am looking for a little syntax advice when using multiple criteria in a dlookup function. I have the following VBA:

    Me![Text228] = DLookup("[CLIN_DESCRIP]", "Cams_Piin_Data2",...
  24. Replies
    2
    Views
    1,118

    Hi all, At the risk of looking very stupid,...

    Hi all,

    At the risk of looking very stupid, can anyone tell me why the following generates an error stating that to run it requires an argument consisting of an sql statement?


    Dim dbCurr As...
  25. Hi all, I am wondering if it is at all possible...

    Hi all, I am wondering if it is at all possible to add a column of numbers conditionally if the background color of the cells is set to a specific color.

    THanks
    Kevin
Results 1 to 25 of 180
Page 1 of 8 1 2 3 4