Search results for query: *

I have completed an Access application and after updates to a table, I need to send table via cmdSEND to an A\: drive as a text file. No delimiters or separators are necessary. In fact, delimiters are not desired just straight data. Anyone have VBA code to accomplish this? Thanks in advance, Danny

Thanks all very much. Excellent suggestions and a great forum. I decided to use GingerR's code (Cut&Paste) and it worked great. I only added 'text box clear' statements at very end so that the text boxes would be blank after a successful login. Thanks GingerR and all Tigerdude

I have almost completed this simple, semi-secure login screen. I have tblPassword with id, UserID and Pword fields. I have basic login screen with two text boxes and one command button. All works well except the UserID input has to match the UserID field perfectly or I get an Access error...

I've been following with great interest your threads on access security. I've tried all of your responses and the ones I've started also. I think we are trying to achieve the same results. Try this thread:http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/705/qid/160349. (Sorry,it is the...

Thanks Lonnie, I appreciate your time and efforts. danmci43@hotmail.com

After updating the database/table, I want to send the table (via command button) to a disk drive so that it can be emailed etc. I know Access will send to print and/or Excel but can you send table to file? Thanks

Thanks, that did it. amazing how one simple clue... I'll take you up on the white paper for future reference. Thank you again for your time and advice. email: danmci43@hotmail.com

Sorry,I must be leaving out a step or maybe I need a step by step. When I attempt to use Access security, I can't get the login screen to come up. I open the current database, then attempt to set users and passwords, then close database. When I reopen, no login screen. Any other suggestions? Thanks

I have created an Access application containing information about students at a local school. I need to create a login/password screen so that only "need-to-know" people can start the application. Can anyone offer a starting point. It can be simple and it does not have to be super...

Below is the code I'm working with. If there are no students that meet the criteria, then I get a Null value; however going forward I need a 0. SELECT tblPopulatedStudents.EthnicityCD, tblPopulatedStudents.PartCD, Count(tblPopulatedStudents.EthnicityCD) AS HawPac FROM tblPopulatedStudents...

I am creating a query that counts records based on different criteria(Compound statements in SQL). As long as there is a record of desired type, all is well. However if there are no records that match, then query returns null.This does not help when creating other queries and reports. (I need...