Search results

All: I created an access database almost 2 years ago that was functioning fine. A key query started giving me an Enter Parameter Value error a couple of months ago without me changing anything. If I make other queries around the same tables, they work but if I duplicate this query, it does...

All: I've been trying to figure out what the issue is with a query of mine that is not updateable. I have a training database and my query is pulling from 2 tables. One table is the records table with employee number, name, course, department, date completed, etc. The parameters of Name...

All: I am trying to create a training tracking database. I have a table that has the workgroups and the courses assigned to each group, a table with employees and the workgroups that they belong to, and a query that deletes all records and repopulates in a record entry master table based on...

I'm having an odd issue where my date will not recognize the year when I use "Between" in my query. Just a quick rundown of the issue: The original date from the ODBC connection is in a short text format. I used CDate to convert it to Date/Time. However, now when I type in a month after...

Hi: I have a query that references a linked table's dataset to filter the datasets down. The issue I'm running into is that I cannot update any of the items that are not in the linked table, because the dataset is filtered by the linked table. Is there any way around this? Thank you

All: I'm trying to filter a query with the between function, however there's something wrong with the date format that makes its implementation bring up the following error: "This expression is typed incorrectly, or it is too complex to be evaluated." I had to derive the date from a longer...

I have a field in a query for [Consume Date]. I've formatted this field as the following: ConsumptionDate: Format([Consume Date], "mm/dd/yyyy") When you build Date()-1 you get yesterday's date. However, when I build [ConsumptionDate]-1, I get #error. Why can I not subtract 1 from this...

Hi all: I am having an issue on some data collection that I was hoping I could receive some assistance on. I have a data collector that checks the temperature of a piece of machinery in my plant 4 times per second. The machinery goes in cycles which create a curve in temperature going down...

All: I'm currently building a database which has numerous entries for physical formulas for two tanks. Each formula has a start date, but no end date. The end date is actually the next start date for another formula. So, there may be formula HEN010717GG10 with a start date of 1/7/17. I may...

Hi all: I have a calculated field in one of my tables that I am using in a query. For some reason, while the number has decimal places in the table, it is rounded in the query. I cannot figure out why this is occurring. Has anyone else experienced this, and how did you fix it? Thank you

Hi: I have, what I think will be, a rather complicated question. Hopefully its simpler than I anticipate. I'm developing a database in which the user will order materials based on a preset schedule. e.g. A product may run from 03/15/17 to 04/03/17, (15/03/17 for the European users). There...

Hi All: I have a form called [frmNewData] with multiple subforms in it. All are data entry forms. Among these, I have one called [frmProducts] of which I enter a new product number and name. Another form I have is [frmRecipes] which needs the product field populated with an existing product...

I'm having an issue where I've created a report that needs to be exactly two pages. On the top of the first page, I have two sub reports that can grow, and at the top right of the second page I have another sub report and a check box, (made of squares), at the bottom right corner. In all cases...

Hi all: I'm having an issue with a report I want to print double sided. I used the following vba on an a button: Private Sub Command109_Click() DoCmd.OpenReport "rptBFForm2side", acPreview Reports("rptBFForm2side").Printer.Duplex = acPRDPHorizontal End Sub The issue is that the back...

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

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

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