Search results

Why do I get 'runtime error 3061 too few parametrs' error with the 'Set rstName = .OpenRecordset()' staement in this: I've followed the example in the help files as close as I could. Next Question: The MsgBox gives a type mismatch error because rstName is not a String. How go I make a RecordSet...

Probably this doesn't really help with your problem but I have done a similar thing. I have a form where the user must enter dimensions. I want them to be in metres but often the information is often in inches or feet & inches. I set up so that the double click event opens a query which prompts...

How do I set up a custom submenu to run a code procedure instead of a Macro? I have a form which was constructed using macros & queries & I am tried to thin out the multitude of macros. Thanks

Thanks Pat I want the warnings off because otherwise the user gets a "You are about to update xxx records" message. strSQL does not need a join because the Small Table is limited to just one record. It is a form used to edit &/or print a single page report for one record at a time only. Field...

Thanks Bj Took a bit of tweaking but I got this to work: Dim strSQL As String Set BigTableID = Me.ActiveControl Set BigTableCodeNum = Me.CodeNum Dim frmCurrentForm As Form Set frmCurrentForm = Screen.ActiveForm Set SmallTableID = frmCurrentForm.ID strSQL = "UPDATE BigTable, SmallTable SET...

I'm not sure if I'm the best person to answer this since I really am an amateur at this but I have done similar tables. If I understand you correctly, you want to end up with a sheet where you have: Load Code Shipper Receiver Trucking Co 021803-001 AAA001 BBB002 CCC003 and you want...

How do I set the form properties so that the form will use a custom submenu when in print preview view?

I want the user to user to press a button or select from a right click popup or something while at the selected record in the big table (datasheet view) an have the record ID# (it has an ID# field) sent to the small table which is open in form view. The big table can be opened as a subform in...

On 13 Feb 03 AccessAmateur wrote: GetInfofromTable I have a form which edits/prints data most of which is obtained from a large (50,000+entries) table which is read only. How do I set up so that the user can open the large table, select a record using any search/filter criteria on any field...

I have a form which edits/prints data most of which is obtained from a large (50,000+entries) table which is read only. How do I set up so that the user can open the large table, select a record using any search/filter criteria on any field in the table then send the record ID# back to the...