Search results

@Pat Hartman - But this was Jet/Ace ... (Good to know, though ...) The main issue here was I was getting a "No current record" error message, rather than "Field Already Exists". I modified your file to work with 64-bit, allow selection of the backend, and use a default BE location on startup...

@jdraw - Thanks! (That didn't work, but I figured out the error from it). Some of those columns were already in my table, they just weren't being used on the form, so I thought they were missing. So the DDL was trying to add a column that was already there and it didn't like that. Thank you...

I'm back with good news/bad news ... Good - @jdraw 's suggestion with using Notepad++ with the Pretty Print extension was great. I've found it easier to Ctrl-A, Ctrl-X my code in the Access DM editor, Ctrl-V into Notepad++, make my corrections, Ctrl-A,Ctrl-C in Notepad++ and Ctrl-V back into...

Posting a demo database. Two things I noticed, but I'm not sure if they cause the problem. In some cases, my FooterBanner rectangle kept the form width, so, if my form was 16.5-inches wide, the FooterBanner would increase to 16.5-inches, and a later form, which would have been 15.8 inches, would...

Also - Reply #43 is incorrect, but I don't understand what is happening. One of the form's works the way I want - the navigation panel seems to take up the entire screen regardless of what the size of the window is. My other forms, which are not the same size, have the gap on the right if the...

This doesn't work either - and seems to leave the same amount of blank space: Me.FooterBanner.left = 0 Me.FooterBanner.Width = (Me.InsideWidth / 2) - (1.525 * 1440) Me.zz_frmNavButtons.left = (Me.InsideWidth / 2) - (1.525 * 1440) Me.zz_frmNavButtons.Width = (Me.InsideWidth / 2) +...

Made a slight change to the form and can't get it quite working correctly. I wanted the navigation indicators centered in the bottom of the form. I backed out the 6-inches of spacing on the left and set the form width to 3.05 inches. Then I added this code, which is working (in Form Open, but...

Marked as Solved since I'm satisfied with how it is working. Thanks to all!

https://www.access-programmers.co.uk/forums/threads/how-to-get-the-path-to-either-the-frontend-or-the-backend.221663/ I think I need to keep one of the tables linked, or the above won't work - however, I have a tbl that we will be getting rid of, so I can use that and just keep that table in...

@arnelgp - Nicely done! - but it doesn't work exactly correct for me. If I open the file and click Form1, the database vanishes - it seems to be open - I have .laccdb files on both the FE and the BE, but nothing is visible. If I open the file and open Module1 and then open Form1, it works correctly.

Current status - Moved the width setting to Form Open code, added 6-inches of space before the nav form. Is not centered and still gives a gap if I open full-screen and size down, but works fine if I open the form sized down or if I open maximized. Maximized: Reduced down and scrolled left...

Somewhat solved - If I put the following code in Form Resize, it fixes the gap: Me.zz_frmNavButtons.Width = Me.InsideWidth Does NOT work if I resize the form, but works if I open it with Access sized down or with Access Maximized. I might move it to Form Current of some other procedure. I...

At least preliminarily, removing the linked table breaks the FE - I get an error when I try to open the respective form.

More updates - I think this will be simple ... First off, I tried adding Me.Move Me.WindowLeft and the API call to my subform in the Enable/Disable Buttons() subroutine, which is called from the FormCurrent() procedure of my main form. It doesn't work. There is a glitch where when I disabled...

Getting there!!! I already distribute as an .accde. I have a production and a development BE and I switch between them often. I was using the linked table as the recordsource for the form. I recently changed that to use a SELECT from tablename SQL statement. Are you saying that if I use...

Forgot the attachment:

Follow-up - I did read the article. My main concern is preventing direct access to the tables. The article mentions setting them as hidden, but anyone can show hidden objects and see them. Is there a better step to prevent this?

I have code in my database autoexec that is supposed to disable the Shift Key Bypass UNLESS the database is opened from my development folder. I am getting ready to release a new update to the database (.accde) file, and I realized that I forgot to set some of the tables to hidden in this view...

I'm going to live with the two line scroll bar. I did see how the ActiveX scrollbar is supposed to work, but it's somewhat glitchy. Attached file opens, but might not be correct. I just changed everything that wouldn't open to PtrSafe and commented out anything that gave me a type mismatch...

No change putting the slider in the footer. Still flashes and doesn't do anything - but the idea is promising. I made a mistake earlier. I shouldn't have inserted the navigation subform in the footer and made the space for it the width of the form. I should have put it in the form at it's...