|
Loops
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?...
|
5 |
12/10/2008 7:44:48 PM |
|
|
Prevent combo box autoexpand for new records
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 box (txtDescr) next to cboPN has as its Control Source:
=[cboPN].Column(2)
If t...
|
4 |
12/10/2008 7:14:04 PM |
|
|
Setting usernames and permissions.
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...
|
1 |
12/10/2008 6:36:00 PM |
|
|
Reports (OutputTo)
How can i automatically save a report (as [basketID]) without end user having
to do anything (i have checkout button on form to open the report)...
|
3 |
12/10/2008 6:27:03 PM |
|
|
Setting Default Value in Form Field
How do you set the default value if the value is an html tag - ex. default
value = <HTML>. What is the syntax? Apparently, I keep typing the wrong
syntax as it views the tag < and > as greater than/less than signs. I've
tried enclosing it in quotes, etc. What am I doing wrong? Please
help!!!....as this is only the most vital part of my app design. If users
have to enter...
|
6 |
12/10/2008 6:19:00 PM |
|
|
Creating a command
Brand new with access-
How can I create a command in datasheet form to open another form? Is this
possible? I tried doing the command in datasheet view/form but it didn't work.
I'd like to create a command next to each person's name. So if I clicked on
their last name in datasheet view-it'd open to a new form with lots more
detail.
Step by step instrucitons please! Where do I put the co...
|
4 |
12/10/2008 5:52:04 PM |
|
|
Running a query for Invoices that start with 5
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
...
|
3 |
12/10/2008 5:50:12 PM |
|
|
Copying all rows from basketContent to basketsContent
If QryDat.BOF = False And QryDat.EOF = False Then
QryDat.MoveFirst
Part of my script, but i dont know how to loop to get all the rows in
basketContent, how can i find out how many rows returned ?...
|
3 |
12/10/2008 5:47:28 PM |
|
|
Selecting Data on Continuous Forms
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 now
like to enable the user to highlight (select) a finite number of fields for a ...
|
2 |
12/10/2008 4:59:30 PM |
|
|
linking to PDF form
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/access-formscoding/200812/1
...
|
1 |
12/10/2008 4:21:31 PM |
|
|
How can I identify the user group in VBA code
Hi. i would like to give some permissions in my form directly from VBA code.
How can I identify to which group the current user belong?
Thanks,
marco...
|
3 |
12/10/2008 3:19:02 PM |
|
|
Create hyperlink in table not working
I'm trying to create a hyperlink to open a PDF document in another folder on
my desktop. Where in the properties box do I designate the location of the
document??
--
Message posted via http://www.accessmonster.com
...
|
1 |
12/10/2008 1:56:47 PM |
|
|
Where is the command button on the form?
I forgot....where is the command button on the form in access?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1
...
|
3 |
12/10/2008 1:33:54 PM |
|
|
Reference text control on tab contol page
Going round in a circle on this one so any advice/suggestions would be
appreciated.
Am using Access 2003. I have a form - frmBooks - on which there is a Tab
control. On one of pages of that Tab Control I have an embedded subform and
a text box.
From that subform I have a cmdButton which on click I want to pass the value
from a text box on that subform to a text box on the same page o...
|
2 |
12/10/2008 12:50:29 PM |
|
|
Trouble generating Filter for emailing report...
Hi there,
I am creating a basic helpdesk database that tracks problem calls. I want to
be able to have the call taker assign a ticket to anyone by having a button
that generates an email (ie. Sendobject). I've created a report for the Send
Object to send, but am having trouble getting the filter to work.
It appears that it is not filtering the report - I still get all records,
but t...
|
3 |
12/10/2008 12:50:08 PM |
|
|
Bells & Whistles
I have a form with 2 subforms embedded. The first subform is datasheet view
and I use conditional format to highlight a field in that form based on a
condition. The condition is a rare condition so I would like to place a lbl
on the main form that will explain what the highlight means. Basically make
visible everytime this condition is true and hide when this condition is
false. (as ...
|
20 |
12/10/2008 12:04:03 PM |
|
|
Query error
Datatype mismatch (productID is number, deleted is Yes/No)
"SELECT * FROM tblBasketContent WHERE productID=" & productID & " AND
deleted=No;"...
|
2 |
12/10/2008 9:37:02 AM |
|
|
Converting Integer to Time Datatype- Possible ?
Hi,
Got a tricky problem here.. I had 4 Text Box(es) input for Hours & Minutes
Respectively as follows:
StartHours_Text StartMinutes_Text
EndHours_Text EndMinutes_Text
'Both have test statement for right inputs Eg: Hours Between 0-23, Minutes
Only (Mod,15)
Problem arises when I need to some minus operations to find time differences
Eg:
Start Time : 08 Hou...
|
2 |
12/10/2008 5:09:53 AM |
|
|
Continuous Form Programming Woes
I have a continuous form in which I have a bound cbo which I use to select
the Proj Number. After the Proj is selected I need a secondary texbox to
display the ProjName.
I have tried various method but when I update the txtbox it updates all the
entries and not just the one currently being edited? I can get the info I
need but cannot get it accross to the user properly. How can i only...
|
3 |
12/10/2008 3:43:36 AM |
|
|
SendKeys "+{right}" problem
Hello to all. I have the following script (Access 2003) for the click event
on a button in a form; it takes me to another application from where I need
to copy (screen scraping?) certain pieces of info and paste them into fields
in a table in my application:
Private Sub Command0_Click()
Dim i, a
Dim nw As Date
SendKeys "%{TAB}", True
SendKeys "smagl", True
SendKeys "{enter}", Tru...
|
2 |
12/10/2008 1:20:39 AM |
|
|
IsLoaded compliance error
I need to have one subform automatically filter information based on the
"filter by selection" of another subform that is open. I copied the
following code and put it in the codebuilder for the form called frmClients.
When I try to filter by selection on frmClients I get the following
Compliance error message: ""Sub or Function not defined" and the "IsLoaded"
is highlighted.
Can y...
|
19 |
12/10/2008 1:14:12 AM |
|
|
Convert string to integer
productPrice = Val(txtProductPrice.Caption)
productPrice is dimmed as integer.
txtProductPrice.Caption is £25 and i want to get 25 out of it.
Help please :(...
|
6 |
12/9/2008 11:51:46 PM |
|
|
Nesting Forms
Nesting Subforms
MainForm with 4 Subforms (1-4)
Subforms are all in a tab control
Subform4 contains another subsubformA
Records of Subforms (1-4) are linked to Mainform by ProjectID
(Child-Masterfield….)
Its works great so far, but (the nested sub…)
Subform4 contains records of TasksID
subsubformA contains TrtmntID
Subform4 is linked to subsubformA by TaskID (Child-Mast...
|
1 |
12/9/2008 11:19:01 PM |
|
|
Having a button to open up the file where a document sits
Hi there,
I have a database that we track projects with. On our server we have a
specific location for each project (by project code) Is there any way to have
a button on the form that when clicked would either show you the directory
(somewhat like the search function) or would open up a new windows explorer
and go to that directory?
Thank you in advance for taking the time to answer...
|
3 |
12/9/2008 10:50:00 PM |
|
|
Create combo box in table properties
Brand new with Access. Just started making a table. I want a combo box. I
chose combo option in the properties but where do I enter in the info that I
want in my combo box?
Thanks
shannon
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200812/1
...
|
2 |
12/9/2008 10:02:51 PM |