Recent content by hortizjr59

Hello txlibertygirl Sorry for the late reply I have been on vacation. I don't understand your question however I will explain how it works: 1st of I can take no credit for the code; just like you I got it from this forum and did need to mod it a little. The way it works is the table...

Understood; Thanks

Got it to work. Thanks for your help. One other question; I used your code with some minor changes however since I am a bit of a novice at this my question concerns the tblestaffAccess. If I am logged in on my computer and select my name from the dropdown it opens the form I selected, if I...

Hello: I reviewed this post and found your sample database to be very useful for me. My questions is: I am using Access 2007 and I notice when I open your application you have Users and Permissions + Replication Options (Administer) on your Database Tools ribbon. I have been trying to...

Yup that did the trick.... Thanks

Dah I should have coaght that. Works great thanks. I have one addtional question you may be able to answer. I have tried to compile my database and I get the error message: "User-Define Type Not Specified. The highlited line is: fso As FileSystemObject Thanks

Thanks for you responce. I do have the correct library referenced in tools reference window. Below is my front end: Set WshNetwork = CreateObject("WScript.Network") GetUser = WshNetwork.UserName Set WshNetwork = Nothing 'Change the LUNmae location below. It's best to use the UNC path and...

I have been using my access 2003 in multi user mode with a VSB front end. The database as worked great for years with no issues. I recently upgraded to access 2007 and noticed the VSB front end no longer works. Is there another solution for using 2007 database in a multi user mode...

Thanks so much; worked great.... How easy was that. :D

I am building a query to give me only records where a check box is checked. I am using a form to have users update records. When the rocord is complete and closed I am having them click the check box. I will use the check box in a report and form that will only show when the record is...

I was wondering if any one could help with the following: I have an access report that is populated from a query I set up. The form I created that populates the record has a command button. When you click the button the record you are updating opens outlook and places the (record) report in...

Thanks for all your help. My next step is to add some security to the database. I saw something on your web-sitethat will help. Have a fun weekend. Hector

Hi Gina: Thanks so much for your help. I resolved my issue. The code below now works, yea. Now when I update the record and I close it with the update my log on the main dash gets update as well. Private Sub Improvement_No_Click() Dim strWhere As String If Me.Dirty Then 'Save any edits...

Good Morning Gina Thanks so much for your help. I understand exactly. My thoughts were that since the data for my form is coming from a query there must be a way for me to update my query before I re-open the main dash form. Then; I think(?) the records should do what I want them to do. I...

You are a genius; it worked but it didn't do what I wanted to happen. My Main Dash form has a log on it that list a records status; when the status changes to Verified it should be removed from the log. I tried a refresh on focus for the main dash form but that didn't work. So I figured if I...