|
sending query result to text file
Hi,
I'm converting a .mdb application to .adp format. In .mdb application I
have a button which sends a query(join of 3 tables) to .txt file
through transfertext of Docmd.
I'm not able to use this transfertext in .adp format. As I have
converted the query to view in SQL Server and transfertext is not
understanding the view name in
DoCmd.TransferText A_EXPORTDELIM, , "vFDXQryWWWRoomExpor...
|
3 |
14.06.2006 06:20:36 |
|
|
How to I export to multiple Excel Sheets in Access
I posted a reply to an old question and am unsure if I should have just
posted a new question so here it is:
I would like to also export a databse to multiple worksheets in a single
workbook but have not been able to accomplish it using the method in this
post.
My situation is that the Access table I have has 100000+ records and I would
like to export to excel having the rows overf...
|
2 |
13.06.2006 08:59:02 |
|
|
how do i set a print command button in ms access to print specifi.
...
|
2 |
14.06.2006 12:03:38 |
|
|
AUTOMATING COMMAND USING A MACRO?
hey guys,
if someone could please provide me with some assistance it would be
very much appreciated...my problem is as follows:
I have just downloaded a Scheduling utility to Run my database on a
certain time....I need to create a macro to execute a particular
command I have written titled "SBMACheckAndEmail_Click()"...currently
this Code/ Command is used as an "On Click" Event proceedur...
|
2 |
14.06.2006 08:29:05 |
|
|
Autoexec drops into debug
I have a database that has been in use by the department for some time
without problems.
We recently added a team member who needs to be able to do some development
work on the database. As I had the developers copy of the database, I moved
it to a common drive that we can both access and keep individual copies to
work on (we have a check out process between ourselves). When he goes t...
|
6 |
13.06.2006 20:26:01 |
|
|
using a list box
hello i'm trying to find the best way to use a list box in a report,
when i pull it in i go through the wizard but when i'm finished and
preview it it doesn't show it. Basically I'm trying to assign a 'type'
to particular record when certain data is pulled, is there any list box
'101' help that i could go to. thanks.
...
|
1 |
13.06.2006 04:07:38 |
|
|
dynamic data in report
Hello, I'm using Access for some reporting and I'm trying to pull in
some dynamic fields that are beyond what's assigned in my data source
(which is one big master query). This report pulls is uses a key
parameter to populate the report with a distinct record, however there
are some fields which will change per match. Basically I'm trying to
see if there is a way to have more than one data ...
|
1 |
13.06.2006 04:05:07 |
|
|
Sending multiple query's in one spreadsheet
I am using the send object command in a macro to send 3 seperate query's via
Outlook email. These query's create 3 seperate spreadsheets....How can I
incorporate these 3 query's in one spreadsheet? I would like to send these 3
query's in one spreadsheet (3 seperate worksheets/tabs)...Any suggestions?
Thank You.
...
|
3 |
12.06.2006 11:27:01 |
|
|
Search LastName and FirstName Fields
Hi All,
I'm sorry if this ends up being a post similar to someone else's that has
already been answered. Here is what I am trying to do.
I'm creating a database that has in it fields for first name and last name.
To prevent duplicate entries, I want the used to be able to click a New
Driver button and input the last name (variable = LastName) and first name
(FirstName) and have the...
|
6 |
09.06.2006 22:09:42 |
|
|
How do I export a date&time in a macro-Transfer Spreadsheet name
="O:\Folder\Folder\FileName" & (Format(Now(),"yymmdd")) & ".xls"
I'm trying to transfer a spreadsheet but want to add the time to the date
because the spreadsheet may be run several times in a day, so I don't want it
overwritten. I've tried adding time by doing the (Format(Time())
expressions, but I get error messages....
|
2 |
09.06.2006 19:41:15 |
|
|
Outputall fileds
I am trying to create a lookup for employee id to open a time sheet entry
form using a filter in the open form in a macro. The form contains several
tables. It says that if you use a filter and not all of the fields are in
the filter, then to set the outputallfields property to yes. Where do I find
this property?...
|
2 |
09.06.2006 17:59:49 |
|
|
need macro for import text file with delimiter
I used access 2000 , i have a table that containe the fields for the
text file
need macro for read the file ,import it,and after all delete the file
can anyone help me?
...
|
4 |
09.06.2006 11:11:21 |
|
|
macro auto execution
does anyone know how to have a macro execute at a given time during the day?
...
|
2 |
09.06.2006 06:40:15 |
|
|
incluir macros no menu de controle
como faço pra incluirmacros no menu de controle e como faço pra abrir un
formu´lário de swtichboard...
|
1 |
09.06.2006 01:10:02 |
|
|
Wie kan mijn makro aanpassen
Sub Mail_workbook_1()
ActiveWorkbook.SendMail "ron@debruin.nl", _
"This is the Subject line"
End Sub
Heb deze makro uitgetest en hij werkt. Wil hem enkel uitbreiden
zodat ik naar meerdere adressen kan sturen en zelfs naar Aan;CC;BCC
Weet enkel niet hoe ik juist meerdere adressen naast elkaar schrijf
zoals de tekenes die er tussen staan..
mvg Bergop
...
|
1 |
08.06.2006 22:06:13 |
|
|
Error when I set filter
I am using article KB208529, which has worked in other databases of mine, to
set up a report filter from a pop-up form. When I choose a value from a
combo box, then click "set filter", I get the following error:
Syntax error (missing operator) in query expression '([Provider
Type]="Physician" A).'
Originally, the source for the report was a crosstab query, but I have since
changed ...
|
8 |
08.06.2006 20:14:10 |
|
|
GoTo Control
I have a DB with a from when you input the emp # it pulls the name, dob, etc
from one table then you are to enter data in the rest of the empy fields on
the form. The form is laid out in Tab view (which doesn't matter much) except
after you enter your data on the first line and hit enter to move down then
enter the emp # and hit tab to populate the other fields it moves you back to
row 1...
|
3 |
08.06.2006 19:50:53 |
|
|
How to "POST" accounting data into underlying tables
I have a form to record customer payment receipts into a Receipts table
indicating customer, amount, date etc... Within that form is a
subform based on a query that selects all open invoices to that customer
from the Invoices table. I want to be able to allocate the receipt among
those invoices that are being paid (in full or in part) into a Receipts
Allocation table.
Receipts tabl...
|
24 |
08.06.2006 19:40:36 |
|
|
Preventing users from being able to create new macros, policy leve
I would like to be able to prevent users from creating new macros but not
prevent them from running existing ones. I can disable access to the Macros
option in the Toolbar and Menubar, but access to Macros is still available
from the list of objects when they create a new database (along with other
objects such as Tables, Queries, Forms, etc).
Is there a way that I can hide or prevent a...
|
2 |
08.06.2006 08:22:25 |
|
|
Setting todays date.
Hi,
Can someone please help. I am using Access 97 and am considering inflicting
serious damage to my pc to allieviate my frustration...
I`m trying to create a macro that will update a field (called, DATE
COMPLETED) on a table (called, POST) when a button (called COMPLETED) is
clicked on a form (called ACTION POST ITEMS) with todays date.
I think I use the SETVALUE action but don`t k...
|
2 |
08.06.2006 08:19:10 |
|
|
How do I run a macro to print only the current record in Access
I have case managers that input cliet information for medications in a form.
I have a linked Report that will summarize the needed info for the doctor.
The problem I'm having is running a macro on the form to print the current
record on the report. Thanks...
|
2 |
07.06.2006 20:40:54 |
|
|
Access 2000
HELP ... Have an Access 2000 databse that has been working well for years.
Now when I try to run it on Acess 3000 it fails on various expressions. Get
an error message like "expression entered has functiion name that Microsoft
Access can't find".
Failures are with fnctions such as "Mid", "Left", etc.
My Access 2000 version is 9.0.2720. Do I need to update or what is going on?
...
|
2 |
07.06.2006 20:37:14 |
|
|
Running Excel macro in Access
I have several excel spreadsheets (call them Data1xl, Data2xl) that downloads
data from websites, Excel formats the data and the tables are linked into an
Access database (call it CenterDB) which then manipulates the data and makes
tables in other Access databases (call then Project1db and Project2db) . In
order to update the Excel spreadsheets a macro must in each spreadsheet.
Is th...
|
1 |
07.06.2006 19:00:53 |
|
|
SendObject question
Hello All
I want to use the SendObject command to send an email to all the 'people' in
table [locums] for whom there is an email address in field 'email'. I know I
could simply 'hard code' the list of email addresses in the To parameter of
the SendObject command, but obviously this would be laborious and more
inmportantly the list would need to be manually updated each time the email
...
|
5 |
07.06.2006 17:19:46 |
|
|
Condition to run validation macro on field with focus
Hello!
I am looking for some help to run a validation macro on multiple fields.
Specifically, I have 11 fields on a form, each one a YES/NO data type, and i
would like to run the condition macro on the Before Update proerty, such that
if the field is set to YES and the user resets it to NO, a MsgBox pops up
confirming the change. If the field is set to NO and the user changes it to
YE...
|
2 |
06.06.2006 21:08:39 |