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 ...
|
Running query for invoices that start with #5???
Wed, 10 Dec 2008 15:41:39 GMT
How do I create a query that will look up multiple invoices that start with
the number 5? When I type in criteria "5" nothing shows up even though I know
I have plenty.....thanks.
Shannon
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1
...
|
RE: Open form from record in list using Allen Browne's search form
Wed, 10 Dec 2008 07:18:01 -0800
I too have am using the contact finder from Allen Brown. I also would like
to double click on any record(s) that have been found and be able to go
directly to that record for editing purposes. I'm just not sure how to edit
the code so that it works for my forms. I keep getting Run Time error 2102.
This i ...
|
