Search results

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?

You might be missing a reference to Microsoft Access 15.0 object Library (or what ever version you are using). In the VBA code window select Tools from the menu then select References and check you have the reference to the above library, then re-compile your database. At the beginning of your...

Cheers, Have a good Christmas, I'm off soon until the new year :)