Search results

I have a form that is used for data entry and it does an add new record after and update. When the user clicks the X to close the form I want to prompt them to complete record yes or no. If they say yes how do I cancel the click of the X and put focus back in a text box. I have been trying...

I have a sum calculated on a main form that is set from a text box in the footer of a subform. I have trained people using forms to use the right click and filter by selection for narrowing records in a datasheet. Problem is the calcualated value on main form is not being updated with the sum...

I am setting focus to a combo box and would like the value in the box to be selected so a keystroke would clear value. Just like the tab key does. thanks, vmon

I have a column that has data I need to sort on. The column is a text field and contains numbers and letters. Could have 1 to 3 numbers in start and 1 or 2 letters follow for half the list and 1 letter in start and 1 to 3 numbers follow. Like this. 10A 19A 20C 2B 2C 402AL 430B 482CL a2 c2 j1...

I am having same trouble. I get ODBC -- Call Failed. [Microsoft][ODBC Visual FoxPro Driver] Error Reading File. (#104). The linked table connections work for a while and then just stop with the message above. vmon

Excellent!

I am creating a text file (csv) and writing text to the file. Is there a way to export text without having my data enclosed in double quotes? Here is what I am trying. Open "c:\john.txt" For Output As #1 Write #1, Trim(rstExport.Fields("RecTyp"), _...

Thanks for the reply. I am not having luck with it though. To get the statement to not error out I added a right paren. It looks like this but frmCompItem is getting set to 0 after the statement executes which is the value in the control on the form. I changed the field name to the actual...

I want to set a varaible to an object but I want the object name to change. I have 3 fields called: field1, field2, and field3 and want to use a varialbe to reference each adding a counter to the end to identify which object. Here is what I have tried. A and B are just numbers. Any ideas...

Nailed it. Try. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tableNameHere", strPath & strFile

Output to excel 5.0 vs 2000 specificaiton I have the following code and I am getting an error that says there are too many rows. The export is sending about 17,000 rows. I am using A2K - ADP with SQL Server 2k backend. Problem is Access uses Excel 5.0 as specification when outputting for...

Figured it out. There is a bug in A2K with SendObject not working. Microsoft Knowledge Base Article - 260819 ACC2000: SendObject Method Fails in Access 2000. I had to add a class object and reference CDO 1.21 to get around problem. I debug it was skipping right over my SendObject.

Help does not tell me which references are reuqired. I have 2 CDO references 1.21 and Windows 2000. I am not sure if I need any others and I don't know the difference between the 2 CDO references. Right now I don't have any CDO references and when I use: DoCmd.SendObject...

What references are required to use sendobject for purpose of sending email? thanks, vmon

Using A2K with SQL Server. I have a subform with a column that has uniqueidentifier data in it. I want to call a stored procedure passing this value but am having trouble getting the control value. Access does not recognize the control in code. Here is a clip of the code. The control...

I figured out a way through it. I added a save record. If you don't mind offering advice. I have a header and detail. The header has a MeterBegin and MeterEnd number. Each detail record has a MeterStop number which must be between the MeterBegin and MeterEnd. Also on the detail I...

I have a form that calls a public sub to calculate a column for each record in a subform. The code is working but the changes are not committed. If I make a change to a record after the sub runs it asks me to Save, Copy to Clipboard, or Drop changes. Also the edits to each record are not...

I am struggling with exporting data in a view to an excel spreadsheet. I have tried variations and then some below. Any ideas? DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryCollectionsExport", strPath & strFile, True DoCmd.OutputTo acOutputQuery, "qryCollectionsExport"...

Wayne, I tried that but same error. I will expand. When I debug the happens after I enable/disable some controls on a dirty event. I hit the statement which takes debug to on dirty then upon retuirning to the statement in question I get the error. Any ideas? vmon

I have a form I run the following code and I get the error message The data has been changed. What am I doing wrong? Select Case rstLevels.Fields("BomLevels") Case 1 ' One level Bill - Tube/Slit strSql = "SELECT" this is a select statement that processes fine...