Search results for query: *

You are on the right track, what I do is put a small command button next to the field I want to search by. myTextBox.SetFocus DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 Exit_Search_Click: Exit Sub Err_Search_Click: MsgBox Err.Description Resume...

Thanks for your reply, data entry is set to no. I can add new records, but can not display the old records once the form has been closed and reopened.

I have created a form that is based off a query when the form opens it displays a blank page with no records. I enter in a record and then move to the next blank record. I can move back and forth between the records with no problem. However, once I close the form and reopen it, I get the blank...

Ultimate Goal: I want to e-mail data from a form to a particular e-mail Address using "SnapShot" format. (the email part I don't have an issue with) Situation: 1. Can't email a form using "SnapShot", snapshot only works with reports. (not a problem) 2. Need to make a...

I have two tables linked together. Table1 is my main table and table2 is my helper table. For example, I have an order form, the main form has all the customer information and is linked to table1. I have a subform with items and pricing, and is linked to table2. In entering the data, and in...

This has been stumping me for two days now. I would like to goto a certain record based on input from a text box. 1> datSecondRS.Recordset.FindFirst "[flightID]=txtFlg.text" I thought line 1 would do it however I get a Run-time Error 3070 "jet database engine does not recongize...

Programs: Crystal Reports 8.5, Visual Basic 6 sp5, Other Info: Using OCX, Data Saved with Report set to Off, Report Refresh button enabled. Problem: Using the OCX a report would be generated correct the first time, rerun the same report and no data would be displayed. Using the Refresh Report...

Using CR 8.5 OCX, I am able to run my report perfect the first time, however when try to run the report a second time, I come up with no data in the report, all I have is just the colum headings. If I stop the app, and rerun it using the same criteria it works fine, until I run it a second...