Hiding Access Main Form/tables/queries/forms/etc
Thank you in advance for any and all assistance.
Is there a way to hide the Main Access window with tables, queries, forms
On Sat, 17 Jan 2004 17:17:16 -0600, "PMBragg" <email@example.com>
>Thank you in advance for any and all assistance.
>Is there a way to hide the Main Access window with tables, queries, forms
Yes. Take a look here for some API code that will manipulate the
Another way, with probably less control than the...Forms question
I'm new here and am a neophyte Access 2000 user/developer. A year
ago, I barely knew what Access was. I was asked by the people that
pay us to begin keeping certain data about the children's crisis
program I manage. After a couple of years doing this by hand on paper
(Yikes!), I decided that this was ridiculous. Out of neccessity, I
had to learn Access and develop a database to track clients and
services. So what I know, I've learned from places like this and from
the many text books I've picked up. I developed the database and
entered almost 3 years of data. We av...Forms and Form
Hi everyone !
1) An example from help:
"Each Form object has a Controls collection, which contains all
controls on the form. You can refer to a control on a form either
by implicitly or explicitly referring to the Controls collection. Your
code will be faster if you refer to the Controls collection implicitly.
The following examples show two of the ways you might refer
to a control named NewData on the form called OrderForm:
' Implicit reference.
' Explicit reference.
The next two examples show how you might refer to a ...Sub-forms of Sub-forms
I'm creating a data-entry form for 3 tables. There is a one-to-many
relationship between table1 and table2 and a 2nd one-to-many between
table2 and table3. What I would like to do is have the user select
from a combo box on the main form a record from Table1. That would
filter the subform on the main form to just the records from Table2
with the PK from Table1. I've got everything working fine up to this
point, but am a bit confused on where to go next.
I need a mechanism for the user to pick one of the records from Table2,
and be presented with an entry for for all records in Tab...Form
I have a table TBL_NAMES : IDNAME , Name_person , ETC..... (15
I have a second table TBL_POINTS : IDPOINTS , LINKNAME_PERSON ,
POINTS_ALGEBRA , POINTS_GYM , etc.... (25 courses)
I have made a form where all the names are listed and when i click on
a name another form is opened with that persons name on top and a
number of labels and textboxes where i put those points in. So far
no problem. BUT... i want one record per person. So the next time i
click on his name i would like to see those points and be able to
change them but i must not be able to create a new record. T...Problem with Totals on Sub Forms and Main Forms
I have an access data project (MS-SQL Svr 2000 backend and MS-Access 2003
Front End) that has a sub-form based on a query view. On the sub form I have
several column's in which I have a running total on the sub-form footer.
This part works fine.
My problem is that the main form, on which the sub-form resides, I want to
display the total from the sub-form total calculation. I have tried
referencing the control on the sub form, i.e. My.Somecontrol =
Forms![formname].[controlname] but this does not work.
How do you make this works. Do I have to do something different because this
is ...Display recordcount of a sub form in a main form
I am using A2 for this database.
I have a main form with bound fields of FlightNumber and FlightDate
I also have a subform. This subform takes details of a passanger along
with other details. I also have a textbox called status in subform.
When a passanger's details are entered, status value is set to
"confirmed", when passanger calls in to reconfirm flight, status value
changes to "Reconfirmed", and when passanger calls in to cancell
his/hres flight, status value is set to "cancelled". Sometimes, status
textbox may also have a value of "Wait...Limit Sub Form records based on Main Form
I have an option group called Issue_Type on my main form
F1_Member_Demographics_Main. When I select one of the 3 options on the
main form from the option group Issue_Type I want to limit the sub
form F2_Member_Issues records based on the combo box Issue_Code_T1.
Option Group Issue_Type on main form:
Combo Box on sub form:
So if I select Complaint from the option group on the main form I only
want to see Complaints on the sub form etc.
Thanks in Advance
> I have an option group called Issue_Type on my main form
> F1_Member_Demographics_Main. When I select one of the 3 options on the
> main form from the option group Issue_Type I want to limit the sub
> form F2_Member_Issues records based on the combo box Issue_Code_T1.
> Option Group Issue_Type on main form:
> Combo Box on sub form:
> So if I select Complaint from the option group on the main form I only
> want to see Complaints on the sub form etc.
> Thanks in Advance
Forms!MainFormName!SubFormName.Form.Filter = _
"Issue_Type = " & Me.Issue_Type
Forms!MainFormName!SubFormName.Form.Filter = True
> BEETHOVEN wrote:
>> I have an option group called Issue_Type on my main form
>> F1_Member_Demographics_Main. When I select one of the 3...Mulitple Main Forms Created by Sub Form Entries
I'm hoping this is a problem just because I'm a beginner at Access,
and so someone can help
I have created a database of companies, with a subform for contacts.
It worked perfectly until I got more than one contact for a company!
If I add a 2nd contact to the subform, when I go back into the
database, Ive got 2 records of the main form for the company, with the
Its not adding a second record to the company table, that just says I
have 2 contacts attached, which is what I want.
How do I stop the record, when I view the form , duplicating its...Continuous Forms with sub-form
I have a need to create a form containing schedule detail with a sub-form
containing a crosstab of date detail. I would like to display it as a
continuous form so the user can see related schedules together with the
dates. Is there a way to get Access to do this? It won't allow continuous
forms with sub-forms. Filling unbound controls on the main form only show
the current record's date information. I would prefer not to use a big
un-normalized temp table.
On Wednesday, December 18, 2013 7:10:34 AM UTC-6, Ron Paii wrote:
> I have a need to create a form containing schedule detail with a sub-form
> containing a crosstab of date detail. I would like to display it as a
> continuous form so the user can see related schedules together with the
> dates. Is there a way to get Access to do this? It won't allow continuous
> forms with sub-forms. Filling unbound controls on the main form only show
> the current record's date information. I would prefer not to use a big
> un-normalized temp table.
Use a datasheet?
Ron Paii wrote:
> I have a need to create a form containing schedule detail with a
> sub-form containing a crosstab of date detail. I would like to
> display it as a continuous form so the user can see related schedules
> together with the dates. Is there a way to get Access to do this? It
> won't allow continuous forms with sub-forms. Fil...form access to form excel
How may I pass in VBA a value from a control in a access 2003 form to
a control in a excel 2003 form ?
I try this but it does'nt run: (oApp=word.application)
oApp.Forms("saisie").tbnom.Value = Form_Form1.tbnom.Value & " " &
...Main Form / Sub Form search issues with combo boxes
I have a main form "Customers", with two sub forms "Items" & "Transactions"=
The forms are all linked through the key fields of ShipDate & AccountNum. T=
ransactions form is linked to Customers, and Items is linked to Transaction=
The account number combo box in the header of the Customer form functions f=
ine. I have combo boxes on the headers of the subforms that work when used =
on the subform alone, but when used as a part of the Customers form, they w=
ill not work correctly. The Transactions subform has an Invoice # combo box=
, and the Items subform has a Sequence # combo box.
I cant get the records in all 3 forms to display the intended record when u=
sing the subform search boxes.
The VBA for the controls is shown below.
Customer Form (Main)
Private Sub cboFindAccount_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs =3D Me.Recordset.Clone
rs.FindFirst "[AccountNum] =3D " & Str(Me![cboFindAccount])
Me.Bookmark =3D rs.Bookmark
For the Transaction subform
Private Sub cboFindInvoice_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs =3D Me.Recordset.Clone
rs.FindFirst "[InvoiceNum] =3D " & Str(Me![cboFindInvoice])
Me.Bookmark =3D rs.Bookmark
For the Items subform
Private Sub cboFindSequence_AfterUpdate()
' Fi...Making MS Access Form as a standalone form like in VB
Well, its sames difficult for me; I love access so much and wish to make
it perform extra task. I prepared an HTML form but can not connect it to
my access table and so I think it is possible to make an access form a
standalone form for user input. Can anyone assist. My mail add is
*** Sent via Developersdex http://www.developersdex.com ***
Oscar, why don't you just code up a VB form for user input and connect
it to an Access backend? To my knowledge, you can't force an Access
form to exist outside of Access. Your users would have to open the
Access file to ent...Accessing data from one form from main form in Visual Basic 6
How do I extract data from a form into the main form for processing? For
instance, I have several image files in a form called images(images.frm),
indexed from 0 to 99, and I want to import these into a variable array in my
main form, main (form1.frm). How do I code a control to get these images
into an array in my main form from the images.frm?
> How do I extract data from a form into the main form for
> processing? For instance, I have several image files in a
> form called images(images.frm), indexed from 0 to 99, and
> I want to import these into a variable...Form size question with Access forms, remote desktop, and MS Surface Pro
I know this is a stretch to ask this question, but:
We have an Access 2010 application hosted using Remote Desktop. When
we access forms from the desktop they look like they should. And from
an iPad. However, a client is using their Surface Pro the forms are
so tiny that she can't use them when accessing our application "on the
cloud". Otherwise, they look fine on a Surface Pro when running it
off the cloud.
Does anyone have an idea? I do not think there is anything that the
people that are hosting our software can do.
On Monday, 29 February 2016 17:30:11 UTC, PW wrote:
> I know this is a stretch to ask this question, but:
> We have an Access 2010 application hosted using Remote Desktop. When
> we access forms from the desktop they look like they should. And from
> an iPad. However, a client is using their Surface Pro the forms are
> so tiny that she can't use them when accessing our application "on the
> cloud". Otherwise, they look fine on a Surface Pro when running it
> off the cloud.
> Does anyone have an idea? I do not think there is anything that the
> people that are hosting our software can do.
It will cost you, but have a look at a program called "ShrinkerStrether from Peter's Software (http://www.peterssoftware.com/ss.htm)
This should shrink or stretch forms and all their controls to match the scr...first form is ignored, second form is forms why?
Does anyone recognize this situation and know what causes it ?
The page starts with just a search form. When you do a search the page
now has a search results form, a save botton, and the search form at
the bottom. There is also a link to add another form with a
dropdown. If you add the third form the page has the search results
form, the form with the dropdown and the search form, in that order.
The save button is set to submit the search results, which is always
forms. If the page has all 3 forms, it works fine. The first form
is submitted,and it is the correct form. If however, the ...Populate key from form to sub-form
I'm trying to figure out how to bring the key field from a parent form to
populate the corresponding field in the sub-form during data entry, or to
filter sub-form records during data viewing and updating.
Can anyone help me?
Bob Mikels wrote:
> I'm trying to figure out how to bring the key field from a parent form to
> populate the corresponding field in the sub-form during data entry, or to
> filter sub-form records during data viewing and updating.
> Can anyone help me?
Use the subform's Link Master Fields & Link Child Fields properties.
See...calling a form sub from another form
This might sound simple, but I'm stumped.
In essence I have a 2 form app that connects to an SQL db and extracts info
from it. This works fine. The problem is with my 2nd form.
The 'run through' is that the user can select an inv no from a combo box on
form1 and when they select one, I auto-extract info from a db relating to
this inv no, concat the various data fields with 2 other text fields
(contains footer info) that are on form 2 and present it in a large text box
on form 1. This also works fine.
The problem is that the user may be previewing the large text box da...Link Pop up Form to main form
I have a main form and use a combo box to open a pop up form. The
combo box lists customers and only one customer requires the fields
that are found on the pop up form.
I can get the form to pop up however I do not know how to link the pop
up form data to the main form record.
On Oct 16, 6:54 am, CJONES <craig...@hotmail.com> wrote:
> I have a main form and use a combo box to open a pop up form. The
> combo box lists customers and only one customer requires the fields
> that are found on the pop up form.
> I can get the form to pop up however I do not know how to link the pop
> up form data to the main form record.
What else does the combo box do? Does it select a record for editing,
the majority of whose fields reside on the main form? If that is the
case, then you could set the rowsource of the popup form to the
rowsource of the main form. Store the rowsource of the main form to a
string variable and pass it in the openargs to the popup form. In the
pop-up forms' form_load event, assign it to the popup forms' rowsource.
On Oct 16, 11:22 am, OldPro <rrossk...@sbcglobal.net> wrote:
> On Oct 16, 6:54 am, CJONES <craig...@hotmail.com> wrote:
> > I have a main form and use a combo box to open a pop up form. The
> > combo box lists customers and only one customer requires the fields
> > that are found on the pop up form.
> > I can get the form to pop up however I do not know how to link t...Linking Pop up form to Main form
I have a main form with a combo box where if a specific customer is
selected a popup form opens and additional information required for
this customer is entered into the form. Data from the main form and
popup form is stored in the same table. I have a field called
certification that I would like to use to link the forms.
what you need to do is to open the popup form in dialog mode (which is
probably already the case). In the popup form you need to add a public
property (Get) and assign it the desired value. Note: a form is just a
class module except that it has a graphical user interface (GUI - the
GUI thing happens way under the hood for Access).
In the popup you can create a public property anywhere in the Form's
code module (not a standard module or standalone class module). In my
sample I am setting a Certification property to a Long datatype. If
your Certification is a string, then set the property to String
'--code for popup form
Public Property Get Certification() As Long
Certification = CLng(txtCertification.value)
Private Sub cmdOK_Click()
Me.Visible = False
In the popup form here I have a textbox called txtCertification. A user
enters information here then clicks an OK button (cmdOK) which only
hides (Me.Visible = False) the form (don't unload the form - it has to
be running so that you can read the value from its property). In the
calling form you would call the popup like this:
'--code for ma...Forms/Subforms in MS Access Database
Why do my Forms/Subforms in my MS Access Database not appear?
All I see is the boxes where they should show?!
What did I do wrong?
> Why do my Forms/Subforms in my MS Access Database not appear?
> All I see is the boxes where they should show?!
> What did I do wrong?
-----BEGIN PGP SIGNED MESSAGE-----
Probably there isn't a name of a form in the sub-form's Source Object
property. Also, the Link Child Fields and the Link Master Fields
properties may be blank - you must enter the names of the link fields,
they hold the field names that link the data between the forms.
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
-----END PGP SIGNATURE-----
On Nov 24, 2:54=A0pm, MGFoster <m...@privacy.com> wrote:
> zufie wrote:
> > Why do my Forms/Subforms in my MS Access Database not appear?
> > All I see is the boxes where they should show?!
> > What did I do wrong?
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> Probably there isn't a name of a form in the sub-form's Source Object
> property. =A0Also, the Link Child Fields and the Link Master Fields
> properties...ms access Form query help
the code below is from ms access 97 vb. I have imported the access
project into Access 2002. I am getting all kinds of errors in the
code now. I am trying to run a query from a form. This is the first
error i get:
It has a problem with the "OpenQueryDef" in the third line below.
Dim MyDB As Database, recset As Recordset
Set MyDB = DBEngine.Workspaces(0).Databases(0)
Set thequery = MyDB.OpenQueryDef("MainQuery")
If anyone could help me or give some advice that would be awsome.
Usually it's good to give a little more detail about the ...Access Form --> Hyperlink to Excel --> Return to Original Access Form ?
I have an Access 2000 form that has a Hyperlink that opens an Excel
2000 worksheet located in the same network folder as the Access MDB.
The Hyperlink works great.
When users close the Excel File, they must choose the correct open
Access form on the Windows Desktop Taskbar to return to the Access form
that had the Hyperlink.
Is there a way to:
1. Open the Access Form
2. Launch the Hyperlink to the Excel Workbook
3. Exit Excel, then
4. Return to the original Access form automatically - without clicking
anything (such as the the TaskBar)
I just need help with #4.
Or, is there a better ...Problem with ControlTip Text on form/sub-form
If utilized as a sub-form, the ControlTip Texts of all the labels (you
know...you can hover the mouse over either the control itself, or the label
for that control) flickers like crazy. Hover the mouse over the control
itself and it's fine. However, if I put the mouse over the short distance
between 2 controls, it also will flicker. Get the mouse solidly over one or
the other control and it's fine.
Also, this sub-form, if used as just a form by itself, is fine. No
flickering either on the label, or "between" 2 controls.
Anyone know why this would be happe...