Search results

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

Hi thanks for your reply I have a VBA Sub I need to open an Excel file go to a defined cell read the contents back to a variable in the VBA sub. Hope that makes it clear Flaghippo

Hi All Im trying to read the value of an excel cell and transfer the value to an Access variable in VBA. Can anyone help ??

Thats Great Thanks alot

Hi That work great but I need to have all the lines in the text file in one continuous line without carriage returns. Thanks Mike

Hi All I am reading a text file (.txt) into VBA (ACCESS) The text file could have an unknown number of lines. I need to write all the lines into one variable for use as an email line. Can any one help ?????