Dear Julie Could I suggest you create a query table whether using vba or a table itself and have *iv* inserted into the code. iv being the unknown veriable. ...
Hi, In my years of developing Access applications, I have managed to get away with manipulating field data through queries and/or one record at a time on a...
Hi Abraham, Do you want to select a treatment facility only if it meets all the criteria? What about partial matches? There are a couple of ways to go in...
No danger in ME being OVEREDUCATED, LOL! I had this happen to me yesterday. I couldn't figure it out either, and I
also couldn't delete the extra _1, _2...
Greetings All, I have a procedure that links a spreadsheet to process the data into the database. The procedure uses a file dialog box that allows the user to...
Hi All, I was wondering if someone could help me. I created a database and for some reason, everytime I print records from the form, the data always shifts...
Hi Bill, Thanks very much for your time.... I downloaded the fixed zip and need to understand some more, please: background: ============= Yes, the form's VBA...
Hi Bill, I looked closer and see how pageup and pagedown got disabled: I went to my original mdb and: 1) enabled the ss# field 2) went to form view 3) pressed...
Hi All, I'm rather new at anything but creating simple forms and databases. My boss has decided that I am the "resident expert" and has asked me to take on a...
Ines As you have seen, printing a form doesn't always work out well. The reason is that forms were never designed to be printed as reports. That print feature...
I'll try to cover both posts below in this one. When you paste an entire event in a form's module, it doesn't always getted linked the the actual event right...
Alan I'm not absolutely sure about this since I have never tried to secure a DB this way, but I believe you can set read-only permissions on the file for a...
Hi, I'm fairly new to Access, been dealing with it mostly as a datasource for web sites and now I'm in need of learning more. I was wondering if I could get...
Alan, Also be sure to make backups before you add security. Even the best of developers take at least 3 tries to get it right with access security :) Neil...
Hi Bill, Thx for the reply... I understand.... now to clarify the problem with a proposed solution a bit more.... 1) for the Form : commented out the Form's...
Yeah, I learned that one REAL fast! Fortunately, I did that yesterday. Unfortunately, I did a day's worth of work before I realized I was the only one who...
Thanks, Bill. I'll go get that article and read it. Sounds like good reading. I'm the only one here today (there's a good and bad side to that), so I should...
Hi, You put in the standard facilities used for treatment, then you separately put in the facilities available at individual hospitals. Then you need to know...
I prepared a sample DB to be uploaded. However, I have no problem with that sample. I will have to investigate it, Thanks anyway Joe ... <myhnews@y...> ... ...
Joe, It seems like the is nothing as good as making a demo for the list....to help you get your head into the problem and understanding it a little better....
Tim, It depends upon where you are in your Access development. I am not familiar with the pre-VBA books, but when you are ready to study VBA I feel the best ...
Tim, The Complete Reference Access 200x by Osborne press is an excellent book that has no code in it, but explains the UI's very well. For VBA I recommend...
What's up with this Error 3159, Not a Valid Bookmark? I've searched & searched the web, but am not finding a solution. The DB I have was working just fine. No...
3159 usually means a corrupt database. Go to http://www.granite.ab.ca/access/corruption/msstuff.htm for some tips on how to repair. Regards, Beth M PS Make a...
Sandra In the scenerio you have, your solution seems to be adequate. Another way would be to list all the keys you don't want to work. That would be the alpha...
Hi everyone. I thought I'd take my turn. On a custom application, you may want to disable the default Access "menu bar" that is at the top of your screen....
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
