Recent content by roystreet

My situation that I'm very puzzled about is... I have a project management database which has correspondences as well as projects. I'm trying to Have a way for Correspondence Item be related to Item 2 & 3. I'd also like to have Item also related to Item 4. All of them have a unique Primary...

I think I may have figured out a way to use DLookup to grab the data I needed!

Hello, I have a database that I've used user level security where people inputted a username/password to allow them in. We've upgraded to Access 2013 & I wanted to use simply a users table that uses the their network logon as their username. For instance... The windows network logon on...

Hey strongm --- Do you happen to know a good resource (website) off the top of your head for finding some templates or examples of this routine you speak of? Thanks so much. I've searched some, but haven't found what I was looking for.

Thanks for your help guys, I will try to do what you offered. Yes, Andrzejek, I totally agree with your thoughts.

The location is actually mapped to a drive letter, so it doesn't have to use the FTP method.

Hey Andy, That's what I'm trying to do. Sorry if I didn't explain that very well. OK, let me explain further...I want them to be able to add a "file" to the database. When they select the file they want, it will place a link in the database for the file. Project database. They need to...

Hello, I have projects database that the users need to be able to upload & download types of files, like pdf's & jpg. I have made a database before that allowed you to upload/download files into the database, but that quickly 'bloats' (Makes the database huge) All my users have access to a...

Hello everyone, Thank you so much for the assistance & the detailed information - All of it helps. You gave me extra to chew on & broaden my knowledge (Here comes the experiments) ~roystreet

As I have been testing these things, I haven't yet built the final code for this. I was trying to simplify it for you, but this isn't being effective I guess. "Mod1" isn't the name. My apologies. dhookom = Please elaborate on what you are meaning by not hard coding control names, but would...

Sorry about that...I was just using the word switch as an example in this case, not the actual situation. You may replace that word with any other useful word. Thank you for that information though. ------------------In mod1------------------- public function help(frm as form) if...

I get an error when I try this... compile error: Argument not optional

Whoops I meant mod1 to appear this way: ------------------In mod1------------------- public function help(frm as form) if frm.txtUserInput2 = "button" then call mod1.buttonhelp elseif frm.txtUserInput2 = "switch" then call mod1.switch end if -I change it to frm.txtUserInput2

Hello, The first function is triggered by a call on a form. Once that function is called, then the function on in the mod will check another value located on the form & then direct it to the correct function in the mod. Example: On form, user inputs value "help" in field txtUserInput if...

Hello, I have a function with an if statement. If a certain value is present, then I want this function to call another one in the same module. Is this possible & how? Thanks, ~roystreet