|
SQL Query def by vba not working.....please help
hi
i have a table LS1018c.that has fields..config, boomlength, opra. i
defiened a query that takes input from two text boxs (txt_or and
txt_bl)and combo box(combo_config).
now i could not get the input referenced to the sql. it is again asking
the perameters ..please tell me where i am going wrong..
thanks in advance..........
ASTY
Private Sub cmd_capacity_Click()
Dim db As DAO.Database...
|
2 |
28.09.2006 13:31:01 |
|
|
Continous Form Issue (Re-Post)
I have the following code that resides within a "click event" contained in a
Sub Form which is Continous:
Private Sub Action_Taken_Click()
If Me.Action_Taken.Value = True Then
Me.cboAction.Visible = True
MsgBox "Select an Action", vbInformation, "Action Required"
Me.cboAction.SetFocus
Else
Me.cboAction.Visible = False
End If
End Sub
The code runs fine; except for that...
|
5 |
28.09.2006 12:36:18 |
|
|
Subform doesn't work
Hi.
i can't enter any word in my subform. i've check the data entry(NO)..and i
don't know what else to do..
even.. my system cannot go to new record..please help
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200609/1
...
|
3 |
28.09.2006 06:20:02 |
|
|
Building databases
I am attempting to build a database that will have a list of employees by
date of hire that I can compare to a list of 'extra' work available and
assign by seniority. Can anyone guide me down the right path?...
|
3 |
28.09.2006 03:27:01 |
|
|
Avery style
I have made a database. I have made a form for mailing labels using an Avery
size. Now I want to use a different Avery size. How do I change that
without starting over. In all of the things you can change there doesn't
seem to be a way. Can someone help or at least confirm that I do indeed have
to start over again.
Thanks,
dgr
...
|
4 |
28.09.2006 02:09:15 |
|
|
combo box help
i have a form that have a combo box. when i select the part from the combo
box then i want it auto to fill the following two fill which is text box. i
have put the code as below
Private Sub Part_code_AfterUpdate()
Me.PART_NAME = Me.Part_code.Column(2)
Me.PARTNO = Me.Part_code.Column(1)
End Sub
in the Part Code after update event. Part_code is my combo box. but when i ...
|
5 |
28.09.2006 02:03:02 |
|
|
Filter Education
I would like to know a good place to go to learn how to work with filters
with forms....
|
1 |
28.09.2006 01:34:38 |
|
|
Print form
I have 'Print' command button in my form. It just print my form and it print
in Portrait format. How can i make print in Landscape Format in my form?
It needs to be coded in my form 'On Click' properties.
Thank you...
|
2 |
28.09.2006 00:56:39 |
|
|
Setting the RecordSource dynamically with a global variable
How do I pass a global variable defined by the first form to set the
RecordSource of the second form?
I have two forms "MasterForm1" and "MasterForm2." Both of these are linked
to the same table "MasterTable."
The first form's 'Data Entry' property is set to "YES" since it always
accepts new data.
The purpose of the second form is to continue entering data for the same row
in the MasterT...
|
4 |
28.09.2006 00:53:11 |
|
|
run sum
i have a form that have a qty. i want to do it as report running sum.
e.g
Qty SumQty
10 10
20 30
30 60
how to do it? have anybody can help me? i dunno how to make the run sum. i
want the SumQty show. how? thanks for helping!...
|
5 |
28.09.2006 00:09:01 |
|
|
exporting number fields
I started this morning doing a job I thought would be quite simple:
Export a table that contained Decimal data right justified with 2
decimal places. Wrong. thank you Mr. Gates, you can't export decimal
fields. So I CDBL. No Problem. I Format Fixed (thanks to the forum).
And I right justify (Left(" ",trim(len(fieldName))) &
trim(fieldName). All that works.
SO NOW I try to ...
|
5 |
27.09.2006 23:26:09 |
|
|
How to Dynamically Reference Objects on a Form?
I am creating a form with a grid of objects (text boxes and buttons). The
grid's dimensions sometimes change: sometimes its' 4x4, sometimes 6x7,
sometimes 10x10, etc. based on parameters set before opening the form. When
the form opens, the objects are created and placed evenly on the form, with
names that reflect their postion in the grid. (For example the button in row
2, column 2 is n...
|
3 |
27.09.2006 22:36:02 |
|
|
forms subforms
I have a form, sub form where I am selecting the combo box to filter records
in the subform. I have my link master/child set. ID to ID and combo0. When I
click on the combo box and select a name, I get the records in the subform
for the previous record in the combo box. If I am selecting record 6, I get
the information for record 5. When I select record 1 I get a 0 (zero) in the
id field...
|
1 |
27.09.2006 22:34:01 |
|
|
Enter time field at leftmost position
I am hoping someone can help. I have a time field on my form and when
tabbing through fields it is easily editable but when the field is clicked
into the cursor remains at that position which isn't necessarily the correct
position nor easily editable (you have to highlight the whole field and enter
again). Is there a way to enter the field in the left most poistion (on
entry) or in edi...
|
7 |
27.09.2006 22:25:02 |
|
|
How do I set a field format to remain the same when store in a tab
I have a payment form linked to a payment table. I have set up the input as
"0000-0000-0000-0000" and works great when you are entering the credit card
information; however is stored as "0000000000000" after I closed th epayment
form on the form view and the table as well. I need to keep the "dashes"
between each set of numbers for report purposes. How can I set up the field
format to ke...
|
3 |
27.09.2006 21:26:02 |
|
|
taiapo@msn.com
try again later thaink you for all your hlep taiapo...
|
1 |
27.09.2006 21:23:02 |
|
|
Format Date
I have Date field, so if i type a date it should show short date and medium
time.
I select in the form General Format and it's not working.
How can I view both same time?
Thanks...
|
3 |
27.09.2006 20:31:03 |
|
|
Toggle Combobox Sort Order
I have a combobox name Account_Num in a continuous subform. The combobox is
based upon a very simple query called AcctDescQry. The combobox pulls two
fields
1)AcctNum
2)AcctDesc
I would like to toggle the sort order with a toggle button between AcctNum
ascending and AcctDesc ascending. I am a novice at Access. Any help would
be appreciated.
Thank you
Valerie
...
|
3 |
27.09.2006 19:57:28 |
|
|
How do I make fields change colors to alert something?
I have been asked to create a database based on a control sheet which tracks
when visits are due, past due or need follow-up. Right now they maintain it
on an Excel spreadsheet and use color coding to let them know when visits are
due and such. Is there anyway to do this with the database as well? Please
be as detailed as possible when replying. Thanks!...
|
5 |
27.09.2006 19:44:00 |
|
|
Combo Box question
Hi Folks,
I have created a combo box full of numbers. I also have a check box
called assigned. When I create a record with a number that is assigned
I would it to be taken out of the combo box list and then when I
uncheck the box I would like it to reappear in the list. Where is the
best place to put my requery statement? Thanx for all your help Fred
...
|
18 |
27.09.2006 18:34:01 |
|
|
How do I convert hourly time to decimal time?
Finally figured out how to calculate a time difference and would like to
convert it to a format that is used in my workplace.
If I enter a landing time of 16:30 and a takeoff time of 17:36, the total
flight time is 1:06. However, our format is decimal-based, not
hours:minutes. That is, for this example, the total flight time would be 1.1
hours. If the total flight time is 1:08, it wo...
|
2 |
27.09.2006 18:14:30 |
|
|
populate a combo box in a form
Hi Access Gurus,
I have a form in Access 2000 which helps our department schedule classes.
The form has a combo box which I want to populate with a list of classes
from which to choose. That would be simple, but I want the combo box's pull
down menu to appear with three columns:
ClassName, CountOfRegistrationID (how many students enrolled so far in the
class) and ClassID,
with th...
|
2 |
27.09.2006 18:01:03 |
|
|
Moving Rows
I am having trouble with moving a row of information from one table to
another. Can anyone assist?
Thank you. ...
|
2 |
27.09.2006 17:55:01 |
|
|
Highlight entry value
Hi,
I'm designing a database, in which the data entry person is a modified
worker who is not familiar with computers at all.
In the entry form, is there a way to highlight the value of the entry box on
click, instead of having to delete it first and then enter?
Thanks...
|
2 |
27.09.2006 17:23:02 |
|
|
OK, I fixed one problem, now I have another
I managed to create a form with a subform. The form has date entered and
key person and operator. The subform contains all the information from a log
sheet that was filled out by the operator. They are linking by a LogID field
(autonumber).
It worked on the first database I tried it in (see post entitled "I'm Lost
Here" from yesterday). Since it was such a nifty little time saver ...
|
1 |
27.09.2006 17:16:01 |