events in forms
I have Form1() and inside it I instantialize Form2() wich is like tool
Form2() form2 = new Form2();
how can i catch button_click events from form2 in Form1().
A form is a class as any other class so you could expose whatever you want
by adding members to the Form2 class (if I remember you can even make a
member public in the propery window). That said, in this particular case it
might be beneficial to avoid exposing gory details i.e. it could be better
to handle low level events in the Form2 class and expose higher level
...Saving web form fields in Access DB
Today, if a customer completes a web-based form for training, the form
information is submitted via an email to an outlook mailbox. We would like to
develop a macro that parses this outlook email content to a Microsoft Access
Database. How would one go about this?
uh pick up a copy of DreamWeaver
and move to SQL Server
"sunflower" <firstname.lastname@example.org> wrote in message
> Today, if a customer completes a web-based form for training, the form
> information is submitted via an email to an ou...Form is appearing off the screen- how do I get it to come back?
I edited a Access form on a dual monitor machine, and now people with
smaller monitors can't see it- where is the property to determine
where it appears?
...How to select record in the subform and to show it in the main form? 09-27-07
I have subform with datasheet view and I need to know how to select
record in the subform and to show it in the main form?
Forget my last post. I misuderstood your question. The code I gave will
give the record "number" (sort o count from the table start) not the refered
> There are other methods but a simple one to use would be
> DoCmd.GoToRecord acForm, "MainFormName", acGoTo,
> Chan...Updating New Record form
I have two tables set up: tblDeals and tblEquip, they have one field in
common called: DealCode.
I have a query qryEquip that links the two tables based on the DealCode
field and adds other tblDeals fields like Customer, Description, etc, to help
identify the deal but only the DealCode is stored in the Equip table.
Form frmEquip is based on query qryEquip and it is working fine.
Here’s what I’m trying to do: When I add a new Equip record I want to be
able to look into the tblDeals for the right deal and then pass the DealCode
to the frmEquip, then have the frmEquip pull the rest o...How to reuse a form?
There are many forms needed and each one only has buttons, labels and
captions on it. Here is my design idea. I would like design one form and
reuse it with a different set of buttons, labels and captions.All these infos
can be retrieved from a table when a form is being built. Could you give me
some hints or your ideas how to do it
thank you so much for your help
One suggestion would be to use a tab control on a form. Have each tab
control to hold each set of labels and controls with their captions. Then
when you are ready to use the form, hide the tabs altog...Search by Form with Checkboxes
I have Access 2003. One of my Tables has multiple fields with the Data Type
Yes/No and a Display Control of Checkbox.
I have a query by form with multiple text boxes and a related query. One of
my query examples is listed below.
Like "*" & [Forms]![F_CatSearch]![txtGumChewing].
I need to be able to make multiple selections for my query's output. My
problem is in the form I have to put "-1" in the field for my query to work.
I want to be able to have a checkbox in my form so the user can check the
items they want selected in the query.
Can anyone help...Not able to add or edit records from an input form.
I have an MS Access input form that is based on a query that is based on a
table called Training. The Training table is actually an SQL Server table
that is linked. There are three fields in the table: ID (The primary key),
CustomerName and TrainingDate. I added three records into the table using
SQL Server Enterprise Manager and can add more. However, I can't add them
using my access form. I can view them but cannot add. I can't edit them
either. What setting do I make to allow edit and adding to occur? I posted
this question in the sql server forum and was ...Refering to control property on a form in VB
I am trying to simply my code in a application by using a sub routine
to amend the control properties of a form but I can't seem to get
basic to accept the control property being sent to the routine as a
The code I am using is :
Private Sub lSubControlPropertySet(stForm As String, stControl As
String, stProperty As string, varValue As Variant)
If IsNull(varValue) = True Then
Forms(stForm)(stControl)(stProperty) = ""
var...Forcing users to use a custom Contacts form OR removing Contacts
Using Exchange 5.5 and Outlook 2000
Is it possible to set it so all users use a cusom contacts form for new
items in their "Outlook Today" folders?
Or better still, is there a way to remove the Contacts folder, or make
it point to a folder in the public folders tree?
...Copying records from one (sub)form to another subform using Append
I have a mainform with products (and thier details) from a products table and
a subform showing ingredients (from an ingredients table).
I wish to select existing ingredient records from one subform and copy them
to so that they appear as ingredients in a new Mainform.
I have a selection box next to each of the ingredients to enable selection
but how do I "copy" these selections to the new record on the new mainform.
Do I use an append query to do this? Any guidance on doing this would be
great (not too experienced in this area).
On Tue, 9 Feb 2010...Popup form resizes itself
I have a popup form which resizes itself each time it is opened,
necessitating a manual resize so it can be used. I've changed the following
properties, but don't seem to be able to stop this from happening.
Scroll Bars - Vertical Only
Record Selectors - No
Navigation Buttons - Yes
Dividing Lines - No
Auto Resize - No
Auto Center - Yes
Border Style - Sizable
Control Box - Yes
Min Max Buttons - No
Close Button - Yes
Open the popup form in design view. Click on Restore button to make it show
in the "smaller" size. Resize the form to the size you want it to have wh...getting window position?
For a *child* window, when you set position and size using
CWnd::SetWindowPos, the positioning is relative to the client area of
the parent window. I must be getting tired, because look as I might, I
can't find an analagous call to get the window position for a child
window in terms of the parent window client area. I'm not sure I can
even see how to compute it from the screen position returned by
CWnd::GetWindowRect. What am I missing? It's seems obvious the call must
be there somewhere, but I'm not spotting it. Thanks.
Is ScreenToClient what you want?
======...Check if a form has changed since it was last saved
I am developing an application using an ms access front end and a
visual foxpro 8 backend. The application uses adodb connections to add/
update/edit data in the back end database. When a user clicks the
save button on main data capture form the user input is
programmatically inserted into a new record or an existing record is
updated by creating SQL INSERT INTO or UPDATE statements on the fly.
I was wondering if anyone knew of an efficient way of coding a
mechanism to check if the form had changed since the save button was
last pressed. I guess this can be achieved by capturing the On Chan...Clearing form to enter addl info but keep history
I have a form with billing info that includes Billing Date, Billing Reasons
and Billing Due Dates. The Billing information is on a tab on a form. There
could be multiple dates and reasons.
What I would like to do is have a way that once the billing info is
completed for a specific date, be able to enter another date and more billing
reasons, so that the fields on that tab are "cleared' however, I will need to
query for the information that was "cleared" for reports.
When I tried "adding new record" it goes to the next customer on the li...Query with Combo Boxes on a Form
I'm using QBF with about six different combo boxes using:
[forms]! [formmain]! [combo1] or [forms]![formmain1]![combo1] -like in a VBA
book. This is so users can select criteria on a form with the combo boxes,
and when they are done, they hit the search button, and it opens up another
form based on the query just performed by the combo selection.
This worked for about three combo boxes, but when I added another one, it
freezes up and opens up a blank page. It's supposed to open the new form
based on the query.
Is there a better way to do this?
Any help would...Finding the position of a certain picture on the screen
I need to make a program in c# that will find a certain picture (not a
big picture, few pixels in a certain formation, which is not
necessarily a rectangle) on the computer screen. I haven't really done
something like that before, so I'm not sure how to do it.
what I had in mind was taking a screenshot (I found a tutorial that
explains how) and then start checking every pixel in the screenshot
until I find one that looks like one of the pixels in my picture, and
then check if there are pixels next to him that are same to the ones
in the picture, and in the same fo...how to create simple forms
how do you create simple forms in outlook to use for surveys?
See http://www.outlookcode.com/d/forms.htm However, unless you know that =
every recipient is using Outlook, an Outlook custom form is not a =
solution for surveys.=20
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"Kenneth" <email@example.com> wrote in message =
> how do you create simple forms in outlook to use for s...Renaming forms tables and reports
Is choosing "save as" and making a copy and removing the original the only
way to rename a report, table, or form? I started with the Issues template
but I want to change the names of the objects. I can right click and rename
the shortcuts in the navigator window, but the name doesn't change and the
references are still under the old name. I do not want my shortcut to be a
different name than the reference name because then there will be confusion
for database maintenance.
I've also tried renaming the objects in their properties window, but I
couldn't find a na...Populate sub form
I have asubform that is linked to the main form via one field, multiples
entries are allowed in the sub form, but the linked field is the same for all
I can add new records manually in the sub form okay.
What I want to do , sactivate a query/programming etc that is done by
clicking a button that automatically adds several records to the subform from
a table that contains potential data items based on a field in the main form.
ie if the item in the main form is set to tru, then the sub form is to have
several specific records added to it.
how do i do populate the subform ...Allowing and Saving Data in Form Fields
Operating System: Mac OS X 10.5 (Leopard)
I have created a Word document with form fields that is password protected. When I saved the document, I selected "Track Forms". However, my recipient is unable to save the data they input into the form field. How do I allow this?
I am not quite sure what you are doing, because your terminology does not
exactly match what I see in Word.
I suspect the issue is that the document must be protected for forms to
enable the form fields. If the document is not protected for forms, the
user cann...HELP:user-fill in form
I need a excel-file with 2 tabs.
In the first tab It must be able to fill a week nr. And then som
Then that values must automattically filled in, in Tab2 in the righ
column of that week.
If you can help me, please reply !!!
Thanks in advance,
Message posted from http://www.ExcelForum.com
You weren't very specific as to if this is from one cell on sheet1 or for
all cells in a column. In any event, you can use a worksheet_change event on
a worksheet module to this sort of thing.
"Stift >" <<S...PDF Form Field Values
Is there a way using vba to simply extract the user input values from a PDF
form so they can be 'Uploaded' into a database?
I don't know about the PDF per se, but you can certainly do this in Word.
If you have MANY PDF files that you need to do this for, look into
converting them Word docs:
Then follow the steps in the first link I posted.
If this information was helpful, please indicate this by clicking ''Yes''.
...What am I doing wrong? (Protecting forms)
I'm doing something wrong and I can't figure out what. I created a
form (like I've done many times before) and I'm trying to protect it
but when the Protect Form pane comes up, I check the box that says
"Allow only this type of editing in document:" and I select "Filling in
forms" from the drop down list.
Normally, the "Yes, Start Enforcing Protection" button becomes active
and I would then select it but it's grayed out as is the the lock on
the Forms toolbar.
This has happened to me once before and I had to start over wi...Hide one page within a form with several pages
Hi all access users
I wonder if anyone can help me with this. I have a form with several pages.
I like to hide one of them untill the user have select a choice from a field
named productcategory. If the choice is for exampel Tools then I like the
page to be shown
If you mean a page on a tab control, you can change its Visible property.
One possibility is to use the After Update event of the control bound to
Select Case Me.ProductCategory
Me.pagTools.Visible = True