Search results

Yep. I have tried that. Preview of the report is no issue and even printing. I think she is having some sort of user limited rights. It says she is a "standard" user and not an administrator. As a test, I saved a word document and then tried to save it directly to her C:/ and it would not...

I did what you said and it is the do.command it is stopping on: DoCmd.OutputTo acOutputReport, "DailyCoffeeReceived", acFormatHTML, "C:\myreport1.html" It is as if it is not allowing the user to save the or output the file to the designated C:\ destination. Could this be a permission thing?

It is happening on the docommand line. It just doesnt make sense it is only on her computer and not others.

We have an access database that roughly 10 people use in Access 2010. We recently had a new employee join us and she is unable to run 2 different events that convert a report into an html document and send it in the body of the email. It works for everyone else but she gets this error when she...

Its 2 fields in one table. Populated by a form. How do I simply add up all the inner box and outer boxes that are the same in both fields for a whole months worth of data? Thanks!!

I am not sure if this is a table or a query question. Basically, I have an access database that we use for work that we enter in our production daily. We enter the number of units and enter the materials used per unit as well as other data. One of the materials we use are obviously boxes for...

I know this may sound weird. I am trying to generate a lottery type system. Basically in the NBA, the last place team gets 250 lottery balls put in, second to last gets 199 balls, and so on. I am in a fantasy football league and we are trying to design something similar for the end of the...

Well. I never got a response so I decided, at least for the time being, to make the Enter Data to Table button to close the form and then reopen it. Here is a sample of the code if any one has a similar issue and needs to reload their form to have their entries update: Private Sub...

Hey guys, It has been awhile. For some reason, I cannot get this to work. It is something I thought I had working, but now I cannot get the fields in the form to update if I complete a certain lot code number for a certain selection unless I close, then reopen it. I have attached my...

Has anyone had a chance to look at this? I am still having issues with showing the received quantity that has not been used yet. If anyone can help, I would really appreciate it. Thanks!!

That is a lot of coding for my knowledge. I have a sample or part of the database that I can show you. I am able to run a query based on 2 other queries that will show me the amount of material (FILM) used since received in using a 3%shrinkage calculation. My problem is, it only shows the...

Hello all, I have a Table that we receive a material into with a quantity or number of items received in. Everday I enter into a Form the daily production. By selecting the material used, I made a query to show the TOTAL amount used during a selected date range. This all works fine. I...

nevermind, found the Control Tip Text to type it in.

Yeah, this works great! I have one other question is there a way to make a popupwindow (small) to occur when the cursor is over the Product Description field? This would explain to "double click for new entry" Thanks again!

Ok, but I must warn you. I didn't create this db and the naming of tables and labels are not done correctly. I cannot send the whole db because it is too large zipped and it has some confidentiality info. Thanks for looking into it! Just go to the form, Receiving Entry: Box/Bag...

I tried subbing the names into the code you wrote, but could not get it to work. Here is my row source: SELECT [Drop Down Box - Inner Box].[Boxes/Bags] FROM [Drop Down Box - Inner Box] ORDER BY [Drop Down Box - Inner Box].[Boxes/Bags]; My form name is: Receiving: Boxes/Bags What can I...

THANKS PAT!!! It works just like you said it would.

Yes, the row source is a table that has only box type in it. What do I enter in as far as code for the NOT IN LIST event so it will add an entry to the box type table and requery the form? Thanks again Pat!

Yea, not sure where it is. Do you know of an example of what the code may look like and what I should change it to? I still want the ENTER button to record to table. Here is the code for the ON CLICK of the button: Private Sub Record_Production_To_Table_Click() On Error GoTo...

I have a Table Box Selection that contains all the different types of Boxes that we could receive in and use for production. When a box is received in, there is a form that I enter in the box receive date, the type of box, the box lot code, etc. When I go to the box type field in the form...