Search results

Hi Christy, If I understand the problem, you have a table with 10 program names (Say "Prog??, where ?? = 01, 02,...,10) and for each program, another field (call it "Compl??", where ?? = 01, 02,...,10) containing "Yes" or "No" depending on whether the person has completed the program. Now you...

Scott, I'm not sure I understand your question, but I will say when I had this thing going it was in a VBA environment, i.e., I was not using a Visual Basic separate from what comes with the Access 2K Developer Edition. Good luck! Jim

Scott, Sorry - lost my head there. I had recently solved the opposite problem - uploading a file into a database using an ASP page. And as you correctly point out, that's not what you're trying to do. :rolleyes: Actually I was eventually able to get the MS Internet Transfer Control to work...

You might have a look at http://developerfusion.com/show/233/ or http://www.codeproject.com/asp/downloader.asp?print=true Jim

Kent, If you have devised a way to let multiple users access your database, then you should have a way to recognize then a new user tries to login. The code I published would go in your procedure for registering new users. I don't know your level of comfort with VBA coding, but you certainly...

Here's some code that will tell you who your logged on users are by logonID and by workstationID. You could put all your users into a table with a "Seen" column, initially False, that you set to True when someone logs on. That would avoid bugging people who'd seen it, but it would hang around...

I'm reposting the demo database I sent a couple of posts above - think it works as it should now. From looking Dave's, it appears that we have taken a slightly different tack, but both seem to be workable, far as I can see. I think the distinctive feature in my approach is that if the back-end...

I'm attaching a 77KB zipped database that has (I think) all the code for linking and delinking tables, and for setting and checking a new back-end data file location. I extracted it from our production system, and unfortunately it doesn't quite work "out of the box". (It "Works" if frmGreeting...

Dave, In addition to my related coments at http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=143034#post143034, I might say that later versions often have bigger and better ideas than earlier versions, so it's maybe a good idea to have code in your front-end system that...

Hi Dave, The back end contains only the tables the user could modify, not all the tables. The database is a "commercial" product for organizations to do a self-assessment of the "in progress" American regulations regarding the privacy and security of medical records (see...

Sorry, I can't see that you have actually removed a text box control, only changed its locked/enabled status. Can't you just look at the locked/enabled state to see if it's "removed"? Maybe I'm missing something fundamental.

Ah - two weeks old certainly ought to be able to power down. I'm really getting in over my head now. You might check the Start>Shut Down... choices to see if ShutDown is one of the choices. If it is, I can't explain why your code didn't work. If ShutDown is not a choice in the Shut Down dialog...

Could be your NT supports it but your hardware does not.

Do you mean check if there is data in the control? Presumably the controls will always be there. If you're trying to see of there's data in a control you can use either If IsNull(Me.txtQuantity1) then 'Check for Null value ... or If Nz(Me.txtQuantity1,"") = "" then 'Check for Null or...

See http://www.mvps.org/access/api/api0016.htm. I notice that the value "1" causes a shutdown, "if possible". Perhaps your machine can't be programmatically shut down.

Guess I need to "fess up". One of the linked tables was being used as a recordsource to an open form, so even though I delinked the form, Access knew(?) thought(?) the table was still apt to be changed, so kept the .ldb file around. Turns out the form only needed one value from the linked table...

If your list is huge, consider having your main form include an alphabet where users select a letter, and have a continuous-form subform that only displays names beginning with the the selected letter. This might be kind of a challenging programming task, but there're probably examples out on...

Anna, If the focus is on the command button, pressing Enter will be the same as clicking it (unless you have done something strange with the OnKey[something] event for the button). Open the form, click anywhere in the section (header, detail, or footer) containing the button, then press Tab...

Perhaps this article will be helpful: http://www.mvps.org/access/datetime/date0009.htm -Jim

I suggest you look at having your form open in "Continuous Forms" mode if you are trying to show a form with all the employees in, say, a query. With the Properties window open, look on the Format tab, Default View. On the form, put the check box and maybe the employee name beside each other...