Export/link Access2007-report
Tue, 8 Jul 2008 00:49:00 -0700
I developed an application (in Access2007) and there is one report that I
want to have (semi)online for my clients. One has told me that 'sharepoint'
will do. Is there anywhere a trial sharepoint services website so I can
evaluate some issues? ...
|
Access 2003 - Send Object - via Email/Report
Mon, 7 Jul 2008 19:47:01 -0700
I am running a macro, where I run a report, and email it to a bunch of
people, etc. on the bottom of the macro building page, there is a field
called 'template file' Where do I find information on WHERE to store the
file, WHERE to save it, how to build it, etc. thanks in advance.
brad ...
|
sendObject - email opens for editing
Mon, 7 Jul 2008 14:06:21 -0700
I am emailing query output thru the sendObject command, using Lotus Notes.
According to the Help, putting "No" in the "Edit" parameter is supposed to
keep the message from opening for editing prior to being sent. This is not
working. The message opens and I have to click 'send' manually in order for
the mess ...
|
Secure acces with Windows login
Mon, 7 Jul 2008 00:51:03 -0700
I want to secure my database using the login of Windows.
This because i want to now what everyone is doing. when someone is logged in
i can use currentuser (i think) and can see what she of he has done.
Is someone who can help me??? ...
|
Macro
Sun, 6 Jul 2008 20:51:29 +0200
hi everyone,
I have an access table with 5 fields and 50 records
like this,
acctnum name address zip city
can anyone give me a tip how to divide this table into 2 parts,
so instead of having one table with 50 records I need to have 2 table each
25 records,
I know I can copy the table & past ...
|
calculating averages from form fields
Sun, 6 Jul 2008 08:45:00 -0700
I'm new to Access 2007 and need to know if I can do an average on the
following fields from my Form:
My form name is Benton
I have three fields:
Field one is "Grade"
Field two is "Grade1"
Field three is "Grade2"
I want to do an average of Grade1 and Grade2 and put it in Grade
I want all of this done from ...
|
parameter collector form for query shows #Name? error
Fri, 4 Jul 2008 20:04:01 -0700
Hello every body,
I have a table that has three column: Share Date, Company Name and Price.
Using this table I made a query that will fetch the share price of the
companies within a specified date range.
As running this query is tough for some people, I made a form which will act
as a parameter collector ...
|
|
|
hastile error
Fri, 4 Jul 2008 11:34:01 -0700
si sabes español.. me puedes ayudar,...
me genera error la siguiente lÃnea:
ActiveSheet.ChartObjects(GRAFICO).Chart.HasTitle = True
Grafico, es una variable de tiepo texto, donde se almacena el gráfico que
deseo aplicar al tÃtulo....
en el libro tengo alrededor de 100 graficos, y debo aplicar esta ...
|
function that would lookup for null value
Fri, 4 Jul 2008 10:57:21 -0700 (PDT)
Hi, I'm trying to find a way to look in a table for null value.
If there's a null value, then I would show a msg box, if not, I would
show another msg box.
I would prefer something like dlookup, dcount ...
I've tried rs.Find "TrackingNO = Null" but not sure how to integrate
it to a if (since it doesn?t flag i ...
|
Edit query by using form
Fri, 4 Jul 2008 07:05:02 -0700
Hi. I want to edit several conditions of a query by using form. I know that
this can be done using macro in the form. But I do not know how to do it. Can
any one please help me with this? I am stuck here for several days and cant
figure out a solution.
I just have a table with company name, date and share ...
|