Recent content by MickM

Thanks Leigh, worked brilliantly. I have removed the '#' from the directories. Cheers Michael

Thanks ajetrumpet, But I am also need to export this to a spreadsheet. FYI, here is an example string "G:\AWD Project\98_Data_Packs_staging\02_BLOCK_107\DATA PACK RE-ISSUE 090805\BLOCK DRAWINGS\1075020020N Rev A INTERNAL PIPING ARRANGEMENT BLOCK 107\2009000019#Rev0001_BUILDING...

Hi All, I need to include a hyperlink field in my table but the address string is too long and I cannot seem to get it to work! Is there another way to add file links to a table? Cheers

Works Brilliantly! Thanks very much. Michael

Hi, new to VBA! I am trying to get the syntax right for opening a query and checking for null records. If the result is nill I then want to run another query. I keep getting errors. here is the code: DoCmd.OpenQuery "Check_Date" If IsEmpty("Check_Date") Then DoCmd.OpenQuery...

Thanks Ron, How would you create a trend line if the query totals are changing weekly without storing that data? Michael

Hi All, Just need a bit of direction here. I have multiple queries (15 or so) that I want to be able to get the total number of records for each query at any point of time. The totals are appended to another table so I can build a graph (trendline) from the data. I know I can use Dcount and...

Thanks Boblarson for pointing me in the right direction. now have it sorted. FYI, here is the final code: Dim dsn As String Dim uid As String Dim pwd As String Dim odbcConnectStr As String DoCmd.SetWarnings False DoCmd.DeleteObject acTable, "GUEST_PROT_CDRL_DOC" DoCmd.DeleteObject...

Hi All, I want to import tables automatically from a server database. I don't really know where to start. I have searched the net, but can't seem to get anything to work. I have a macro but I get the error "could not find installable ISAM" When I import manually Here is the sequence of popup...

Hi All, I have created (for fun/learning) a database for checking lotto numbers against a ticket. I have successfully made this database work by using a large number of queries. But this becomes a pain if I have more games on a ticket as I have to add queries/modify tables/modify code each...

Brilliant Bob!! This is the best forum ever. saved me from a straight jacket. Now go and buy yourself a beer, cheers MickM

Thanks Wayne, Here is a sample. Note I have only set up one combo box so far. Thanks again

Still no luck. Maybe there is a better way. What I am trying to do is have a form with 4 comboboxes which filter the subform on the afterupdate function for 4 of the fields. Therefore, the user can select any combination of values (each box to have an <ALL> option) and the results will display...

Thanks Wayne, but still doing the same. If I open the main form and select any value except <ALL> it works and filters for that value. If I select <ALL>, then no records show.If I then close the main form and reopen it, All the records show. But if I then select a record other than <ALL> nothing...

Hi All, This is driving me nuts!! I have a form with a combo box that populates a subform with data equal to the combo box value. I have added "<ALL>" to the combo box to display all records if selected. The after update code changes the queryDefs. The problem I have is that when "<ALL>" is...