Search results

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

CDate() was the perfect solution. Thank you! :)

Here's an example of an imported date 2017-10-24 08:59:01 -04:00

I'm getting #Error when I try to subtract 1 from either the Consume Date or the Consumption Date. Is there a way to work around the string issue? I'm drawing this data from an ODBC connection and the field giving the date and time also gives me the #Error.

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

For some reason, when I rounded to 3 decimal places in the original table, it brought back the decimals in the query. I can't say why this happened, but the query is somehow fixed. Hopefully I develop a better understanding. Thank you for your suggestions.

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

I thought I would clarify a bit more. Say these are recipes for sandwiches. and I currently have a chicken sandwich in table1. table two has the elements available, so it would have "bun", "Chicken Patty", "Lettuce", "Tomato" as entries. Table three has the recipe, so column one would have...

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

Perfect! Thank you so much!:)

Perfect... I figured there was an easy solution. Thank you!

The issue with this is that when I do it, the sub-report doesn't cut off at the records and bleeds into the footer. When it is set to 'Can Grow', the form takes the final full record before the footer and begins with the new record on the second page.

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

I ended up solving the issue by making a delete and append query to update a table with the IDs I want. That way, I can link the original table to the appended table and make editable forms. Thank you for your help. It was much appreciated. :)

The issue with this is that it shows all records for the tank. The purpose of the query is to find the last record for the respective tank. Essentially it hopefully will work like this: I make a new batch in tank 2, let's say with an ID of 8 There will be a block representing tank two on the...

I've made the tanks into a separate table per your request.