Making All Forms Available To VBA

Aug 21, 2007

Good evening,

I am trying to use VBA to address a field in three different subforms on a form. When I am in the VBA environment writing the code, I noticed that only two of the subforms are listed in the Project window on the upper left. I ignored that and wrote the code anyway, and when I execute the code, it works fine for the two subforms in the Project window, but when it gets to the third subform, it throws this error:

"MS Office Access can't find the field '|' referred to in your expression."

The code is this:
Private Sub Test_Number_AfterUpdate()
[Form_Consumables Entry].Test_Number.DefaultValue = [Form_Test Director Panel].Test_Number.Value
[Form_Squawk Entry].Test_Number.DefaultValue = [Form_Test Director Panel].Test_Number.Value
[Form_Event Log Entry].Test_Number.Value = [Form_Test Director Panel].Test_Number.Value
End Sub

Can anyone tell me how to make all of my forms available to VBA?

Thanks!
Erik

View Replies


ADVERTISEMENT

Forms :: Making Forms Invisible When Code Is Running

Jan 12, 2015

I'm opening forms to get data then closing using VB code.

Is there a way to stop the screen showing these forms as the code runs

something like Display refresh off then display refresh on.

Just to hide my workings.

View 1 Replies View Related

Making Forms Show Relevant Records

Apr 3, 2005

I have been able to successfully solve the problem of my pages showing relevant records by using form control.
How should I make my form display a new record everytime I open it? So, that when a lame user opens it , he wouldnt change the existing data on an existing record. How to solve this problem?
Kindly help. thanks

View 11 Replies View Related

Making Access 2000 Forms, Non Editable

Jul 17, 2006

Could anyone out there tell me if it is possible to make the output on an Access form read only.
I want to be able to input information as records, but when it is saved I don't want it be able to be altered.
Mainly I am saving recipes on a form, and I don't want my children to be able to add anything to a record once it has been saved.
Thanks in advance
Ken

View 6 Replies View Related

Forms :: Making A Field Grow In Size?

Jan 26, 2014

I have a subform that shows notes entered but if there is more text in the field then you cant see it all. Can I make it so that this field will grow so the whole input is visible or can I make it so when you click on it it opens in a larger window showing all the txt?

View 1 Replies View Related

Forms :: Making Directory - Runtime Error 13

May 25, 2014

I'm getting a runtime error 13 on this line of code. Its a piece of code to make a directory, but I cant see anything wrong!

Code:
strBackUpDogNameFolder = "c:GPandDetectionDogTrainingLogBackUpsandReports" & Forms![frm_Profile]![Discipline] " & Forms![frm_Profile]![DogName]"

View 8 Replies View Related

Forms :: Making Object To Appear On Button Click

Jul 3, 2014

What vba code would I use in the on click event of a command button to make another button appear?

View 10 Replies View Related

Forms :: Making A Control Have A Fixed Position?

Sep 26, 2013

Is it possible to make a control have a fixed position so that when the form is vertically scrolled the object stays in the same position?

I have a continuous form that shows records based on criteria that the user puts into an earlier form. There is a close button on the page but you cannot see the close button if you horizontally scroll too far along the page. You have to horizontally scroll because of the amount of fields that are on the form.

View 2 Replies View Related

Forms :: Making Cascade Combobox With 4 Comboboxes?

Dec 2, 2013

I want to make a form where i have 4 comboboxes in a cscade combobox thing.

I already made 4 tables with info.

- My first table contains devices:

- ApparaatID (Primairy key)
- Apparaat(with 4 entries)

- My second table contains if it is hardware or software:

- TypeID (Primairy key)
- ApparaatID
- Type (where I entered hardware and software in 2 different entries)

- The thirt table contains operating systems:

- OSID (Primairy key)
- ApparaatID
- TypeID
- OS_versie (where I entered all the OS I want to enter)

Now I made a form I called problemen with 4 comboboxes.

- cboApparaat
- cboType
- cboOS
- cboProbleem

1) What I want is that when you select device 1 and 4 that cboType can select both hardware and software but with device 2 and 3 you can only select software.

2) If you have selected software is cboType I want you to be able to select 1 of the 11 OS I have pre-entered in the table.

3) That you get specific problems with the previous made choices. For example if you select Hardware in cboType, thta you only get problems with hardware to select from and the same with software and OS.

4) I want a textbox, that will contain the solution of the problem you selected and that if there and several solutions that you get all of them at once.

View 13 Replies View Related

Forms :: Hiding Parts Of A Form Or Making Them Greyed Out?

May 15, 2014

hiding parts of a form if a option button is selected. There are two option buttons and two parts to the form. I would like each part of the form greyed out or made invisible depending on which radio option button is selected.

View 14 Replies View Related

General :: Multiple Forms And Making One Form Primary

Jul 15, 2013

I have got 3 forms, and at the time of running, I want to make one primarily one form to be showing up and the other 2 to be hidden or closed, and the primary form will have 2 buttons, and clickning respective buttons should be able to open another 2 respective forms.

At the moment am using, DoCmd.OpenForm "Form1", which works fine, but am confused in brining the form 1 only to be shown at the first most time.

View 2 Replies View Related

Forms :: Making Data In A Field On A Form Appear If Content Is Not Null

Dec 31, 2014

I have a subform with continuous records. One of the fields in the recordset of the subform is a field named "Remarks". This field does not need to be visible on the continuous subform as it is rare that this field will have any entries.

I plan to apply conditional formatting on another field (IDcardNo) in the record line of the continuous subform so that when field "Remarks" contains any data it will show as a different format on the field IDcardNo.

I would like to make a small form appear when one points to the IDcardNo field with the different format, so that the data in the field "Remarks" pops up when one points to the field IDcardNo with altered format, showing that there is data in the field "Remarks".

View 3 Replies View Related

Making Specific Fields In A Current Record Copy Themselves When Making New Record

Mar 28, 2005

;) Hey everybody,

I am working on a database used in recording device characteristics/test information. The main table of information has dozens of columns for test/part detailed information. When inputing the data for each specific test, many of the info. details are repeated when testing say 20 devices of the same part all at once. Rather than retype every piece of detailed information in every field, everytime, is there an easier way? Does anyone know of a way to make specific fields copy/paste the previous record's information in the fields automatically when a new record is created? Please, if anyone could help or has ANY ideas, let me know...

Thanks

gunwax

View 9 Replies View Related

Database Creation And Testing Complete / Will Making It ACCDE Clear Everything Except Forms

Feb 7, 2015

I've created and tested my database. What step or steps do I take now to make it so it's a program that only shows the forms and menu's I created, not all the Tables, Queries etc and the formatting options? Is there a link that explains what to do step by step?

View 2 Replies View Related

Forms :: Making Textbox Visible On A Form If Checkbox Is Checked On Same Form

Aug 30, 2013

I am having a problem with making a textbox visible on a form if a checkbox is checked on the same form. I have done research on this site and have written the code below, but I am getting a Syntax error, see yellow highlight.

- My checkbox is named: Case is a Readmission from WRCA IP to WRCA IP
- My textbox is named: Date of Current IP Admission (I have defaulted this textbox to not visible).

Here's the code I have written:

Private Sub Case_is_a_Readmission_from_WRCA_IP_to_WRCA_IP_Clic k()
If Case is a Readmission from WRCA IP to WRCA IP =true then
Date of Current IP Admission.visible=true
Else
Date of Current IP Admission.visible=false

[Code] .....

View 14 Replies View Related

Forms :: Requery Form After Making Changes In Another Form

Sep 17, 2014

I have a form that shows a companies engagement with our company. If someone wants to edit the details of that company (address phone number etc...), they click the "edit" button, which then opens a form where edits can be performed.

After the edits are done, the user clicks a save and close button which runs docmd.runcommand acCmdSaveRecord, and returns to the companies engagement form.

When I return to the company engagement form, I would like to see the companies information reflect the changes that I just made. Currently, I can only do this by exiting the form and re-opening. I have tried using Me.Requery in the OnGotFocus, Activate and Current events to no avail.

I should mention that I have a company combo box with multiple columns that are used to display address, postal code, etc... in textboxes on the same form.

View 1 Replies View Related

Making Me See Red!

Jan 25, 2005

On my database I have a text box that accepts a map grid that starts with two letters. If the letters arnt within certain perameters then the box turns red and a message box appears informing the user of this. My probem is that I am using a continuous form and if one box goes red, they all go red if the grids are OK. my code is below, can anyone help?


Private Sub Grid_BeforeUpdate(Cancel As Integer)
If IsNull(Me.Grid) Then Exit Sub
If Me.Text289 = "UK" Then
Select Case Left(Me.Grid, 2)
Case "ST", "SY", "SU", "SZ"
Me.Grid.BackColor = 16777215
Case Else
MsgBox "Invalid Biagram for your chosen Database.", vbExclamation
Me.Grid.BackColor = 225
Cancel = True
End Select
End If
If Me.Text289 = "Germany" Then
Select Case Left(Me.Grid, 2)
Case "MB", "NB", "NC", "MC"
Me.Grid.BackColor = 16777215
Case Else
MsgBox "Invalid Biagram for your chosen Database.", vbExclamation
Me.Grid.BackColor = 225
Cancel = True
End Select
End If
If Me.Text289 = "Desert" Then
Select Case Left(Me.Grid, 2)
Case "NJ", "NH", "NK"
Me.Grid.BackColor = 16777215
Case Else
MsgBox "Invalid Biagram for your chosen Database.", vbExclamation
Me.Grid.BackColor = 225
Cancel = True
End Select
End If
End Sub

View 1 Replies View Related

Making An Exe

Sep 20, 2005

i developed a program and i used ms access for the database.
i compiled the program i made.
the question is, can i install the program i made into another computer eventhough it doesn't have a ms access? because i tried to install but it doesn't work at all. what do i need to do in order to make it work.

your response is greatly appreciated.

View 3 Replies View Related

Making Graphs

Apr 18, 2006

I am not sure where to post this so could someone please move it to the appropriate area thanks.

I want to make a graph that will show how many employees are in the company for each year (Going back 10 years and keeping up to date) I have never done this before and our teacher feels that its best if we learn on our own (basicaly he's an idiot).

How do I go about using the pivot chart?

I have made a query which adds up the total number of employees at the current time.. but apart from that I havent a clue. I want the graph to have the years on the bottom and numbers up the side (1,2,3,4,5 etc) and then the number of employees that were in the company during that year will be plotted.

I will use a table that is to be used for archiving to mke the query as it will have all the employees who were ever in the system record.

The table is thus:

Employee_ID
Emp_First_Name
Emp_Surname
Age
Emp_Home_Number
Emp_Mobile_Number
Emp_Address_1
(so on and including postcode)
Date_Started
Position_ID

I have no idea what to do other than to rename the axes and change the increments, but they are jsut numbers, no dates or anything.

Any help apreciated.

View 6 Replies View Related

Making A Dictionary

Dec 11, 2006

Does anybody know if its possible to export data from Access into a "filename.LEX" file for use in MS Word?

If so - Do you have any idea what the fieldnames/file structure looks like.
I have tried oipening a .LEX file to check this out, but with no success.

Thanks

View 4 Replies View Related

Error In Making MDe

Nov 15, 2007

Hi guys,

I am having error message when I tried to make my mdb file to mde. The error message is "MS Access unable to create an MDE database". Reading through the help message it says that this problem always occurrs in trying to compile large db into MDE. So what can I do to solve this problem. Also what is MS access memory capacity. thanks

View 6 Replies View Related

Who Is Making My Backups

Apr 14, 2008

:mad:Is there anyway, I can tell who is making my backups. Is there any thing I can use to find out who is creating a backup. I have sent out emails to the users, but no one will confess who is doing yet. I have 200 users now. I have talk to our IT people, they mention it would take a lot of there time to track it down.

Does anyone know if there anything I can do?

Thanks

View 14 Replies View Related

Making One Column The Sum Of Other Two

Jan 3, 2008

Hi!

I have a table called "products"

One column is "Unitary Price", another one is "Quantity" and another one is "Tax"

And I want another column called "Total" that shows:
Unitary Price*Quantity+Tax*Price*Quantity

Is this possible to be made?? :( I'm a bit newbie to MS Access, so try to explain as most detailed as you can! For example, if I have to write [Unitary Price] between brackets... I tried doing this on the "Default Value" field of the column but I couldn't make it.

Thank you!!
Luis

View 9 Replies View Related

Making Totals Of All, Except For One

Sep 12, 2005

I'm trying to make totals in a query, but instead of using all, I need to leave one out, how to do that? for example the table looks like:
A 2 3
B 4 6
C 2 5
D 3 5
E 2 3
How can I leave row 1 out? So that the query will look like:
11 19

View 2 Replies View Related

Help Making A Form...

May 17, 2005

This is probably a stupid question but could you please tell me how i can set up a form in access to look similar to the one in the attached picture?

View 4 Replies View Related

Making A Mde File

Oct 12, 2005

:confused:

Hello I have a small DataBase with 4 forms (Access 2002)

1. frmMainMenu
2. frmAddEmployee
3. frmAddEmployeeRegion
4. frmEmployeeStatistic

The MainMenu calls the other 3, when I execute the mde file the only form opened is the frmAddEmployee! it should open the frmMainMenu because this one calls the others....! I've tried several times....the same result!

Any idea what I'm doing wrong?

Thank you

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved