Problems Retrieving Database

H

help1080

i'm trying to run a report, but whenever I try it gives me an "Action Failed"
error.

Condition: True
Action Name: OpenQuery

how do I stop this?
 
W

Wayne-I-M

what are you "doing" to run the report. Clicking a button, updateing a
control, closeing a form, etc, etc.

If you could post the code behind this event you will get a better answer
 
H

help1080

Hello,

Before I begin, let me say I never designed this databse, nor do know access
programming, I just know how to use it access.

Anyways,

When you open the file, you get three options:
Enter Invoice Number
Update table
Exist Databse
Click to expand...

so... what you do is, enter the invoice number, close the window, then click
on update table. close access.

open the excel file...asks you to update, and enable automatic refresh. you
click on update then on enable automatic refresh.

and from my previous post about pages. the maximum number of pages the
report will run is 3 pages. and sometimes invoices are longer. how do you add
pages so excel can retrive from the databse and automatically update the
macros itself.

I don't know if this makes any sense, but thanks in advance.
 
W

Wayne-I-M

Hi

1st you didn't mention that you were transferring to excel in your previous
posts.

What you describe doesn't seem that difficult to fix you have a prompt on a
query that updates a table and then transfers the data to excel. It is the
export that seems to be the problem.

BUT rather than you going into any form code or DB modules (and "possibly"
messing things up) I would strongly suggest you get someone to come in and
look at the DB. Work out what you want them to do (before they arrive - it
will keep their time and so costs down) and ask them to fix the DB for you.

If you place a post in this forum stateing approx. your office location and
ask for anyone who sub-contacts out I am sure you will get some answers -
don't put your exact location or private email in this forum though.
 
J

John W. Vinson

Before I begin, let me say I never designed this databse, nor do know access
programming, I just know how to use it access.

Anyways,

When you open the file, you get three options:


so... what you do is, enter the invoice number, close the window, then click
on update table. close access.

open the excel file...asks you to update, and enable automatic refresh. you
click on update then on enable automatic refresh.

and from my previous post about pages. the maximum number of pages the
report will run is 3 pages. and sometimes invoices are longer. how do you add
pages so excel can retrive from the databse and automatically update the
macros itself.

I don't know if this makes any sense, but thanks in advance.
Click to expand...

There are evidently errors in the database programming - not errors in
Microsoft Access, but rather in the program developed by the person who
created this database. The prompts that you see come from this person's
program; they are NOT builtin Access features. Access doesn't "know" anything
about invoices, any more than Peterbilt knows what will be hauled in the
trucks they build.

You will need to either contact the person who designed the database; hire
someone who knows Access to fix it for you; or climb the rather steep learning
curve and learn how to fix it yourself. We'll be glad to help with the last,
but don't expect us to be able to give you a "go here and do this" answer,
since we can't see your database nor do we know how your programmer set it up!

John W. Vinson [MVP]
 
J

Jaime Mediavilla

no me importad


Wayne-I-M said:
what are you "doing" to run the report. Clicking a button, updateing a
control, closeing a form, etc, etc.

If you could post the code behind this event you will get a better answer
Click to expand...
 
Top