Search results
-
N
Using * variable to change set the property of multiple controls
Using * wildcard to set enabled property of multiple controls So I'm using the following code to check if a field has data in it, and if it does, it's enabled property is automatically set to False on form load. Private Sub Form_Load() If Form![PID1] = Null Then Form![PID1].Enabled = True...- Nangasaur
- Thread
- Replies: 11
- Forum: Modules & VBA
-
N
Update multiple text boxes in a report from a single table field
I did a google search on the error message I was getting, and found a post on another forum from "Bob Larson" (yay! hi there!) describing what I needed to do to fix my relationships and explained the primary key/foreign key stuff enough for me to understand it. My only question with it is... -
N
Update multiple text boxes in a report from a single table field
Okay, I've made 5 separate tables: Customers - Contact details only MedData - Medication data (lot numbers and expiration dates of the medications) Vest Insp Log - Logs all the inspection dates (DC1 thru DC16 for the time being), Who did the inspections (PID1 thru PID16), and next... -
N
Update multiple text boxes in a report from a single table field
I'm separating them into records for individual customers. For instance, the example one I left in the database I uploaded is just "John Doe". In the database I'm actually working with, it contains over 300 records (Each record is a specific person), but I deleted all those to upload to here... -
N
Update multiple text boxes in a report from a single table field
Certainly. For now, I've gone with the mundane and primitive approach of hiding and unhiding boxes on my form, depending on if data is present or not in their associated fields of the table that stores the data. It's working the way I want it to, somewhat, but I really don't like it and it... -
N
Update multiple text boxes in a report from a single table field
Okay so here's where I'm at again, after falling asleep last night with this on my mind. Using SetProperty function in a macro that fires on load of my VestCardUpdateForm, I'm telling it to do this: [Init1] Is Not Null SetProperty Init1Box, Visible, 0 And Similarly for all my boxes. I... -
N
how to associate label in different sections?
Sounds similiar to what happens when you make a tabular layout for controls. If you create a text box in the detail section, it makes a label next to it. If you then go to the control layout, and click tabular, it moves the label to the page header, with the text box control to the detail... -
N
Update multiple text boxes in a report from a single table field
No :) Not trying to enter data using a report :) I was merely trying my best at describing my predicament per the posting guidelines. I want my Report to mimic exactly what our paper-form does when we do it by hand. I dabbled a little bit today in using a subform, before I read your reply... -
N
Update multiple text boxes in a report from a single table field
I'm very new to access, mostly self taught through modifying templates and getting the results I want through lots of trial and error. I've created an access report to basically mimic a DA Form (Deparment of the Army) that records equipment inspection dates, who did the inspection, and when...