Search results

i was just about to zip it for you but its now working! god knows what was wrong very weird problem indeed!

heres an image of what i mean there should be 11 items but theres only 10 being displayed as ya can see from the subReports border theres a gap for 1 more it just isnt displayed.

sweet that fixed it thanks

i just added to my forms that use Quires Private Sub Form_Open(Cancel As Integer) If Me.RecordsetClone.RecordCount = 0 Then MsgBox "ERROR: There are zero records in the data source!", vbInformation, "No Records Found" DoCmd.Close acForm, Me.Name End If Problem is this...

i can get the second page to display some records now.. but the last record in this case number 32 is not displayed.. when i turn the border on the subform on it shows theres space for it and everything its just not there.. its Very starnage!!

the if statment now works! thanks heaps. But i cant make the text box invisible im just using me.txtAdjustersName.Visible = False this dosnt work. any ideas of what would work? EDIT::: looks like Me.txtAdjustersName.Application.Visible = False works EDIT X2 :: OK NO IT DOSNT! :) it just...

in the report Open event

ya i thought of that its defently a real second page not just over spill from the first

i need to have like a if statment on a report. If adjusters code = "NA" then dont display adjuster details and display insurer details.. else dont display insurer details and display adjuster details. but i keep geting the message that the text area needs focus. but i cant set focus on a...

the report uses a sub report to display a list of items and prices it works fine untill you fill up the page it creates a second page with nothing on it if need be i can zip up the database for you to have a look at Thanks Heaps!

i just worked it out! im such a dork! :) it was that i was showing a colume in the quriy i shouldnt have been, took it out made the report use a sub form with another qurie and it works Sweet now! Thanks for ya help though!!

no formula just using the total part and select sum i gess if it had a formula it would look like Sum([theRetail]) but all it dose is just give me the value in the last record count also says theres only 1. but theres clearly 2 records in the query

i need to work out the total of a colume in my query but when i use sum its just telling me the value in the last record in that colume if ya need anymore info just tell me thanks heaps!

I just checked if the relationship between the two tables had ERI ticked and its cool its was all ticked. this is what ya mean isnt it? thanks for the heads up though!

i just worked it out my Qurey was a little off works sweet now

ok i have a sub form and i have linked the child and master fields But when i try add a new line to the subform it Says "The LinkmasterFields Property setting has produced this Error: 'the object dosnt contain the automation object' tblInsurance." then when iopen the QuoteItems table the item...

this image should help explane what i mean and why I need this grid

i need a way of entering lots of items into a form or viewing this list of items and editing them. much like how the DataGrid in VB.net works ive been siting here scratching my head wondering why there isnt just a grid in access for entering data using a form. list box Sort of dose what i want...

exlent! and thanks for the good ideas! defently want a date feild there to see when they joined! :D Thanks Heaps again!

dose this look right? the insurance Table is pritty big though :confused: