Search results

  1. R

    Trsuted Locations & Autoexec

    Managed to get past this problem. As it turns out even though full version was installed it was still trying to open via the vApp. Once vApp was uninstalled, I then set Default program to the new full install Access .exe. Moral of the story, stay away from the MS Access virtualised client.
  2. R

    Trsuted Locations & Autoexec

    Its each and every time Minty, with the same copy of the FE on the Public Desktop folder. Public Desktop and the network share with the back end are added in the Trusted Locations
  3. R

    Trsuted Locations & Autoexec

    hi folks, its been a while since I posted, mainly as my organisation is trying to move away from MS access applications. Anyway, here's my problem, I tried to deploy and Access database to a number of machines. these machines didn't have Access installed, but rather a virtualised client. The...
  4. R

    Business Objects universe

    HI all been a while seen Ive been on, mainly cos Ive moved away from Access. Anyway, onto the problem at hand, Ive been sent an .unv file to upload to our BOXI server. Now Ive been doing a bit of digging on the web but most searches that are being returned are about importing excel documents...
  5. R

    PEDMAS / BODMAS rule

    I certainly remember BODMAS, also applying brackets where there are none to denote doing the divisions multiplications and before additions and subtractions ie 4 + (4x2) + 3 + (3x4)
  6. R

    M2M / Master Child Form Design

    A subform links to the master not another subform, unless the second subform is the child of the first subform
  7. R

    Splitting database

    by drop down tables do you mean lookup's via a combo box? If so, you could make the source of the combo box a select query (using distinct so that you dont have repeating values) rather than an actual table. Theres load of examples on the forum, try a search
  8. R

    Friday Homework 3

    The Monty Hall problem!
  9. R

    How to make filled form from first form

    first off, demanding help is not going to assist your problem, secondly the aim of the forum is to educate as much as help. Look into an update/append query!
  10. R

    Permissions broken moving from 2003 to 2010, Help?

    sounds like your problem lies with active directory/server permissions rather than MS access
  11. R

    Its Friday again so :Homework for an 18 ish year old.

    2% maybe its just me but the wording looks like its meant to have you doing a lot of calculating when the answer is already there
  12. R

    2 front ends and one table structure

    you would need to have your tables on the share point server,as for log in etc, you could take care of that via Share point (permissions) and still have your Access FE on your desktop with whatever forms you wanted, you only need to publish certain forms on SP ie for booking!
  13. R

    2 front ends and one table structure

    I dont think that its cheap. Plus you have to weigh up the other problems you might encounter if you go down that route, for example, to allow external access to a Share point server within your network would mean allowing http traffic through the firewall for example, meaning the firewall would...
  14. R

    2 front ends and one table structure

    If you have a sharepoint server then thats the way to go, but I would refrain from ever just having the system on your desktop, unless your PC is backed up nightly, even then your creating a security hole into your PC
  15. R

    2 front ends and one table structure

    depends what you mean by online (ie available via www or just networked) put the backend on a server/network share which is more likely to be backed up than your desktop, plus if you have the backend on your desktop, it will only be available when your PC in on, plus there's permissions to...
  16. R

    Access database from mobile phone/tablet?

    http://www.access-programmers.co.uk/forums/showthread.php?t=235205
  17. R

    How to import JPG format picture size into ACCESS individual input cells

    you need to read in the metadata from the jpeg try this https://groups.google.com/forum/#!msg/comp.databases.ms-access/f7KDJNYNVgw/ZOKbUSd3KrcJ I would think you would need to read in the attributes (and amend the code accordingly) and the parse the result into the text boxes
  18. R

    Seeking comments/opinions on TV shows

    Dont know if you guys in the US/OZ etc get "An Idiot Abroad", but I did find that hilarious
  19. R

    Seeking comments/opinions on TV shows

    there are some good series out there, Game of Thrones, Breaking Bad and Vikings to name but a few in terms of good comedies however, there isn't much to go on
  20. R

    Question Converting Macro to VBA

    have you tried a simple If statement If Top20Site = True then me.ControlName.backcolor = vbWhite Else me.ControlName.backcolor = vbYellow end if on a side note. keep spaces out of your object and control names
Back
Top Bottom