Search results for query: *

so is there any solution?

eeeek...so am i supposed to make things such as Me.Detail.Height a long data type, how is this done... Changed the difference var to long, but that wasn't the problem

heheheh....dammit i'm silly thanks a million :)

about 40000? This is just a guess, i have these values printed on the form except they do not update when the error occurs,

Me.Detail.Height = Me.Detail.Height + Difference is highlighted where Difference = Me.QuoteParts.Height + Me.QuoteParts.Top i don't do any division anywhere within the code?? it's puzzling

Thankyou for your suggestion and i tried this option but ran into a difficulty... I'm having trouble entering data into the subform in datasheet view. As soon as i change this forms data entry property to yes the subform becomes empty and there are no rows to enter or change any existing data...

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, I just tried to implement the code given above in cmdOK_Click() but get Run-time error '2001': You canceled the previous operation on my DCount line: If DCount("Name", "QUOTE") = 0 Then

a table

I don't quite understand what you mean by joining the header table to the item table. I only want one quote displayed for every quote number, at the moment it displays multiple quotes for a quote number (which are all the same) as there are different part records for the quote number in the...

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

Ok now only the header is displayed and i get error# 2455 saying that You entered an expression that has an invalid reference to a property Form/Report Thanks a lot for your help Appreciated Muchly

it's still only displaying the first record. Must be a silly mistake i'm overlooking. Could it be anything to do with the relationships i've set up

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

QuoteNumber is an autonumber and i am not getting anything on the main form either, only the header. I have Private Sub GetQuoteNo2_Enter() Dim stDocName As String Dim stLinkCriteria As String stDocName = "HUNZA Quotes" stLinkCriteria = "

I'm not quite getting it to work, the problem i think is that the form has a subform whose elements are also referenced by quote number, this is not putting any records in the subform (records are needed in the subform for another part of my code)

Thankyou very much for that help. Worked Perfectly. Cheers

I am putting this combobox on a separate form that contains several different types of searching the records. So onEnter i will have to make it open the required form with the record i searched for