Recent content by flaghippo

Hi all and thanks for your responce. It is working now but only finds the first record ! Any further help would be great. Thanks

Hi All I am having problems with Dlookup from a table which is linked to Excel. The heading on the fields from Excel have been imported as F1, F2, F3 etc... the code I am using is as follows ..... LOOK = DLookup("F6", "DATABASE_LOOKUP", "F1 = 1338087") F6 = A date I am looking up...

Hi thanks for your reply My table has go far too big approaching 256 fields I Could easily split Into 3 or 4 tables and then link together The table has a few thousand records so I need to find as easy way do this. Thanks flaghippo

Hi all I have a table which basically has got too large far too many fields I need to split into two tables and then link Does anyone have any ideas how to do this ? Thanks Flaghippo

Hi all I have a table which basically has got too large far too many fields I need to split into two tables and then link Does anyone have any ideas how to do this ? Thanks Flaghippo

Thank you both for your kind replies. I will give you suggestions a try. Flaghippo

Hi I would like to force a new page on a report when grouped. I need the page filled up with as many groups as possible. If infomation will not fit onto one page then force a new page at the bottom. All information in the group must be together i.e. group header and details If you have...

Thanks for your help its worked a treat!

Hi All I am trying to link two fields in a table here is an example .... Field A Values stored could be.... AAA, BBB, CCC, DDD etc LIST TO LOOK UP AAA = UDC2 BBB = UDC1 CCC = UDC4 DDD = UDC3 Field B Needs to lookup listi n Field A and get correct UDC1, UDC2 etc... Can anyone help ? Thanks

Hi All Everytime my form loads the navigation pane is visible. :( I have unchecked the Display Navigation Pane in ...... Access Options>Current Database>Navigation> Closed and re-started Access and its still there !!!!! Please see attachment for an example. Anyone had the same...

Hi The Control & Name are exactly the same. Please see attachments .... (NOT SURE THESE ARE ATTACHED) COMPILE ERROR: INVALID QUALIFIER

Hi The error is.... Compile error invalid qualifier. Its seems to me the VBA code has lost its link with the control on the form. I have tried ..... [formname].Form![controlname].SetFocus and [formname].Form![controlname].value = variable Still the same code Is the form corrupt I wonder...

Hi All I am using the code below to read into form control combo boxes. Me.CUSTOMER.Value = EX_CUSTOMER Me.Contact.Value = EX_CONTACT Me.QTY.Value = EX_QTY This works fine until I get to this code Me.PAINTING.value = EX_PAINT Strange thing is... When I enter the...

Thanks for your reply

Hi all I have 10 users with various screen resolutions all using Access 2010. Is there a neat bit of code that will check the resolution on load and re-size. I have tried DoCmd.Maximize with no luck. Any help would be great. Thanks Flaghippo