Search results

I was under the impression that subforms could not be used in continuous forms? Good idea, i'll be sure to implement this sometime. Those values are calculated via a module and not directly edited by the user. You are correct that TaskNumber keeps the fields in order. Those fields were...

From Table "WorkOrder": PR# WO# Rev# Customer TaskName RequiredDeliveryDate Complete From Table "WOTasks": Description Quantity Material From Table "TaskOrder": Shop Previous Next CalcTaskNum Notes Ready (Hidden, used for conditional formatting) From Table "Task Complete": Complete Comp Date...

I have already set up the junction table (TaskComplete) :P When the task is entered the field "ready" is given a value of yes or no (its a checkbox). If its a yes the data is highlighted to show that this step is ready to be created. The table "TaskComplete" has a record that corresponds to each...

I don't have unused fields in my tables... My main form is based off of the WorkOrders table. I had created subforms from queries that pull the data from the the WOtasks Table and the TaskOrder table to show only the tasks that correspond with a single process. (I think that this is my...

The table named WorkOrders shows just the work orders alone. The next table (WOTasks) contains the part names/information that relates to the all processes done on said part (essientially this is just an intermediate step for the 3rd table). All this table does is go "Hey part Top Clamp is apart...

It's entirely possible I've messed them up... This is my first "large" database. So... here it is! Let me know if you need anything else! Users Enter in the Work Order information. Using that key in the WOTasks they enter the parts. Using that ID links to the Task Order table where the...

OK, full explanation.. I am working on a database which manages the creation of transformer clamps and cores. Each clamp/core is given a work order number which contains information about the customer, the price, the due date and such. Each clamp/core has multiple parts which go through a set...

Using subforms was actually a work around for a different problem. Everything is divided into work orders. Each Work Order contains a number of parts that have different shop processes done to them to create the part. This form shows which work order each process is within. So what I was...

Hello, I'm working on a form that needs to look similar if not the same as the report that contains the same information. When building the reports I was able to sort the data so a value that applies to many entries appears only once at the start of the corresponding group of entries. How can...

Actually, the question still holds...

I seem to have answered my own question... Turns out once i turned snap to grid on, it looked OK!

Hi, I'm working on a report where the users want grid-lines between rows and columns instead of the alternating colors. I've searched the UI, but can't seem to figure out how to create a grid. I've tried using borders around the field and making the borders touch eachother, but I find the...

I was looking into this earlier and I couldn't find a way to create multiple sections (other than the detail, header/footer and page header/footer). Is there a way to create new sections?

Thanks for the help, Ill be sure to implement this soon. I've got 1 other questions to ask you... Is there a way to expand a form larger than 21 inches?

Hi, I'm working on a scheduling system for my fathers company that automates some redundant tasks. Most importantly the system manages the order of processes on different parts (ie, part "tubes" may be cut, then drilled, then welded, then shipped). I'm trying to create a form that allows for...

Sorry for the lack of detail in the initial post - wanted to get something posted before heading for my lunch break. Anyway, that was what I was afraid of (having to use subforms). I'm working on a scheduling system for my fathers company that automates some redundant tasks. Most importantly...

Hi, Is there a way I can add more sections to my form? For example right now I have a section named "Header", "Detail" and "Footer". Can I add my own?

Ah, thankyou again. Saved me hours of frustration. :P

Hi BluIshDan, That works! Should I be using that syntax for my field searches?

Hi everyone, I'm fairly new to programming in general and have been working on a database for my fathers small company. The database is set up to automate the entry of new Work Orders and in turn set up the routing (order of events to be done to each part) for print. I'm working on a module...