|
Creating an Outlook Task from Access
I already create email notifications to distribution lists in my db, but what
I REALLY want to do is send Task Requests to an individual at the same time.
We're running Outlook 2003 and Access 97 to add some joy to the puzzle!...
|
1 |
18.09.2006 19:20:02 |
|
|
Time format changes when going from Access to Word
Hello all,
I'm not sure if this is the right forum but based on other questions I've
read, I should at least start here. I have a field in a table called
StartTime and the datatype is Date/Time and the format is Medium Time. I
also have a phone number field that is stored in Access with hyphens in the
appropriate places. This all works great in Access. However, when I output
this fi...
|
3 |
18.09.2006 18:57:01 |
|
|
Calculation Question
using vb in access2003 i get various values like 503, 1202, 1234
i need to know how many 500's are in the number and then the remainder
for example 503 = 1 * 500 with a remainder of 3
1202 = 2 * 500 with a remainder of 2
1234 = 2 * 500 with a remainder of 34
has anyone any ideas please...
|
3 |
18.09.2006 18:45:01 |
|
|
hyperlink
I am currently creating a database. What im having problems with is I have a
field on a form that the user will enter a number of a previously scanned
document that is saved on our network share drive (G Drive) when i loose
focus I would like to create the hyperlink in the second field. Now for the
problem. I cannot create the correct hyperlink.
I am currently generating a hyperlin...
|
1 |
18.09.2006 17:50:02 |
|
|
Change Name of Spreadsheet when using DoCmd.SendObject
I have an Access program that we use to email reports out to clients. I have
the date of the report in subject line of the email, but the spreadsheet that
is emailed is automatically given the name of the query. I'd like to add the
month and year to the name of the spreadsheet, because customers often get
confused about which month's report they are looking at. I don't see anyway
to d...
|
2 |
18.09.2006 16:37:40 |
|
|
Display Number Reports to be printed
Is their a way to read the number of pages that will print using a DoCmd?
I got a form that I use with some different fillers and than I will do a
DoCmd.OpenReport stDocName, acNormal
to print off a batch of reports. Before it starts printing I would like to
display the number of reports the printer is going to print to a message box
for a double check. Any ides?
--
thank You...
|
5 |
18.09.2006 16:33:02 |
|
|
Using "Between" in VB Script
I have a text box that the users enter a number between 1 and 10. If the
enter a number between 1 and 5, I want a yellow box to appear; if between 6
and 10, I want a blue box to appear. I've been able to code it partially but
don't know how to make the range included (if between 6 and 10 then), etc.
What I have so far is listed below - thank you!!!
Private Sub Text8_AfterUpdate()
If...
|
10 |
18.09.2006 15:34:57 |
|
|
Seperating Whole Numbers and Decimal Numbers
Using vb in access 2003 i end up with a value of 1.006
i need to get the 1 on its own and the 006 on its own. Is there a function
that will remove the numbers to the left of the decimal point and to the
right of the decimal point?...
|
3 |
18.09.2006 15:01:02 |
|
|
Rename report fields and linked data fields via VB
I have a report that is linked to a query which has around 52 fields that
change when the fiscal years changes. For example the fields may be
txtFY06sales, txtFY06inventory, etc.... Also the linked data fields in the
query are similarly named. Changing the query is no problem, but changing 52
fields in a report(actually it may be more then 52) is very labor intensive.
Is there an e...
|
4 |
18.09.2006 14:19:37 |
|
|
access runtime program won't open after install xp pro
get error "can not open...ouside iternet...files outside
workgroup...untrusted site". Any ideas?...
|
1 |
18.09.2006 13:09:02 |
|
|
Access 2002 to Access 2003
Hi All,
I have an ADP project maintaining attendance of employees. I made this
project on my home PC with Access 2002. This works fine. I transferred this
project to my office PC with Access 2003. The pivot table created in access
2002 does not seem to work. When I open a form in Pivot view, it gives an
error " The query could not be processed. The data provider didn't supply
any further e...
|
1 |
18.09.2006 12:48:37 |
|
|
conversion to SQL backend
Hi all,
I have a access project for attedance backend is SQL.
I have a mdb/vba code which needs to be converted into sql,
can anone help me formulate this:
Private Sub Command4_Click()
Dim StrSQL As String
StrSQL = "INSERT INTO Attend ( AttStudent, AttDate, AttType ) " _
& "SELECT " & Me![scrStudent] & " AS F1, #" _
& Format(Me![Text0], "mm/dd/yy") & "# AS F2, " & Me![scrAttend] & ...
|
14 |
18.09.2006 12:46:46 |
|
|
transferdatabase
I link table from an other access database by : docmd.transferdatabase
aclink, ...
in access 2003 it is very long, when i use on the same computer 2000 it is
very fast why ?
The both base are in access 2003
the Subdatasheet Name property are set to none
The disk format is NTFS
short name are used for both database
thanks for help
...
|
1 |
18.09.2006 07:33:02 |
|
|
How do I compile data in different rows and output to a new column
for the sake of simplicity, This Table has a column for names and a column
for seating assigments,
Joe, table1
Mary, table1
Peter, table2
Frank, table2
I want to output as follows:
table1, Joe and Mary
table2, Peter and Frank
I know it could be done, please shed some light on my old brain
thanks....
|
4 |
18.09.2006 00:03:40 |
|
|
getting values from form
Hi,
I perform filter on subform.
After filtering I want to append values from column of subform to another
table.
This code is not working :
DoCmd.RunSQL "INSERT INTO [Tissues for RNAs] ([Tissue ID])
VALUES(Forms![Browse All Tissues]![Tissue ID])"
The problem is to get values from column in subform.
Thanks in advance.
...
|
4 |
17.09.2006 17:43:16 |
|
|
Error Attempting to set Default Value of Table Field through VBA
Greetings.
I manage an event database for foot races.
I have written VBA code to allow users to set the default
length of the race. But everytime I attempt to execute the
code, I get the following error:
Run-time error '3420'
Object invalid or no longer set.
Here is the VBA code that executes:
Private Sub Length_AfterUpdate()
Dim RunTab As DAO.TableDef
Dim LgthFld As Field
...
|
5 |
17.09.2006 04:43:02 |
|
|
Runtime Error
Every time I try to enter an event or access the code builder I get the
following message:
Runtime Error!
Program: C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE
Abnormal program termination
Any ideas on how to correct this?
Thanks.
--
mjb...
|
11 |
16.09.2006 22:00:01 |
|
|
Need help to develop orders management database & software in acc
I'm in desperate need to develop orders software. Having tables, queries,
forms, reports etc.
...
|
1 |
16.09.2006 18:26:02 |
|
|
task scheduler macro
I'm doing a task scheduler macro that is deleting data from a table and then
adding
a new data there.
"C:\Program Files\Office\Office11\msaccess.exe" "C:\SomePath\MyDB.mdb"
/x mcrMacro
Everything is working.
But, I'm getting MS Access worning notifivcations before rows deleting and
append query.
How could I avoid it?
I was trying to use a function in a module with the same queries an...
|
8 |
16.09.2006 13:53:30 |
|
|
Animation in Access
Hi,
I *hate to, but, have to* do this for reasons beyond my control : pure
easthetics and no functionality.
I have a Company Logo that looks a lot like a coin. I've to flip it (i.e.
rotate) on the sign-on screen.
1) Can this be done through VBA ?
2) If not, are there any free tools that allow me to make an .avi file based
on this pic ?
Thanks for any help.
--
Sreedhar...
|
5 |
16.09.2006 10:22:54 |
|
|
Access options settings in code?
Is there a way to set some of the Access user settings (Tools/Options
settings) in application code so they are automatically set a certain way
when the user opens the application?
...
|
7 |
16.09.2006 04:49:02 |
|
|
Export an Access toolbar
#1 Today, 02:57 PM
llkhoutx
Registered User Join Date: Feb 2001
Location: Houston,Texas USA
Posts: 2,607
Export a custom Toolbar
--------------------------------------------------------------------------------
I support 30 (non-techie, Access newbee) accountant database users and their
several hundred Access 2000 (non-compiled) mdb production databases.
I want ...
|
2 |
16.09.2006 04:00:32 |
|
|
On Timers and CPU Usage
Hi everyone,
I am trying to use a hidden form to check out certain events happening with
its OnTimer Event. The timer interval is set to 1000, i.e. one sec. Is that
going too hard on the processor ? The screens are acting crazy (flickering
and all), though the code is doing what I've asked of it. I'm sure the code
is very light.
The form is supposed to remain open till the User signs...
|
4 |
16.09.2006 02:40:01 |
|
|
code query to update textbox and table
hi, how to run a query in my form_load (ms access 97) so it set the
value of the query to a textbox (txtinfo) and put the value in my
tblInfo table. My query is Select count(project) from tblproject;
...
|
3 |
16.09.2006 00:37:33 |
|
|
Freeing Resources - DAO
I inherited an Access 97 db that is running on a windows XP box, and it has
started running into memory errors. This may not necessarily being a DAO only
question, but the code I am working with is DAO/VBA.
I have ruled out drivers as a cause of the errors, as the application has
sucessfully run three times since the issue started, and I can open the
linked tables before running t...
|
3 |
15.09.2006 21:15:25 |