Search results

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

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

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

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

I have a production form that I enter data into daily. On this form, I have a combobox that autopopulates a lot of the fields. I have also designed a command button for each material used that I can click and update some of my receiving of materials tables. I will click this command button...

I have a sample of my database attached. In the sample, I have a Receiving table that gets updated when a material (Boxes/Bags) is received. I tried to create an update query so that I could run it on open of a form. This update query will run so that when something is received or...

I am running an update query on an "On Load" macro for a form. Is there a way to get rid of the 2 message pop ups stating that you are about to run a query, click yes and how many rows will be updated, click yes? Is there a way to bypass this and automatically run the query and make yes be...

I have an update query that I need to be ran on open of access or a particular form in access that gets updated daily. I know I could get a command button to run the update query, but I was hoping to avoid this and just have it update automatically. Thanks!

I have a material Receiving Material Table that gets updated based on entries when material is received in each having a specific lot code number. I also have a Daily Production Form that I enter in a customer's materials used. As of now, when a customer's material is used up, I go to the...

I have created a form that based on a selection in an item code combo box, I have roughly 10 items that autofill. This works fine. One of the fields that autoupdate is FILM. The issue I am having is, I want the FILM to update another field, FILM LOT CODE. I created a combobox and can get...

This may be a real simple thing to do, but for some reason I am stuck. We receive a material in and have a quantity and material lot code that we begin with that gets entered into a form and populates a Receiving Table. When the material is run for a given product, I type into a Daily...

This may be a real simple thing to do, but for some reason I am stuck. We receive a material in and have a quantity and material lot code that we begin with that gets entered into a form and populates a Receiving Table. When the material is run for a given product, I type into a Daily...

I don't know if this is the wrong way to go about this or not, but here it goes. In our Access database, I have figured out a way to have a certain material get received in access the day it was received with a lot code number. I then input daily production and have a form setup to pull the...

I have an auto fill for a form to update other form fields after the selection. Once this selection is made for a certain box, that box field then auto fills its box lot code field on the form. For a certain box, there are multiple lot codes in the table. Is there a way to tell the SQL query...

I am curious if there is a way to put in a production date in an entry on a form and have a cell auto calculate a julian date or a specific code date for a customer. for example, today's production date would be 11/26/08. The Julian Date would be Yddd - Y('last digit year of date...

Our access database at work is connected to a network. When I open it (before anyone else) I can make additions, save changes, etc. As soon as anyone else opens the database, I no longer have the rights to make changes or save edits. Is there a way to prevent getting "bumped off" or...

I was wondering if I could use a calendar to run a report. Currently, I click on the report and it asks beginning date and end date. Is there a way to use a calendar pop up to select the beginning and end dates instead of typing it in? Thanks for the help!