Select All Forms In VBA
I want to run code to change the format of all open forms dynamically
Thank you for taking the time to report an issue.
What's wrong... Please write below.
on click event
I dont really have a clue about vba but im trying
Seeing as I have multiple forms, I have created a Combo box containing the form names for the user to select, and would like to create a VBA code for a button placed at the bottom so If Incident report, then open "incident report" If Hazard, then open hazard" ect.
I am only new to VBA and am a little unsure on how to do this, and every thing I try doesn't seem to work.
1) Option Compare Database
2) Option Explicit
3) Public strLOC As String
4) Public strCode As String
5) Public strJCodeKey As String
Load them with this code:
1) Private Sub RadfordMatch_Click()
2) strCode = [Forms]![View RHI Job Pricing Master]![Job Code]
3) strLOC = [Forms]![View RHI Job Pricing Master]![LOC]
4) MsgBox "You will now be selecting matches for this position: " & strCode & " - " & strLOC, vbOKCancel
5) DoCmd.OpenForm "select Radford Jobs", acNormal, , , acFormEdit, acWindowNormal
6) End Sub
And then when a "select" flag is toggled on the following form the fields get copied to the form:
1) Sub Select_Flag_Click()
2) Dim strFlag
3) strFlag = [Forms]![select Radford Jobs]![Select]
4) If strFlag = -1 Then
5) [Forms]![select Radford Jobs]![RHI Job] = [Form_View RHI Job Pricing Master].strCode
6) [Forms]![select Radford Jobs]![LOC] = [Form_View RHI Job Pricing Master].strLOC
8) [Forms]![select Radford Jobs]![RHI Job] = ""
9) [Forms]![select Radford Jobs]![LOC] = ""
10) End If
11) End Sub
I have trouble finding how to use SELECT statements within VBA in a simple context as mine surley is. The fact is, the table contains the names of every checkbox in a form, I want VBA to get those names from the table, see if they = TRUE, and then APPEND to a new table (which, thankfully docmd.runSQL works for). It just seems much cleaner than having to pour in sixty control names into the VBA code.
I've heard about using querydefs but they seem way outside the scope of my application, which is small
However, upon adding numbers to the form names (and trying to update the VBA respectively), the VBA no longer executes.
Run-time error '2450'
Microsoft Office Access can't find the form '13-frm_Transportation' referred to in a macro expression or Visual Basic code.
I've been running into this type of problem with of my forms -- VBA code which previously worked, but referred to other forms in some manner (include opening said forms), no longerwork when numbers are added into the form names!
I've got to ask: does Access not like people to put numbers in their forms? What is the correct syntax for referencing to forms in this manner?
I am also looking for some clear and concise resources that I can look at for reference.
I have an initial start up page where someone in any division can go and select their division from a combo box. What I want them then to be able to do is click one of the forms (New Entry,Edit Entry,.).
For the form New entry I am looking to open the form with the division name to filled into a text box. I also would like to have that box that box also correspond to a field in a the table for a new entry.
Can anyone tell me how to select a record based on its value.
Eg I have txtbox1 which contains =Format(Now(),WW) to give me the week number.
I want to look that week number up in LstBox1 and select it using VBA.
Got a lil problem. I want to lock down my dB after inactivity. working good. But if one clicks on the dB they can see what is on the screen (but not do anything as the prompt is modal!). Coolie. But, they can still see. So I want to hide the forms. Great, so hide any form. Problem is, how would VBA know which forms were open. It farts (breaks) if any one form is not loaded and viola, lockout does not occur. Ooops.
So, I tried a multitude of conditionals but I can not seem to get it to consider what is open and what is not before invoking actions on the forms which renders a error if said form is not open.
How can I get VBA to understand what forms are open, so it may hide them?
Matt L - new father, drunk, and OCD
I'm able to get the query to run if I limit the list box to only one selection, but if I enable the multi select to Extended and run the query it returns an empty record set.
I apologize, but I'm not as tech savy/smart as most and I've not used VBA so I'm not able to translate someone elses code to suite my purposes.
I wanted to attached a copy of my database in order for you to see what I'm trying to accomplish. But I am unable to upload any files to this forum site, I keep getting an error message
The only way to do that (than I seem to think of) is to use VBA and change the SQL of the query making it an append query.
So this query would be changed back and forth in VBA. Is this the right way to do thisand common practice or do I need to look for a different solution?