Filtering records based on user
Mon, 6 Oct 2008 15:59:31 -0700
I want to set up a filter where a specific user can only see certain records
within my tblEmployees. I have a table (tblDepartments) that is linked to my
tblEmployees. I also have a table (tblUsers) that is linked to tblDepartments
as well. Each user has a specific department they are responsible for so I
on ...
|
passing params to multiple querydefs and transferspreadsheet
Mon, 6 Oct 2008 15:38:19 -0700
Hi,
I know how to transfer params from a form to a querydef. And I know how to
use TransferSpreadsheet to put query results into spreadsheet. What I'd
like to do is combine the two for multiple queries, e.g.:
Open my form
1 Set a Querydef equal to an existing Access query
2 Pass the params from the for ...
|
Entering New Records - Joins
Mon, 6 Oct 2008 15:42:05 -0700
Hi,
I have a data entry form that displays data from 3 tables, the main client
table and 2 archived data tables. The main client table has more records than
the two archived tables, including new clients.
The primary key is the client ID number. Data is retrieved and displayed in
the form including arch ...
|
Calculating Monthly Averages in a Query
Mon, 6 Oct 2008 14:42:24 -0700
Say you calculate total sales every month by pulling out "month" from each
sale date using the DatePart function, and setting "Month" to "Group By" and
"Sales" to "Sum".
How would you use the SumOfSales column to calculate the average sales per
month? I want the number of months to be a parameter so it can ...
|
Access 2003 Crashes when I delete a record
Mon, 6 Oct 2008 14:18:21 -0700
I am deleting records from a table. I can usually delete the first one, and
then when I delete the 2nd one, Access crashes. Every time. I'm at SP3, have
turned off cascading deletes, have compacted and repaired the db several
times.
This is a new problem. I used to be able to delete records without a
prob ...
|
query look up(?)
Mon, 6 Oct 2008 14:11:43 -0700
Hi,
I use the following code in a click event on a command button in my form to
look up data in a table & insert the relevant info into text boxes on my
form. However, can I use this simular code to carry out the same function
but looking up the data in a query (as apposed to a table)??
I know it wont be e ...
|
Runtime ERR 3075 in VISTA
Mon, 6 Oct 2008 13:17:02 -0700
If I add a new WHERE clause to a SELECT query the query definition will
not be saved.
Any existing query with a clause, when run, returns a runtime error 3075
A table with say RECNAME, RECDATE and RECADDRESS fields will list all
records if I SELECT them.
But if I want say records WHERE RECDATE <DATE()-10 the ...
|
|
|
PCCharge SDK (developer's kit or devkit)
Mon, 6 Oct 2008 12:41:34 -0700 (PDT)
Hello everyone,
Does anyone have the PCCharge SDK (developer's kit or devkit)? I just
need
the VB instructions for the File Method, I do not want to spend $598
and purchase the entire SDK Suite, only for the VB instructions for
the File Method. I am ready to pay you whatever you think is fair for
sharing
this ...
|
Query results
Mon, 6 Oct 2008 12:30:31 -0700
I'm trying to get the criteria in my query to produce a form that shows a
list by customer. Say my customer name is ralph but it might have different
offices so in our customer database we might have ralph-windsor or
ralph-london. I want them to be able to type in "ralp" and get any customer
with "ralp" in ...
|
Errors Trying to Open Database
Mon, 6 Oct 2008 12:11:12 -0700
Good Afternoon: I am so frustrated I don't know where to begin. I'm
attaching a zipped file that I have been using everyday without a problem.
But, starting last week I was unable to open this file. I tried removing MS
Office and reloading, I've tried looking at security settings, I just don't
know where ...
|
