Search results

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...

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...

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

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

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...

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

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

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

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...

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

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

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...

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!!

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...

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.

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...

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

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?

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...

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...