Search results for query: *

Hi I created several charts, one for each employee showing their monthly prgress within a six month period. I have a form on my switchboard that has each employee's command button that when clicked will show their personal chart. The problem that I am having is that when I click on one of these...

Hi I have a report that I would like to insert a chart based on three fields from a table I created. The fields being Month, Office Repairs, and Plant Repairs. I add the information for let's say September with 54 Office Repairs and 23 Plant Repairs. I also have the months October, November...

Hi I have a report that I had done in my database that included a chart, but everytime I open up the report or go from design to print preview state, a message box opens and says "Preparing to Install" with Windows Installer as the heading. How can I stop this from happening so I can just open...

Hi I am trying to create a query that will pull information off of two tables. Table one and table two. In table one, I have two fields, scraps and repairs. In table two, I have two fields, scraps and repairs. The tables are from two different department. What I want the query to do is add...

For some reason, all of sudden when I open my database, Access hides my database window. I have to click unhide everytime I open it. Is there some way I can have Access open my database window without having to click unhide every time I open it?

I have a combo box that lists different values based on a search. I would like Access to display the contents of each record listed in the combo box on the same form. I have in the After Update procedure of the combo box the following code, however it doesn't work. Can anybody tell me what I am...

I have a database that is on my C drive that I deal with all week, adding, deleting, updating. Anyway, our company has a network drive as well. For security reasons, I added a switchboard that has two reports on it and posted that in the network drive and it gets updated once a week. When a...

I have a search form that a user can search four ways, RMA, NCT, JOB, and DWG. Then when a user clicks on search, Access displays the results in another form labled "results". Example: I type in 456 under DWG, click search, and I see the results on the results form. This works great! However, if...

Hi everyone!! Can anybody tell me what I am doing wrong? I have this statement in my code and I keep getting "run-time error 424, Object Required" Any help would be greatly appreciated!! Thanks! Forms_SearchResults[cboNDW].RowSource = "qrySearch

Does anybody know how to add fields to a combo box, then display the information when an option is selected?

Can anybody give me a syntex for adding records to a combo box after a user performs a search? (Access would then place the matching records in a combo box for the user to choose which record he or she would like to view.) Then be able to click on a record in the list to view its contents?

I have a search form with four items in which a user can search by. I have another form in which it displays the results. I have a combo box on this form so if more than one record has the certain, let's say "drawing number" on it, the combo box will list all the records that has that number on...

I keep getting a "run-time error 3061 Too few parameteres. Expected 1" when I use the following code. Set rs3 = dbOpenRecordset ("SELECT * " & _ "FROM Employee_Scrap_Log " & _ "WHERE Employee_Scrap_Log.[NDW#] = '"& me.NDW.Value & '";") Can...

I have a search form that displays the results in another form called results, however the problem that I am having is that there could be more than one record with the number that they are searching by. So, right now, it will only display one record when I need it to,... say list the ticket...

Hi I have a form that when filled out needs to save in two seperate tables, by saving the info in the one table (we'll call it the info table) and calculating points into the other table (we'll call it the points table), which it is successfully doing. In this form, I have a field "Expired"...

I get a run-time error message 424 object required using the following code and I'm not sure why. rs = db.OpenRecordset("Select * " & _ "FROM Plant_Employees " & _ "WHERE Plant_Employees.[Clock#] = " & Val(Employee_Scrap.[Clock#]) & ";") Does...

I have a drop down menu box with several options. For some of the options, they have specific activities to do so I listed those in my code specifically. However, for the other options, which are 12, there is only one thing for all of these to do. In my code I put: If OperationName.value <>...

I have a code where when executed an error of too few parameters in the following sql command pops up: Set rs = db.openrecordset("Select * " & _ "FROM Plant_Employees " & _ "WHERE Plant_Employees.[clock#] = " & val(clock.value)) Is there...

Hi I am working on a code for my database through a form and I starting receiving a run time error as follows: Run-time error 3734. The database has been placed in a state by user "Admin" on machine "HMeyers" that prevents it from being opened or locked. Does anybody know what this means...

Hi I wrote a code in VBA for my Access database. When I fill out the form in which the code is in, Access runs through the code with no problems when I save it, however I get a message box that says "You entered an expression that has no value." I have worked the last two days trying to figure...