Description:
MS Windows' relational database system, Access.
|
|
|
SQL extra filtering query
|
| |
Hi,
I want to filter further the results I get on a query which contains 2
fields "average no of transactions" and "no of transactions". I want
to return only records where the no of transactions is less than 20%
of the average.
I use the following new field:
Expr1: 1.2*[SumOfCreated transactions]-[AvgOfCreated transactions]... more »
|
|
|
Send report to individual recipients
|
| |
I have a difficult problem with a database. We have patients from multiple GP Practices. We need to send these practices an individual report with the results for their patients, say on a monthly basis. There may be up to 80 practices.
I think I understand how to, say, send one email containing one report... more »
|
|
|
Speed/Performance
|
| |
When opening a recordset, is it signficantly faster to use a saved query instead of a select statement?
I'm using Access2000 & FrontEnd/BackEnd with linked tables
Option 1:
Dim rst as DAO.Recordset
Set rst = Currentdb.OpenRecordset("Selec t * From tblInvoices Where Cust=" & txtCust & " Order By InvoiceNum")... more »
|
|
|
SQL query that uses parameters
|
| |
Hi,
I am trying to write an Access query where I choose the tablename the
results will be output to. I thought the following should work but I
end up with the results stored in the actual tablename called
"tableName"
PARAMETERS [TableName] CHAR;
SELECT [Averages - 2].* INTO [@TableName]
FROM [Averages - 2];... more »
|
|
|
Making Sure A Database Is Running
|
| |
I need to run a process using a timer. The process needs to be running all day long. We are looking for a way to ensure that the program is running, and, if not, then relaunch it.
Some thoughts I had were:
1) Find a utility that runs in the background and checks periodically if the db is running, and, if not, relaunches it.... more »
|
|
|
Force Instantiation Of Excel 11?
|
| |
I've got an environment where both Excel 11 and 12 have been
installed for a year or so.
Excel 11, however, was the default version.
But recently somebody's Excel app broke when the data exceeded
65,000 lines. Accordingly, The Powers That Be changed the
environment so that Excel 12 became the default.... more »
|
|
|
Print Excel 2010 Sheet to PDF from Access 2010
|
| |
Hi,
I have an Access app that I need to do the following:
1. Open an Excel file
2. Change a value
3. Print a sheet to pdf
4. Close Excel file
Because the production machine is Office 2007, I am using late binding and don't have a reference to the Excel object library.
Because of this, the code is failing at Step 3:... more »
|
|
|
Access10: used for a photos database?
|
| |
I have Access10 that I use for invoicing etc and I
want to use it for sorting and cataloging my photo
collection.
There are over 3000 photos altogether.
Can someone give me some clue about starting this?
Peter
|
|
|
Indexed field
|
| |
In Access 2010 I defined a table field as indexed no duplicates but I have no idea how to use this index to find and display any particular record on a form. Can any one help please?
Thanks,
Eric. (fairly new beginner)
|
|
|
* * * OnTimer event may be the cause of your pain! * * *
|
| |
I have a huge project that has turned into a debugging disaster. Errors are multiple and inconsistent, I am (or was??) baffled, client is furious.
Erorrs include:
2162: A macro set to one of the current field’s properties failed because of an error in a FindRecord action argument.
3420: Object invalid or no longer set ... (everybody's favorite vague error)... more »
|
|
|
