|
Drop down subforms
Okay, this is what I want to create. I thought it would be easy, perhaps I'm
just having a mind blank, but I can't figure it out.
I have a main form with course information.
I want a subform with student info - name, location and contact info.
I want this subform to work in such a way that once a student is added once
I can choose them from a drop down menu and it will display all the ...
|
2 |
22.09.2006 17:36:01 |
|
|
graphs don't show in a form in access
I have a form with several graphs that don't fit in just one page. Although
the form runs perfectly and all graphs get updated, when I print it out (or
even by looking at the print preview) the graphs in the second page don't
show...there is only the outline of the frame of the graph. What could I be
doing wrong? Thanks!! Alejandro.
...
|
1 |
22.09.2006 17:24:02 |
|
|
Email different messages based on check boxes
Hi,
I have a parking database that I need to send emails out to people once
they have been assigned a parking spot. I have 3 different types of
parking (handicap, VIP and Regular).
The problem is I have 2 check boxes one for VIP and 1 for handicap and
I have written my code as follows:
'***creates an instance of Outlook
Set objOutlook = CreateObject("Outlook.application")
Set objEmail = ob...
|
5 |
22.09.2006 17:03:32 |
|
|
Combo box default value
I currently have combo box in which agents select their own ID when they are
completing a quote.
THey also have their own log ins and I was wondering if it was possible to
set this combo box default value to the current user.
I have tried entering =CurrentUser() in the default value but this does not
work
Any ideas?
Thanks,
Matt...
|
22 |
22.09.2006 16:21:02 |
|
|
To John Vinson if possible
I did what was recommended below but am having an issue.
How do I incorporate the delivydname(tried adding it as a primary key and
get no records on the query)
I believe this should be Client specific. I am having an issues with having
the same yard numbers for different del yard NAMES
Example:
Prairie Material’s yard # 15(Delivydnum) is Addison(delivydName)
Ozinga Concrete’s ...
|
1 |
22.09.2006 16:20:01 |
|
|
Run-time error for Invalid brackeing....
Hi,
i have a crosstab query and a Form, when I run the query through the
Form it populating
Run-time error '3126'
Invalid bracketing of name '[Forms][frmMainForm]![Date]'
where Date has been declared as a PARAMETER in crosstab query,
i tried to change the bracketing but nothing is happening only getting
the same error
pls anybody suggest me the right way of declaring this.....
...
|
10 |
22.09.2006 16:06:09 |
|
|
sub-form problem- i'll try again for help
i have a form with a subform attached. actually the subform does not share
data with the same form, but is an independent table. The table on which
the subform is based is edited and records are added from another dabase
with a
linkded table. I would like to have the subform requeried every time the
underlying table is added to. Is there anyway to do this? An alternative
would be to requery...
|
3 |
22.09.2006 15:37:03 |
|
|
Autopopulate
Hello.
I have been successful in having field 2 autopopulate based on entry in
field 1 combo box based on a query I built. This however, is the only
time I have gotten it to work. I have tried to do the same autopop in
a new form, checking and re-checking to make sure everything is the
same, but cannot get it to work more than that one time. What am I
doing wrong? I have many things I ...
|
10 |
22.09.2006 15:36:20 |
|
|
Expression for Min/Max values in subform
Good day,
I need an expression that groups on data from a sub-form.
The form I have tracks car mileage for a given day. The master form has
boxes for Date, Odometer start, Odometer End and a text box for an
expression to calculate the difference on the Odometer fields. The subform
is a table for starting and ending odometer at each stage of a given day.
An ID generated by Autonumber a...
|
1 |
22.09.2006 15:00:24 |
|
|
Filter issue?????
I know the problem is with my Where clause but I am not sure how to fix
it. Here is the error.
Syntax error in date in query expression '([RCName]= 'Athletics' AND
[DeptName] Like '*' AND [Date Entered] Between ## and #9/22/06 >0)'.
Here is the current code:
Private Sub Apply_Filter1_Click()
Dim strRCName As String
Dim strDeptName As String
Dim strDate As...
|
3 |
22.09.2006 14:40:53 |
|
|
Due Dates and Option Groups
Hello;
I am working on a Contact database to track psychiatric appointmets. I am
new to this, so I am just learning and I need some help. I have a subform
which has the following fields
DOC#
Appointment Date
Appointment Time
Return to Clinic
I would like to have an Option Group which would calculate the following
options from the Appointment Date field and return a date automat...
|
7 |
22.09.2006 14:28:02 |
|
|
Autonumber
I have two querries from one table, and each querry create different form.
In this table have autonumber, how can I create the form share the
autonumber, for example, enter data into each form, will add the data into
table follow the autonumber.
Thanks...
|
2 |
22.09.2006 14:17:02 |
|
|
Open Excel spreadsheet from Access form
Hi,
I want to open an Excel spreadsheet from an Access form using Call Shell.
This is what I have so far:
stAppName = "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE " &
Chr(34) & "C:\Documents and Settings\worksheet 1.xls" & Chr(34)
Call Shell(stAppName, 1)
Only problem is, I want to prompt the user for the path to the spreadsheet.
The name of the spreadsheet ("worksheet...
|
6 |
22.09.2006 13:41:27 |
|
|
Access Security with Oracle back end
I have a database in Oracle XE with an Access front end. It connects
successfully via ODBC without any problem. All the data is accessible but no
inserts or updates will work. I have created a new Workgroup Information File
with a default administrative user (as described in SECFAQ) which is the
default administrative user in the Oracle database and the user that logs in
through the ODBC. Ev...
|
5 |
22.09.2006 12:45:43 |
|
|
Lost form Design Rulers
I have using Access for years but all of a sudden I've lost the form rulers
(white area at the top and left side of the form) as well as the box at the
top on the left that you click to select form properties. I use several
databases and this is true on all of them. When I access the forms on other
PC's I don't have this problem. Anyone have any ideas?
--
Gary in Michigan, USA...
|
3 |
22.09.2006 12:33:02 |
|
|
Filter error
hi can someone help! pleease! i've created a filter for a date and a text box
that contains the phrase "no performance target" however i keep getting an
error saying 'data mismatch' 'syntax error' how can i fix this?
If Me.ch_exercised = -1 And Me.ch_pt = -1 Then
Let Me.Controls("frm_options_issued_list").Form.FILTER = "((DATE_EXERCISED =
Is Not Null))" And ((PT_NAME = "no performance tar...
|
3 |
22.09.2006 09:24:54 |
|
|
Command button transparency
Is it possible to change the level of transparency of a command button? I
would like to set some to about 50% transpasency so that both the button and
whatever is underneath can be seen.
tia
--
Jock Waddington...
|
7 |
22.09.2006 01:31:34 |
|
|
Easy way to transpose a query view
I have a table with many fields (columns). I want to compare 3 rows. The best
way to do that is to have the 3 rows in columns and then all the field values
as rows.
Is there an easy way of transposing the normal table view to this other
format?
--
Diane...
|
4 |
22.09.2006 00:22:38 |
|
|
Please HELP!!
I have the following code which gives me my stock quantity ....
Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As Long
'Purpose: Return the quantity-on-hand for a product.
'Arguments: vProductID = the product to report on.
' vAsOfDate = the date at which quantity is to be calculated.
' If missing, all transactions a...
|
5 |
21.09.2006 23:04:11 |
|
|
Allen Browne's code for duplicating selected data in subform
Hi,
I have a form/subform for Bin numbers and activities. On the main form is an
unbound search box and a bound combo box for Bin numbers. The subform shows
all activities related to the Bin number selected on the main form. No
problem. On the subform is a command button to run code that duplicates some
of the data of the subform record and creates a new record for the same Bin
number. ...
|
1 |
21.09.2006 23:00:23 |
|
|
Calculation in a form
I have a table that I have based a form on. This form is used to update and
add information to the table. There are three number fields in the form
(from the table). Field 1 and Field 2 are for entering numbers, Field 3 is
to add the first two fields and return the sum in Field 3. All three numbers
are then to be added to the table. I am having a hard time having Field 3
(the calcul...
|
10 |
21.09.2006 22:30:01 |
|
|
I have a form based on a query and it won't let me input data
I have created a form based on a select query. The query has linked tables as
well as imported ones.
I have been able to input data directly into the form - until I tried today
and it won't let me (just the ping).
Any ideas?
Thanks...
|
2 |
21.09.2006 22:29:53 |
|
|
Opening app
I have my app all ready to use. Problem is when I open it using a
shortcut to access with startup as my input form, The form opens up
fine but behind it I see the access application/development window. I
only want to see my input form when I invoke the app.
Could someone please tell me what else I need to do in startup to make
this happen?
Thanks
Joanne...
|
8 |
21.09.2006 22:22:15 |
|
|
combo box search
i have a combo box that is based on a query.
PrimaryKeyID, Lastname, Firstname.
I want the user to be able to search on the lastname but
i need the PrimaryKeyID stored.
thanks for the help.
patti...
|
3 |
21.09.2006 22:02:01 |
|
|
How do I exit a form without saving the entered data in a table?
I created a form that takes data entered by users and saves it to a table. I
added a "Cancel" button. If a user begins to enter information in the form,
but decides not so save it to the table, I want this button to close the form
and not save the entered data to the table. Are there any suggestions?...
|
9 |
21.09.2006 21:24:02 |