Search results

Right clicked on the .accdb file and selected Create Shortcut(desktop)...

I have installed a copy of the Front End for my 'split' database on a brand new Windows 10 laptop connected to our LAN. After I have run it for the first time, I note a record locking file remains and the operating system will not let me physically delete it : saying that Access is still using...

Thanks for the your feedback, not quite what I had expected nor hoped for as a 'quick-fix'...

Having recently split my 80MB database into a front and back end parts ... if i were to host the 'back end' (tables) in the cloud .. what is required to enable connectivity to the _BE from the 'front-end' client interface ? Are there any perceived issues running across the internet in this...

OK - my mistake I had the code to hide in the Report Footer format event and not the Report Header event ... now working fine! Thanks for your help

Default view for Report is Print Preview and I am viewing in Print Preview mode. I have removed the Report prefix but the problem persists....

I have used this code to test... If (Report.Page = Report.Pages) Then Me.PageHeaderSection.Visible = False End If I have stepped through in the code and this property is set to False, but when the report displays, its still there.. any ideas..?

Thanks - would the page increment / checking code go in the Report_footer Format event..?

I have generated an Access report that I am proposing to have hosted as PDF file on a website for clients to download... (so it is not being dynamically generated by Access). The last page of the report I want to include some notes on use of the information on the preeceding pages... I guess the...

... perhaps my margin setting on the left wasnt sufficient.. just increased it to 30mm and it looks better!

.. do that and I lose the margin despite on the left despite the settings shown (attached)...

... there is none.. (see attached).... I have 'select'(ed) all fields to show the only cells / fields on the report...

I have several fields on a report that (in Design View) are positioned a couple of inches from the left hand side of the report. However, when the report is previewed the alternate row colour shows beyond the full width of the row which looks odd against the row above/below that has no...

That works a treat - thank you!

So have I ... but if I am working on the front end in 'design' mode having access to everything from the Navigation view I want a quick way to action the form...

I have a database comprising many forms/reports/queries etc. and to run the Switchboard I have to navigate each time into the Forms group, find the Switchboard form and run it... Am I able to add a button onto the Ribbon to action opening of this particular form...? Im sure its possible but...

I have a split DB with the back end database on the server and the front end database on the client machine. The client connects to the server at another site via VPN... Is it possible to link tables to the back end in the normal manner...or are there other considerations for this to work...

I am using Access Runtime on some terminals, is there any reason why some of the reports are failing to display correctly...? They were displaying correctly prior to splitting the database..... ?

Great thanks. "Thanks all for your help"

Is it possible to reverse the 'Split'ing of a database back to a single instance of the DB file...? How would one go about doing that ? .. preume that would be a manual process... Simply take a copy of the _fe file and import a copy of all the tables from the _be file..?