|
Counting records in a subform
I would like to count the number of records in a subform and if this number
is above a given amount, I want to set the AdditionsAllowed property of the
subform to false.
I am using DCount funtion and get some of the results I want. The problem is
I need it to set the property before any updates or changes take place. Can
you tell me which which event to use? Or should I be trying anothe...
|
5 |
26.09.2006 18:03:02 |
|
|
Required entries
I have a 'LOG IN' or 'LOG OUT' button on a form that a user depresses when
logging a part into or out of inventory. I also have two field, WHSE and
STATUS, that must be populated BEFORE the user can LOG the part in or out
using the buttons. If either (or both) of these fields are empty and the
user hits the LOG IN or LOG OUT button, can a prompt be displayed 'WHSE is
Required' or 'ST...
|
5 |
26.09.2006 17:47:01 |
|
|
Selstart and cursor position
he following code is at the end of After_Update coding that filters a
continuous forms data via the textbox in the form header;
If Not IsNull(Me![Text34]) Then
Me![Text34].SetFocus
Me![Text34].SelStart = Len(Me![Text34])
End If
for example if the search is for "air" the coding correctly has the len as
3, but the cursor always appears at the start of the field before th...
|
12 |
26.09.2006 17:05:02 |
|
|
Options controls
Hello. I'm triyng to use two Option controls to define what report should it
print when press the Print button. I'm using the following code:
Dim mapa1 As String
Dim mapa2 As String
If Option23.OptionValue = 1 Then GoTo mapa1
If Option25.OptionValue = 2 Then GoTo mapa2
mapa1:
mapa1 = "rpt_ControloCustos_NotaProducao"
DoCmd.OpenReport mapa1, acPreview
mapa2:...
|
5 |
26.09.2006 16:51:02 |
|
|
Setting Focus to Word
Hello,
I am using the following code, but would like to set the focus to MS Word
after completion. Any help is appreciated:
Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Documents.Open "f:\filename.doc"
Note: both oApp.Visible = True and oApp.Application.Visible=True does not do
the trick.
Any help is appreciated.
--
David...
|
3 |
26.09.2006 14:40:01 |
|
|
Activating textboxes with tick boxes
What code can I use to activate a certain textbox if a tickbox is clicked on
and then if its taken out deactivate it?...
|
10 |
26.09.2006 14:35:42 |
|
|
Counting records in a subform
I would like to count the number of records in a subform and if this number
is above a given amount, I want to set the AdditionsAllowed property of the
subform to false.
I am using DCount funtion and get some of the results I want. The problem is
I need it to set the property before any updates or changes take place. Can
you tell me which which event to use? Or should I be trying anothe...
|
2 |
26.09.2006 14:31:01 |
|
|
dbo recordset
Can someone offer me advice on the following?
I am creating a dbo recordset based on a stored proceedure. I am using
Access 2003 and this is an Access Project.
I am trying to create the recordset at follows:
Set rstCandidatesFilteredForReport =
dbInfo.[dbo].[uspCandidates_EmpMasterData_Dynamic](GetKey(), lngUserPerNbr)
I get an error saying, Method or Data Member not found, with th...
|
1 |
26.09.2006 14:29:02 |
|
|
Sending a group Email from Access
Hi.
With help from Doug Steele and David Cox, I've managed to set things up so
that users can, within Access, filter down a set of records, then enter a
subject and body text and click on a command button which automatically sends
a common Email to that set.
However, now that I've got this working, I realise that it takes the form of
a seperate Email to each recipient and means that ...
|
7 |
26.09.2006 14:05:01 |
|
|
User access his own records
Hi,
I have multi user database form where a record field takes automatically its
value from the GetCurrentUserName() functions on the On Dirty event.
I want the user who opens the form to be able to edit or delete only the
records that have registered his/her name in the certain field.
Do you have any idea how?
thank you
GL...
|
8 |
26.09.2006 13:08:55 |
|
|
Inserting new records with the "Next" nav button
When having the last record in a table as current record in a frame, the
"Next" navigation button is enabled. When the user presses this button, a new
record is inserted. This i very anoying if the user keeps pressing this
button is order to come fast to the last record. How can this behavour be
turned off?
Leif S.
--
Systems Analyst...
|
6 |
26.09.2006 11:33:16 |
|
|
getting combo box to work in a subform
Hi all,
I have been working on this code for many hours but I cant get it right.
Hope somebody could help a desperate here. This is my problem.
I have 3 combo boxes in subform. The second combo box row source will depend
on the selection of the first as well as the third will depend on the second.
All works fine when opened as a main form but when it is being called as
subform, I get...
|
3 |
26.09.2006 07:51:02 |
|
|
calculate next level test
Here's what I've got. A form (frmtesting) that is based off of a table
(tbltesting). The form shows the fields in tbltesting
chrTestLevel (lookup box showing level 1-4)
chrAttempt (lookup box to choose which attempt number this is)
dtmTestDate
chrScore
I have added two unbound text boxes to the form to show what the next level
will be and when the next available test date is. I'm new...
|
7 |
26.09.2006 04:09:52 |
|
|
Semitransparent line
Hi,
Is it possible to draw a semi transparent line on a form?
Thanks
swas...
|
5 |
26.09.2006 02:12:16 |
|
|
How to display the referenced value of a FK on bound forms
Hi All,
I'm pretty sure this is easy, and that I've done it before, but it's the end
of the day and apperently I can't think straight... ;-)
I have a form bound to a table that has foriegn keys (and who doesn't). I
would liek to have those fields display the referenced values rather than the
associated ID's. Now, I could create a query instead of using the table, and
I think that the D...
|
2 |
26.09.2006 00:36:44 |
|
|
Me.Refresh works sometimes??? Please help!
Hey All,
I have Me.Refresh in two places, the first example works but second does not
and unless I rem it out the code won't compile. Can someone tell me why?
Thanks,
Gina Whipp
1st Example: This works...
If IsNull(Me.txtNonConformanceID) Then
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE tblGetAUPReferenceID SET
tblGetAUPReferenceID.garAUPReferenceID = [garA...
|
10 |
25.09.2006 23:09:45 |
|
|
Embed Word document in Access
I have Access 2003.
I'm trying to programmatically load a Word document into Access via OLE. I
have a table with a field called Reqmnts. Its data type is OLE Object. I
have a form with a bound Object Frame to the OLE Object. The field has an
"OLE Type Allowed" of Either.
If I use drag-and-drop of a Word document to the bound field on the form the
document is embeded with no pro...
|
1 |
25.09.2006 22:16:02 |
|
|
Function or Variable Expected
I have this SQL Statement that keeps giving me the Error...
Function or variable expect...any help appreciated.
Thanks
DS
Dim MORESQL As String
DoCmd.SetWarnings False
MORESQL = "UPDATE tblChecks SET tblChecks.ChkPaid = -1 " & _
"WHERE tblChecks.CheckID = Forms!frmCheckPayment!TxtSalesID " & _
DoCmd.RunSQL(MORESQL)
DoCmd.SetWarnings True...
|
7 |
25.09.2006 21:55:07 |
|
|
Lookup Logic and Display Values
Hello:
A co-worker just showed me her database that has tabbed forms. The first tab
has information on the call while the 2nd tab has all of the information on
the caller such as address, city, state, phone number, etc. There's also 3
other tabs for related information.
When someone calls in to make a complaint, she wants to look up the caller's
name in the database, and if their nam...
|
3 |
25.09.2006 20:55:02 |
|
|
Update Text Field Based on Value in First Text Field
I have a form that will be used to add records to a table "loanTracking". I
want the first field on this form to be a text field called "account". Users
will enter a loan number in account, and when they tab away from that field I
want it to look up the borrower's name in the query "openLoans". Then I want
to store both the user-entered loan number and the borrower's name in the
table "l...
|
5 |
25.09.2006 19:41:56 |
|
|
sql update of text field
This should be fairly simple, but I'm not seeing the flaw in my code. the
database field is: "planningstatuscomment", the field on the form is
"planningcommenttext" and is unbound. The field content may include special
characters. I've tried variants of:
strsql0 = "UPDATE project SET planningstatuscomment = " &
me.planningcommenttext & " WHERE (project.projectname = '" & Me.Project...
|
3 |
25.09.2006 18:22:18 |
|
|
Print Command button question...
Hi. I have a print preview button that is on about 22 forms. I was
wondering is there a way to declare this code globally so that I don't
have to code each one separately. Trick being that each one has to
open with a different report template. For example if the user is on
form1 then when he/she clicks the print button it has to be viewed in
report1, but if they are on form2 and click the...
|
3 |
25.09.2006 16:51:16 |
|
|
Enable field during filter only
Hi all,
I have a couple of fields on a form that are disabled. I need to be able to
allow the user to filter on these fields when they use Access "Filter by
Form". However, when select "filter by form" they remain disabled.
I have tried putting this code in the "On Current" of the form but it looks
like I'm missing the boat here. Little help please?
If Me.FilterOn = True...
|
4 |
25.09.2006 15:48:02 |
|
|
scroll bar position in continuous forms
I've got a continuous form in a subform control that gets updated every 10
seconds. The trouble is that no matter where the user puts the scroll bar, it
returns to the top with each refresh of the data. If a record is selected, I
can reset the form to that record and that keeps the window in a fixed
position. But if the user doesn't select a record, is there a way to make the
same record...
|
6 |
25.09.2006 15:38:02 |
|
|
Assign the Control Source for a Label and a Text Box Dynamically
I am trying to develop a form which contains 12 labels and text boxes for
MonthYear combinations which I would like to derive based on a starting
month/year entered by the user. The form contains labels(lblMonth1 -12) and
text boxes (txtMonth1-12)
I have a loop to increment a counter(b) and the InMonth and InYear values
that I would like to assign as variables i.e.
Forms!frmInput!lb...
|
3 |
25.09.2006 15:18:01 |