Recent content by kermit5

Thanks. I appreciate the advice. I am still learning to effectively use the references. The advice you gave did the trick.

I am getting error 13 "Type Mismatch" in the following code when I run the code: set rs = db.openrecordset(strSQL) Any idea why? Here is my code: On Error GoTo hypSupplyProposal_Click_Err Dim db As Database Dim rs As Recordset Dim strSQL, stDocName As String Dim intBidID As...

Is there a way to export date/time appointments from my A2K2 database to my outlook callendar? What I have is a calendar of projects that have bid dates assigned to them. I would like to export the date, time and name of the project automatically to Outlook where I can manage the time...

Thank you. You were correct. Here is what it required: strSQL = "SELECT * FROM [Bid - Contractor List] " & _ "WHERE [Master Project ID] = " & intMasterProjectID & _ "AND [Contractor] = '" & strContractor & "'" Because strContractor is a string variable, I need to set...

Unfortunately, I still get the same error.

I'm not sure I understand what you are asking? If I include a semi-colon here: strSQL = "SELECT * FROM [Bid - Contractor List] As myTable " & _ "WHERE myTable.Contractor = " & strContractor & _ " AND myTable.[Master Project ID] = " & intMasterProjectID; I get a compile...

Here is my code Dim intMasterProjectID, intContractorListID As Integer Dim strSQL, strContractor As String Dim dbs As Database Dim rs As dao.Recordset intMasterProjectID = Forms![Bid - Master Form]![Master Project ID] strContractor = Forms![Bid - Master Form]![Bid - Bid...

I am having difficulty figuring out how to deal with fractions. The database that I am designing is for a company who's industry standard nomenclature is in fractions. For example, 5-3/4", 1/2", 3'2", etc. I need to perform mathematical operations on the user's input. For example, if the...

Is there a way to set up a find feature available via right clicking on a control? That is to say, I have a control that contains the names of projects. It is a combo box that finds the record according to the project selected. I would like the user to be able to right click this field and...

How do I error trap an input mask violation so I can display a more user friendly message?

I have an application running in A2K in which I have the database window hidden. I have created a replica of the design master but I do not have the option available in either the design master or the replica to synchronize unless I first display the database window. Is there a way to enable...

I am still getting a compile error:Invalid use of property at the line: rstClone = Forms![Bid - Master Form].Form.[Bid - Quote].RecordsetClone

I am using Access2K2. I do have that referenced.

I have a report that requires the user to input a date range. For example, 1/1/03 thru 5/15/03. I need to determine the MonthlyAverage over the specified range. In this case, I would count the number of items and divide by 5 for a montly average. This is easy to do manually (because I know...

Here are a couple of hitches: With the line: rstClone=Forms![Bid - Master Form]![Bid - Quote].RecordsetClone i get a compile error:Invalid use of property rstClone= With the code: Set rstClone=Forms![Bid - Master Form]![Bid - Quote].RecordsetClone I get error # 438:Object doesn't support this...