Search results

Right, problem solved. View created to replicate the table except it casts the bigint as a varchar. View now replaces table. Query works fine. Time to go home and have a rest, cheers Minty.

Maybe? In SQL it is linking a varchar to a bigint although Access reports them both as text when looking at design view of the table. I should have mentioned, Access is using linked tables.

Hello Minty. No, its not the date. In the query design window it shows in UK format but in the SQL view (within Access 2010) it shows that way round. The query does get results, the exact same number of lines as the SQL MS version but there is just no data in the Access query for OptionB and...

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

Sorted it. I opened the main form and then used the code builder to get the correct references, this is what I now use: Requery Forms![CallLogMain]![CallLogDetails].Form![Child68].Requery Forms![CallLogMain]![CallLogDetails].Form![Child71].Requery...

Thank you for that link. I have tried using the code but still can't get focus off the subform. Any ideas. Ta

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

I have started doing a database for each ODBC source. It has taken 3 hours for me to link the 741 tables from one source. That means, I have another 10 sources to go in 10 different databases. See my post of amending MSysObjects. That would help me loads. Thanks so far

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.

I appreciate what you say but the database it not going to have any forms or any other objects, just the linked tables. This is needed for my job as I often have to go into the tables from the datasources to check for problems or help with writing Cystal Reports etc. The network traffic is not...

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

Can someone convert it to Access 97 please and then repost it. Thanks

I use this on the On Close event Forms![formnamehere]![subformnamehere].Form![comboboxnamehere].Requery You can remove the ![subformnamehere] part if it doesn't have a subform: Forms![formnamehere]Form![comboboxnamehere].Requery Works fine for me.

Not an answer but are you compiling a database for all the cars in GT4?

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

s'not worked. Is doesn't like the Dim MyOutlook to Dim Dim Subjectline part. Can I have a problem with my references? Ta

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

Private Sub Command0_Click() DoEvents AppActivate "KEA! 420 - FINANCE" - switching to the application SendKeys "{ENTER}", True - pressing enter to go to the first option that is highlighted SendKeys 2 & "{ENTER}", True - goes to option 2 and then enter to open it SendKeys 8 & "{ENTER}", True -...