Search results

Hey guys! Been a while, I know! I have a peculiar need. What I am wanting is to be able to build dynamic form content/elements based on entries on a table. This is for a gym membership system. What this form is going to be used for is to allow the front desk to scan a membership card which then...

I have found how to check if the database was opened in Shared mode and exit the application if so. I've found lots of things, but not what I am looking for. I need to be able to check via VBA if someone else has the database open and if possible, what they have open/locked. How would I do...

Quick background: I've developed a solution for the company I work for that populates a MS Access database based off of the build done in a multiple worksheet Excel file. This data is then used to create files that are used to rapidly populate a clinical system via an HL7 interface. I've had...

SOLVED: WININET.DLL FtpCommand Issues All, I have a working class and set of functions that I use to send and receive files to an FTP server with no problem. Currently, I am trying to add the functionality to issue a "SITE" command to the FTP server so I can change the umask of the files that...

SOLVED: Is there a way to check MSACCESS.EXE cmd line arguments? I am very new still to window's programming. Working with MS Access and VBA has been my first venture so far. How my code currently works, is that a user will double-click on the application.accdb file, which launches the full...

What I have is a form, ProcessStatusWindow, that has a text box, status, with vertical scrollbar enabled. As my application does its work, it puts updates to the status text box using this method: Global statusfrm As [Form_Process Status Dialog] Set statusfrm = New [Form_Process Status Dialog]...

I had struggled long and hard with finding a way to properly close out the EXCEL.EXE processes that were being "orphaned" when my function would finish its business. I had done all of the "XlApp.Quit" and "set XlApp = Nothing" and it still wasn't working. I finally found out an answer that...

Firstly, I have minimal previous experience with Access but year of experience with SQL, databases and the like (former Informix DBA and Unix Sys Admin). I have an INSERT query that I use to grab data from a table and concatenate it together to create a specific string and store that string...