Search results

Hmm. That is an interesting option. It has promise. I will try tomorrow.

Hello all, I use Call Shell("C:/plink.exe databasessh -l ****** -pw *******" to open an ssh connection to a remote server when my DB is opened. Is there a way to kill that command or kill the shell or kill cmd or whatever when I exit the database? I can't see any documentation of a Shell kill...

Solution For those who are interested- The main problem stems from the on_current event of a form. It is not a specific problem but so far it appears to be related to Function Calls. It is not all function calls, and I haven't found a unique element yet, but certain function calls cause the...

Sorry about the 2000 format thing. Must have missed that. I will redo the form. So sad. I wonder how far I can get with copy and paste. Thanks guys. I will let you know if it works.

Sorry. Here is another db that is compiled with no errors. The main form opens. There is a square with 3 dots next to 'Contact'. Click that. This opens the problem form. You will see a checkbox with the label of Check104. Type something on the form and notice that the checkbox does not get...

Ok. This is ridiculous. It works exactly as needed. I made a new db with 1 form and 1 table with the same thing and it worked. Now, why doesn't my real form work? Is it corruption? Is there a possibility for a weird setting that I am unaware of? I am going mildly insane here.

I can't get the on_dirty event to call at all. I type in a field and my checkbox isn't checked and my message box doesn't message. I feel like a fool with all of this. The problem with the afterupdate only being called when I change a record is that I want it called when the form is closed. I...

The field does not need to be bound because it just needs to be true when the user clicks the close button. I don't want the record to remember that it has been updated. This is going to be used as a way to log if a record has been changed. So if afterupdate is called after you move off a...

Here is a small portion of my db with only a few non-important records. I have the test form I made as well as the problem form (frmContacts). If there is a way to delete this attachment once it has been looked at that would be great. If not, so be it.

Okay. So I imported it into a new mdb file and that did nothing. I made a new form that is bound to a table and put on an unbound check box and I did me.check3 = -1 on both on dirty and on update events and nothing happened when I typed. HOWEVER, when I used the record selectors at the bottom of...

The checkbox is not bound to anything. It is used as a debugging thing. The afterupdate event gets called when I click the Close button and the checkbox becomes true, then the form closes. Corrupt form? It works well in all other regards. How could it be corrupt?

Here is the oddity. I tried setting a checkbox to true on the ondirty and beforeupdate and afterupdate but the checkbox would never update. I would enter something into a field, exit the field and the checkbox remains false. Does it matter if MySQL is the backend?

I have a form. On this form is a field that I want to update when the user changes a field on the form (a sort of tracking feature). I can't get the on update event to run when I change a record. The only time it runs is when I click the Close button. This is no good because you can open the...

I have a ruby script that does some stuff that I need to get done. (sorry for the vagueness). To get it to work flawlessly, I need to pass it the 'SampleID' for the record that a user is currently on. This brings in 2 questions. 1) How can I call this script? (current plan of attack is calling a...

FE/BE all users have their own copy. Regular backups are being made. In fact, I made a little script that kicks everyone off the database during backups to see if that would help the situation. We are getting less corrupt records but this error prevails. I am planning to move to a MySQL BE soon...

I have a form bound to a table. The table has 73,000 records and has been working mostly well for years. Lately (after a recent switch of fileservers) when someone adds a new record it will either take the first record in the table and put that info into the new record, or it will take the info...

Given Up Ok. So I've given up on that idea but only because I discovered Snarl. This is a customizable messaging service for windows that works with VB. It is based on Growl for Mac. It solved all my problems. I would still like an answer as to why I couldn't change the popup value, but I also...

I have a form that will quit Access at a certain time so that A backup script can run and maintenance can be performed. The form uses the timer event and displays a countdown in 10 second increments (the timer increment). I want the user to be able to finish whatever work they are working on and...

One question. Would the corruption occur in the .mdb and .ldb that is being copied onto the external media, or would the corruption occur in the file that users are currently connected to. It seems like it shouldn't make a difference if the system is just reading the file (it is on a unix...

Wow. That is just what I needed to know. I am going to have to rethink the backup scheme and maybe force the app to close before I make a copy. Good to know. I do have a copy of the FE in the same folder as the BE for backup purposes so at least that is going well. Our offsite storage is 20...