Search results

Example:I have a table with 3 fields: Name,Book,NumBooks Each Name can have more than one book. I want to count the number of books each name has and put it in the NumBooks field. ie: Update 'NumBooks' to equal count 'Book' for 'Name' = 'Name'. Setting up a Query Update Name to Count(Book)...

How Do I find out what the screen resolution setting is? I am using MoveSize to position a form (used as a control box) on another form but if I position it correctly for a 1024x768 monitor is is irretrievably pushed off screen on an 800x600 monitor.

What is the VBA code equivalent to an append query? Query SQL is: INSERT INTO Table1 ( NBR ) SELECT Table2.NBR FROM Table2; Thanks

How do I make an 'announcement box' like a message box but with no OK buttons? eg screen box says "I'm busy doing something" which doesn't have to be acknowledged & can be closed when the task is completed. I have tried to use a form which would just display a string sent to it as open...

Ignore last post. I hit the wrong key & it posted before I was finished. I have two forms. How do I do the following?: Sub: Event dbl click Open the 2nd form Transfer control to the 2nd form so that the user can select a record WITHOUT finishing this routine. ie suspend execution of this...

I have two forms. I want to do the following: Event.double click

I have a form open in datasheet view, the user is to select the record wanted & double click. On double click I want to pop up a box like a message box which gives the user a choice of three or four options similar to an option group box. The form is open in datasheet view so I can't use an...

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...

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

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

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...