|
sendObject question
I have a form with a button which, when clicked, opens Outlook, puts the To,
the CC, the Subject Line in place, and even writes a message to go with some
information spun out of query. It's very nice and extremely useful. Just one
catch...
It always, always, always comes up in plain text -- courier font. I want
Outlook to open in the same way that it does when I click the 'New' email
...
|
2 |
08.09.2006 19:22:50 |
|
|
How to handle a blank feild
I am using = Me!Fld1 = Me!ControlName.Column(0) However the Fld1 is blank at
times. How do I handle this issue in code.
--
Matt Campbell
mattc (at) saunatec [dot] com
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200609/1
...
|
4 |
08.09.2006 18:41:01 |
|
|
Access Database Synchronizing
Hi, I have developed a software which is to run on multiple PCs on a network
sharing the same database on an inhouse server. There is another database
which has some similar tables that sites on a server where the website is. I
need to have the common tables synchronized. How is this possible and what
issues will I have in doing this?
Well there be a problem if the synchronization ha...
|
6 |
08.09.2006 18:14:02 |
|
|
Update Link to Excel Worksheet
I am trying to update a link to an Excel worksheet. We receive an Excel file
that's based on the date name. I have been able to change the link to any
Excel file, but when I try to change the sheet name, I receive the error -
Run Time error 3268 Cannot set this property once the object is part of a
collection.
on the line that updates the sheetname - .SourceTableName = SheetName + "$"
...
|
3 |
08.09.2006 16:11:01 |
|
|
Archiving tables with date stamp
rI need to achive several tables and keep mulitiple versions, each time
stamped. I tried using simple macros and assigning the name based on a value
in a text box on a form, but there was no way to use a variable in the name.
I figure I need to use VB, specifically DoCmd.CopyObject. Will this allow me
concantonate a table name based on text plus a value in a text box on a form?
I alw...
|
2 |
08.09.2006 15:56:02 |
|
|
Filtering query results using a ListBox In Access 2000
Good morning all,
I managed to get the code below to choose ultiple entrues in a listbox and
then filter a report using strwhere. I was hoping I could use the same
technique to run a make table query filtering the results also by strwhere.
In the code below, SelectCategory is the name of the listbox and I am using
it to allow users to choose names from a list. THerefore the query pul...
|
2 |
08.09.2006 15:52:31 |
|
|
Launch Acrobat
I would like to launch Adobe Acrobat from a module. The application will be
used by various users who may have different versions of Acrobat, and thus
different paths to the executable.
Can this be done?
Thanks in advance....
|
5 |
08.09.2006 15:32:22 |
|
|
Update or cancel update without addnew or edit error -2147352567
Hi,
When i update a record via a form and then use a combo to select another
record i get the following error:
Update or cancel update without addnew or edit - error -2147352567
I found one other thread with the same issue and it recommended the
following code in the 'on change' section of the combo
If me.dirty then
me.dirty = false
I tried this but it didn't solve the problem....
|
2 |
08.09.2006 14:51:01 |
|
|
Populating a listbox all at once
I've got a listbox that's populated with table/query data. There are a LOT
of records that go into this list box -- around 14k records at the moment --
and I believe the way the listbox is being populated is the cause of a
problem.
When I scroll down a page, the scroll bar goes halfway down the scroll bar
box. Then when I scroll down again, it goes halfway to the bottom again.
Anot...
|
4 |
08.09.2006 13:36:19 |
|
|
file link specification problem
I am using Access 2002.
I have a database the uses several text files which are updated frequently.
I want to relink these everytime I open the database. I created a splash
form and put in code to do so. I put the splash form into the startup
parameters.
When I open the database with the shift key, then open the splash form, it
seems to work just fine. When I open the database w...
|
6 |
08.09.2006 12:58:02 |
|
|
Query/Subform Help
Good day,
I have a table with the field OrderID that is a primary key linked to other
tables with one too many relationships.
I generate a query based on the information inputed in a main form with
subforms and it does not display the
information unless I go through each subfrom and press enter which makes a
record. Basically I donot want to have the user to do this all the time if
...
|
5 |
08.09.2006 12:37:02 |
|
|
pass address to Groupwise
Is it possible to pass an email address to Groupwise? ...
|
7 |
08.09.2006 12:06:01 |
|
|
Macro to expotrt to open Excel wookbook
Im trying to creat a macro in Access that will export selected data to an
open excel work book. It would be nice if io could also chose that work sheet
it went to or have it make a new page.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200609/1
...
|
1 |
08.09.2006 11:41:24 |
|
|
Email zip file from VBA
I am trying to email an mdb from Access. I have everything set up except the
zipping bit. I have looked at a previous post giving this reference
http://www.members.shaw.ca/AlbertKallal/zip/index.htm
but I am struggling to make sense of it.
In my code I am hard coding the path/name of the db in and the zip I want
out but my guesswork so far is giving me an error 'Compile error:
User-defi...
|
2 |
08.09.2006 09:45:02 |
|
|
Access functions
What I am doing is creating a database of advertising pieces sent to me by
our financial advisors. What I would like is, when I enter the advisor's
name in the "name" column, to have it automatically search the column of 150
names (our top advisors) to see if the name I typed is found, and if so, then
put an "X" in the "Top Advisor" column.
I think that it needs to be a function, but I...
|
2 |
08.09.2006 09:02:55 |
|
|
Date in MS ACCESS 97 query
Hi, I need to display the total number of projects of Agreed date that
is greater than Anticipated date and the differnece should be between 1
to 14 days. My query is
SELECT Count(ProjectID) AS Count_ID
FROM tblProjMilestones
WHERE (((Agreed_Date)>=[Anticipated_Date]+14));
However i'm not getting the correct answer. Could you please tell me
what i'm doing wrong.
...
|
2 |
08.09.2006 08:57:18 |
|
|
Logical & Phisical Drives
Hi,
Can any body help how to map a PC knowing all the Logical & Phisical Drives
in VBA (Access) ??
I need both Logical and Phisical .
Thank You !
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200609/1
...
|
11 |
08.09.2006 07:31:55 |
|
|
Code modification to select a unique record from a list box
Hi,
I have a list box that shows "company names" and their "work type"
(plumbing, electrical, etc.). My problem is that I have some companies that
are listed under more than one work type and when I select a company name I
get all of the work types for that company name. How do I specifically select
a company name with only that specific work type? I copied my code below.
Thanks,
Jim
...
|
2 |
08.09.2006 00:44:02 |
|
|
I need to store a MS Word Template .dot file in an access databas
I have a word template and data in MS access. I would like to populate the ms
word template using the ms access data. Does any one have any experience how
to do it?...
|
2 |
08.09.2006 00:33:02 |
|
|
Add Favorites to Shortcut Bar in Save As Dialog Box
I'm using this code to bring up the Save As dialog box.
http://www.mvps.org/access/api/api0001.htm
It works great except for one thing I would like to add.
I would like the Icon shortcut for Favorites to show on the
shortcuts/favorites bar on the left side of the SaveAs dialog box. When I
use save as in Excel it always shows up.
--
Billy Rogers
Dallas,TX
Currently Usin...
|
7 |
07.09.2006 19:37:03 |
|
|
Tap into Exchange Server data
My boss would like me to write some code to analyze usage of our Exchange
Server. I found the Exchange link in the Get External Data popup, but that
only lets me link to my mailbox.
Does anyone know how to tap into the Exchange Server data store so that I
can get more detailed information about our Exchange Server usage?...
|
1 |
07.09.2006 18:50:02 |
|
|
Display Current State of AllowBypassKey
I'm using Michael Kaplan's ChangePropertyDDL function to toggle off the state
of AllowBypassKey. When working on the database, however, I will want to
toggle it back on. After making changes, before posting the new front-end to
the network, I'll toggle it back off. To make this more fool-proof, I'd like
to display the current state of the property on my form.
Can anyone tell me how t...
|
5 |
07.09.2006 18:47:01 |
|
|
advanced programming
Can Access be programmed to self generate reports at the beginning of every
month and automatically email reports to a predefined group?...
|
6 |
07.09.2006 18:21:13 |
|
|
Variables
I have an accounting database in which cost centers are tiered into seven
levels. No cost center in a lower tier may charge any cost center above it.
I'm trying to figure out a statement or formula that will look at the tier
number (1,2,3,4,5,6, or 7) and exclude any cost center within a higher
tier...Any suggestions?...
|
4 |
07.09.2006 17:23:02 |
|
|
vbCritical??
What's that mean in VBA?
Relevant code:
Private Sub cmdCOFbyExpenseCode_Click()
If DetermineNoNullValues = True Then
DoCmd.OpenQuery "qryCOFSummaryByExpenseCode", acViewNormal, acEdit
Else
MsgBox "You must enter both a start and end date for the month to run this
function.", vbCritical
End If
End Sub
I understand everything but the vbCritical part...thanks
Dave
--
Brevity ...
|
3 |
07.09.2006 17:19:02 |