Search results

  1. C

    Issue with combobox autofill

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

    Report to show a query result and a table result

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

    Report to show a query result and a table result

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

    Making a form populate two tables

    I know I have said this before, you are smart as heck. Thank you again for the help. This definitely works!!
  5. C

    Making a form populate two tables

    i put this in the criteria field under Product Description in the newly created query. It highlights the SELECT and gives an error. Is there something I am doing wrong? Do I need to enter it somewhere else? Thanks.
  6. C

    Making a form populate two tables

    I will try to attach the sample. I cannot send the whole database due to privacy with customers. In the database, you should see the table that gets populated, Boxes/Bags: Receiving Log. (Forgive me, this database was written by someone else in 1997 that had no idea what the rules were as far...
  7. C

    Making a form populate two tables

    The issue I am having with either one of these examples is that I am only pulling from 1 table and these examples are pulling from 2. Do you know of a simpler way to go about it? Is there a Criteria I can enter in the Query that will only show the last 3 most recent entries for a material...
  8. C

    Making a form populate two tables

    Ah. I see. How exactly could I run a query to make the condensed view to show the 3 most recently received Lot Codes of each material? Thanks again for your help.
  9. C

    Making a form populate two tables

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

    SQL to use specific lot code for a field based on a Yes Selection in another field

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

    Julian Date or Other Code Date

    Where do I enter this in?
  12. C

    Julian Date or Other Code Date

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

    Calendar select date to create a report instead of typing beginning and end date

    Again, you have helped me. Thank you for the quick responses and feedback. You sure know what you are doing in Access. Thanks
  14. C

    Access Editions made by only creator/password

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

    Calendar select date to create a report instead of typing beginning and end date

    Thank you for your help on this. It took me a while to get exactly what to do, but now I understand that the Query goes to the calendar form which then I can preview the report after I select the date ranges. I have a new question. Is there a way to get the start date and end date selected...
  16. C

    Calendar select date to create a report instead of typing beginning and end date

    How do I get the calendar to pop up when I run that query. All it is saying is Forms!frmCalendar.txtFmdate for the beginning date and Forms!frmCalendar.txtFmdate for the end date. If I type the dates in, it will still work, but I want to use the calendar pop up to select the dates. thanks
  17. C

    Calendar select date to create a report instead of typing beginning and end date

    Thanks for the replies. Sorry about this, but how do I actually get the report to use this for the beginning and ending date selections to generate the report? Basically, it is a report that generates from a query I built with a Production Date Field that is pulling from a Daily Production...
  18. C

    Calendar select date to create a report instead of typing beginning and end date

    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!
View older results
Back
Top Bottom