Search results

I was given a Dell computer about 6 months ago..worked fine before I got it and worked fine with no problems at my house until about 3 weeks ago..First, it said keyboard failure but went right on and booted up. Then one day, it wouldnt boot past the Dell screen (1st screen). So, I bought a new...

I have a new computer and I cannot see any color but blue and a yellow green...everything that should be red is black and the colors are drab. I have been to control panel/display/settings (and every other tab) and color quality is 32 bit (highest) but the only colors are blue, black, white and...

I have a computer that was bought many years ago with Windows ME and later ME had a problem, bought XP, and had installed(by someone else)..ran fine for about 2 years, then just last week the computer wouldnt pull windows up, just sat there trying to load. I took it to the local computer store...

Now I need help on the query for the form I have not worked in Access for a while and cant seem to remember how to do simple things!! I have searched before I posted this and nothing seems to be exactly what I am looking for so here goes. I have a table (tblmembersinfo) holding name, address...

Thanks to everyone, I have my db finished..except for 1 thing. On my form, I have an unbound textbox that I enter associates (number). This textbox is the last part of a 3 part calculation..when I enter the number of associates the next textbox(unbound) shows calculation (textbox name is...

In my table and on the form, I have a combobox that the user chooses the plant the product comes from and the combobox has 2 colums: plantid(text) and minutes(number). The bound column on my table and form is 0 which of course is plantid such as CH. The table holds it correctly and the form...

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

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

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

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

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

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

I want to know if I change the menu bar in an Access db (such as take out every thing, edit, view, format, tools, etc. except file and exit) would it remain that way in every other db that was opened on that pc? I want to restrict access to every tool except file, exit on only one pc (a public...

I did such a stupid thing..I went into the startup of my database and chose to not show full menus...we are having some "wanna be's" messing around in the database so I was going to restrict their ability to "roam". Now, I cant get in to undo the procedure...I tried by holding down shift key...

I have a form that requires date, picker id, no of pallets, and a unique identifier (which is date + no of pallets). On my form, there is an unbound text box (displaydate) that takes the date field and converts it into a number, format([date], "mmddyy") so that 04/15/05 looks like 041505. And...

This code works fine except it only "rolls over" the first record. I need it to roll over all records that show up in my form. The recordsource for my form is a query that asks for day (Mon, Tue) and then pulls out those records... On clicking the command button, I want it to insert all records...

I posted a question last week in query section that SJ MCAbney answered for me. SJ suggested that I use an append query(which, by the way, does exactly what I need it to do) but still having a small problem. So, here goes. Used a select query to open form by making deliverydate criteria as...

I know this is a simple question but I just cant seem to get it right. I have a form that is run by a query...the query filters out all records from the table that match the dayofweek I input..for instance, when form opens popup box asks what day? and I input Monday...all records with shipday...

I have a form that employees use to enter the minutes of each order that is being picked. The problem is some employees have found a way to use the back arrow key to look at previous records and sometimes changing the minutes...That causes the employee's minutes to be incorrect and therefore...