Search results

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

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

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

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

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