The following is what I found at Http://uberkuh.com/node/666
This worked perfectly.
Thanks Again . . . Rick
Here was the solution.
If you download Internet Explorer 7 Beta 3 and have IE7 Beta 1 or 2, you will be asked to uninstall 1 or 2 before installing 3. Easy as 1, 2, 3, right?
Wrong...
I installed IE Ver. 7. Worked fine except for a particular web site that I MUST have for business.
This site obviously is not ready for IE Ver. 7.
I uninstalled IE Ver. 7 and tried to install IE Ver. 6 but it said there is another newer version of IE and would not allow me to install IE Ver...
Hi Jerry . . .
Thanks for the info.
The number of records that I import are, at times, over 100,000!
I'm going to try your suggestions.
I'll let you know what I come up with.
Thanks again.
Rick
Regarding the import errors table.
Are the RECORDS reflected in the import errors table deleted from the imported table, or just the data reflected in the import errors table fields list?
Also, why does Access 2003 fail to import this date format from a delimited text file?
2006-07-18...
Of course it was the margins.
However I feel that Access 2003 falls far short on this as there is no way to visibly show the current set margins in design view.
And the ruler measurements are not consitent with the overall page size.
It's very archaic.
Thanks. . . Rick
About a year ago I installed MS Office Professional 2003 WORD, ACCESS, PUBLISHER and EXCEL. I did not install POWERPOINT.
Tonight I decided to install Powerpoint. I did not select the prior installed programs. Why would I???
However, the original four programs are now TOTALLY GONE from the...
About a year ago I installed ACCESS, EXCEL, Publisher and WORD 2003.
I did not install Powerpoint.
Tonight I installed Powerpoint and the other three programs have totally dissapeared!
If this is really gone from the hard drive I'm screwed and it's a MAJOR flaw from MS.
What happened?
Rick
I have a form based on a query that I used to edit specific records.
Will my record edits in form view automatically revert through the form, back to the table the query is based on?
Thanks . . . Rick
Well, I got it fixed, however - I don't know what fixed it. I think Access 2003 leaves a lot to be desired.
In this case, maybe printing grids in report design mode.
Thanks . . . Rick
I've searched through the forum but cannot find a answerthat has worked.
I have a 5 by 8 card where I want to print an address label in the lower right-hand section of the report.
I have the page size correctly in landscape mode.
In print preview the fields show up perfectly - in every other...
Paradox 8
WIN XP PRO
2 GIGs RAM
400 GIG Mem
Dual Core Proc
I'm running a small report in 8 1/2 x 11 landscape mode but each time I try and print it I get a GPF error.
When I get into the error I can see subject referrence but no way to understand just what it is referrencing.
Parafox 8...
HEY EVERYONE . . . your postings were EXCELLENT.
I tried PHV's example.
INSERT INTO [large table]
SELECT *
FROM [smaller table]
Ah the simple things in life.
I then ran into the named field MUST be the same error.
I found this strange as Paradox 8 doesn't care about the fields names. It's...
...an SQL.
The following when run states that . . ."You are about to append 0 rows . . ."
INSERT INTO [Copy of RICKSFARM]
SELECT [Copy of RICKSFARM].*
FROM [Copy of RicksData] INNER JOIN [Copy of RICKSFARM] ON ([Copy of RicksData].[Lot SQ FT] = [Copy of RICKSFARM].LotSize) AND ([Copy of...
I spen the last hour delving into the book ACCESS 2003 Bible but for the life of me I can't figure it our.
I have two simply tables.
A matching number field, ie., 448-342-98 in both tables.
I want to add ALL of the records form a smaller table to the large table. I KNOW FOR A FACT that the...
You know . . . CanShrink/CanGrow are for verticle movement on a field.
What about sizing the field horizontally to expand or contract based on the amount of text in the field.
Al would shrink from William, and whereas william would grow from Al.
How is this accomplished in Access 2003...
This is taken right out of Access 2003 help file on Can Shrink Can Grow but it fails in my field control source in my report.
Trim([First Owner First Name] & ("& "+[Second Owner First Name]))
Any ideas . . ?
Thanks . . . Rick
Okay it's working for FIRST OWNER FIRST NAME and SECOND OWNER FIRST NAME but it's not adding FIRST OWNER LAST NAME to the end.
Castille.[First Owner First Name]+" "& IIF(IsNull(Castille.[Second Owner First Name]), "", "& " & Castille.[First Owner Last Name]) AS [OWNER NAME],
What could it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.