|
Logic for WHERE statement in a combo box?
I am building a room allocation part of an existing database. This
section of the database uses a table with a date, a session, a room and
a supervisor. My table is using:
fldRoomingID - autonumber - primary key
fldDate - date field
fldSession - Text field
fldRoom - Lookup field, using room numbers from a defined list in
another table.
fldSupervisor - Lookup field, using supervisors na...
|
6 |
29.09.2006 00:37:03 |
|
|
Report to PDF
I have PDF writer 6.0 and am saving(printing) my reports to pdf by OpenReport
macro. I have the default printer set to my pdf. This is working fine.
Each report is for different customers.
How can I automatically save(print) the report to pdf with [CustomerName] as
the file name?...
|
2 |
29.09.2006 00:00:01 |
|
|
Access crashes when breakpoint is removed.
Hi All,
I have a problem that i cannot figure out. I have a report that runs
when you press a button. It was working fine now all of a sudden then
the button is pressed the database crashes and closes down. I kept a
breakpoint on the button clicked event. now when i click the button and
go into debug mode the report opens and prints out and works fine. As
soon as i remove the breakpoint and ...
|
4 |
28.09.2006 23:00:11 |
|
|
Automatically populating values
The user is allowed to pick a vegetation code (VEGCODE) from a look-up table
on the form. I want 2 other controls on the form to be automatically
populated with the common name and latin name for the vegetation species (so
the user knows which species the vegcode belongs...sometimes people know
common names...others latin names). The latin and common names are values
already containe...
|
4 |
28.09.2006 22:58:01 |
|
|
Create records
Hi,
I have a main table with several child tables. I need to create a record in
each child table for the 11,000 records I have in the Main table. Can I do
this through an update or append query? The child tables only contain
records that match some of the main records, for example not all contacts in
the main table have a phone number record in the phone table.
The reason I need ...
|
13 |
28.09.2006 22:55:42 |
|
|
DATEPART, DATEADD or DATEDIFF ???I want data from last year
I have a query where I want to see the average price of orders in last
year in US or CANADA
AVG((IIf((([Location]="USA") Or ([Location]="CANADA")) And
(( datepart( 'y', ([ORDERDate])) = datepart('y' -1, getadte())
as [AVG COST LAST YEAR],
would I do -1 or what else??????????
...
|
3 |
28.09.2006 22:47:02 |
|
|
Output report to a BMP
I have searched this group and the internet. I have found some
possible solutions but none that really give me what I need.
I would like to export a report to a BMP format. I can do snapshot or
PDF but I need it in BMP.
Anyone have any ideas on how to do this?
Thanks in advanace for any help.
...
|
3 |
28.09.2006 22:22:04 |
|
|
Resort numbers
Brand new to Access.
Let me give some set up to better explain my problem.
Right now I am trying to develop a database to be used by two different
groups. The first group are shop supervisors and the second group are
mechanical engineers (of which I am one). The database will allow the shop
supervisors to input projects into a database. The engineers will then take
the projects,...
|
5 |
28.09.2006 22:15:02 |
|
|
Lengthy SQL String In VBA (Requesting Help With Line Continuation and Concatenation)
I have a lengthy SQL string in my VBA code. Using line continuation and
character and concatenation, I've tried to appease the compiler.
However, I keep getting Expected errors. I think that there are
limitations to SQL strings in VBA i.e. lines and characters. From
reading other posts, I see that multiple occurences of strSQL can be
used too. I've tried coding this string different ways with...
|
7 |
28.09.2006 21:51:02 |
|
|
Microsoft Access - Cutting and Pasting between tables
Currently, we have a database here that keeps records of all our
inventory that is out in production. When we have a piece of equipment
that is removed, it needs to be put into a removal table for
accounting/auditing purposes. Anyway, my question is - Is there a way
when I use the delete key to automatically cut it from one table and
paste it in the the removal table?
...
|
3 |
28.09.2006 21:44:09 |
|
|
Query Results in a Report
How do I show multple query results in a report. I don't want to show the
whole query but the results of the query....
|
2 |
28.09.2006 21:41:02 |
|
|
How to change owner of macro object
Hello,
I have a task to change Autoexec macro in my company Access application, but
Access doesn't allow it, it says that I don't have read premissions for this
object, and that I don't have read design premissions for it.
When I open User and Groups premissions dialog it states that current user
is "Admin".
For every object I have all rights except Autoexec macro.
How to solve it??
...
|
4 |
28.09.2006 21:39:19 |
|
|
Can anyone explain this
I have a report to filter records
Here is what I entered into the Criteria field to create a parameter
query for the filter
Like "*" & [Enter Sub Category or leave blank for all] & "*" Or
[Enter Sub Category or leave blank for all] Is Null
and it works!
Somehow, after I save the query, and reopen it, the Criteria field gets
truncated to
Like "*" & [Enter Sub Category or leav...
|
13 |
28.09.2006 21:26:14 |
|
|
How to find keywords in visual basic code?
I am working on some visual basic code that refers
to the query that the form is based as follows:
me.QueryItem
But under help the me brings nothing. How to find
out if this is keyword or not? If it isn't how to find its
definition?
...
|
2 |
28.09.2006 21:14:39 |
|
|
creating a new module and populating in with vba
Howdy
Is there any way to create a new module usng vba along ?
I checkout the app.modules collection, but there doesn't seem to be any
"append" or "insert" method.
Any suggestions ?
The scenario is;
We have developed an add-in.
The first time the addin runs I would like to have the addin create a
new module with a function that can be used in the startup of the
master database.
Thi...
|
1 |
28.09.2006 20:58:39 |
|
|
AutoNumber
I have an AutoNumber field in my database but Access skipped some numbers;
how do I fix this? I want all the numbers to increment by "1"...instead, it
goes from 1-43 and 154-208. I tried to change the starting number of an
AutoNumber field but it didn't work for this particular case.
Any help would be appreciated....
|
12 |
28.09.2006 20:46:50 |
|
|
Print Preview Multiple Page Icons
I'm trying to find the multiple page icons (one page, two page, multiple
pages), or the menu pick - View, Pages... to place in a custom toolbar. Is
this not available, or am I just not looking in the right place while in
Customize?...
|
2 |
28.09.2006 20:39:33 |
|
|
How to run access 2003 from the command line?
I have access 97 and 03 running on the same computer.
The following command only brings up the 97 version:
"msaccess.exe /decompile"
How to bring up the 03 version with that command?
...
|
2 |
28.09.2006 20:37:31 |
|
|
Where is Northwind Database?
I just installed Access 2003 and Office 97 is still on
the computer but I cannot seem to find the example
DBs.
...
|
9 |
28.09.2006 20:30:50 |
|
|
TransferSpreed Sheet
I'm having trouble figuring out how to transer ALL sheets in a single
workboog into an access table at the same time.
I've tried using a 3d range in the argument =ACNI04:SNFP01!B55:G160
But it doesn't seem to like it. If I leave range blank, it only brings in
the first sheet. How do I import every sheet and append them regardless of
their number and name.
Thanks!...
|
2 |
28.09.2006 20:28:46 |
|
|
can you view access database pages without access on your comp
I am about to put Access on several computers here at work. will other
people v\be able to view these database spreadsheets?...
|
2 |
28.09.2006 20:21:50 |
|
|
Can't use pivot table view on replica
Hi,
I just replicated an existing database which contained queries in pivot
table view format.
The replica looks good except that when I run the existing queries, the
pivot table view retrieves a blank page. I have to drop the row, column and
data fields again.
Since you can only make design changes to the replica I have to do this
everytime I want to display the pivot table in my r...
|
1 |
28.09.2006 20:01:02 |
|
|
launch copywrite/tite page while loading main form
I am an extreme amateur in Access.
I have hidden my database and set the default form at launch to be a
copywrite/title form. I want to use an ontimer event so my copywrite/title
form remains open while my main form loads and displays behind it. Then, at
end of timer the copywrite/title form closes allowing user to view and access
the main form.
I cannot determine how to accomplish ...
|
3 |
28.09.2006 19:56:01 |
|
|
Hide a Record
I have a database that tracks the status of certain tasks. I would like to
be able to "close" a task using a drop down field on a form. After I close
the record, I would like to keep the record available to me (in case I need
to reference it later) but I don't want it to be one of the active records in
the database. In other words, if it is record one, when I open my form, I
should be...
|
2 |
28.09.2006 19:22:01 |
|
|
query to find avg of ordertotal from last year and this year
I need to find out the avg amount of Ordertotal for last 1 year and
this year
if location is USA or Canada
This query gives me error for present year and how do I do this for
last year
avg((IIf((([Location]="USA") Or ([Location]="CANADA")) And ((
(datepart( 'y', ([OrderDate]))) = (datepart('y', date() ) )),
Ordertotal ,0))) AS [Average Order Amount This year],
Will...
|
1 |
28.09.2006 18:56:41 |