Search results

StrTable value is Tbl_Version what I'm trying to do is check if the Linked table exists i.e. has the back end moved then depending on the result re-link it of just go on and do what it needs to do. At the point of failure the BE has been moved so I'm testing the link procedure many thanks Cliff

Sorry the line that starts VarRet =CurrentDb

Hi All I'm trying to get access to link to the Back End tables, no problems there..usually StrTable is a passed table name ("Tbl_Version") I've set a variable VarRet as Variant and I'm using VarRet = CurrentDb.TableDefs(StrTable).Fields(0).Name If Err <> 0 Then CheckLinks = False Else...

Nice solution, maybe a batch file the copies FE then opens it as well as the checks

The BE is already referenced like that as all the users have the BE server mapped as something different anything between F:\ through to Z:\ :rolleyes: thanks again

Hi CJ Great, clear advice as usual Hopefully one day I can help someone too many thanks Cliff

Thanks Doc We have corporate licensing or Enterprise not sure which but I can check that. All other users will have run time versions on their machines. I was thinking they would have a FE copy installed on their PC but it looks like the ones who need it will have a Citrix account. We have...

Hi CJ you said this in your answer I have found out that our company has Citrix Receiver :banghead: and from my research there is a module within Citrix that allows users to import their databases directly to Citirx. This would stop a lot of my boss's reservations about using my DB as it...

Hi Lightwave thank you for the link. I've been going through the whole site and getting tonnes of info for my boss. many thanks Cliff

Hi CJ thanks for the insight Cliff

Hi all Has anyone had any dealing with Azure and connecting to tables. I'm trying to research ways of connecting my database backend to people in both the UK and USA any ideas or guidance would be gratefully received. Some have said a mixture of VPN and Citrix/Terminal Server, but on the...

Thankfully the Boss has put a stop to that

Hi isladogs yes I've downloaded the theme manager and it is very good, I've changed one of them for the corporate default so I can revert the db back. Cliff

:D:D:D what a wonderfully wicked idea...

Hi MajP that looks brilliant, I will bury it in my DB then uncover it when needed :D

Hi All Update of the colour changing forms. My boss was over here for a few days and asked my how it was going, when we are going to roll it out etc. He wasn't best pleased that I was "Wasting your goddam time doing this h****s**t" (he is American BTW) so that has been shelved. I really have...

Cheers Uncle don't think the boss will want me paying for something like that but good call

Cheers isladogs great little colour changer. I've just got to alter it a little so that when a user changes the setting it is saved for that user only and everyone else who feels the need to change the default setting...that reminds me need a default button on there somewhere Cliff

Hello everyone, I'm quite advanced with writing my Technical Support database, so far that we are about to roll it out to users in the States (using a mixture of VPN, form timing and other things my IT bod has helped with). It has been well received but now one of the test users has said...

Have you tried to do this in an Append query to see if it works correctly?