Search results

Hi all, I know this is a simple thing but I've absolutely forgotten how to do it. When creating a form and adding new field, how do I have the label in the header and the text box in the Detail? Having a total brain fart. Thanks, Tim

Hi All, I'm trying to design a query to run on a command button (cmdGetResults) on a form after a user has selected two dates: each from a different control (i.e,, txtDateTime1 and txtDateTime2). Once the two dates are selected, I'd like to click cmdGetResults and have a report open with the...

Hi All, I'm designing a DB for the quality assurance department of a steel manufacturing plant. The primary data collection is from inspections of materials and products as they are delivered, rolled, welded, painted, fabricated, etc. The challenge is that all of the various TYPES of...

Hi All, I don't know how many times (over the past couple of years) I have written the next sentence (lol): I work for a steel manufacturing company in QC. I developed an inspection database in Access 2016 to collect our daily inspections and provide reporting on activities. The inspections...

Hi all, I'm trying to create a report for manufacturing inspections by job number. Our job numbers look like this: A762502001. The first five characters (e.g., A7625) are the actual job number. The next three (e.g., 020) is what we call the Task. The last two e.g., 01) are what we call the...

Hi all, I'm not up to snuff with error handling and am wondering if anyone could point me to some tutorials. I've googled and there are a lot of tuts for Excel VBA error handling and not very much for Access. I did find Allen Brown's page but am hoping for something that would go in to a...

Hi All! It's been awhile. :) ....and now I'm in need of your expertise again. The Manufacturing Quality Inspection DB has been performing well (even though I'm thinking of replicating it and modifying the design ...but that's a different discussion). But yesterday, out of nowhere I began...

Hi All - A legacy database that I've been "gifted" with managing is returning an error on two calculated fields when I open it. Actually when I open the report, "Calibration Due Report," from the Main Menu, I am first presented with an "Enter Parameter Value" "Format$" msg box. I click ok and...

Hi All - I've inherited management of a legacy DB at work. The DB was created by a gentleman who is of course no longer with us. On top of that his naming conventions leave quite a lot to be desired and the DB itself is ponderous to put it lightly. In any regard, I have a form (Calibration...

Hi All, I have a form that has a text box that is meant for inspection notes. When I try to save out of the form I get an error message whenever the notes include a hyphen, comma, etc. This is a problem as it is routinely necessary to add a fractional dimension in the notes (e.g., 1/4"). How...

Hi All, I am havnig an issue with a hyperlink not wanting to remain a hyperlink after data entry in a form. I have two tables we'll call Table1 and Table2. There is a field in Table1 called "Photos" which is formatted as a hyperlink datatype. If I have Table1 open I can paste a link address...

Hi All - In our mfg inspection db, I enter new (upcoming/not yet started) jobs. Basic data will include scheduled start date. This may be next week or four months from now or something random like 37 days from now. In other words, not every 3 months, 6 months, etc. I would like to have Access...

Form1 has a command button that opens Form2. Form2 has two buttons on it, I want one of the buttons to be invisible when Form2 opens. Here's the code: DoCmd.OpenForm "frmLineStop", acNormal, , , acFormEdit, acDialog, Me.txtInspectionEvent_PK...

Hi all - I have a table, tblInspectionEvent, that has many fields - one of which is Notes. The PK for this table is InspectionEvent_ID. I have a form used for data entry for Notes. It is opened twice - always - at the beginning and end of an event that may take a few minutes or a few days...

We have alphanumeric job numbers that all start with an uppercase letter - currently "A". Typical job number looks like: A732802001. Only the first character is a letter and I want it stored as uppercase. I have lazy typing sidekick coworker who routinely types a lower case "a." Aside from...

Hi All - I have a mockup db attached. It represents our real world workflow needs. There are two tables: tblCampingTrip and tblTripDetails. tblCampingTrip has a field named MiscThoughts. How to populate that field from a 3rd open form is the subject of this post. There are three forms that...

HI all - super simple mockup attached. Two tables, two forms. Tables are related via the CampingTrip_ID field. The value of CampingTrip_ID is passed from one form to the other via OpenArgs and converted to a Long before being entered in the field control on the second form. The user opens...

Hi All - I have the following code that serves as the Record Source for a report: SELECT tblinspectionevent.datetime, [jobnumber] & [task] & [resource] AS Job, Operator.firstname AS Operator, tblinspectionevent.bundlenumber...

Hi All - I have a main form that has a bunch of command buttons on it that open various types of data entry forms for various types of process inspections. The main form is bound to tblInspectionEvent. All of the various inspection forms each have an underlying table that is linked to...

Hi all, I have a form (frmGetAString) with an unbound textbox (txtUnbound) on it. That same form has a bound textbox on it named txtStringID which is bound to StringID in tblOfStrings. The user enters a 6-character alphanumeric string (StringName) from the real world into the unbound...