Search results

Tested the following code and both seem to work splendidly! Will start implementing this for my other form(s). Thank you! ' Improved version of the PDF button Private Sub cmdPO_PDF_Click() 'TESTING 1/8/2021 DoCmd.OpenReport "PurchaseOrdersReport", acViewReport, ""...

Hello The_Doc_Man, Thanks for the reply! I'll certainly give that a try tomorrow and post my progress. Here's what Access gave me when I clicked that convert button. Private Sub cmdPDF_Click() On Error GoTo cmdPDF_Click_Err ' _AXL:<?xml version="1.0" encoding="UTF-16" standalone="no"?>...

Well, thank you for replying to my question, but you didn't really address all of it. Out of interest, I clicked the convert macros to VBA button to see what those would look like. Interesting anyway.

Hello all and Happy New Year! In the database I built in 2019, I created macros for the two main forms to 1) save current record as PDF or 2) print current record. I know there's that button that will convert a form's macros to VBA, but I don't want all of them converted. Here's screenshots of...

I decided not to change it after all. Any changes I make to the tables, I close the FE and open the BE with exclusive rights (or whatever it's called). Save the changes, close the BE. Open the FE and use the Linked Table Manager to refresh the tables (just in case).

Both the FE and BE are Access (accdb).

Got it! Thanks!

@pbaldy @Isaac So it's as easy as refreshing linked tables for the changes to go all the way through to the form controls?

Hello, I tried searching the forums, but unfortunately I don't think I have the right terminology for it. In the past when I've changed a field on a linked table, like long int to decimal, or short text from 255 to 30, or added a validation rule, etc., I've had to delete the corresponding text...

As it turns out, the external IT department does daily backups of the server. So, I guess this thread is solved? Thank you to Dbguy and arnelgp for replying!

Sounds good! Is this something I can set on one machine (which is connected to a shared network) without having to install on others? Can it be used to backup to something like a flash drive?

Hello, it's me again. Sorry :LOL: There's a few things I want to ask about, but I suppose this topic will be first. I searched for my topic on these forums, but didn't find anything. If I missed a thread, please point it out. Thanks to theDBguy, I added a button on my database's main menu (on...

Created a batch file on the server and sent it as a shortcut to my desktop to test it out. I had to change a few things: md C:\Access del "C:\Access\SERCOM Database_FrontEnd.accdb" copy "\\<path>\SERCOM Database_FrontEnd.accdb" C:\Access start msaccess "C:\Access\SERCOM Database_FrontEnd.accdb"...

Unfortunately, you are correct. How I used batch files in Skyrim and how they work eludes me. All I ever do is type "bat <filename>" in the console and it does what I coded it to do. 😫 Okay. So I'll have to delete the FE's that are their desktops and give them a shortcut on their desktop, for...

Cool! Two questions. 1) Do I have to make a new directory? I figure mine would be: del C:\Users\<User>\Desktop\database.accdb copy "\\<ServerName>\...Path...\frontend.accdb" C:\Users\<User>\Desktop\ 2) Why is "c:\DwgLog\DrawingLog.accdb" on the last line? Since you already have "c:\DwgLog" on...

I'm familiar with Linux commands (not all, but some), so I'm guessing this is done in a command line for a Windows machine? I've messed with batch files using console commands in Skyrim, but never anything else. But this is interesting! I don't have access to the other users' machines because...

Yeah. The BE is currently on the shared server and each user, including myself, has a copy of the FE on their own desktop. There's a "master copy" of the FE on the server where I import changes made from my desktop FE. Then I copy&replace their desktop FE with the updated "master copy" FE. If...

That's a great idea! I'm building a case for why I think certain fields should have requirements, validations, etc. and see what they'll say. Unfortunately, I'd have to take down the database to make those changes and they're never happy when I do that.

For sure! At least I won't be with them forever and the next person can sort that mess, mercy on their soul. Thanks again for the help!

I tried to make many fields require a value (notnull), no zero length strings, validation rules/texts, but they didn't want any. Tried to delete fields that are rarely or never used. They already have a system that generates "official" orders, another for invoice/billing, and something called...