SUBDATASHEET HELP
Thu, 6 Nov 2008 05:57:09 -0800
I am a new user of Access and need some help with subdatasheets. I have a
database set up with a one table that has a subdatasheet and that
subdatasheet has a subdatasheet.
1. Table
2. Subdatasheet
3. Subdatasheet
The problem I am having is when I add a new record in the second data sheet,
the fields ...
|
Help Needed: Calculated Fields!
Thu, 6 Nov 2008 02:59:01 -0800
I am trying to create a query with a simple multiplication of fields, ie
[Amount]*[Unit Cost] to get a Total for each item. I know I need to use a
calculated field in the query, but I have no idea how to do this! I have a
query with all my fields at the top. Where do I put the calculated field,
and how do ...
|
FIlter subform on time-range defined by mainform cboTimeRangeSelec
Wed, 5 Nov 2008 16:56:01 -0800
I have Mainform with cboTimeRangeSelector based on tblTimeRange:
RangeID Range RangeExpression
1 Month "Between Date( ) And DateAdd("m", 1, Date( )) "
2 Quarter "Between Date( ) And DateAdd("m", 3, Date( )) "
3 Year "Between Date( ) ...
|
Field Size: Integer to Double
Wed, 5 Nov 2008 15:15:28 -0700
I have this function to download data from a Pervasive SQL into MS Access
Public Function get_hrs(WOPRE As Double, WOSUF As Double)
Dim sql As String
sql = "SELECT * FROM WOLABOR WHERE MTWOLA_WOPRE = " & WOPRE & " And
MTWOLA_WOSUF = " & WOSUF
CurrentDb.QueryDefs("DBA").sql = sql
DoCmd.SetWarnings False
...
|
Nz function not working
Wed, 5 Nov 2008 11:44:06 -0800
In the MainForm there is an unbound box MainformTotal showing total from
Subform.
Its Control Source goes:
=[SubformName].[Form]![SubformTotalControlName]
and it works perfectly.
When the SubformTotalControlName is empty (no records in the Subform), the
MainformTotal control shows #Error.
I change its Contr ...
|
can i get a preview image as i hover over hyperlink?
Wed, 5 Nov 2008 11:27:01 -0800
...
|
Show Properties Window in Form-View
Wed, 5 Nov 2008 10:46:08 -0800
I've just learnt that some of my forms allow to view the Properties Window
and change it parameters without switching to Design View, while others don't
let choose the Properties Option once right-clicked and allow this only in
Design-View.
Is it selectable feature and how can I choose it? ...
|
|
|
How to adjust Access 2003 design window please ?
Wed, 5 Nov 2008 09:24:09 -0800
...
|
format question
Wed, 05 Nov 2008 13:42:43 GMT
I have a simply query, Two of the fields being First Name and Surname. All
the fields in the database are in upper case.
I would like to format the query so I get the Initial only of the first
name and lower case for the Surname with a capital first letter
So STEVE GOODRICH becomes S Goodrich
I have got ...
|
Delete query from two tables
Wed, 5 Nov 2008 00:55:01 -0800
Hello, I want to run a delete query from a button on my form. The form is a
continious form and each row has a text box "txtEmployeeID" that shows the
UserID. I want to be able to delete the information pertaining to the userID
from two tables and the "UserID"
1) tblUser -Field: UserID (pk)
2) tblInput-Fiel ...
|
