Search results

I have a form that shows our manufacturing schedule. It has a sub query in it that you select which operation you want to preview the data for. It loads the data in another sub query in which I have a button that will print that data. The sub query on the left is labeled qProdHrs5bRS2. The query...

I have searched all over but can't seem to find a definitive answer as to what is going on with this form. I'm preparing to roll out a new version of our database and when testing it on another users computer I find this issue with the subforms. On my computer everything lines up nicely. On the...

We have a table that is an ODBC connections from our erp system. Any time a new sales order is added into the erp system I need the ODBC table to also create that record on another table. We will call it Engineering sales order table. I've googled and cannot find this answer. Is there a way to...

We currently have an access database that's used by 10-15 people. It controls all of our engineering jobs, quoting jobs, as well as the metrics we report for these functions. The next step is to add our manufacturing schedule into it. Within the past year we've started getting issues with the...

I have 4 revised ship date columns, an est ship date, and an actual ship date. I have a column summing days late for est ship date and one summing revised days late. The expression I am having problems with is to calculate the total days late for the revised. I want it to check the 4th revised...

We have a database that I am taking over that controls all our jobs through engineering. We are adding some functions for manufacturing currently. I could just go add the new fields to the main table but it is really starting to have a lot of fields and is getting cumbersome to navigate. What I...

We have a chart that is showing jobs by customer. I'd prefer it be in a pie chart but it's way too many to read. We changed it to a bar which is much easier to read but it displays the percentages as 100% for everything. I cannot figure out how to change it. Can someone please help me with this?

I am creating a report from a database we have. Each item has a product code. I want to list each product code as one item on the report and then it display the average number of days it takes to design that product code. I have a field that has the product code as well as the days for each...

So I have a continuous form and I have a button that is pressed when a job is released and it record a date in a field. I wanted to turn that button to disabled after pressed but after lots of reading found that it couldn't be done in a continuous form due to it disabling all buttons :banghead...

I have 2 dates that I need to count between. Easy enough just use the datediff right? Nope cause it won't count just the 5 workdays. I researched and found that the "w" in the function doesn't work the way I need it to. I found lots of code to make a module that will do it for me and they all...

I have a query driving a report that fills in the on time or late based on comparing the release date to the production due date. The code works except for if we haven't released it yet and the release date is void. I need it to then check versus today's date and then populate the late/on time...

Let me start off by saying I am new to this so go easy on me. I have a form that I cannot get to act like I think it should I have a date (duedatetxt) that calculates (=DateAdd("w",14,[Approval Date])) off of an approval date (Approval date). Now I have a text box (text25) that I use as a status...