Search results for query: *

Hello Everyone. An interesting problem has come up at work. Our report generating software created a report that produced 799 ".csv" files and places them in a folder. These files contain a single cell that holds the "Total Sales" for a specific store. I need a way to open each file, select...

Hello everyone. I'm using access '97 for this. I have a form that uses a tab control to display a large amount of data. Sometimes 2 records, due to customer requests for quotes, are very similar. To save time for the users and eliminate reentering data I am trying to allow the user to copy...

Hello everyone. I'm using access '97 for this. I have a form that uses a tab control to display a large amount of data. Sometimes 2 records, due to customer requests for quotes, are very similar. To save time for the users and eliminate reentering data I am trying to allow the user to copy...

Hello everyone. I'm working in Access '97. I have a form that records information on quotes. In this form there is a subform that holds a great deal of information about the part numbers contained in the quote. Sometimes the parts as very similar and my users want to be able to copy a record...

Hello all. I have a form in access '97 that opens another form in datasheet view. These forms are related by a field called "RecordNo". This is the code I use: Private Sub cmdInvoices_Click() Dim stcrit As String stcrit = "RecordNo = " & Me!txtRecordNo.Value Debug.Print stcrit...

Hello everyone. I must say this has completely frustrated me. I'm using acces '97 and I'm trying to open a form to a specific record. This is the code that I am using to initially open the form Private Sub Command18_Click() If Me.NewRecord Then MsgBox "Please enter a tool...

Hello everyone. I'm using Access '97 and I have a question about one of my subforms. The subform is a continuous form that has a command button. When the command button is clicked it opens a new form that is dependent on an AutoNumber field in my subform. So here's the problem. If I click...

Hello everyone. I'm using access '97 and I'm getting an error that I don't know how to correct. I have a form with a subform and as I go through the records and come to a record that has data in the subform I get this error. "Object invalid or no longer set." The error seems to be in the on...

Hello everyone. I'm doing this in access '97. I am using the following code to open a form to a specific record. DoCmd.OpenForm "sbfrmActionItems", acNormal, , "[RFQNumber] = '" & Me![RfqNumber] & "'" This works fine but if a record doesn't exist I want it to create a new record with the...

Hello everyone. I have a form I using as kind of a menu. I'm using access '97 by the way. My form has two buttons. When the first button is clicked I want the form it opens to open in data entry mode. If the second button is clicked I would like the form to open NOT in data entry mode. How...

Hi everyone. I when a specific event occurs I want all of the text boxes on my form to be cleared. Here is an example of how it is done now Forms!frmReportCriteria!txtStartDate.Value = "" Forms!frmReportCriteria!txtEndDate.Value = "&quot...

Hello everyone. I have a form in access '97 that has a list box [lstCodes], a text box [txtCodes], and a command button [cmdAddCodes]. What I want to happen is the user will enter a number of characters into the textbox and when they click on the command button the value in the text box will...

Hello everyone and happy Friday. I'm using as SQL Pass Through query to bring in som information from one of out systems. The date is formatted year month day. to 05/22/2001 would looke like 20010522. I need ot get it into date format. My first though was that there had to be a function...

Hello everyone. I am working in access '97 for this application. I have a table that needs to be refreshed every time the application is opened. Right now I'm using a create table query and running it in the on open even of a form. However, the user is required to answer yes to questions...

Hello everyone. I don't use access charts very often but for my current project I need to create several pie charts. I have a query that the report is based on. This query already sumarizes my data so I have 1 record. The query is called qrySummary and it has the following fields: Internal...

Hi everyone. I have a column that contains data resembling the following: 123;455 1000;2000 12.5555;5.5555 I need to be able to capture everything to the left of the semicolon. I am using access 97 with an ODBC connection to a Progress database. Believe me this was not my weapon of choice...

Hi everyone. I'm running into something here that hasn't seem to happen before. I'm using a combo box called cboFind to let the user select which record he/she wants to work with. Here is the code. "Private Sub cboFind_AfterUpdate() Dim R As Recordset Set R = Me.RecordsetClone **...

Hi everyone. I have a form in access 97 that uses a tab control. The tab control has several pages. For security in certain instances I need to set the "enable" property for one of the pages to false. I'm not sure how to tell access what page I want. It's a syntax problem. I can...

Hey everyone. In Access 97, is it possible to fill in several text boxes with the information that was in those text boxes on the previous record? Thanks in advance, Jason

Hi Everyone. This problem has beed driving me crazy. I have and access application that I didn't create. This application has a main form with a subform. When I try to add a new record to the subform I get an error that says: "RunTime Error -2147352567 (80020009) Record is...