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 Chriss Miller 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 MortenB

  1. MortenB

    Same text comparison, two results

    I suppose the form's code window is the module you get when you edit any event in the form. I have checked them and they are both marked "Option Compare Database". Is there anywhere else I should look?
  2. MortenB

    Same text comparison, two results

    I have a form with an unbound control where the user can type a search criteria. Clicking a command button will refresh a combo box which is based on a query that uses the value from the control as search criteria. The search criteria looks like this, <.. where RefNum Like...
  3. MortenB

    Passthrough query as rowsource

    PH Unless you have a spesific reason for adding DAO, I don't thing it will change anything. I know that DAO is included in my reference list and ADO is not, so there is no possibility for conflict. I have done some more research on the subject, and my theory now is that it is simply impossible...
  4. MortenB

    Passthrough query as rowsource

    Dim recSite As Recordset Dim wrkODBC As Workspace Dim conOracle As Connection Dim strCriteria As String strCriteria = "ODBC;DSN=......." Set wrkODBC = CreateWorkspace("newODBCWorkspace", "usr", "pwd", dbUseODBC) Set conOracle = wrkODBC.OpenConnection("Connection1", dbDriverNoPrompt, ...
  5. MortenB

    Passthrough query as rowsource

    I am rather surprised that I didn't get any replies to this interesting question yet. Maybe it is because I did not specify that my front-end is Access 2002 and my back-end is Oracle? Or am I advancing in undiscovered territory?
  6. MortenB

    Passthrough query as rowsource

    Hi, There is a nice feature in Oracle sql that elegantly performs a treewalk for you. I have prepared a passthrough query with such a syntax and put it as the rowsource of my form, and it works fine (read-only but that's no problem). Now I would like to parametrize my start criteria for the...
  7. MortenB

    Form for Many-to-Many

    Reply to jgoodman00: Any car of course. Otherwise it wouldn't be many to many.
  8. MortenB

    Automatically save a new record

    You've got a point. However, what I really need is to save a record which is untouched by human hands when I move to the subform. But even if the default values are displayed the record is not marked as changed. I beleive I have tried the current event with no luck. The only way I have succeded...
  9. MortenB

    Form for Many-to-Many

    Let's call the two end tables DRIVER and CAR and the middle table DRIVINGRECORD. I must fill in the driving record for each driver at the end of the day. I will therefore create a main-subform where the main part consists of DRIVER and the subform consists of DRIVINGRECORD. CAR will appear as a...
  10. MortenB

    Automatically save a new record

    The point is that autonumber is not generated before the record is saved, and the record is not saved before the user has marked the record as changed by altering one of the record's controls. Catch 22! You can try it in any form that displays default data.
  11. MortenB

    Automatically save a new record

    I have a form where a new record contains default values, default foreign keys, and auto-generated primary key. The user doesn't necessarily want to change any data before he clicks his way to the sub-form. If a new record is not changed changed manually by the user it will not be saved using...
See more

Part and Inventory Search

Back
Top