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...how to hide a empty txtbox and show a label??
I have a report and I'm trying to do the following:
If a record has a null value for "Worker" then I want to show a label
called "Vacant". I've tried to put the following in various placed (using
the code button) but can't seem to figure it out.
The report is based on a join query from 2 tables, one table "MasterData"
contains the people and "Jobs" contains the various information about the
jobs (payrange, hiredate etc...)
Private Sub Report_Open(Cancel As Integer)
If IsNull(Me!Worker) Then
Me!Worker.Visib...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
Thanks again for all the help. I've got another question though.
How to I hide an entire row (A16) if A17 - A23 ALL have vaules that = 0 (Not
null but the number zero).
The archives would prefer a better subject line.
"Bob" <email@example.com> wrote in message
> Thanks again for all the help. I've got another question though.
> How to I hide an entire row (A16) if A17 - A23 ALL have vaules that = 0
> null but the number zero).
&g...Hide/Delete entire rows based in the content of one cell
Hello all. I have a spreadsheet that is over 500 rows long. As it is I have
no use for all of the rows at the same time and have to keep hiding and
showing them as need arises. Is there a macro to hide chunks of it based on
the value of one cell of the row? In other words, en each row I will have a
formula like =if(a1=0,"HIDE","") and this value will tell the macro wether to
hide the row or not. I tried case.select but it takes a LONG time and I would
have to write a piece of code for every line. FYI, the rows that need hiding
will be in sequence, in other words, fro...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...Failed to hide column with message "cannot shift object off sheet"
I've a Excel 2000 worksheet that has 173 columns (A to FQ)
with comments in a number of cells. I can't hide columns
(say E:BW) with error message "cannot shift object off
I searched into Microsoft Knowledgebase and found article
211769. I followed the resolution but stopped at
step "3." where I can't find "Comment" of Format menu.
Can anyone tell me how to resolve this problem?
What is in columns FR through IV? If nothing, columns FR:IV and Right-click
on a selected columns header - select "Delete.
HTH...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...Hide Outlook messages error
is it possible to hide the error window for a particular
I've this problem: an internal POP3 mail server doesn't
support shared access to a single mailbox. This mailbox is
needed to receive faxes and all user check this mailbox
every 2 minutes.
The problem (for users work) is raised when the error
window appear too many times in a day...
May is it possible to hide this windows via registry
settings or other else?
thanks in advance.
No, not possible. Better is to lower the frequency users check the mailbox.
Robert Sparnaaij [MVP-O...