Search results

Currently, I only have the Tanks as a Lookup Wizard, (Enter your own), column. However, it would probably be best if I did make them a separate table to track the different sizes. I will go ahead and do that... Especially if it helps with this issue.

I've attached a sample Db with just the two tables concerned. What I want to be able to do is create a form for each tank to attach to the opening Form so that the user can change the status or change the data for the current run of each. As you can see when opening the query, I cannot update...

Hi All: I have what should be a simple issue. I'm making a database for a department that has 20 tanks to put product in. I have a table called tblBatchRun in which data is filled in for each tank including status, date etc. On my opening form page, I want to have pictures of each tank, and...

I'm sure this isn't a new issue, but my calculations are doing some strange things. I have a query in which the following calculation is done: ([eQuantity]*[tQuantity])/minUnits As an example, the following are the associated numbers eQuantity - 9.519 tQuantity - 1 minUnits - 1 This should...

Hi All: I have what should be a simple formatting question. I have an entry page with multiple columns. If the user enters one item into cell D4, then depending on the product the user only has to fill in certain cells below. I made a conditional format that looks up a table on another sheet...

Evidently there are 170 database connections when I run the report. I was actually able to fix my particular issue by taking one of the Union queries and changing it to a regular query with an elaborate if/then statement to replace the separate unioned queries. It actually took it from 170...

Hi: I'm having an issue after splitting a public database. As a precaution I chose to split a shared database on my company's shared drive to ensure the data would not be corrupted. Within this database, I had a report based a Union Query and within this report, I have a button which has the...

Hi all: My company recently upgraded to Office 2013, which has ostensibly made all of our Access databases currently unusable since we used the pivot chart feature in all aspects of our operations. I've been charged with the task of fixing this dilemma, particularly before our quality audit at...

I've tried creating pivot charts in Excel by linking my Access query, and then inserting the excel sheet into Access as an object. However, when I insert the object into the form and open it, it only allows me to make one filtering change and then freezes. This is highly problematic, as before...

So, I'm going to have to make an append query to store the data I want to delete into a separate table and use that table as the basis for my update criteria from which to delete archived data? It's a long way around, but I agree in that it's the simplest solution and seemingly the only one.

Hi all: Hopefully this is a quick fix. I'm trying to create an Update table for an Audit database and I am receiving the error in my title. I'm not certain what makes this different than other update queries I have made. As an example, the following update query worked: UPDATE tblTarget...

I changed the ActionDueDate to: IIf([ActionReq]="Yes",CDate(DateAdd("m",2,[DateComplete])),""), which for my test row returns a date of 7/20/2015 The compliant formula is the following: IIf(([ActionDueDate]<Date()) And ([ActionDueDate]<>"") And ([ActionTaken]=False),"Overdue","Compliant") I...

Hi all: I know this likely has a really simple solution, but I've been coming back to it for days now with no success and I feel like I'm going mad trying to figure it out... so here goes. I have a database with a table tblSOPAudits. In this table there is a "date completed" column and two...

I was able to find a work around for my particular purpose. I created an update for my appended table that finds records not in the ODBC table. Then I created a delete query that removes those records from my appended table. Then I just inserted a button that does the three functions of...

the outer joins do not work. I still cannot edit. When I outer join to the ODBC, no data comes up and when I outer join to the tblTargets all the appended data comes up, when all I really want is the data present in the ODBC table. In all scenarios, the system will not allow me to check the...

Hi: I am having an issue with a query not being able to be edited. I created a database with an ODBC connection to my company's Warehouse Management System. However, for purposes of auditing product from specific sections, and the ODBC table being unable to be edited, I created a new table...

Hi: What I would like to do is to create a calendar wherein shift schedule dates following a particular pattern are highlighted, (or dates off are highlighted). I also want it to understand the different shift switched to. Essentially the pattern is work 5 days on 1st shift, have 2 days off...

Thank you so much! I know how I'm going to do it now. Use the left function make a table and then query off of that table connecting the color key with the left column. I really appreciate all of your help.

I'm still not certain how I would be able to coordinate with my other table. For example, if I have only 4 records so far: Georgia Green 8:00AM Horizon Blue Georgia Green 7:36AM Slate Blue 5:22pm And my table with the colors looks like: Color_Like Color Georgia...

I assumed that was the issue. However, with the format of the excel page I'm linking to, it would never come up. Essentially, the page actually has a drop down in which the colors are located and they choose one. However, often they unlock the page and put notes. For example, when changing...