Creating a form for a Password
I have created a Password form that will secure another form. Once the
password is entered it will open the form that has the list of reports. On
the form I have a text box that accepts the user's password and I have 2
command buttons one is OK and the other is CANCEL. Can anyone tell me how to
make these buttons work to open the form of reports?
On Wed, 10 Oct 2007 13:52:00 -0700, mrsgwen wrote:
> I have created a Password form that will secure another form. Once the
> password is entered it will open the form that has the list of reports. On
> the form I have a text b...Selecting variable records from a form
I've created a checklist form and would like to create a report that
demonstrates only the items in the form that have data.
Message posted via AccessMonster.com
...Report can't print form field
My report heading contains a text box with the following data source:
="Transactions since " & Forms!frmPrintTran!txtDate
The on-screen preview shows the date fine, but on printing, this textbox
The form remains open during print.
Happens with both Access 2002 and 2007, DB structure A2000. What gives here?
This usually happens when there is code in the On Close of the report that
closes the form.
Microsoft Access MVP
> My report heading contains a text box with the following data source:
> ...Forms Check Box cell link
I am using a check box created with the Forms menu. I created a box over
cell D4. Using the Format Control box, I linked the check box to cell D4. I
want to copy the check box in cell D5, D6, D7,.... and I want the cell link
to integrate in the same mannor; check box in cell D5 should link to cell D5,
and so on.
Is there a way to accomplish this short of going into the format control box
and manually editing each cell link after I have copy and pasted several
check boxes? I have NOT entered the link using an absolute cell referense.
I got the idea for this from Dav...Customizing Forms Wizard
It is possible to control or customize details of the way the wizards creates
For instance, we have internal naming standards for controls and I would
like the wizard to name each control according to our standard.
I know I can use a form template for the forms created without wizards, but
what about controlling the creation of the ones done via wizards too?
Thanks in advance,
See if this helps:
Román Valoria wrote:
>It is possible to control or customize details of the way the wizards creates
>For ...Form Menu : Check Box
I am trying to enter 300 or so check boxes onto and Excel spreadsheet.
I find that I can link the 'return' cell using the right click / Forma
Control / Control tab / Cell Link option but I need to do this for eac
Is there a way around this ? Whereby I can create one Check Box an
then drag or copy it down
jagstirling's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=110
View this thread: http://www.excelforum.com/showthread.php?threadid=50634
Maybe you could jus...Access-Forms-VB links
After years in software development/database programming mostly on
Unix/Oracle I'm tasked to change some Access forms to use redesigned
tables. I'm having trouble with the relationship between forms and VB.
For example I'm looking at some VB code that frequently references the
Me class which I assume to be the default reference to the current
(form) class (like this in C++), but I can't see how/where the class
is actually defined. Can someone please provide some links that
provide concise explanations of the relationship between Access and
VB. My googling has only turned up pag...can a form display current table field names?
I need to create a form that will display the current field names resulting
from a make-table querythat can change from audit to audit. This way the user
is always aware of the "current" field names in their dataset.
Currently, a form displays the structure from a linked (text formt) table
that I have to manually export every time the make-table query changes and
I'd like this to be generated from a macro or from code.
I thank you,
This article illustrates how you can list the field names, types, and
descriptions for a table:
...Sinking MS Access form events from MFC console app
I'm trying to sink MS Access form events using technique described in <<HOW
TO: Handle Events for Excel by Using Visual C++ .NET
Of course I did do all the needed code substitutions etc.
All works rather well, I mean I'm getting to MS Access form
But the last code line -
hr = m_pConnectionPoint->Advise(m_pAppEventListener,&m_dwConnectionCookie);
doesn't work and returns hr = -2147220990.
Here is MS Access form events interface ID I use:
const II...Monthly Summary of days of the week ?
I hope someone can help me with this issue.
I have one spreadsheet with worksheets for each month for the last 18
Each worksheet has column A being the date eg 1st -31st January 2009
Col B has the formula to set the actual day of the week - 1/1/09 =
Then I have numbers in columns B to G for incomings etc and outgoings
then a net figure
Now I have all sorts of averages per day per month per year but would
like to have an automatic calculation so I know what day of the week
(e.g Tuesday ) is as a percentage of the weeks $$'s
Therefore knowing the best and ...Linking Form and Report
I have a Main Entry Form for the entry of installation data. I have a
Report set up to be used as an Audit tool. I would like to have the Audit
Report pop up for review when the Save & Close button is depressed. The Form
and the Report are linked by Folio No, unfortunately I have not been
successful, when you push the Save & Close the form opens but its blank. I
have checked the underlying tables and the data seems to be there. Is there
something unusual about trying to attach a Report to a Form at all.
Private Sub btnSaveRecord_Click()
On Error GoTo Err_btnSa...Passing Values between forms
I am trying to link to forms. I have a button on the main form
(frmCompanies) that needs to open another form when a button is clicked. The
new form that opens is frmScheduledActivities. When it open it needs to check
to see if there is an existing record (scheduled activity) for the company
and if there is no scheduled activity be set to add a new record.
When the button is clicked on the main company form (on the on click event)
this code runs:
Private Sub cmdCallBack_Click()
On Error GoTo Err_cmdCallBack_Click
Dim stDocName As String
Dim stLinkCriteria As String...Display Query from form in Foreground
I have a form upon which the user selects display, filter and sort fields.
He then clics the submit button and a query is built and then displayed with
the following code:
DoCmd.OpenQuery "Queryname", acNormal, acEdit
The query works but shows up in the background and cant be clicked on until
the form is closed. The idea was to create a form on which the user could do
adhoc queries until he gets it right and then click another button to do the
Excel extract. Is there a way to show the query in the foreground?
On Tue, 22 Jan 2008 17:54:27 -0800, rmcompute wrote:
> I ha...Return Value from Form
I need to return a value from a form displayed modally.
Many years ago, if I used VB classic, I could create a public method that
took care of any arguments, displayed the form modally, and then returned
appropriate return values. Something like this:
Public Function GetValue(Args As Integer
m_Args = Args
m_Result = DefaultResult
GetValue = m_Result
However, it appears Access VBA doesn't support this. For one thing, there's
no Show method (and so it certainly can't have a modal argument).
I like this approach because ...User Form Security Question
I'm creating a form, which onces completed transfers the data over to
the spreadsheet. But the guys in work don't really pay much attention
to what they have entered , so i was wondering is there any way to make
the user double check every entry?
I was thinking, once the user clicks ok, a msgbox would appear giving
the user the value they entered, click ok if correct or cancel to
Is there a easy way to do this?
harpscardiff's Profile: http://www.excelforum.com/mem...I did do an update today form Microsofts update page #2
If I can remember correctly, it was 2 new items that came
out today for the OS. Could that have casued this. But it
worked Ok afterwards. Nothing else installed in the last
...Automating a Summary Tab
I have a workbook that I need a summary page that will breakout 2 different
tabs and subtotal it
Is there a way that if 1 tab holds
Part #, Desc, and Price
Another tab holds
Total Price for the type of project it is
So that would be: Model, List Price
In a Summary tab I would like to show
Item # (this would automatically start numbering each row) depending on how
many choices they made in the other tabs
Length of term
They could choose anywhere from 2 parts to 15 parts how do I get it to
automatically populate for what they chosen in this new...How to I stop the form from resetting
I have a table linked to the header of my form. The table has for records.
Here's what happens. When I choose a record (say record 3) record 1 ALWAYS
The form is meant to be printed out.
Can someon please tell me how I can get the record I choose to print out?
Thanks in advance!! :o)
Although it is possible to print a form, it is not advised. You will get
better results if you create a report and print the report.
Dave Hargis, Microsoft Access MVP
"Printing only filtered data in a form" wrote:
> I have a table linked to the header of my form. The table h...Pass Through query with criteria on a form
I have a Pass Through query that looks like this.
sd_term_name_loc as 'Location',
sd_term_city as 'City',
sd_term_st as 'State',
sd_term_cntry as 'Country',
from detail (nolock)
-- ***** The dates below refer to the date and time at which the
transaction was loaded to PRM.
-- ***** The number of pings which have occurred BETWEEN those dates/times
will be counted.
-- ***** Enter the date/time in the format '09/16/2007 14:00:00.000...issue with serial port on module, updating form
Ive created a serial port instance on a module. In the same module I have
the sub data_received.
Now I'd like to update a control in a form, how can I do it?
Thanks in advance
You need to use Control.BeginInvoke or .Invoke to update the UI via a
Delegate. You can download the VB2005 Terminal example from my website,
which illustrates this.
Richard Grier, Consultant, Hard & Software 12962 West Louisiana Avenue
Lakewood, CO 80228 303-986-2179 (voice) Homepage: www.hardandsoftware.net
Author of Visual Basic Programmer's Guide to Serial Comm...How can I put photos in Microsoft Access Form
I used the information BobLarson said in putting photos in Microsoft Access
Form but it's not working. My computer keeps asking for Form1, which I
deleted because nothing was happening the way I wanted it to. What I would
like to know is there a online video that can show how you can do this
procedure. And how can I get my computer stop asking for Form1.
"Helen" <Helen@discussions.microsoft.com> wrote in message
>I used the information BobLarson said in putting photos in Microsoft Access
> For...This form Requires Word
I am reasonably up to snuff on Outlook and have used it for as long as it
has been around. I am running Windows 2k Pro and Office 2k Pro and Outlook
is configured to use Word as the default email editor. It does so quiet
well both composing and reading email, except when email is receives from
one particular person, one out of hundreds. This lady <the sender> is also
using Outlook 2k pro and windows 2k pro and word as default editor. When I
receive mail from her and try to open it I receive the message
"This form requires Word as your email editor, but Word is eith...Multiple Record Inputs with one Form
I'm programming with SQL and can't seem how to figure out how to send more
than one record to the table with one form.
You've described a "how" ... as in how you are trying to do something ("send
more than one record to the table with one form").
Now, "why" ... as in what will having multiple records generated from a
single form allow you to do (i.e., business need)?
This isn't idle curiosity ... if we knew more about the underlying business
need, we might be able to offer alternate approaches.
Microsoft Office/Access ...Attaining Form for Excel
We are having some difficulty in attaining 'Forms' on Excel 2007. We have
been directed to 'Down loads' and then attempt to down load 'Exel 2002 Add-
in:Template Wizard with data Tracking.
So far we have been unable to find any wizard after the down load.
what do you mean by "attaining form"?
Please give a more complete description of what you are trying to do,
disregarding the download of the wizard.
If this helps, please click the Yes button.
> We are having...Listbox selected freezes the form
I'm using the following line in the form_open to select the first item in the
list which susequently selects data in the second listbox:
Me.lstDate.Selected(0) = True
However the whole form freezes and nothing works? Any ideas?
"ShariS" <u40676@uwe> wrote in message news:7e4b3831704cd@uwe...
> I'm using the following line in the form_open to select the first item in
> list which susequently selects data in the second listbox:
> Me.lstDate.Selected(0) = True
> However the whole form freezes and nothing works? Any i...