Search results for query: *

Hi, I'm having trouble with an overflow error with one of my forms. I am resizing a subform depending on how many records it holds each time the user goes to a new record, the size of the subform updates. I resize the Me.Detail depending on how big the subform is. I think this is where the...

Hi, Trying to add new records (containing differing info) to two separate tables from one form containing text boxes and a datasheet. Was trying to implement this using SQL INSERT INTO within VB code, but cannot get it to work. This is for an invoice, i want to send all of the customer details...

Hi, I need to resize a subform each time the user cycles through the records in the main form, what is the event that occurs when the user presses the arrows at the bottom of the form to go to next record? Thanks in advance Bec

Hi, just wondering what would be the best way to find statistical information about a customer (ie the number of quotes for that company and the total cost quoted by the company) There is a table which contains company info and quote info but the number of quotes for a particular company, and...

Just another quick query, i was wondering if it is possible to stop a form displaying a record for (that is the same in the main form) for each record in the sub form. For example If i have a main form key of 1 and subform elements of 1 2 and 3 then the main form will display 3 records each...

hello, i want to change the height of a continuous subform depending on how many records it contains. To do this i was going to use NumRecords?? Me.QuoteSubform.Height = NumRecords*RecordHeight this would be placed in the OnLoad event of the parent form

Hi, I want to seach records to display a form relating to a specific quote number. The user will enter the quote number they want in a text box and press a search button which should display the specific quote record on a form. Any Help would be greatly appreciated Thanks

Hey, Just wondering how to go about resizing a (continuous) subform at runtime (so the user does not have to do anything) so all of its contents are visiable. This contents may change according to the users request. Thanks

Hi, Just wondering if there is any way to display an image (not just its name) within a datasheet. I don't think this is possible but maybe there is some way around it. I have made a form to display a quote and need to show images of all parts that have been quoted, the images are stored in a...