Search results

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

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

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 All Im trying to read the value of an excel cell and transfer the value to an Access variable in VBA. Can anyone help ??

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