Search results

Hello Everyone: Does anyone know of a sample DB or know a way to select a drive (for instance we'll say the C:\) from a DB and it scans for all the documents and their full paths? I'm currently using a wonderful sample DB that will allow me to type/copy-paste a documents path, which I don't...

Hello: I have a DB that has an attachment field used to storge EU agreements. Each record needs to have 1 signed EU agreement attached in order to save the record. Is there a way to have a validation/error handling rule that knows when 1 attachment is made, the save button goes from disabled...

Thank you for replying ghudson, I'm still learning access 2007 so please bear with me. If I understand you correctly, you would like me to setup a new field in my devices table for the username, than create a relationship between the two tables? If this is the case, than what do I need to...

Hello All: I have an issue and I hope that you could assist me. When a user logs into the DB, I would like all the records for the user to be the only ones that he can view/edit. The table name where all of records in question are is called: Devices This table is bound to a query: Devices...

Thanks for your input guys! Darn...ohh well, system beeps it is... Thank you Bob

Bob/Everyone: I'm in love with Bob's FE auto updater. It has made my life so much easier. I just have one question. When opening up the previous version, a window pops up along with a sound advising me to update to the next version. How do I change the sound? I have an access DB with funny...

Hello Everyone: Happy New Year! :) I'm having a problem with my DB and have tried searching this forum as well as google, but I don't quite understand where to start with my specific problem. As the title states I get this error: error 3075 |1 in query expression '|2', this error comes up...

I know that this is a very old thread, but is there a way to easily integrate this into an Access 2007 project? I saw this and my jaw dropped because it's so awesome! This is the kind of security I need. Right now I'm just using a general user name and password setup. I tried importing it into...

Bob: This is fantastic! It works perfectly on both machines! I'm so happy. Again, I can't thank you enough. You're Awesome! Brian

Bob: I followed the web page and it works now. I haven't tested the "environ" part yet, but I have another question. Would making this into a module work better, and then have the hidden form timer call it? Im not sure if I'm asking the right question or not. I just want to make sure that this...

Bob: Ok, let me know more when you can, I don't know how to set a break point...I'm still very new at this. Again, thank you so much for your time. Brian

Bob: Well, importing it into a new container didn't work. I had to remove a lot of stuff from my DB just to upload it, but here it is. It's not pretty. Brian

Bob: The trusted locations was blank, so I added the directories and still nothing. Nothing fires. Brian

On Timer and set the Timer Interval to 1000. Still nothing. I'm using Access 2007 if that helps. Brian

Bob: Im on windows XP. But I have another problem, I can't even get my original code that I started with to fire. I had it load up on a hidden form at startup, it worked before but now it's not, and I can't figure out why. LOL, this is way to complicated for me. Brian

Bob: I just tried to test the code that you provided to me, and it doesn't fire. I have a feeling that it's the computer name isn't right. I looked at the "My Computer" preference and typed it in perfectly. But alas, nothing happens. What is the best way for me to obtain the computer name...

Bob: That's fantastic, I truly thank you for all your help. In regards to the flags, how would I go by setting that up? Is there a place where I can read about it? Or is it pretty simple and you could throw me a sample? Thank you again: Brian

Bob: Here's my code: Private Sub Form_Timer() If Environ("computername") = "WALSH-BMOORE" Then If Date = DateSerial(Year(Date), Month(Date), 1) And Format(Now(), "hh:mm:ss") = "10:00:00" Then DoCmd.RunMacro "Daily Project Tracker" End If End Sub I'm getting this error...

Bob: Is there a way that with this code that only one computer could email this report? I have a front end that does this, but when I get ready to deploy it, I don't want all of the FE's to be sending the same email. I've seen here somewhere that you could implement a code to verify a...

jdraw: No I couldn't figure out his method. What we do here is prep hundreds of cell phones and laptops for our customers. When we are ready for deployment, we bar code scan all data into access. However, to reduce the amount of actual clicks, we would like to use defaults to control the...