Search results

Hello all. Just noticed I haven't posted in here since 2006, I was amazed I could still log in! I have a query which uses the same table 3 times, the aliases all appear ok and if I run it via SQL Management Studio, I get the expected results. The code is as below: SELECT...

Good afternoon (well, it is here in the UK) We have just changed from Access 97 to 2000 (only 6 years behind) and I use a database that has this piece of code running: Private Sub DateOfAction_AfterUpdate() DoCmd.Requery Forms![CallLogMain]![CallLogDetails]![Child68].Requery...

Well, the title says it all. Is it possible to amend this hidden table? It is for my ODBC links, I would like to amend (enmass) where it is linked to and the table name. If I could amend this table, it would only take seconds.

Hello fellow users, I am the admistrator of a finance system. The tables all sit on Oracle and I can happily link them into my Access 97 database using the external data option. 2 problems though. 1 - Each datasource has around 70 tables and there are 11 different datasources I need to link to...

Hello. When linking a table via ODBC I usually get asked to pick a field that contains unique values. This is all very well but I have hundreds of tables to link to across a slow network and would like to leave it running for a few hours. With the current set up, this is not possible and I...

Hello again, Anyone know why this condition in a macro doesn't work: :confused: DCount("[TESTqryPaymentRun]","STATUS") = 0 TESTqryPaymentRun is my query and STATUS is the field I want to count. What is supposed to happen is if the count of records is 0 then a form is displayed. At the...

Hello all, I have a database that automatically sends out emails. This has been working fine until today when I get an error: Compile Error User-defined type not defined The code being used is (not written by me): Public Sub Send(ByVal Email As String, ByVal Subject As String, ByVal htmlbody...

Is there any other way to refer to the NUM LOCK and END key in the sendkeys statement? I have tried using {NUM LOCK} and {END} but it is not doing what I want (NUM LOCK needs to act like a shift key and END brings up a menu in the application is it using. I have seen references such as PF1 and...

I am using Access 97 and a windows based program. I want to automate some input in to the program using sendkeys which works fine until it comes to a certain part. You have to press NUM LOCK to toogle a mode (like shift), then END (to display a menu) and then UP twice (to get the the option...