Recent content by omnialive

Actually, that helps a lot! Here is where I'm at: if the front desk scans the members card, then we are guaranteed a singleton match. However, if the member doesn't have their member card on them, the front desk can search by name. This might result in multiple records. So, this bring up a...

Not 100% sure I know what you mean by "bound Access.Form", but I do know how to trigger things based on events and when I find a new record. I also know how I can enable/disable certain fields on the form based on current record values. Might be my general ignorance of how Access works with...

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...

To chime in on the "telepathy" bit, some convincing scientific research and evidence has come from a group in Colorado (I believe) where they setup a TV monitor in Room A and a camera in Room B. Now, the TV monitor randomly swapped from showing the picture in Room B and some other benign image...

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...

The problem was that the "umask" SITE command was not supported by my FTP daemon. I did read and found out that the "chmod" SITE command could be enabled and once I did that, everything worked fine with using the "SITE chmod" to change the file perms. My FTPD is vsFTPD which works well enough...

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...

First thing it looks like you are NOT closing the work book, unless I am not understanding what the "xlWB.Close False" line of code is doing. Wouldn't you want that to be "True"? As you can tell, there are stark differences between how you instantiate the object variables and how I did it which...

DJkarl was spot on! I tested it and it works perfectly! Way to go man! You are my hero! I'm not used to application help files (especially MS's) being helpful! ;-) This will allow me to develop the app to run in a batch mode whenever the '/cmd "MODE=BATCH"' is used on the command line! Awesome...

In the book, "Beginning Access 2007 VBA", authored by Denise Gosnell, in Chapter 12, pp 330, she talks about how you can distribute the application with the Access runtime using the "Packaging Wizard" which comes with the Office Access 2007 Developer Extensions installed as part of the Visual...

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...

One thing I had to do is to check for the len of the status text to make sure it wasn't greater than 32767 (max size of integer) as SelStart is an integer!!! Very frustrating as the text box max length is 65535! Here is what I had to change: If (Len(statusfrm.status.Value) < 32767) Then...

Worked like a charm. Only thing I had to add was a "SetFocus" because it didn't like me using the SelStart without it. Two lines of code fixed my problem: statusfrm.status.SetFocus statusfrm.status.SelStart = Len(statusfrm.status.Value) I knew I had to reverse how I was appending info to the...

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]...