Search results for query: *

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...

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...

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

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...

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...

If the [Second Owner First Name] field is null, then nothing it returned in the [OwnerName] field. How can I fix this? Thanks . . . Rick SELECT Castille.[First Owner First Name] + " "+"&" +" "+ Castille.[Second Owner First Name] +" "+ Castille.[First Owner Last Name] AS [OwnerName] FROM Castille

This code (query) is run via a command button on a form. I'm looking for a way to allow the user to insert a date, ie., 2006-08 into all three date fields at one time as they will always use the same date; LISTDATE PENDINGDATE CLOSEDDATE Thanks . . . Rick SELECT OCDownloadRES.CITY...

I'm posting it here in case no one catches it at the end of the other thread. I'm so close now . . . the query below produces the correct results, only for the entire table! I need to know how to allow the user to enter a date, ie. [Enter yyyy-mm] and have it placed in the three date fields...

I just can't figure out why this doesn't produce any results, just 0? SELECT OCDownloadRES.CITY, Format("LISTDATE","yyyy-mm") AS Expr1 FROM OCDownloadRES WHERE (((Format("LISTDATE","yyyy-mm"))="2006-08") AND ((OCDownloadRES.PROPSUBTYPE)="PROPSFR")); What I'm trying to do is get all of the...

This is not producing the correct count(*) results. It's returning 21 for all three; LISTDATE, PENDINGDATE, and CLOSEDDATE. What am I missing here? Thanks . . . Rick SELECT Count(*) AS LISTDATE, Count(*) AS PENDINGDATE, Count(*) AS CLOSEDDATE FROM OCDownloadRES WHERE...

This happens with Access 2003 so often it's not funny! Type Conversion Failure | LISTDATE | Type Conversion Failure |STATUSCHANGEDATE | The date in the imported text file is as: 2000-06-20 00:00:00 Any ideas? Thanks . . . Rick

That's the error that I get when attempting to run this query. ..SFR.. | 2006-08.., calc count all, AS "SFR New Listings" | ..CONDO..| 2006-08.., calc count all, AS "CONDO New Listings" | I never could figure out how to calculate same fields in the same table using different selection...

I give up. Error is "Alias is not currently opened. Table Working:ScmlsNormalize.db Alias Working Table ::ScmlsNormalize.db" method pushButton(var eventInfo Event) var;----------------Declare Variables------------- Scmls, ScmlsNormalize table qbe query endVar;-------------End Variable...

Error says "the design object MYDIR:cbnrtofc, could not be opened. Cannot find MYDIR:cbnrtofc." cbnrtofc.db is a small table with only one field in it in the working directory. I know that the script I'm running is finding the table because when I debug the code and look at the variables the...

I have this in a small method in Paradox 8. tblname = "Type the Table Name To Be Queried..." tblName.view ("Which Table?") Is there a way to view a list of tables in a folder and select a table name to insert here? Thanks . . . Rick

I don't get it. Looks just like a sample in the Paradox Manual. method pushButton(var eventInfo Event) var;----------------Declare Variables------------- Mrmls table MrmlsNormalized table qbe query endVar;-------------End Variable List-------------...

H. L. E. P. I’m still fighting to discover a way to select a table name from the first query and pass it to the below query. SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Not Like "~*" And (MSysObjects.Name) Not Like "MSys*") AND ((MSysObjects.Type) In (1,4,6))); Is...