Thank you Bill and Chris! I have a question :) Using: If Len(txtMyText & vbNullString) = 0 Then... If testing for the NOT NULL condition which is better or...
The <> syntax requires more resources than the = comparison, so I'd imagine the: If Not Len(txtMyText & vbNullString) = 0 Then... syntax is better than the...
Hello All, I am new to this group, but have been working with Access for over 5 years now. I however, have never used any security for any databases I have...
Welcome to our group, John. I strongly suggest you go to our links section and download the Access Security FAQ. It has step-by-step instructions on securing a...
The Access Developers Handbook has a nice security section as well. Chris Mackin www.denverdb.com Denver Database Consulting, LLC ... From: Bill Mosca...
It sounds like your variables are not coming through properly. First things first. Use a variable for your SQL statement. It's easier to debug. Change it to: ...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Mar 2, 2003 4:58 am
3641
I recall working on a project with a guy about 6 months ago who used API calls to populate a table with the person's PC log in everytime they hit a db of his....
Thanks for the advice Bill. I downloaded the document and will review it and implement my security. John Conklin ... Access ... database, all ... isn't ... ...
Chris, Thanks for the advice. I will have to see if I can get a copy of that book, I am sure it will come in handy for other items as well. John Conklin ... ...
Wow, did I get myself in a bind. I've set up multiple tables (with associated forms) as logs for my agency's different activities. I used the Long Date as...
No sweat, big guy! We just need to do some trickery here. First we'll convert the date to a string and format it as mm/dd/yyyy. This will remove the time...
Ok, so far so good. Everything is working great. I do have another question though, they never end! In my medication table I have two date fields. One for the...
Something like this would work, in the after update event of the to company date (assumes a date field): Me.ReOrderDate = Me.ToCompanyDate + 45 Paul ... know ...
Hi All I am considering options on how to best communicate this to the user, and thought I'd ask the question. I have a tbl setup along these lines. Tbl ...
Hi, I've created an access database and rolled it out to a small group of users. To enable me to make changes to the database design, I've copied the database...
The first step you need to take for us to be able to help you is for you to tell us what you are trying to do. Not how, but what. Once we know what you want...
Try: me.txtOrderDate = dateadd("d",45,me.txtStartDate) Also be sure to always name your controls different from the recordset field name they are bound to. ...
It sounds like it's a folder rights issue. You can probably copy files but not delete or overwrite them. Get your network person to give you full rights. ...
Hi, First of all, excuse my bad english, i'm not native speaker. I'm new in this group, and need a little help :). I'm developing a MS Access '97 app wich need...
Hello again, I am trying to automate a date range in 4 queries. I have set up a queary that creates a table with the 'start date' and 'end date'. Then I...
Welcome to our group, Victor. I've done this in the past by storing a low-level "encrypted" password and user id in a table. It's not the most secure way , I...
Is [Range of dates] a form? If it is, your syntax is a little off. Try this: SALES_COMM_ADJ.ADJ_DT) Between Forms![Range of dates]![Start date] And ...
No, it is a table. But thanks for the advice. Is [Range of dates] a form? If it is, your syntax is a little off. Try this: SALES_COMM_ADJ.ADJ_DT) Between...
Hi Dears I would like to asking access professionals I am programmer of ms access and designing and developing for small business program, already i...
Diane Since I don't have the db and can't test this I don't know if it will work or not, but try putting the line: (SALES_COMM_ADJ.ADJ_DT) Between #1/1/2003#...
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.
