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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by funger

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

Part and Inventory Search

Back
Top