Echo?
Wed, 10 Dec 2008 21:29:34 GMT
I have a form open on startup, and code run on the form open. All the code
does is follow a hyperlink, then close the database.
I'm basically using the database as a "portal" from a frontpage website, so
anyone who does not have access to the department drive (where the database
is), won't be able to access t ...
|
Macro Running Qurey with Multiple Criterior for Export to Spreadsheet
Wed, 10 Dec 2008 20:47:50 -0000
Hi All,
My skills are such that I need to do this with a macro if possible.
Currently I have five virtually identical queries with slightly different
criteria that I need to transfer to spreadsheet. I am ok with the transfer
to spreadsheet because that is how I am doing it now, but can anyone suggest
how, i ...
|
Re: Need most recent date out of many
Wed, 10 Dec 2008 11:08:01 -0800
So...this might be a stupid question, but what if there was a third field
with "Item Ordered" and this was also needed to be pulled in, as the most
recent ordered item, along with the most recent date?
Thanks!
"Jason Lepack" wrote:
> Is OrderDate a Date/Time or Text? If it's text then I only have one
...
|
Tables screen not showing anymore
Wed, 10 Dec 2008 11:01:01 -0800
I have no changes on my computer and no changes were made to securities or
anything else other than adding certain people to have access.
This morning someone came to me and said the form pops up when you open the
database but now the window with all the tables/queries, etc. won't show in
the background an ...
|
Dates stopped
Wed, 10 Dec 2008 10:58:12 -0800
I am working a project with a huge database in access. The person that
created it is no longer with the company and not willing to help with
anything.
The queries just stopped feeding any information down the line after
September 28, 2008. I have gone through tons of tables and queries on all of
the data ...
|
Crosstab Query Omitting Some Items
Wed, 10 Dec 2008 10:38:27 -0800
I have developed a query by the name of Query1 that pulls only those product
units that have been sold over the last 14 weeks. In this query, I have
[date_purchased], [product_model], and [units_purchased].
I am now trying to create a Crosstab Query off of Query1 that totals
[units_purchased] on a weekly b ...
|
Date Expressions
Wed, 10 Dec 2008 08:31:35 -0800 (PST)
Does anyone know how to make an expression pull dates that are greater
that two months old? I'm looking at building a database that will
allow me to track the employees that have been here for more than two
months. ...
|
|
|
Can I have user input update "Top Values" in Property Sheet?
Wed, 10 Dec 2008 08:21:02 -0800
I have created a Query to filter numbered values greatest>lowest, Is there
any way I can add a prompt to allow the user to input how many of those
records they want to see returned? That way if they only want to see 10
records they enter "10", if they want 40 records...you get the idea.
Thanks. ...
|
Help with Date Ranges
Wed, 10 Dec 2008 08:18:00 -0800
I'm trying to show "within TRTW" or "Not TRTW" using fields already in my
query. This is what I have been trying but I get the following error "You
must enclose IIF function arguements in Parentheses"
Status Within TRTW?: (IIF[Time Tracking]![Benefit Begin Date] Between [TRTW
- Scorecard]