Search results

That is the way the database is set up. The table I originally described is like your table tblWork. The employee field is a number which is the employee ID field from the employee table. The task and description fields are set up the same way. The only one not set up like this is clients...

I'm not sure if this is the right place to place this thread but what I need to do is create a report with grouping. The fields are: Employee Task Description Clients The form is set up with drop down boxes for task and description and the clients is a multiselect listbox. This form was...

Pat, Excel allows me to select columns that way but when I place it into Access it does not allow me to do it. I can not link the spreadsheet because there will be a different one each week and I wouldn't want to relink them each week. I'm assuming I will have to go with Surjer's idea and...

I have a spreadsheet that I'm importing into a table using TransferSpreadsheet. We are recieving this spreadsheet from a client and do not want all the fields imported into our system and I want to make this as fast and user friendly as possible. I know to set the range argument you use...

Thanks Wayne that was exactly what I was looking for.

I have a listbox set up on my form which lists all of our employees. I also added a "Select All", "Select All Canada" at the top. Is there a way to check which item was selected as soon as the user selects an item. What I want to do is as soon as the user selects "Select All Canada" I want...

Thanks Pat that's what I figured but figured I would ask anyway just in case there was something I didn't know about.

I have two identical tables in my database and I need to do a sum of certain records from both tables so I created a union query to pull the information from the two tables. Now I need to do a sum of the records from the union query. I know that I can create a seperate query to look at the...

I was wondering if Access keeps track of any changes made to a database. I'm having problems with a database that someone before me created. Some how records are magically disappearing from tables and a field in certain records in another table are magically being changed. So I'm wondering if...

SubRoutine(rst![Field Name])

I would definitly be interested in that. I've done quite a few projects like that before.

I'm not trying to change someone's web page. We are data-entering customer info into a form. We need to do a credit check on the customer so we need to fill out a form on a web page. To receive their credit score. The web form asks for a lot of the same info our database asks for. So I'm...

I was just curious if it's possible to take information typed in a form and paste it into HTML. We need to data-enter customer info into our database but we also need to enter info into a form on web page. The web page is not ours so I can't set the page up to send the info to access. Is this...

I've found the problem and fix just in case anyone else has this problem. When office was installed on the user's computer it did not place the DAO dll in the correct place. If you download COM Explorer from www.4developers.com you can view any problems with any of the DLLs on your computer...

I have a database setup to track daily tasks. When you open the database a login form automatically opens with a drop down box of names and a textbox for passwords. When one of my users opens the database he gets the error "Method 'Recordset' of object '_form_sfrmLogin' failed. Error...

I figured it out. I had this code in the before update event of the frame. I placed it in the on click event and it works fine. Thanks for your help.

I get that error when I set the focus first. If I set it after I get the original error.

I don't have any loops in my codes.

If I do that I get the error "You must save the field before you execute the GoToControl action, the GoToControl method, or the SetFocus method.

I have a customers form and in the form header I have a frame with 2 option buttons. I want the user to choose to either add a new record or search for a specified record. The search works fine but the DoCmd.GoToRecord , , acNewRec doesn't work. I get the error "You can't go to specified...