|
Import Word Option Buttons into Access
I'm trying to import information from a word template into an Access
database. I'm having a problem writing code to import the option buttons.
This document is a survey which has 5 options per statement. I've grouped
the 5 options by naming them the same name under Group Name. This is working
so only one option can be selected. I don't know how to retrieve these
options and import th...
|
2 |
24.09.2006 00:57:01 |
|
|
Drop down list to launch macros
Hi,
i have a form and on it instead of buttons that trigger the built in wizard
macros (find record, print form) I want to create a drop down box which has a
list of options (save, print, find) that when you select one it triggers the
macro.
The data for the box will be a table.
The code for the macros will simply be taken from the ones the wizard
generate.
But how do i tie everythin...
|
6 |
25.09.2006 12:53:20 |
|
|
Export forms or reports automatically
I need to export a form or report to another database automatically by
pressing a command button. Is it possible to initiate the same routine as
when you right-clic on a form and select "Export"? What I need is to open a
browser window right after I press the button so that you can select the
database to export to.
Thanks in advance
Michalis...
|
3 |
25.09.2006 10:49:02 |
|
|
Logon (connection) to SQL Server
I would like to handle connection by my own logon form !
Some ideas ??????????????
...
|
9 |
25.09.2006 09:53:01 |
|
|
Error 3078 received using the 'OpenRecordset' statement
Hi,
The following code was working but now isn't. I'm not sure what I changed
(if anything) to get the error. The table 'Tbl_Filenames' does exist, a
sub-form 'Tbl_Filenames subform' has it as it's control source. The error is:
'Run time error 3078'
The Microsoft Jet database engine cannot find the input table or query
'Tbl_Filename'. Make sure it exists and that the name is spe...
|
1 |
24.09.2006 23:56:02 |
|
|
Info: download mdb module for creating internal documentation
Hi,
i've created a selfcontained module (tested with Access2003) for download
which allows you to document your systems (done via two tables) here a short
description:
'#######################################################################################
' mdlCreateObjectListingInTables
'#######################################################################################
'
' Att...
|
1 |
24.09.2006 23:38:26 |
|
|
form
how load files in a form?...
|
1 |
24.09.2006 23:25:02 |
|
|
Can not execute MSysobjects because of permissions
I am trying to open and access fill using .Net 2.0 and the OLEdb. The db
opens but when I try to read the msysobjects with a select I get an error
that the table does not have read permissions.
--
Jim L. EWeb Tracker, Inc....
|
2 |
24.09.2006 19:52:09 |
|
|
export table
How do I export a table from one database to a second one?
The VBA-procedure resides in the first database.
...
|
2 |
24.09.2006 18:19:19 |
|
|
docmd.Openform not working with text
I need some help please - I have been playing with this code in my form
for two days now. I have a form the shows a few field of a table. I
want to click on a unique identifier in the form and open another form
that shows the full record of the identifier I clicked on. I have other
places I am using this with ID fields that are numbers but I can't seem
to get it to work with text and I have n...
|
2 |
24.09.2006 16:58:00 |
|
|
Path & Filename
I've been browsing through some of the previous questions however I still
can't quite find what I'm looking for.
I would like to store the path and filename of various documents in a table.
Users should be able to browse windows for files and when they select a file
the path and Filename of the file should be copied to the relavant text boxes
on the form.
Thanks in advance
Duncan...
|
5 |
24.09.2006 15:45:02 |
|
|
update entry with code
want to update a date in a entry in a table called ApmUpdateDate(which only
has one field and one entry - LastUpdateDate)
would like to update it with todays current date when i click on a button
and run the code.need help please
this is my code....
Dim Olddate As DAO.Recordset
Set Olddate = dbs.OpenRecordset("ApmUpdateDate")
Dim datenow As Date
datenow = Now()
...
|
3 |
24.09.2006 12:29:01 |
|
|
Returning focus after calling filedialog.
Getting the filedialog to operate wasn't a problem, but it seems that after
selecting the target and closing the dialog, focus is not returned to the
calling object. Does anyone have a work-a-round for this glitch?...
|
2 |
24.09.2006 07:13:02 |
|
|
List The files in a directory with a command button
I Try to show a list of all the filles in a specified directory. The
directory is for instance: C:\my documents\example
...
|
2 |
24.09.2006 07:09:31 |
|
|
Can I FTP a text file created by Access, to an FTP server
I used the TransferText method, in Access 2002, to create a text file from a
table, on my harddrive, Can I now set up an FTP instruction from within
Access to send the file to a FTP server....
|
5 |
24.09.2006 05:55:01 |
|
|
access 2003
how do i design an access database table for compiling all the laws to help
prepare me for taking a bar examination?...
|
1 |
23.09.2006 23:01:02 |
|
|
Open a specified file in a directory with a command button
The command button opens by instance the following file: document1.doc
in the following directory: c:\My documents\examples
...
|
4 |
23.09.2006 21:16:09 |
|
|
multi-select file dialog
Good morning,
I'm looking for a method to have a dialog open where my users can select 1
or many files within a folder/directory and then process their selection one
file at a time.
how can this be done?
Thank you,
Daniel...
|
10 |
23.09.2006 19:56:31 |
|
|
Copy a folder using vba
I am attempting to copy a folder full of sub-folders and template files and
then would like to rename this copied folder. This new name would correspond
to a field in a form. Does anyone know of a way to do this? The folder I
would like to copy is a "Template Folder" that, like I stated earlier, has
files also in it and multiple sub-directories.
THanks a bunch in advance. Your help ...
|
9 |
23.09.2006 19:42:27 |
|
|
Find linked database location
In VBA I need to have a string value with the location of the linked
database. Currently I have this code:
strTableName As String
strTableName = "MyTableName"
strSourcePath = Mid$(CurrentDb.TableDefs(strTableName).Connect, InStr(1,
CurrentDb.TableDefs(strTableName).Connect, "=") + 1)
This works but I would like to remove the need to name a table, with VBA
looking at the table set. ...
|
2 |
23.09.2006 19:31:41 |
|
|
Append data through VBA
I've almost 50 to 60 tables imported from everywhere which have very
different names but the same structure. I'm required to create a master table
by appending all the data into one table to provide meaningul interpretation
of data.
I tried the following code with erratic results.(i.e., it appends some of
the data from some of the tables and then an error message shows up, saying
"Ru...
|
3 |
23.09.2006 18:13:02 |
|
|
changing the background color of all controls
Hi - I requested help this morning in changing the background color of all
controls on ALL forms in a database and received the response below - the
problem is I get a Data type mismatch at this line of code: For Each Doc In
Ctr.Documents
Am I possibly missing a reference? Thanks.
(Response)
This is the function that I use to change the colour of all forms and
controls, it is set up f...
|
3 |
23.09.2006 15:04:02 |
|
|
ARGB function
I am trying to use the ARGB function to create a transparent image. I have
included System.Drawing.dll in my project, but it still doesn't seem to work.
my command looks like this:
v(i) = color.argb(0,255,0,255). This doesn't work.
v(i) = color.FromArgb(0,255,0,255) doesn't work either Any ideas?
Thanks!
Pete M...
|
1 |
23.09.2006 14:10:02 |
|
|
DAP on the web
Hi. I have a Access 2003 database that I maintain and I'd like to create
DAPs for others to access via the web. Everytime I create the page and try
to access it through another computer I get a message stating that it can not
open a "temp" folder/file. When I try to create a connection to the database
which I have on a server it defaults back to a temp directory on the PC I
used to cr...
|
1 |
23.09.2006 12:01:01 |
|
|
Function
i have a Module in Access 2003 visual basics.
the module consists of several functions, for example
function1
function2
function3
when a pushbutton on click event is initiated a sub is run. within the sub
is the link to function 1.
What happens is when function 1 is run it seems to run all the other
functions within the module.
Is this normal?...
|
3 |
23.09.2006 08:51:02 |