Search results

I posted here previously on another matter (hiding a subreport, if) and that was resolved. The issue I now have is on the same report (but a different issue). The QCcheck subreport is cut off the main report when the ingredient list is too long. I've tried so many different combinations of Can...

Hello, I will try my best to explain. I have a main Recipe report that contains two sub reports (one sub report contains the list of ingredients needed, and the other sub report contains the QC checks needed for the recipe). Both of these are linked to the main report with parent/child...

Access 2007: on Data Entry Form, this is what I hope to accomplish: If I choose [90ft Line] from ComboBox on main form, then limit my choices on Items Subform ComboBox to include only those items from [90ft Line table]; OR if I choose [80ft Line] from ComboBox on Main form, then limit my...

(Running Access 2007; limited understanding; trying to pull data together for a report) My dilemma: I have an Item# that has a production standard that may differ based on how the production line is run - (i.e. Item 1234 Prod Std 5; Item 1234 Prod Std 3 and so on). There is a production...

I'm missing something somewhere but don't know where. This is what I typed in a query parameter (Access 2007). I tried adding/removing parenthesis and spaces and brackets with no luck. Total: ((IIf([ProdBatch_Type] Like 'Batter*',[ProdBatch_Weight]*[ProdBatch_Number_Batches]*0.9 OR...

Hi All! I'm using Access 2007. I am a beginner - no formal training just trying to figure it all out; and willing to learn. What I want to do is create a report that I can use to pull data by a date range. This is the data I need (columns) in the report: #Days worked / Minutes available /...

I want to enter start times and stop times for each process done on multiple production lines. The data to be entered includes: StartTime, EndTime, and ProcessCode (Process codes being: "producing", "down time", "lunch time", "changeover", etc.) We want to see where the time is being spent...

I have a combobox on a subform with a recordsource from a query. The query includes 2 tables - Toppings and Toppings_Items. I am assigning multiple toppings (subform) to an item on the form. The hiccup is that I can't get the combobox to sort by the part/topping description. It is sorting by the...

I have forms that are printed based on a query parameter of [enter item number]. There are several of these forms that I would like to print at one time (with one command) making it easier for the user to gather their information at the beginning of the day. I also don't want to lose the ability...

I want to be able to edit fields on a record in a form and then when I go to the next record - to NOT be able to change the data on the previous record. Is this done in the "On Current" form property? What would I enter? Something else to keep in mind is that I want to be able to go into this...

I'm using a form to select a date range. Using the following, and entering start date of 6/1/14 and end date of 7/1/14 I would expect to pull the records with a date of 7/1/14; however it doesn't. I have to enter and end date of 7/2/14 to pull 7/1/14 records. Any advise please...

I have an "Returns" master form that contains two subforms. The subforms contain items that we are returning back into our inventory. The underlying queries in each subform show only those records where the "Return Date" is null. The query(s) works fine, except that if there are 3 items that...

I have a command button which uses a macro to open a form for the user to enter an invoice. Here is the macro info: F_Invoice, Form, , , , Normal Since I don't want the user to be able to open an invoice that had already been entered the query has a parameter of InvoiceDate = is null. This...

Hi Folks - I'm wondering if it's possible to kick users off the database after it has not been in use for a certain amount of time? Thanks!

Is there any way to require data into a field at the FORM level and not in the table?

Hi all. I thought I had this problem resolved from previous posts, but as it turned out when I started adding data I found it didn't work. So, I went to an existing database template and modified it for our use. However, there are two things I can't do and I'm guessing it's in the structure...

Hi Folks - could someone please direct me to where I can get some understanding . . . On a form field I want to use the property event "after update" code builder. (Essentially I want to make a field "null" when I make an entry in another field.)

Hello. I'm stuck on how to accomplish this. We have material that we're selling by the container. The material is loaded into a labeled "container" and labeled "lid". We want to know which container and which lid is shipping to which customer. The customer then returns the container and lid and...

I have a table with an auto number PK. This table will contain orders. I'd like to use the PK from this table as the Invoice number on the invoice. I'd like to have it start at a number other than "1" just because it looks better on an invoice. I don't know how to do this. I looked at the table...

We have an Items table (item number is PK) that contains general information about an item (color, weight, description, etc.). There are also Production tables which allows us to enter the Item number and a depositor (both PK) so that we can enter different settings (however, in the same...