|
Ascending order
Hey guys,
I've created a report based off one of my queries, put in all of my hardwork
into it and sorted "ascending" vs. "descending". Is there a way to remedy
this without starting all the way over from the beginning?
Andre Adams...
|
4 |
5/30/2007 5:43:36 PM |
|
|
Access 2003 Reports and Vista
Why cant I view Access 2003 reports in Vista. I can view the reports using
XP Pro.
Thanks...
|
4 |
5/30/2007 4:30:47 PM |
|
|
Send Password
Is there anyway I can send a password for an ODBC connection (SQL) database.
I have information I am taking from a SQL program and want to share with
others. I don't want to give out the password but want the Access
information to update when the database is opened. I need to send the
password, can I automate with a macro? Thanks
...
|
3 |
5/30/2007 3:13:03 PM |
|
|
Help needed with IF DSum in query
Hi
I have created a transactions table in an inventory application. I have also
created a DSum function that shows the quantity in stock on a form, by
calculating the number of incoming transactions minus the number of outgoing
transactions.
However, I would like to include this DSum function on a query. The query
asks the user for what make of shoe, name, colour and size they want. ...
|
10 |
5/30/2007 9:07:35 AM |
|
|
Input Box
Is there any way you can change the way an Input Box is displayed that is
used in an On Click event procedure?
For example: size, position, colour etc>
Thanks for any help...
|
2 |
5/30/2007 8:03:37 AM |
|
|
Simple Question re: Input box for query which selects Table to get data from
Hello, i would appreciate any help regarding a problems i am having.
I have setup a simple database with working query's. Sadly i think it
would be a much better design
**if i could run my query's & have it ask me what table i would like to
extract the data from.**
Currently at the end of each day i am provided with a 2 new csv files. I
have been importing the tables and calling the f...
|
4 |
5/30/2007 7:21:38 AM |
|
|
Lookup wizard question
I have a large table with 2 columns (first name and last name) in it and I
would like a drop down of a list of possible first and last names from the
Name table. I am using the Lookup Wizard for the list of names but if I
have 25 "Joe's" with different last names, is there a way that in the drop
down for "first name" that Joe only appears once?
Thanks
...
|
5 |
5/29/2007 11:37:31 PM |
|
|
Date Range
Hey guys.
I want to know...Is there a way in Access that I can have the Date Range
that I type into the query to show up automatically in a report. So if I ask
the database to find me all records within 01/01/2007 and 01/31/2007, can it
insert that date in to the actual report to let the user know that date range
of the report their looking at?
Thanks.
Andre Adams...
|
2 |
5/29/2007 7:58:35 PM |
|
|
New Query
If I want to create a query out of the below information, how would I do it?
Money Manager (Our clients)
Account Number (Clients Account)
Gross Commission (Commission Generated - on per trade basis)
Plan Sponsor (State account is sponsored by)
So the table looks like this....
Money Manager Account Number Gross Commission Plan Sponsor
Best Suits, LLC 39875 ...
|
8 |
5/29/2007 4:28:04 PM |
|
|
Putting a space in front
Hi,
I created a web site about a year ago, and never published it. I plan to
publish it , but I have noticed that it is now the style to have space on
both sides of the page. I assume that is to accomodate all of various
browsers out there.
My site was designed to be left justified. Is there an easy way to add
space in front of all of the cells at once? Thanks...
|
2 |
5/29/2007 2:41:18 PM |
|
|
Centering a form
Hello, I have a form In my database and its size is Width 9.375". But when I
open it, its always to the left. Is there anyway to center the form in
regular view without using the pop up option? I use this on different sized
PC screens and wanted it centered because it looks stuped on larger screens
being all the way to the left....
Thanks, Chad!...
|
8 |
5/29/2007 2:17:54 PM |
|
|
Text Column
Hey guys,
If I have a 1V and a 16 in the same column, will access import both these
fields under text? Under what data type do I import them?
Thanks.
Andre Adams
Loop Capital Markets...
|
4 |
5/29/2007 2:03:03 PM |
|
|
Moving to Access 2007 from 2003 - where is the Tables View
Can someone direct me in the right direction.
I have just moved to Access 2007 from 2003 and I have a issues I can't
resolve (and feel silly about it).
I have a very complicated but well behaved Access DB (from 2003).
It works fine under 2007 however.... I can't find the Tables View (in
2003 I had tables, forms etc) all that is hiden under the 2007 DB?
Now I know this is becuase i...
|
2 |
5/29/2007 11:23:06 AM |
|
|
window resize issues after relink tables
Hi All,
I hope i can explain my situation clearly..
I have resized the windows containing the forms to show a few rows of details
After resizing, i saved the forms and have no issues with the window sizes
whenever i open and close the forms after that. Everything is fine.
After I re-link the tables, I have issues keeping these window sizes
containing the forms:
If I had set the form p...
|
4 |
5/29/2007 3:52:57 AM |
|
|
how to record time in minutes, seconds & milliseconds in a table
I am trying to record results for athletics meetings and cannot format the
time cell to accept the data in the above format. Any help much appreciated....
|
2 |
5/28/2007 11:52:57 PM |
|
|
closing a pop up
Helo, I have a button on a form that brings up a pop up that has buttons to
bring up reports. My question is what can I add to the VBA code to close this
pop up when I run a button? all my reports run a query that asks for a date
range name ect. so I still want to be able to run that. The pop up will stay
ontop everything untill I close it and its getting anoying...
Here is one of the cod...
|
8 |
5/28/2007 7:47:01 PM |
|
|
sorting question
I have a database which includes a date of birth field'
I run a report based on a query showing me the "birthdays this month"
I added a column to the query Month([date of birth]) criteria Month(Now())
I would like to sort the birthdays by day - when I sort by the date of birth
it sorts by year
how do I get it to sort by day
many thanks
Steve
...
|
3 |
5/28/2007 6:48:48 PM |
|
|
embeded forms
I have a "Stock" form that is based on a Query of the Stock Table and a
couple of other Tables. I have embeded that form in another form that is
based on a Cusomer Table and linked the query to an Unbound text box. When I
put a stock item into the Text Box, I think that it should displat the record
in the embeded form. However, even though the Query and the Form display the
correct recor...
|
7 |
5/28/2007 9:33:00 AM |
|
|
Problem filtering records using date
I have a telephone log database but am having problems filtering for all
records for a particular date using Filter By Form. The underlying table has
1 DateTime field using the General Date format and it's populated through a
data entry form. All forms are based on queries.
The form used for filtering is a read only form that's been set up with (2)
copies of the DateTime field. The firs...
|
5 |
5/28/2007 2:42:00 AM |
|
|
Need help with Report formula
Hello, I have this formula:
=Abs(Sum([Shift]=1)*[DT REGULAR])/Abs(Sum([Shift]=1)*[EMPLOYEE TIME])
in a text box in a report just showing a total for shift 1 thats on the
report. I want to change it to show by Supervisor and name like this:
=Abs(Sum([Supervisor]=Bill Black)*[DT REGULAR])/Abs(Sum([Supervisor]=Bill
Black)*[EMPLOYEE TIME])
It keeps giving me an error when I change the ...
|
7 |
5/27/2007 4:20:01 PM |
|
|
Formula in text box on RPT help...
Hello, I have this formula:
=Abs(Sum([Shift]=1)*[DT REGULAR])/Abs(Sum([Shift]=1)*[EMPLOYEE TIME])
in a text box in a report just showing a total for shift 1 thats on the
report. I want to change it to show by Supervisor and name like this:
=Abs(Sum([Supervisor]=Bill Black)*[DT REGULAR])/Abs(Sum([Supervisor]=Bill
Black)*[EMPLOYEE TIME])
It keeps giving me an error when I change the ...
|
10 |
5/27/2007 4:18:01 PM |
|
|
Query expression Help
Hello, I have a query that I want to have an expression and I wnat to use it
on a RPT but everytime I write it it asks the expression after it asks for my
date range. I want to sum EMPLOYEE TIME for a perticular supervisor say Bill
Black. How would I write this in the query as an expression and the criteria
being Bill Black?
Thanks!...
|
9 |
5/27/2007 4:16:00 PM |
|
|
Slimming down an application
I have an application that behaves differently on different computers. It
has suddenly begun to behave irrationally on 3 out of 5 computers. The
problems are in formst that haven't been edited, but which are large and
complex. After checking out OP Sys and Access release levels, my best guess
is that the problems happen on the computers with the fewest resources, so I
undertook to try...
|
2 |
5/27/2007 9:49:06 AM |
|
|
Backup and Restore Files
A short time ago I placed on this post a simple question:
What is the best way to backup and restore a runtime database file?
I received a lot of valuable input but none that I could really use. To
understand what I was trying to accomplish let me explain the parameters of
the program.
The program was written for yacht owners, specifically to keep track of
maintenance and fuel cost as...
|
2 |
5/27/2007 9:44:58 AM |
|
|
REQ: Date field and automaticl Sort field fill - solutions, ideas
Hi,
I am putting together a simple database of parish register transcriptions.
My date field (text) looks like 01 Jan 1813 to enable me to carry out sorts
on this field I have set up a sort field 1813 01 01. I only want to enter
the data into the date field and have the sort field automatically created
and filled in.
Any ideas solutions would be much appreciated.
Jeff
...
|
5 |
5/27/2007 7:40:15 AM |