Topics Search

Select All Forms In VBA

Select All Forms In VBA
Views: 13
Please can someone tell me if there is a way to select all open forms in Access in the same thinking that Screen.ActiveForm selects the active form.

I want to run code to change the format of all open forms dynamically
Sponsored Links:

Similar posts...


VBA for opening different forms

VBA for opening different forms Icon
I am creating a HR database with forms such as Incident, Investigation, Hazard, Non conformance, appraisal ect. I need queries so that each report can be somehow found without having to go through all the data. I have created a form called "searchcentre" where I have placed unmanaged Combo boxes and text boxes so to help with the queries, ie Name, date, location. This all (to my knowledge is working fine)

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.

on close event select listbox x item data. how?

on close event select listbox x item data. how? Icon
I would like to have a form close and on the form that remains open select a row in a list box. not really bothered which row(as there is only 1). I thought it would be something like this

on click event
select [forms]![frmClientSalePaymentScreen]![lstToPay]![ItemData]

I dont really have a clue about vba but im trying

What causes Inconsistent Behavior of VBA Global Variable?

What causes Inconsistent Behavior of VBA Global Variable? Icon
I declare these global variables:
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
7) Else
8) [Forms]![select Radford Jobs]![RHI Job] = ""
9) [Forms]![select Radford Jobs]![LOC] = ""
10) End If
11) End Sub

Renaming a Form Stopped my VBA from Executing

Renaming a Form Stopped my VBA from Executing Icon
Recently, I renamed my forms and my tables to have numbers in front of them (mostly to establish a temporal order in my forms). I had a code which worked when the form names didn't have numbers in front of them.

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?

SELECT in VBA Access (small db)

SELECT in VBA Access (small db) Icon
I want to invoke a small SQL statement to select datums from a table and pass that onto a string variable. Note I don't mean to dump the entire table into VBA but just 1x1 field, one at a time of course.

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

VBA coding for forms and command buttons

VBA coding for forms and command buttons Icon
I am completely uneducated when it comes to access and VBA programming. I do have some programming knowledge but that is limited to the classes that they have taught us in engineering school.

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.

Hide x Forms

Hide x Forms Icon

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

Where does VBA comes in

Where does VBA comes in Icon
I have made a couple of databases and tried to apply the 1st, 2nd and 3rd Norm as much as possible.
So starting off with the business concept, making tables, queries, relationships, entry forms, overview forms, reports and the like, I always struggled where and when to use VBA. I seldom use any macro's.

VBA to select record in listbox based on textbox value

VBA to select record in listbox based on textbox value Icon
I've been reading up on selecting records in a list box using VBA but so far I can only find details of selecting a record based on counting how many there are.
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.

ms access and maybe its VBA

ms access and maybe its VBA Icon
all, I need some thoughts here. I pick up a small side job, so I thought. When I first open it was access. When I tried to see all the objects, it just had the queries and tables. So when I install the complete application the forms came into play. So then my next thought the forms are hidden. Bottom line I could not find any forms or macros. When I look a little bit closer I found that the task bar is completely different. So now I am thinking maybe VBA and MS Access combined. Could that be possible? Now this was created in 1999.

Would there be any way I can see how the forms were designed?

As of right now I am just looking at the end result of the form and trying to see how it all came together from the tables and queries.