Search results

  1. N

    Please help quickly!!

    Okay, I got it narrowed down to this: I put my calculation for Expected in an unbound field..It comes out exactly right. But, my unbound field is Fixed and my Expected field is short time. I dont know how to get the results from the fixed format to short time format. Can someone help me...
  2. N

    Please help quickly!!

    I have looked in the forum for an answer to this question and I KNOW you have answered it many times...but, I am so weary with this db that everytime I try one of the answers I dont get what I need. I feel it is something to do with my format. But, here goes. (and I have a deadliine that is...
  3. N

    How to roll off a record

    Hey thanks guys, I figured it out..made a query with timepe is null as criteria and used query to open form. DUH!!!
  4. N

    How to roll off a record

    I do want to see all the records that are not complete because they are continuously adding and updating records. If me.putaway.value = true and me.timepe.value >0 then me.requery? I cant seem to figure out the syntax. Sorry, I am at a loss
  5. N

    How to roll off a record

    How do I "roll off " a record when I have finished filling the entire record? I have a form that is continuous..the record is complete when I check a checkbox(Putaway) and fill out time ended(timePE). (Of course, there are several more records beneath that are not complete). I want that...
  6. N

    Can you program Access to automatically close if not in use

    It Worked !!!!!! Thanks To Both Of You Guys For All Your Help!! Noreene
  7. N

    Can you program Access to automatically close if not in use

    We are having a problem with mulitple users leaving an Access db open and then I am not able to make new reports, etc. without calling everyone to close their session. Is there a way to automatically close a db if user has not used in certain amount of time? Thanks, Noreene
  8. N

    Trouble with a simple dlookup

    Thank you so very much...that worked!!!
  9. N

    Trouble with a simple dlookup

    I am trying to use dlookup to fill an unbound textbox on my form. I know I am doing a simple thing wrong and I cant figure out what it is. My form has a field from table(m5Warehouse) called M5Location. It is a bin location. My form has an unbound textbox called BinMax. I have a table...
  10. N

    MS Access Run time

    Thanks so much for your quick reply. Just what I needed to know.
  11. N

    MS Access Run time

    If I install Access run time on a pc, would that enable me to protect all the code from wanna be programmers?
  12. N

    Need help with code behind form

    I have a db that has only 1 table and 1 form (picker db). That is because we only use it to gather info from pickers and dont want them to be able to do anything but enter data. I have a master db that is used by Managers to import data from pickers db to master db to run reports. Problem...
  13. N

    Query only latest info

    I DID answer my own question!! I found the answer somewhere in these forums...what I did was make a new query for unmatched results...then built my append query from the unmathced resuts query...works great!!
  14. N

    Query only latest info

    I thought I answered my own question!? I tried taking the two tables (the original table for managers and the linked table for warehouse) and creating a relationship on Id field (which is pk on both tables).. When I ran the append query it added the records from linked table to the original...
  15. N

    Query only latest info

    Is there a way to make an append query check a linked table and append only the records starting with next autonumber? Maybe I am asking for something that I could do better in another way.
  16. N

    Query only latest info

    Someone please help.. How do I make an append query only append the records beginning with the next autonumber? I have linked tables in db...one db is for warehouse employees to input their orders and the other table is in the original db for managers to use for reports. I need to append...
  17. N

    Importing data between databases

    I tried it and it WORKS GREAT!!!! Just what I needed...thank you so much Peter...
  18. N

    Importing data between databases

    A link is all I need? Even if the warehouse db is on a different drive than the original? And by linking, is there any way some user could access the original db?
  19. N

    Importing data between databases

    Thanks to both of you for your help...I was trying to stay away from security..I never have been able to implement security because I dont know enough about it and it is such a headache. All I was hoping to do was: to run a macro in the original db that opens up the warehouse db imports...
  20. N

    Importing data between databases

    I have searched and not found exactly what I am looking for..so here is my question. I have a large database that works fine, IF people would stop trying to play in it!! What I want to do is to restrict access to everyone except managers. So, I copied the db for warehouse users to input their...
Back
Top Bottom