Search results

I have a query that I am trying to build, that joins 2 other queries together. There is one field named "Value" and the actual values in that field are populated based on a field named "Name". So in the Name field, I want to pull "Sheet Length*", "Sheet Width" and "Sheet Count" and have the...

I have a linked table in my access database, that is an excel file with built in links to PDF's by item. In my access database, I created a form where I select the item number and it opens that item in the table so I can click on the link to the PDF for that item. However, the links won't...

Start Date and End Date with specific times I am trying to write a query, which will pull all records from a start date that is user defined, with a specific time and an end date that is user defined with a specific time. For example, I want all records with a [Start Date] say, 10/29/2017 and...

I work in a mill, and our shifts run from 6:45am to 6:45pm. Our production dates, recording dates are from 6:45am until 6:45am the next day, we are a 24hour operation. How do I write in a query that I want to pull information from 6:45am yesterday to 6:45am today? I have a sample field that...

:banghead: Hoping to get some help with this one. We have a company that designed a Quality system for us, but didn't build any of the reports, so I have been left trying to figure out the different queries to run these reports. Here is my latest issue: the company built a quality table...

Our company is pushing out a company wide production & quality system, this is going across 4 different sites. In the SQL server tables, the date/time field shows up as a date/time field, however, in my ODBC linked table access database, the date/time field somehow got switched to a text field...

:banghead: I am trying to update a data entry form our lab techs use. I have Min LOA and Max LOA based on a table. On the entry form, the lab techs select the overall base paper, and this fills in the Min and Max LOA values based on the base paper they select. On the form, I am trying to use...

Seems simple, but for some reason I'm struggling. Trying to set up a report based on a table (being fed by a query). One of the fields is "period" or month. I want the period field to go across the report then sorted by "line" with other vaious information under each period going across. No...

I have what I hope is a simple question. I have a form, in which various people have to use to enter data each day, several times a day. I have been experiencing a lot of errors in their entries and was hoping I could use some conditional formatting to make things stand out to them when they...

:confused: It's always something for me. I have a combo box on a form (cboBrand). I am trying to figure out how, based on whichever brand is selected, how to fill in process high, low and targets for various tests. Normally I would use the Column (1) etc stuff, but unfortunately, I have more...

:o Okay. I have a frustrating one. This is embarassing to me, because it seems so easy. Anyways, I have a form, where a person could select up to 3 different months and up to 3 different paper types. These combo boxes are listed in the criteria of those fields in my query. If I use the...

:confused:Okay, here is one that I'm struggling with. I have a form used for data entry. On that form, one of the fields control source is set to do a calculation to give me a ratio. I noticed this value now doesn't go into my data table. So, I created a text box, and want to set that value...

:confused: Hi everybody. I have started trying to be a little more creative and making my systems a little more what the big boss where I work would like to see. I have set up an Access Data Page, with one form on it where the user would enter some required information, which is saved into a...

I have a query that currently calculates a rating based on various values entered into the database. This rating corresponds to a Quality Index value based in another table. I tried to set up a query that links the rating value in the query to the Rating in the table, however, when I run this...

I think this should be simple, but my mind just isn't functioning today. I have a form that people have to enter information in every hour. It has a lot of repetitive information to be entered each time, for example, they are supposed to enter their initials or name so that we can track them...

:confused: I have a combo box on a form that is used for data entry that allows the user to pick the date. This is based on a table that includes date, week ending date and month, all very specific for our business. I used a function that says Me.txtBox=ComboBox.Column1 for example. So my...

I have a form that our operators use to do their hourly quality audits on. This is getting to be a huge burden on them because right now, they enter the date, the week ending date, the month every time they have to do an entry, and for me it is a nightmare because they can still enter the wrong...

I have several forms that our machine operators have to enter data into several times during their shifts. The question/suggestion was brought up as far as having the date automatically fill in based on the time they enter on their screens. However, the tricky part is we use date based on...

I have several forms that our machine operators have to enter data into several times during their shifts. The question/suggestion was brought up as far as having the date automatically fill in based on the time they enter on their screens. However, the tricky part is we use date based on...

:confused: I have a table, that records various information about cartons by date and lane and carton type and product type for those cartons. In the lane fields, there is 11 of them, it records the number of cartons with specific issues (tears, globs and fallbacks). I am trying to run a...