Search results

Ah, that works. Great. Thanks.

As in height = 0?

I have a report with multiple subreports, one below the other. All reports are set to Can Grow/ Shrink which works fine until a report has more lines and runs over the report underneath it. Is there a way to dynamically move the location of each report based on the final size and location of the...

Ah, I think you have hit the proverbial nail. Open with shows options for both 2016 and 365. If I click on the 365 option the database opens normally. If I select the 206 icon, it opens under runtime. Its as simple as the association (and some poor uninstalling by Microsoft and probably my IT...

The extension is accdb. I will try the open with option but I am also thinking there is a registry issue somewhere.

Tried that. Issue persists

I was running Access 2016 and my database front ends were on my desktop in a trusted location. I could click on them and open them in editable format (i.e. not runtime). My office upgraded me to 365 (with Access) and two days later my database front ends are opening only in runtime mode and I...

I am not sure how I go about this. I have contracts which are listed in one table (Contracts). A contract can be affected by different regulations, depending on the industry (lets say Insurance) So, I have a related table (Regulations) on which I want to list the different regulations for each...

Working remotely (like everyone else) I am hardwired to my router and have to use a VPN to log into my database BE. If I go off hardwired and onto WiFi the whole system slows down drastically and is more prone to drops. On a hardwired link with fibre (in South Africa fibre is not so widespread)...

I have developed an access database in Office 2016 and distributed it, partially successfully with 2016 runtimes (issue are security related only). My company is moving to Office 365 over the next few months or maybe longer (16000 employees take a long time to move). I want to move to 365 now...

I thought originally that what you are suggesting would work but when it did not I found J Street Relinker and put that in. I think something on the network in the corporate environment is to blame - possible network shares. J Street works fine though (it is a great piece of code - Thanks...

Thanks for this assurance. You can't be too careful these days but I am happy to trust this community

This is the exe I downloaded but I do not know whether to trust it or not.

I am in a corporate environment but I am not sure my IT will edit registries on my say so. To give this context, I am not an IT person, I am a legal adviser, creating a database that we need to work more efficiently and differently from the usual way legal advisers work - data driven. I relink...

I have tried localappdata and it did not work - I suspect the runtimes don't add it as a trusted location. The next one is Accwiz which I believe the runtimes do create. I didn't know Microsoft had instructions to edit the Registry for trusted locations?

Yes but I am very nervous about editing registry. Never done it before and don't really understand how it works. I have found information that the runtime automatically creates the ACCWIZ folder as a trusted folder so this is the next thing I am going to try. After that it looks like registry...

Unfortunately this is not possible when the user is using runtime files

I have a database split between FE and BE with the BE on a network folder and the FE distributed to users. In distributing to a new user, he needs to link the FE/BE. To date I have VBA code that does the relink and which is initiated by the Autoexec macro. However the new users computer does not...

Great. So I need to tell it which column to look in. Works now. Thanks very much

I cannot see what is wrong with this: vblUpdatedBy = DLookup("[FullName]", "tblAUsers", vblUser) The variable (vblUser) is defined as a String and picks up its value from a function (fOSUser) which give the username. It has this correctly as DKNIGHT (text). The DLookup function is finding the...