Search results

Figured it out. Below where I commented out: DoCmd.OpenReport "rptErrLog" Add DoCmd.OpenReport "rptErrLog", acViewReport per https://stackoverflow.com/questions/17429709/vba-ms-access-open-report-in-report-view

In this case (and in most cases), I am only adding new tables and or new fields to existing tables, but point 100% taken. From what I've found with the test BE - other than getting an error message when you try to run the query b/c the table field already exists, nothing bad happens. Pat's file...

@ebs17 - You somewhat missed the point of @Pat Hartman's database. The idea isn't to create 50 queries and run them and hope for the best. The idea is to create one query, test in in the test backend. Create another query, test in the test backend. And then run ALL the queries in the...

@Pat Hartman - Challenge accepted. I figured out a little bit what is going on. q001 works fine. q002 gives me an error (as expected and designed). The original version of the database just tried to send a file to my local printer. The modified version pops up a msgbox with "No Current...

@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: