recordsetclone not working
Wed, 10 Dec 2008 12:37:02 -0800
Hello,
I am hiving trouble with recordsetclone.
I have a form that I open and want to display the number of records. The
code that I am using is:
Set rst = Me.RecordsetClone
Me.txtRecordNumber = Me.CurrentRecord
Me.txtRecords = rst.RecordCount & " record" & IIf(rst.RecordCount = 1, "",
"s")
The txtRecord ...
|
Minimizing SwitchBoard
Wed, 10 Dec 2008 12:31:02 -0800
I want my Switchboard be minimized every time I work with any other form.
Tried to do so with coding OnLostFocus event, but it did not do the job.
I woud not like to code every button (wich are responsible for opening
different forms and reports) on the SB to minimize its motherform on click.
Is there any othe ...
|
Loops
Wed, 10 Dec 2008 10:51:02 -0800
Set QryDat = Mydb.OpenRecordset("SELECT * FROM qryBasketContent;")
If QryDat.BOF = False And QryDat.EOF = False Then
QryDat.MoveFirst
how can i loop to get each row ? how can i find out how many records was
returned? ...
|
Setting usernames and permissions.
Wed, 10 Dec 2008 10:36:00 -0800
Can anyone give me a brief how usernames and permissions work? and how to set
them. Also within VB how would i check if the current user has permissions to
access the form / query / table / report and how would the user log in?, can
i password each form? etc. Thanks in advance ...
|
Package solution wizard and diferent languages?
Wed, 10 Dec 2008 20:02:17 +0200
In Access Package solution wizard one can choose from different languages as
"Install language". If you choose some other language as english the
"Ok -button" is dimmed out. There's an link to the right of the dropdown
meny where you can choose "Add support for more languages" that links to
http://office.mic ...
|
I want the Subform total in a textbox in the main form
Wed, 10 Dec 2008 17:30:32 GMT
I want the Subform total in a textbox in the main form.
I got a subform with invoice number and for each invoice I got a total on
each line. I want the sum of each line in the Total column to show in a text
box on the main form.
...
|
Close Preview Select Form
Wed, 10 Dec 2008 09:11:00 -0800
I have a form that allows you to select one or several reports for preview by
using a command button. I want the Form that has the selection of reports to
automatically close after I've hit the print button.
Here is my code. What Event Procedure do I use?
Private Sub Report_Open(Cancel As Integer)
...
|
|
|
linking to PDF form
Wed, 10 Dec 2008 16:21:31 GMT
I'm trying to create a hyperlink in my table or form (which ever one will
work ) to open a PDF document in another folder on
my desktop. Where in the properties box do I designate the location of the
document??
Shannon
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acc ...
|
Prevent combo box autoexpand for new records
Wed, 10 Dec 2008 10:57:59 -0500
I have a continuous subform for selecting Part Number (PN). Each PN has a
description. The combo box (cboPN) for selecting PN has the Parts table
(tblPart) as its Row Source. Its autoexpand property is set to Yes. PartID
is the bound field; the next two columns are PN and Description. An unbound
text bo ...
|
Selecting Data on Continuous Forms
Wed, 10 Dec 2008 07:54:09 -0800
Hello,
I am using a continuous form to display data to user. Column Names (labels)
are contained in the Form Header and fields (text boxes) are in the Detail
section. The form's record source is a simple SQL statement with a WHERE
clause that limits the records to those applicable to that user. I would n ...
|
