Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. funger

    Access Calculation

    guess I'm not quick enough. Glad you figured it out though!
  2. funger

    Access Calculation

    This should do it for you.... to use a conditional statement in a query use the iif() function. More information can be found in help. SELECT tblHours.WorkerID, IIf(Sum([TotalHours])>8,8,Sum([TotalHours])) AS Normal, IIf(Sum([TotalHours])>8,Sum([TotalHours])-1,0) AS Overtime FROM tblHours GROUP...
  3. funger

    Table security

    I have a database that consists of a frontend and a backend. I need to be able to secure the tables in the backend so that I can access them through code, and the interface, but so that the user can not access the tables directly, nor can they import the table objects into a new database. How...
  4. funger

    NotInList Event + Formatting = Problems.

    Hi! I have a dropdown that holds a list of dates. I want this list to all be formatted the same: mm/dd/yyyy. The problem arises when someone enters m-d-yyyy... Because the NewData value in the NotInList event does not follow the format of the data in the list, the code crashes. Can anyone...
  5. funger

    Include Access 2000 Runtimes - P & D Wizard

    HI all, a little help please. :) I am trying to create an installation package for my database. I have the package and Deployment wizard installed. I am going to be distributing my database to clients who may or may not have access installed, so I want to include the Access Runtime Libraries...
  6. funger

    Deleting external forms

    billpower, it just seems like VB continues on with the code before the object has been completley copied. I was having all sorts of problems. And as far as the response goes... I don't think I could have been happier to see a useful response this morning. If I keep getting help like this, I...
  7. funger

    Deleting external forms

    billpower, You ROCK! Thank you for your help. It's really been difficult trying to find help on this subject. :) I was really close, but just couldn't get it to work. I was also using transferdatabase to move things around, and it just doesn't seem to work as well as CopyObject... is it...
  8. funger

    Deleting external forms

    Hi all! I am trying to make a small 'patch' database that will replace items in a much larger 'master' database. In this patch I need to replace two forms in the master database. I am able to use DoCmd.TransferDatabase to move the forms from the patch into the master, however I don't know how...

Part and Inventory Search

Back
Top