|
PDF and open report in acViewPreview or acHiddden
Hi all,
I think I should email this to Stephen Lebans, but since I have couple more
question and thought it may benefit to other people here in this forum so I
posted out here.
First, I would like to say thank you specially to Stephen Lebans for your
code to convert Report to PDF avaible for me (and everyone else) to use.
Second, I have a problem with what to do with docmd.openreport...
...
|
2 |
14.09.2006 17:56:01 |
|
|
Need Help please with email programmatically!!!!!
How can I send an email without bringing up outlook. I want to send an email
without the user knowing an email was sent.
I.E. a "silent" email.
Can this be done?
...
|
3 |
14.09.2006 17:23:01 |
|
|
Setting up auto backup
I would like to find a way in vba to set iso that every time that the Admin
(me) closes the DB that it creates a backup. That way there is always a
current backup.
--
Message posted via http://www.accessmonster.com
...
|
2 |
14.09.2006 17:20:02 |
|
|
compare data bases
A:I want to compare the data in two fields in two separate bases, then choose
wheather to update selected reecords. Is comparewiz the only solution?
B:Suddenly I have a number of tables (MSysAccessStorage, MSysAccessXML,
etc......)that have appeared in my database. What did I do, and how do I get
rid of them. The system won't let me delete....
|
4 |
14.09.2006 16:11:49 |
|
|
Protecting the database
To help protect my database I passworded the database. On the user's desktop
is an icon where the target is an mde file with the password whos only
function is to open the passworded database.
Question: I would like more security that would not allow the users access
to the database through Windows Explorer or Excel ..etc. I was thinking,
lets say there is a directory where I have t...
|
2 |
14.09.2006 16:00:02 |
|
|
Help with 'Right-Click' filtering
I posted this in the forms programming forum, but to no avail...
I am trying to filter a datasheet that was created using a disconnected
recordset (ADO). But when I try to remove the filter Access gives a 'Data
Provider could not be initialized" error, then crashes...
Does anybody have any ideas about why this happens or how to solve it? If I
could disable the right click filter menu, t...
|
1 |
14.09.2006 15:41:34 |
|
|
Oralce and VB6
Hi all
I have created an interface in VB6 which passes the values entered
through the textboxes to the backend procedure running in Oracle 9i. I
am pasting the exact code which I have for VB6 interface
Private Sub Command1_Click()
Dim conn As ADODB.Connection
Dim comm As ADODB.Command
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Set conn = New ADODB.Connection
conn.Open "DS...
|
2 |
14.09.2006 12:37:07 |
|
|
ComboBox problem
Hi,
I'm using Excel 2003
I have a spreadsheet using a ComboBox that allows selection of one of
several sets of data. Each set is a 3 column row of data. I have the
following properties set:
BoundColumn: 2
TextColumn: 1
When a selection is made the ComboBox displays the column 1 value.
The ComboBox seems to behave normally, except that when I close and open the
file the combox displays the...
|
2 |
14.09.2006 12:08:10 |
|
|
Listing contents of a directory in a listbox
Hi, i need to know how to list the files in a directory in a listbox, but i
am unsure how, any help would be greatly appreciated.
...
|
3 |
14.09.2006 12:08:02 |
|
|
compress and repair in code
Hi i have this code (some of it)
Function ExportToSecuredDB()
Dim strDestinationMDB As String
Dim dbsData As DAO.Database
strDestinationMDB = "\\server\pcg\pcg.mdb"
Set dbsData = DBEngine.OpenDatabase(strDestinationMDB, _
False, False, ";pwd=PannNuka1234")
'Export form
'DoCmd.CopyObject strDestinationMDB, "kunder", acForm, "Kunder"
'Export table
DoCmd.TransferDatabase acExport, _
"Mic...
|
5 |
14.09.2006 11:45:02 |
|
|
Update all records in VBA
I have a form frmParts with record source tblParts. In frmParts, I'm using
the macro action setvalue to set the value of many fields in my form, which
are then stored in tblParts. The setvalues expression is a dlookup looking at
fields in other tables in my database, tblA and tblB, which I haven't been
able to successful relate with tblParts.
My question is: tblA and tblB are often upd...
|
2 |
14.09.2006 11:34:20 |
|
|
Set to default printer in MDE (MS Access 97)
Hi, in my case, the the user opens the mde file, the forms does not
have a full bar toolbar expect the print preview and print button (the
one with the printer icon) nor the menu bar. If i compiled on my
machine to make the mde file, it will pick up my default printer (for
example 'hp laser 123', 123 is a unique number). If somebody is using
that mde on a different floor, it will give an erro...
|
2 |
14.09.2006 11:28:28 |
|
|
Packet Size
After some testing, I've determined that most if not all of the errors that
our application generates on a daily basis will go away, if I can change the
network packet size from 4096 to 16384.
For the life of me, I cannot figure out how to change my .adp file to make
the packet size configuration stick.
The test dataabse already has its packet size set to 16384, but this does
not see...
|
2 |
14.09.2006 08:16:59 |
|
|
controls flickering while mouse-over
Hello,
I have an unbound form which host a tab control with 6 pages.
On any of this pages there are many controls eache of them unbound and with
some labels NOT joined to the controls that will receive data (this is due to
the need to design the form to look like the paper form).
In form view I noticed that when the mouse-cursor goes over the un-joined
labels all of them flicker a bit ( q...
|
2 |
14.09.2006 02:33:05 |
|
|
Multiple AddNew on Recordset
Greetings.
I'm writing an application to register 2-person relay teams for a 10 mile run.
But whenever I run my code to add both people to the table of runners,
VBA returns the following error:
"Number of rows with pending changes exceeded the limit"
Here's the code that I wrote to add both runners to the table:
With rst
.Open "runners", CurrentProject.Connection, adOpenDynami...
|
3 |
14.09.2006 02:31:02 |
|
|
Can a Report's OnPrint event update the Report's Recordsource?
Hi,
My report's recordsource is a single-table query. I would like to record
the date/time that each record was printed in a field in that same table. It
seems to me that the report detail's OnPrint is the right event within which
to try to update the Date/Time field in the recordsource table.
The only problem is I can't seem to get Access to let me do it.
The recordsource query i...
|
4 |
14.09.2006 02:31:02 |
|
|
Pull characters from a file name
Let's say that I have a file with path C:\TEMP\LRQAD362.CHK
The 3 numbers are significant to the purpose of the file...how do I get those
3 numbers out, and use them in as a string?
Thanks in advance!
...
|
4 |
13.09.2006 23:31:05 |
|
|
GoTo Record
I have a form with Tab control. One tab has a form in datasheet view,
based on a query called Open_Items. When I double-click the
Date_Reported field, another tab appears, with the details of the
selected record.
The problem I'm having is I can't get the correct record to display. I
have a primary key called cntlNum.
For example, on the datasheet view, I choose the second record in the
l...
|
2 |
13.09.2006 21:15:02 |
|
|
text file import
Hello.
I have a .TXT file to import to a DB. The file is Space delimited. The
problem is that the file has more than 255 columns, and the number of columns
can vary. Is it possible to create a routine that imports this file spliting
it into multiple tables?
Thanks
Luis...
|
2 |
13.09.2006 20:55:59 |
|
|
Calling a procedure
How do you create a function procedure that calls a sub procedure? I am
trying to execute a Sub procedure by using the RunCode Action in a macro.....
but it tells me: "To run a Sub procedure or event procedure, create a
function procedure that calls a Sub procedure or event procedure."
I've got the Sub procedure working perfectly....just need to know how to call
it from a macro.
Not sur...
|
3 |
13.09.2006 17:51:02 |
|
|
how do i reference a pdf document in ms access
I want to create a list of pdf documents using a listbox and then by
double-clicking a row in the listbox access will open the appropriate pdf
document, any ideas?...
|
2 |
13.09.2006 16:51:23 |
|
|
ListView and Tab Control Display Problems
I have a tab control with two pages. I have a ListView control in each of the
pages.
My problem is that when I navigate from page 1 to page 2, the ListView in
page 2 is not displayed properly. Navigating back to page 1 and then to page
2 seems to fix the problem.
Does anyone know how to make the ListView control in page 2 display properly
(correct location, data rows, etc.) without hav...
|
4 |
13.09.2006 14:42:02 |
|
|
Specify SMTP account when sending email through Outlook
Hi
I was wondering if it is possible to specify an SMTP account/service when
automating mail through Outlook using Access 2000. Most mail will be sent
via the default Microsoft Exchange server, but there are certain emails which
need to be routed through internet mail. I am using the standard code:
Function SendMessage(stAddr As String, stSubj As String, stBody As String,
Optional ...
|
4 |
13.09.2006 14:10:44 |
|
|
Changing form's defaultview in VB
How can I change a form's defaultview with VB? I've tried the following and
get a message telling me to go to Design view.
Me.Defaultview=2
me.Defaultview=Datasheet
Forms!MyForm.Defaultview = 2
--
Thank you,
Del...
|
2 |
13.09.2006 13:03:44 |
|
|
changing controls on form
Hello,
I have an unbound form and many textbox on it which I should like to change
into checkbox instead.
Since I'm talking of about 75 controls...I was figuring if there was a
shortcut to achieve my aim by code.
I wrote the code, and I'm pretty sure it works fine, but I constantly
receive the message 'This control can't be changed in the type you have
chosen'.
Help doesn't mention any...
|
2 |
13.09.2006 12:57:59 |