|
How do I move autocorrect file to another Front End?
HI,
I've just switched from my laptop to using a company tower. My autocorrect
file has many entries that I would like to bring along. Where do I find this
file and how do I get it into use on the new computer?
I did move the front end containing all the forms, reports, etc., onto the
new computer and it seems to be working fine....
|
1 |
3/28/2007 12:55:50 AM |
|
|
Error importing from Excel
I am using Access 2003 and trying to import a table from Excel and keep
getting an error message but am unsure what the error relates to. I have
tried to change various aspect (data types etc) but still get the error.
In my Access database I have some fields which are checkbox options - the
table in Access translates these as -1 for yes and nothing for No. I assume
that the data in Exce...
|
5 |
3/28/2007 12:54:23 AM |
|
|
Pre-populate a web page form
I have the following code that opens a web page within an Access form:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Dim objIE As SHDocVw.InternetExplorer
Dim strURL As String
strURL =
"https://wwwpp10.landg.com/ProtectionOnlineWeb/FORWARD_TO_LOGIN_PAGE"
Set objIE = Me.myBrowser.Object
objIE.Navigate2 strURL
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This works fine a...
|
1 |
3/27/2007 11:18:59 PM |
|
|
Running Excel Macro
In my Access database I have a routine which opens and Excel Workbook and
calls a macro within the workbook. It usually runs smoothly but at times
fails to find the macro. The last time this happened, I renamed the macro
and changed the related line in the routine and it worked smoothly again.
Is there some way to protect against this happening?
Thanks for suggestions.
--
Best wis...
|
1 |
3/27/2007 11:12:33 PM |
|
|
Exporting a report to xml, generating HTML file through xsl
I think that I don't understand exactly what's happening here. But I was
hoping to export a report to xml and generate an HTML file in the process by
setting the option with xsl. I do the following to a report:
File, export, (save as type) xml,
(check off) xml, xsd & xsl,
(check off) more options
in the presentation tab
(check off) export presentation
(check off) client (html)
put...
|
1 |
3/27/2007 11:05:37 PM |
|
|
Exporting results of a Union query
I want to create a dataset and save it as a csv file. To create the correct
data set I have had to use a UNION query. Everything is working fine up to
the point of exporting.
If I try to export it as a text file I get the error message "Too few
parameters".
If I export to Excel the date format changes. I need to have the short date
format (d/M/yyyy) and that is how it is set in all t...
|
3 |
3/27/2007 11:04:57 PM |
|
|
Exporting two queries to the same sprdsht
How can I do this preferably with both queries on the same sheet. I haven't
done this before so please be clear and concise.
Thanks...
|
1 |
3/27/2007 10:15:55 PM |
|
|
³ö¹ú¾ÆµêסËÞÊ¡Ç®ÇÏÃÅÓë·½·¨
"Ó¼ÙÆÚ" Ϊͬҵº£Íâ¾Æµê¼´Ê±Ô¤¶©Ó뼴ʱȷÈÏ£º
¢Ù άҲÄÉ - 3ÐÇ 42 Å·ÔªÆð
¢Ú ºº ±¤ - 3ÐÇ 55 Å·ÔªÆð
¢Û ¶¼°ØÁÖ - 3ÐÇ 59 Å·ÔªÆð
¢Ü ²¼Â³ÈÕ - 3ÐÇ 66 Å·ÔªÆð
¢Ý ÈÕÄÚÍß - 3ÐÇ 73 Å·ÔªÆð
¢Þ ²¨Ê¿¶Ù - 3ÐÇ 73 ÃÀÔªÆð
¢ß ŦԼÊÐ - 3ÐÇ 99 ÃÀÔªÆð
¢à θ绪 - 3ÐÇ 85 ¼ÓÔªÆð
µç»°: 010-64892689, 010-64987025,
ÍøÖ·: www.cosmosholidays.net,
ÔÚÏß MSN : hotelwholesaler@hotmail.com, eurohotels@hotmail.com,
sh...
|
1 |
3/27/2007 12:25:16 AM |
|
|
Batch be DB with Linked Tables is a Pain
I wrote a batch file that upon open of the FE checks the version of the
client to that of the server and if it is not up to date it copies over the
new client, everything works great except for the fact that I have linked
tables. When the client opens I have to select the machine data source for
every linked table and enter my user name and password. This is such a pain.
I tried pass through...
|
2 |
3/26/2007 9:24:16 PM |
|
|
Linking Access and Excel 2003
What is the easiest way to create a link between access 2003 databse and
excel 2003. i want to import data from excel to access and export from access
to excel.
entrepreneur4real@yahoo.com
...
|
2 |
3/26/2007 1:20:22 PM |
|
|
Data source dialogue window does not open when ODBC import is sele
After selecting ODBC datbases as the file type for to import a table. The
data source select dialogue box fails to display. I've been using the
function for quite some time and have never had this issue. Any thoughts?
--
Rich D...
|
2 |
3/25/2007 11:41:51 AM |
|
|
Updating the tables from old database to new
All of the discussions about merging or appending data in tables fail to
mention the primary key and other related tables. I am trying to write a
routine to update a client's backend file to the latest revision and I am
runnining into the problem of making sure that the old primary keys are
maintained so that the relations to subordinate tables don't get mixed up.
I tried to copy/append...
|
2 |
3/24/2007 7:18:02 PM |
|
|
Time Format
I have an excel spreadsheet with a field with the time format "7:00:00 AM".
When I import this spreadsheet, the value showing in the Import Spreadsheet
Wizard is .29166666667. Each time value has a different number similar to
this representing the cumulative percentage of the day gone by (i.e. 12:00 PM
has a value of .5). The problem is that when I try to use this field in a
query to m...
|
5 |
3/23/2007 3:48:12 PM |
|
|
Transfer Text with Variable file name
Ok, so I've got code that will go through the open file dialogue in access and now I'm trying to save the value of that file and feed it into a macro that does the transfer text delimited. I keep getting this error that the expression I'm entering is the wrong data type for the section. (the file name that I'm trying to set = to the variable that is saving the file name in my code "openTextFile"....
|
2 |
3/23/2007 3:39:45 AM |
|
|
Text length when transferring into Excel
When copying/pasting or exporting an Access table into Excel, the longest
text fields are truncated in the Excel version after a set number (256
possibly) of characters. Excel cells definitely have capacity for
more--anybody have a workaround? TIA...
|
2 |
3/23/2007 3:38:32 AM |
|
|
Exporting an table to XML
This is a multi-part message in MIME format.
------=_NextPart_000_0022_01C76CAE.1A4A3A50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Good Day,
I need to export a table as an XML file. Access 2002 does not have to =
ability to transform the file with an XSL into the correct format and =
save it as the style version but rather save it a...
|
1 |
3/22/2007 10:15:42 PM |
|
|
Retaining formatting when exporting data from Access to Excel?
When converting an access table to excel it loses it's formatting and
rearranges the columns in alpha order. How can this be prevented?...
|
5 |
3/22/2007 8:01:13 PM |
|
|
Data Query - Text file specification does not exist
I am having problems with corruption of a Data Query in an Excel workbook
which works fine until I run the routine below which causes a
‘[Microsoft][ODBC Misrosoft Access Driver] The text file specification ‘…’
does not exist. You can not import, export or link using the specification.’
error message when I try to refresh data queries in other worksheets. When I
look in the Acc...
|
1 |
3/22/2007 11:18:00 AM |
|
|
wordwarp in excel after export
Hello,
When I export my query into excel all the formatting in excel in all the
cells text have word wrap format on them. If the column width is shorter then
the text it does not appear correctly - only the last part is showing.
What I want to know - is there someway of forcing the formatting on the text
fields, such as no word wrap, or left justified?
I am using a command button...
|
3 |
3/22/2007 4:12:21 AM |
|
|
Inserting Bookmark
I am using Access 2003 and have a field for adding hylerlinks. When I go to
the Insert Hyperlink box the Bookmark button is not showing. Help!
--
Message posted via http://www.accessmonster.com
...
|
1 |
3/22/2007 4:00:21 AM |
|
|
Exporting data
I am trying to export a query from access into excel but the as part of the
export the number values are exported rather than the word chosen.
For example - the title field is a pull down menu in the database where 1 =
Mr and 2 = Miss the export is transferring 1 rather than Mr and 2 rather than
Miss.
Is there a way round this? ...
|
3 |
3/21/2007 8:29:01 PM |
|
|
Outlook 2007 profile transfer
Hi, is there a way to manually pull all your account profiles in either
version of Office 2003 or 2007? I log into many different conf rooms and have
profiles that I would like to manually back-up. I rather not use the file and
transfer wizard that comes with Vista. The profiles are stored here:
users\user alias\appdata\roaming\microsoft\outlook [2007]. In 2003 Outlook
these are stored...
|
1 |
3/21/2007 7:05:23 PM |
|
|
vinculated table from sqql server200 into access 97, problem with numeric data
I have a table in Sql Server 2000 with a numeric field, actually float.
I use this table in an access 97 application, when trying to insert rounded
data I receive an error talking something like "decimal precision it's too
small yo receive the numeric value you tried to insert"
The code its:
INSERT INTO dbo_Celp (ValorTotal)
SELECT val(format(CxCH.Cantidad*CxCH.Valor,"############"))...
|
1 |
3/21/2007 1:06:54 PM |
|
|
Help on Importing a Date/Time Data Type
I have a program that exports data into an excel spreadsheet that I want to
import into Access. I can get the file imported into a table without any
problems. However, two of the fields are a Date Time Group in the following
format: dd hhnnZ MMM YY; where the Z is a time zone identifier. Is there any
way to get Access to recognize this as a Date/Time Data type instead of text?...
|
5 |
3/21/2007 12:26:05 PM |
|
|
can't export from Access 97 to Excel
Hello all,
We can not export data from Access 97 to Excel (either 97 or 2000). All of
our reports are set to run with Access 97 only, so this is a "must have" fix
for me.
I am trying to set this up on a Dell OptiPlex GX745 that is running Windows
XP SP2 (which apparently is part of the cause of the problem).
I've tried renaming the htmlmarq.ocx, and even renamed it in RegEdit. Still
no ...
|
5 |
3/20/2007 1:36:16 PM |