Search results

  1. C

    Password for admin and user

    Ok - Long story short. For 'user' I dont want them to be able to edit tables or anything (disable menus and what not). For the admin I want to be able to make these things viewable again. Is there any way to do this in VB??? Thanks
  2. C

    Where to put oncurrent code

    Hello...I have a form that needs to have code placed in it so as not to have records updated. Thanks to a previous post, I believe the code I was showed will work. But I do ahve a question: Where can I put this 'on current' code? The form has text boxes binded to a table. I want to be able...
  3. C

    parameter/wildcard w/dates

    Hello there... Searching through the forum I have come close, but not totally correct yet as to the syntax I need to use. tbl_1 has dates stored in medium date. I have a query set up to do many aggregate functions on the results, but before I do that, I want to specify a date range. The date...
  4. C

    Locking existing records in form

    Hello I have a form that is populated with data from a table. The form's entry's are bounded to the fields in that particular table. My problem is, I want the user to be able to veiw existing records, but when they make a change I want to force a new record and NOT save changes to the current...
  5. C

    Datediff() return minutes with leading zeros

    I searched through the forum, and found alot of examples on DateDiff(), but I need to take two dates (both stored in a table as [Off Time] and [On Time] and subtract them. Then show them in hh:mm:ss format, keeping in mind this is in a query. The datediff() function gives me and error if I try...
  6. C

    QBF problem? or just me?

    Maybe someone out there can tell me what I am doing wrong. Cause I am loosing my mind today!!! SELECT tbl_equipment.Equipment, Sum(tbl_log.[Off Time]) AS [Off Time] FROM tbl_equipment INNER JOIN tbl_log ON tbl_equipment.Equipment = tbl_log.Equipment WHERE...
  7. C

    making a string form various things

    Hello I was wondering the vb code to do something for me. I have a field that is ##_#### The first ## is the current week / 2 The '_' has to be placed in and the last #### is the year. ie: 23_2002 I want this as a default value for a field on the form. So AfterUpdate on a list box, it will...
  8. C

    form validating input

    Hello - this is my first post. I have browsed through most of the form section with no real solutions to my problem. The problem being: I would like a field entered via a form on table_a validated by the same field on table_b. ie: Employee List table's Last Name field validates the last name...
Top Bottom