|
copy/paste a recordset
What is the best method for copying and pasting a recordset from one database
to another?
Thanks!...
|
2 |
08.06.2006 17:33:01 |
|
|
Excel Import: no wizard showing
Originally I had an Excel import problem that doesn't allow me to specify
field options for any field other than the first. I read the help file and
followed the advice to update Office. Downloaded and installed an update and
service pack 2.
Now I can't even get the wizard to come out when I tried to import data from
Excel. Nothing happens after I select the Excel file from the Imp...
|
3 |
08.06.2006 16:55:01 |
|
|
docmd.transfertext acExportFixed
At the end of processing I export out a fixed length record using a query.
There are nine different queries that I run.
Sometimes the text file is created and sometimes not. It appears the problem
is that one query isn't finished before the next one starts. I have tried
putting a for loop with a count to slow things down but that also is hit or
miss.
Below is the code that I am using...
|
1 |
08.06.2006 15:41:01 |
|
|
Import Distribution list members from Outlook to MS Access - Is it possible???
I have done a bit of reading on this and I think it is not possible but
would like a confirmation from you more learned people.
I have managed to succesfully import my outlook contacts into an access DB
table. The distribution list are present in the export but only the name of
the list. Is there any way to import the members of the distribution list
into access? I know you could do this...
|
1 |
08.06.2006 15:15:06 |
|
|
Export Access with Chinese Characters to Hong Kong MYOB
I need to (regularly) translate up to 10,000 product names from English
to Chinese, then import the Chinese names into the Hong Kong version of
MYOB (popular accounting package). Note you can (apparently) type the
chinese characters straight into MYOB and have them appear correctly on
subsequent invoices.
I have set up tables in Access to do the conversion and they are
working beautifully...
|
2 |
08.06.2006 05:23:52 |
|
|
Searching through one Column and update a bookmark when result found
Hello,
I designed a word template with some bookmarks and a word table with 7
cols(Prod.No, Descr, price, qty, colr, etc) .
I've also designed a userform with a list box to enable user select the
products. This listbox is populated from a products table in access.
When the user selects a product from the list, the Prod.No, Descr., and
price details are entered into the word table cells. ...
|
2 |
08.06.2006 05:18:07 |
|
|
How do I combine data from two fields on the same database
I had just downloaded a database. However, it is comma delimited and I need
two fields to come in as one. Access does not allow me to combine the 2
fields while I download. Can anyone help please. Thanks.
Irma
PS I am a new Access 2003 user....
|
3 |
08.06.2006 01:16:01 |
|
|
Export query to Excel
I have this query:
SELECT PHQ.SSN, PHQ.PHQDate, PHQ.PHQTOT
FROM PHQ
WHERE (((PHQ.SSN)=[whichSSN]));
How can I export this to Excel programaticlly?...
|
5 |
07.06.2006 19:23:01 |
|
|
View in SQL Server float, same view linked in Access Long Integer
Why is it when I link a view from a SQL Server backend to an Access front end
it converts the data type for one specific field to a Long Integer,
effectively truncating all the data that has anything in decimal form? I can
open all rows and look at the data in SQL server, and it is fine. But when I
look at it in Access, it's truncated. I looked in design view in Access, and
the data type...
|
1 |
07.06.2006 15:20:02 |
|
|
How do I export an Access table to include "" for empty columns ?
When I export a table to a comma delimted text file using " as the text
identifier, I need to have empty columns display as "" in the text file.
When I run through the export wizard, the repeating double quotes are shown -
but when I open the .txt file after the export, I do not have the ""....
|
2 |
07.06.2006 08:17:29 |
|
|
Importing Character
Hello,
Using Access97, not a VBA user. I am importing a file, which I'm saving as a
text file. One field has this character [] , but smaller, preceding SOME of
the actual data for this field. Many records do not have the symbol.
How can I get rid of this character, either before or after the import?
Thanks for any help....
|
1 |
07.06.2006 02:26:01 |
|
|
Use macro's or VBA to write table relationships after import table
Hi there
Is there a way to "automate" the writing of realtionships between imported
tables?
I have a situation where I need to re-import tables through an ODBC
connection into access a few times a day, and I need the relationships to be
maintained.
Currently, any macro wirtten to delete and then re-import the tables,
requires all relationships to be deleted first.
Is there a wa...
|
2 |
06.06.2006 20:00:31 |
|
|
RESERVED ERROR (-7716) WHEN TRYING TO LINK TO ODBC
I am getting reserved error (-7716) while trying to link to an ODBC database
through Access 2003. Can not find any solutions on line....
|
1 |
06.06.2006 19:27:02 |
|
|
Linked Tables with Primary Keys?
I'm trying to help make it easy for our end-users to use SharePoint and
Access together. By using the techniques in
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dnsmart03/html/sa03i1.asp
I've been able to programmatically link a table in Access to a
SharePoint list - but that's not exactly what's needed. The problem
is that an Access table linked to a List has no fie...
|
1 |
06.06.2006 14:51:08 |
|
|
how to detect if file exists
Is there any way to detect if a file exists?
I want my database to display a command button only if file "export.csv"
exists on the server....
|
2 |
06.06.2006 11:42:14 |
|
|
Converting Access database into Outlook database
My company wants to take all it's records in Access and convert them into a
usable contacts database that we can all share in Outlook. What is the
easiest & fastest way to do that without nay major programming or having to
purchase any additional software.
Lucy...
|
2 |
06.06.2006 05:23:16 |
|
|
importing text files into Access table
Hello!...I have imported an Excel text file with numbers which have decimals
(example: 2.3) into Access as a separate table. However, when I open the new
table, the number has been rounded to 2.0. How can I keep the original
decimal format? (btw, if I import as a text field, no problem but of course
you can't do any calculations then). Your advice is greatly appreciated.
...
|
4 |
06.06.2006 02:49:02 |
|
|
accessing XML data
Hi,
I need to import data from XML to Access97 , what is the best way???
Is there any ODBC solution??
Thanx!
Domac
...
|
2 |
05.06.2006 21:51:06 |
|
|
Import a recordset or link fields?
What is the best way to accomplish this?
I would like to import/export or copy/paste a recordset with related data in
5 tables from one database in Access 2002 to another database in Access 2002.
Or...would I be better off linking the tables? My thought was to base it on
a field in the first database called JobNumber. When that field is null, it
would not be linked, but when a value is...
|
2 |
05.06.2006 20:34:19 |
|
|
DATE/TIME
I am linking an excel spreadsheet with a new database table. The spreadsheet
has a number of consecutive date fields (ie. Delivery 1, Delivery 2, etc).
When I link the first field is correct, but subsequent fields change to
"text" fields in the database. Is there any way of stopping this?
Regards...
|
2 |
05.06.2006 20:32:51 |
|
|
Linked Table to Excel File
Hi - I hope you can help.
I'm using Access 2003 Professional Edition - I've created a table linked to
an excel file.
I would like to create a relationship with the linked file (foriegn key) and
my customer table and display a subform of the linked Excel file.
When I create a foriegn key field and do a look up to the linked table from
the Table Design mode, Access tells me the relati...
|
1 |
05.06.2006 19:47:01 |
|
|
Import a zipped excel file
Is there a way to import from a zipped excel file without manually unzipping
the excel file first?...
|
1 |
05.06.2006 14:12:02 |
|
|
DoCmd.SendObject
ive used the DoCmd.SendObject to send an email via a command button. when the
button is clicked the email editor opens and you have to click send. Is there
anyway to send an email without the editor opening and pressing the command
button....
|
2 |
05.06.2006 12:54:51 |
|
|
linked contacts from access apear as a blank email in outlook
I trying to create a linked contact data base in access
The database is linked to outlook but when access updates to
outlook the contacts open up as a blank email ...
|
1 |
05.06.2006 12:45:02 |
|
|
DoCmd.SendObject
I've used the DoCmd.SendObject to send a email via a command button. when the
button is pressed the email editor opens with the email, u then click send
and the email is sent.
Is there anyway to send the email without the email editor opening and
having to click send?...
|
1 |
05.06.2006 11:59:01 |