|
How to highlight a row in a detail section by selecting 1 field
I am trying to highlight a single row in a detail section of a form when the
user selects one of 10 different fields. Does anyone have a clear cut way to
do this? I've downloaded some code, however, it seems too cumbersome. I
have tried using a macro, however this does not work too well since I can
only use the gotocontrol once. I am using Access 2003. I'm not too well
versed in code...
|
4 |
12/4/2008 7:37:14 PM |
|
|
On Timer Help
I'm trying to create a Label whose caption changes every XX seconds.
I know about the ontimer event and how to use the label.caption in the code
but how do I get it to change to a different caption that is predefined in
the code?
I searched here but wasn't able to locate anything.
Thanks.
...
|
3 |
12/4/2008 6:59:08 PM |
|
|
Update on fiscal year
Thanks to Marshall Barton I have solved some of the problem. I got the box
to total up the right number of months to a fiscal year by changing some code
but when it comes to next year in April it continues to total up instead of
starting a new year. Fiscal year is 1 April to 31 March
Public Function gettxt6MET(UserID As Variant) As Integer
Dim strWhere As String
If Not IsNull(...
|
1 |
12/4/2008 5:11:02 PM |
|
|
Help with error 3075 please
Hi,
i got this syntax error please help :
strSql = " SELECT * FROM dbo_A WHERE soundex(lname) = ' " &
Soundex(Trim(Me![lname])) & " ' "
Thanks you for any reply....
|
3 |
12/4/2008 5:02:01 PM |
|
|
OLE updating problems
I have several embedded excel spreadsheets in forms in a database and the
customer would like it that when the form is called to open that excel opens
and displays the latest data. However, i have not been able to figure out how
to code the opening event to force the spreadsheet in excel to refresh and
pull the latest data. How would I do that?...
|
1 |
12/4/2008 4:36:03 PM |
|
|
How do i make a combo box go to first row, rather than blank
How do i make a combo box go to first row, rather than blank...
|
2 |
12/4/2008 4:30:56 PM |
|
|
Baskets..
Im using one form to do many functions, search for a product, then a button
to add that product to a basket.
Should i have a subform from the basket table? i want a fixed height and
width and be able to scroll within. Also would need to change the quantity of
the product (how many the customer is buying) and also delete the row.
If the row get deleted i would need to update tblProducts...
|
1 |
12/4/2008 3:11:02 PM |
|
|
Main Form Cannot Generate Query Output
Hi,
Private Sub FunnyQuestions()
' I got a 'funny questions' that puzzled me.
' My main form contains mutiple tab control, within each TAB control consist
of subform.
' NOTE: All subform are not bound to main form in any way.
If (I run the subform individually) then
Able to see the output.
ElseIf (I run the form) then
Can't view the output from this subform.
En...
|
2 |
12/4/2008 2:10:30 PM |
|
|
Append queries...
INSERT INTO tblProductsLog ( staffID, productID, [timestamp], quantity )
VALUES ([staffID], [productID], now(), -[quantity]);
i got that in a query, but when i use DoCmd.OpenQuery it asks me for
variables which is already set before i execute it, therefore i need to do
the query some other way? please help :<...
|
2 |
12/4/2008 1:29:43 PM |
|
|
Hello i want to use a subform for a basket....
Hello i want to use a subform for a basket....
Is there any other better ways to make a basket, and have fixed height/width
and it can scroll? or is a subform the best way to go?
I got a button on the form which will add products to basket, will the
subform automatically update? if not how can i do it via vb?...
|
1 |
12/4/2008 10:07:06 AM |
|
|
runtime Error.. cant assign value to this object
I am using the Search Code found in the Microsoft Issues Database Template
Everything works but the filter
i get an error message that says Runtime error 2448 " you cant assign a
value to this object"
On Debug this is the highlighted code
Me.F_BrowseAllParts.Form.Filter = strWhere
My Subform is F_BrowseAllParts
does anyone know where im going wrong??
Heres my code.
Pr...
|
1 |
12/4/2008 12:39:00 AM |
|
|
Starting a form with no available Where clause value.
I have a form.
That form has a Combo Box with a separate query.
All the other fields in the form use the form's query.
The form query is dependent on the Combo Box selection. When I start
the form it remains all gray.
I have done some tests and concluded that until I give some useful
value to the query's Where clause that results in, at list, one
record, it displays the form perfect...
|
7 |
12/4/2008 12:29:55 AM |
|
|
Bookmark property works when stepping through code in debug, but not when run
In the code snippet below I'm attempting to set the .Bookmark property
of a Form to match the bookmark of an ADO recordset:
Private Sub Form_Load()
Dim rst As ADODB.Recordset
Dim mctlFieldName As Control
Set rst = New ADODB.Recordset
Set mctlFieldName = Forms!frmCDs!cboFiledUnder
rst.Open Me.RecordSource, CurrentProject.Connection, _
adLockReadOnly, adCmdTable
Set rst = rst.Clo...
|
10 |
12/3/2008 11:02:26 PM |
|
|
De-Highlight Unbound Text Box
I have an unbound text box that I use on a form that updates text to it as
code progresses in VBA. It updates the user what the program is doing. It
works well, however, I can't seem to get the "highlight" off the text. Is
there a way to get that insertion point at the end of the text - in the
unbound text box, or at least not highlight at all......
|
4 |
12/3/2008 10:29:32 PM |
|
|
Incremental number
I have a main form with a subform the subform is used to create new records
(One-to-Many relation). What I am trying to do is to fill a field [Cycle]
with the next incremental record number. This is what I have entered in
Default Value of the [Cycle] filed of the subform:
=DMax("Cycle","tblOxygen","[Calibration_ID]=Forms![tblCalibration]![CalibrationID]")+1
The problem is that it doe...
|
3 |
12/3/2008 10:05:50 PM |
|
|
Re: De-Highlight Unbound Text Box
Oops, that should have been
With Me!MyTextbox
.SetFocus
.SelStart = .SelLength
End With
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
news:...
> With Me!MyTextbox
> .SetFocus
> .SelText = .SelLength
> End With
>
> --
> Doug Ste...
|
4 |
12/3/2008 11:47:11 PM |
|
|
Hello i have two fields, one text and the other combo
Hello i have two fields, one text and the other combo. When i focus on one,
how can i make the other one blank?...
|
3 |
12/4/2008 9:14:02 AM |
|
|
How can i force a selection of a combo box via vb
How can i force a selection of a combo box via vb ? e.g. 2 is selected and i
want blank selected...
|
2 |
12/4/2008 1:25:03 PM |
|
|
Form Problem
I have a form created that currently uses a combo box to validate the records.
I would like to switch this to a text box and have it validate against the
same table.
Table name is: part/description
Field name is: partnum
Basically once the user enters a value into the textbox and tabs out of that
textbox I want it to verify that they entered a valid part number. If they
do not enter a ...
|
9 |
12/4/2008 2:32:29 PM |
|
|
Combo box
Ive got a combo box which got two columns, staffID and staff name, the first
column is 0cm and second is 2cm, how can i get the first column value via vb?...
|
3 |
12/4/2008 3:16:19 PM |
|
|
Combo Box in a Datasheet Form
I have a main table, tblParents, and a one-to-many related table,
tblParentContacts, related by ParentID, an autonumber.
I am trying to design a form in datasheet mode based on a query.
The query contains ParentID, Last Name, FirstName, and one field that
concatenates the parent's first and last names (LastName, FirstName) from
tblParents and also contains the ContactDate, ContactTime,...
|
3 |
12/4/2008 4:01:03 PM |
|
|
How can i stop the end user entering custom values in a combo box?
How can i stop the end user entering custom values in a combo box?...
|
2 |
12/4/2008 4:31:15 PM |
|
|
every 10th
I am working on a database where right now they have to fill in a specific
part of a form that relates to a test. I am trying to make the database only
ask for them to collect that data every 10th unit. I can not figure out a way
to make this work. I would greatly appreciate any help that anyone can give....
|
2 |
12/4/2008 5:44:11 PM |
|
|
list box source problem
I need to populate the source of a list box from an ado recordset
Dim rec As ADODB.Recordset
Set rec = New ADODB.Recordset
rec.Fields.Append "AttyID", adBigInt
rec.Fields.Append "AttyName", adVarChar, 100
rec.Open
Then I get the value from a combo box and do the following:
rec.AddNew
rec!AttyID = Me.cboAttorneys.Column(0)
rec!AttyName = Me.cboAttorney...
|
2 |
12/4/2008 6:57:06 PM |
|
|
Automatic Fill in the ChruchID text control
Hello,
How can I make it that everytime I add recorrd and starting typing Firstname
Txt Control in the form, there is an automatic fill to ChruchID text conntrol
that take data from Default table field chruchID.
Thanks in Advance
--
H. Frank Situmorang...
|
8 |
12/3/2008 9:29:24 PM |