Search results for query: *

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...

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...

I am very new at Access 2007. I have a Photo field on a form that a user can click on to add a photo of a person. I would like to actually store the photos in a separate database. The one I have now is extremely slow due to all the photos stored in it. How do I leave the form field as is but...

I saw some code once about password protecting a Tab on a form. However, it says to place the code in the "On Change" event. I do NOT see an "On Change" event. The code is: Private Sub TabCtl0_Change() Dim strInput As String Dim ctl As Control ' Hide controls on tab until...

I have recently converted over to Access 2007. I package my application using the Packaging Wizard. When a user installs, it apparently only lets the user open the application in Runtime version. This is actually a Good thing. Question: Is there anyway for a user to get around the runtime if...

I guess I am just real Stupid. I can not find the startup options in Access 2007. i can find it easily in 2000, 2002, etc. Where is the startup options in Access 2007? Also, in Access 2007, I am trying to insert an object in an OLE field. In 2000 or 2002, I just right click on the field and...

I have recently learned, to my surprise and also to my delight, that you can package an application in Access 2007 using the Access Developer Extensions that you can download for free. I paid a LOT of money for Office 2000 Developer and Office 2002 (XP) Developer. Now, apprently it's free in...

I know how to simulate a runtime environment by adding /runtime to the end of the shortcut line. I distribute my application using Office XP (2002) Packaging Wizard. I want my application to open in runtime even if the user has the full version of Access. Isn't there a way, in the Packaging...

I am having a problem installing a packaged application. I created my application using the Access 2002 Packaging Wizard. I also included Access Runtime in the package. The problem is that when a user goes to install the program, it gives an Error stating, "The Office System Pack cannot be...

I know how to simulate a runtime environment by adding /runtime to the end of the shortcut line. However, I distribute my application using the Packaging Wizard and I include the runtime in the package. When a user goes to install the package, I want the application to open up automatically...

I am hving a problem installing a packaged application. I created my application using the Access 2002 Packaging Wizard. I also included Access Runtime in the package. The problem is that when a user goes to install the program, it gives an Error stating, "The Office System Pack cannot be...

I am fairly new at Access Security. I distribute my application, so of course, I would like to learn more about security. I use the User Level Security Wizard to setup users and passwords for those users. I then set specific permissions for each user. I have that part down. I also know that I...

I believe I saw this not to long ago but I can not find it anywhere I look. I want to populate a field in a form with the information from the same field in the previous record. I want to think there's a way to do it with the ALT key in combination with another key. Any Ideas...

When do you recommend setting up SQL Sever? Do you base it the number of workstations? I have some customers on a network with as many as ten (10) workstations and they work fine. Also, I have NEVER done SQL Server. I have the SQL server 2000 that came with my Office XP Developer edition...

I have been designing and selling databases for years now. I have numerous customers and most of them are on a network/server. My questions is probably a dumb one, but what is SQL Server 2000? I have the Office XP Developer Edition which consists of a total of Seven (7) CD's. I have loaded...

I have a customer with a Front End/Back End database on a server. I have the back end on the server and the front end on each user. There is a problem with the linking. It asks you to link to the back end each and every time you log on. It loses the beck end connection for some reason...

I have a Backend that should contain a large amount of data. All of my Front Ends lost their links to the Back End. I went and checked the Back End and it is still there. The Back End is named ReportCopWashinton_be.mdb. The problem is I can NOT open the Back End. It gives me some kind of error...