Recent content by TheTomCat

Soryy....here is the complete code. Private Sub PrntTimeSheet_Click() If OTTotal < 0 Then Report_r_TimeSheet.OTTotal.Visible = False Report_r_TimeSheet.RegularHours.Visible = False Report_r_TimeSheet.OtherRegular2.Visible = True Else If OTTotal > 0 Then Report_r_TimeSheet.OtherRegular2.Visible...

I am working on a Time Sheet (r_TimeSheet). If an employee has overtime (time and a half), I want it to print the Overtime total (OTTotal), and any extra regular hours. I have that working fine. The problem is when you come up with Negative overtime. Then I want it to NOT print the Negative...

You need to Create a Filter Query: Create a New Query with the Table you are working from. Add the Table to the Query. Click on the * at the top of the Table and put it in the First Field Line. In the second Field line, add your ID# from your Table. Then in the Criteria line (Under the ID#)...

The best way would be for you to first; Disable the shift bypass key. You could enable from a command button on your switchboard. Second, you could set a password in a Module design's Tools\Properties. Third, you could make the application an .mde file. For distribution I would definitely...

lameid is definitely correct. I distribute my application as an .mde a,long with a couple of other protections. I would not do it any other way. If not an .mde, anyone can get to the code and password. My way, the Shift Key is Disabled unless you know the correct password to enter in the...

First, make a backup of your database just in case something goes wrong. Create a new Module. You can name the Module anything you want. Mine is just named ByPass. Place the following in the Module: Public Function SetProperties(strPropName As String, varPropType As Variant, varPropValue As...

I enable my ShiftByPass key with a Command button on the Main Switchboard. Just click on it, enter a password, then close and re-open with the shift key held down. I can supply the code, etc. if this is what you want. Thomas Bailey a/k/a TomCat

Mr2006, Do you still need the Shift ByPass information along with a way to enable it? Thomas Bailey a/k/a TomCat

First, with Access 2007 you can now get the Developer tools for Free. Juts download it from Microsoft.com. You can then also download the Access 2007 Runtime for Free. As far as protecting your database: The .mde is definitely a good idea. You can also set a password in the Tools\Properties...

There numerous ways you can protect a database. I have mine protected at least four (4) different ways. First, you should definitely consider Spliiting your database. Then with the Front End you could disable the Shift ByPass. On mine I have a command button that you have to enter the correct...

There is also a way to change the shapes and/or colors of command buttons. I cannot remember the site off hand. Will look for it and Post back. Thomas Bailey a/k/a TomCat

Nim180 You are THE MAN. I have it working perfectly. It is even better than I was hoping for. I went back and amde the text box invisible again and it seems to still work fine. I also edited the Command Button code so that it will open straight to the folder on my Server that stores the...

Nim180 I finally got it working. I typed in the path to my server and also typed in the picture number. Now I have the photos showing in my form, for each record, and they are saved elsewhere. Great. Now, as I mentioned in my earlier response to you, do you know of any easy way to add the...

I have designed a database in which the user enters all kinds of data into the forms then prints out Report forms. Anyway, I have it set up now so that if you enter a person's data (one time) in a Master Index Form, then their inormation shows up in combo boxes in the Form. In other words, as...

Nim180, I want to make sure I have everything right. It's mostly self explnatory but I want to make sure. I created the new column in my table and named it ImagePath. You said to then get the path for each image and save it to the appropriate field. Would you please explain that part...