Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Iif statement in access query with color criteria

    Hi

    I am trying to alter the following IIF Statement:

    IIF(IsNull([Diff],"",IIF([Diff]>0, "Over","Not Over"))

    This is working correctly but I was wondering if there was a way to add in a light...
  2. Replies
    10
    Views
    1,300

    Hi Paul/Jeremy Thank you guys for all the...

    Hi Paul/Jeremy

    Thank you guys for all the help--it works perfectly and is a godsend not to have to adjust each workbook for importing.

    Jean
  3. Replies
    10
    Views
    1,300

    Hi Is there anyway you could just share with...

    Hi

    Is there anyway you could just share with me the exact code that would create the loop? I am not proficient in writing code--I just find code and adapt it!


    Jean
  4. Replies
    10
    Views
    1,300

    Hi Paul Sorry it took so long to get back to...

    Hi Paul

    Sorry it took so long to get back to you but it crashes on the If UCase ...
    Here is the code:


    Dim i As Integer
    Dim zXLFPath As String
    Dim zXLFName As String
    Dim...
  5. Replies
    10
    Views
    1,300

    Hi Paul It means changing 75 workbooks. So...

    Hi Paul

    It means changing 75 workbooks. So there is no easy fix to the existing code or any other code I can use and adjust?

    Jean
  6. Replies
    10
    Views
    1,300

    Hi Paul I need the code you suggested not that...

    Hi Paul

    I need the code you suggested not that savvy with understanding what you mean?

    Cheers, Jean
  7. Replies
    10
    Views
    1,300

    Need VBA code that changes field name in table

    Hi

    I found the following code to change a field name in a table:

    Dim dbs As DAO.Database
    Dim tdf As DAO.TableDef
    Dim fld As DAO.Field

    Set dbs = CurrentDb
    Set tdf =...
  8. Replies
    36
    Views
    18,306

    Hi I used the following code with a button in...

    Hi

    I used the following code with a button in Access 2010. I allow the user to choose the excel files they want. This might be a start in helping you setup this procedure automatically. The...
  9. Replies
    11
    Views
    1,831

    Hi Mark All set with page breaks. In design...

    Hi Mark

    All set with page breaks. In design view it does not show the page breaks. In print preview it did show the breaks. As for the PO I hedging toward an automatic generation of PO numbers,...
  10. Replies
    11
    Views
    1,831

    Page Break in a Report and Entering a PO Number

    Hi Mark

    That is awesome--thank you so much with the help. I have another request. I have attached the database again. I have a PO and I am having trouble with page breaks!! I also wondered if...
  11. Replies
    11
    Views
    1,831

    Calculated Field in a query

    Hi Mark

    Sorry about that I do not use this forum that often and I forgot to upload the attachment. The attached database is just the piece that you are helping me with. If you need more I can...
  12. Replies
    12
    Views
    2,750

    Hi I did as you suggested with an update query...

    Hi

    I did as you suggested with an update query and it worked great. Had to relearn how update queries work. Thank you again for the help.

    Jean
  13. Replies
    11
    Views
    1,831

    Calculated Field in a query

    Hi Mark

    Attached is a zipped database that I think would be easier then me going back and forth trying to example what I am trying to do.

    Jean
  14. Replies
    11
    Views
    1,831

    Hi Mark I tried your suggestion by altering...

    Hi Mark

    I tried your suggestion by altering the formula to fit my needs in the select query: PO Order: [NeedtoOrder]+Choose(Weekday(Date()),[Mon Safety],[Tues Safety],[Wed Safety],[Thur...
  15. Replies
    11
    Views
    1,831

    Hi Do not want to do in a form. Prefer to do...

    Hi

    Do not want to do in a form. Prefer to do in query. Will do in vba if that is my only choice.

    J
  16. Replies
    12
    Views
    2,750

    HI Both fields are in the one table. Can I do...

    HI

    Both fields are in the one table. Can I do this in a select query versus an update query?

    J
  17. Replies
    11
    Views
    1,831

    Calculated field in a query

    Hi

    I have the following formula:
    [To Order]+[Mon Safety]-[On Hand] all number fields.

    I need to change [Mon Safety] according to the day of the week, for example, on Tuesday I need to alter...
  18. Replies
    12
    Views
    2,750

    HI Thank you for the help. I do not use this...

    HI

    Thank you for the help. I do not use this forum very often so I am having trouble posting a new thread. I have another question. This involves a calculated field. If I have a field On Hand...
  19. Replies
    12
    Views
    2,750

    Hi Thank you for the help but I need to be...

    Hi

    Thank you for the help but I need to be able to enter item codes which I know pretty much by heart. Can you switch it around?

    J
  20. Replies
    12
    Views
    2,750

    Combo Box

    Hi

    Attached is the test database. The combo box works when you choose from the list. The combo box does not work when you type in the Item ID. Appreciate the help.

    J
  21. Replies
    12
    Views
    2,750

    Hi I created the two tables and I have a combo...

    Hi

    I created the two tables and I have a combo box that is working but why can't I just type in the value. It only works if I choose from the combo box. I used an event procedure OnChange. ...
  22. Replies
    12
    Views
    2,750

    Access database sample for route deliveries

    I am trying to use Access 2010 to do the following:

    The company specializes in delivery of product to nursing homes. There are 12 delivery routes throughout the region. Each driver is...
  23. Delete the Field contents in Access 2010 using VBA Code

    Hi

    I have a table named "Items" with several fields. I want to delete the contents of two fields but retain the column headings. The two fields are named "OnHand" and "Dates". I was thinking of...
  24. Replies
    36
    Views
    18,306

    Hi That works great. I did take out the...

    Hi

    That works great. I did take out the backslash \ in front of Student and I got the results I wanted. The input box pops-up and the user can enter ANGB01 and it becomes part of the filename. ...
  25. Replies
    36
    Views
    18,306

    Continuation of Exporting from Access to Excel

    Hi Again

    I have the following code working perfect but I have been researching and reading about letting the user input part of the filename instead of hard coding it.
    This is want I have:
    ...
Results 1 to 25 of 40
Page 1 of 2 1 2