Recent content by faradhi

  1. faradhi

    Automatic Front End Database Updating

    This is not necessarly true. There are often instances that someone needs two versions of Access installed. In which case, it is necessary that the absolute path be used rather than depending on the windows path statement. ;)
  2. faradhi

    Delete Query?

    Break it up in several queries. Run an Append to the new table and a delete query from the old table.
  3. faradhi

    set parameter as user input

    What do you want to do with the set of records? Do you want to display or process etc....
  4. faradhi

    Either BOF or EOF is True, or the current record has been deleted...

    I the problem may be with the line criteria = "[User] = """ & Forms![Login]!user & """" THe line should be criteria = "[User] = '" & Forms![Login]!user & "'"
  5. faradhi

    Automatic Front End Database Updating

    Another way to handle this is login scripts if you can talk your systems admin to allow you to add a snippet of code. You can test for the database on the users system and then use robocopy or xcopy to overwrite the local copy if there is a change.
  6. faradhi

    Searching Object Properties

    Well that didn't work either. States that the object doesn't support this property or method. Any other suggestions???
  7. faradhi

    Searching Object Properties

    Thanks SJ I knew it was something stupidly simply. I just could not remember how.
  8. faradhi

    Searching Object Properties

    I have this function code that I know will not work. What I hope to accomplish is that the function is passed the property name and it returns a propery value. Function GetProp(StrPropName As String, StrLDAP As String) Dim Objuser As Object 'Opens the LDAP object for the active...
  9. faradhi

    Help with Table structure

    That is what I thought. Thanks for the confirmation and quick reply. Bryan
  10. faradhi

    Help with Table structure

    I have an Access Database for that aids in Parking Management for a small college. In the Database I have two tables. The first is table tblLots, which holds the Lots that are managed, has the following fields: LotID LotDesc The Second Table tblCustType, which holds a type of customer, has...
  11. faradhi

    Validation Rules

    I have a table called tlbAsset that has the following fields. tagid (primary Key) Make Model UserId SerialNum I have another table called tblproducts that has the following Make (primary key) Model (primary key) Type I would like to set the validation rule in tblAsset to only allow...
  12. faradhi

    Udate to move a record to another table

    You Could just copy what is in the field to be updated OnEnter.
  13. faradhi

    Query Propeties and VBA

    I have an Append Query that updates an external database. Since it is possible that the Destination DB may Move I would like to change the Query property "Destination DB" with VBA. Can Anyone tell me how to do this. :confused:
Back
Top Bottom