Search results

Thanks Mile-O & vbaInet thats the easy bit done- 3,000 of the 5,000 records sorted

To start my learning curve I have filtered out the easy ones to start with, I have replaced the spaces with comma's MemberID Boats 1000 Dreadnought,Oracle,Otus,Otter 1001 Churchill,Warspite,Spartan,Sceptre,Superb 1002 Courageous,Conqueror,Valiant,Superb,Splendid 1003 Artful I have used code...

That worked Thanks vbaInet.

I did and it made no difference

Thanks Milo. H34 & O10 are boat names, albeit old ones. Sorry I did not make it clear in my first post that MemberId & Boats are seperate fields.

I'm not sure if I am biting off more than I can chew. I have a text field in each record in my database (Inherited) The db has nearly 5,000 records. I would like to split the field into records in a seperate table. An Example of the table as is now; MemberID Boats 5882 Opossum(78-80) (87-89)...

The status bar does not show in design view

I am using Access 2010. I Have the 'Display Status Bar' box ticked in Application Options but the Status Bar is not being displayed. Any suggestions please?

Sorry, off to specksavers in the morning. Thank you.

Sorry I should have mentioned I am using Access 2010 and the Access 14.0 Object Library is ticked

I am trying to code a button to select a file path. I get a compile error: User-defined type not defined on the following line; Dim fldg As FileDialog

Thanks, that worked. Thank you also JD for your time.

Its calculated

Hi JD Problem still exists Regards Keith

I have a form frmUpdateSubs with a subform frmSubTransTemp. I have a control Running Total on the main form with a control source of =Nz([Forms]![frmUpdateSubs]![frmSubTransTemp]![txtSum],0) Every thing works ok when I open frmUpdateSubs. I have a main form frmMain with an option group 'Menu...

Solved, Just the fact that I posted the question made something click. I added the criteria to the query grid highlighted in Blue in the SQL view of the query. SELECT tblMembers.MemberID, tblMembers.LastName, tblMembers.Initials, tblMembers.FirstName, tblMembers.DateOfBirth, tblMembers.Rate...

For some hours now I have been researching how to pass a parameter to a query in VBA. I can't get my head around it - I must be thick. I have a function that when called transfers a query recordset to an excel spreadsheet then emails it. At the end of the function I use code to write the date...

For some reason it didn't like being filtered on BranchId I changed it to filter by Branch Name and it worked a treat. Busy now coding the send email bit.

Solved. I changed Open Report to; DoCmd.OpenReport "rptSubsDue", acViewReport, , "qrySubs1!Branch_Name = " & Chr$(34) & strBranch & Chr$(34), acHidden It works now

Thanks for the tip Dale. Thanks Paul, I have inserted the missing comma. The only difference now is instead of every record from qrySubs1 in each file only records from Branch 1 are in each file.