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. EnglishMan

    MDE question

    No. Any changes to the data in the MDE file are not in your MDB file. If I was you, I would split the MDB file into 2 parts using the database splitter tool in access. This way the data is in one database (back end) and the forms, queries, reports is in another database (front end). Then make...
  2. EnglishMan

    MDE question

    From what I understand you must keep your orginal MDB file and if the user requests changes, change the MDB and then create a new MDE file.
  3. EnglishMan

    Calling a dll that is not a windows dll

    I am trying to call a dll that is not part of windows and is therefore not in the SYSTEM32 directory. I have declared the function. However, when I call the function I get an error stating the dll file can not be found. I have included the path to the dll in my path statement. Any thoughts????
  4. EnglishMan

    Triggers

    I have done triggers on UDB 7.1 for OS/390 from one table to another table in the same Database. However, I am having a problem when the triggering table contains a timestamp column or a smallint column. When I try to create the trigger it gets a -189 sqlcode. E.g. of a create trigger for...
  5. EnglishMan

    SQL and/or DAO question

    Please post code. It makes solving problems easier.
  6. EnglishMan

    Using LIKE before the where clause

    Juice05, What DBMS as you using? Do you have the IIF statement then I think I have a solution that will work. Table 1 contains the following data a hill b car c hop d hill e cat f apple Table 2 contains the following data hill top car hop Then by using the following query, all rows are...
  7. EnglishMan

    SQL Query for gap in sequential field

    impulse24, The only way I could think to show all the values in the gaps would be to create a table with all possible values in the table for the Certificate Number. Then you could do the following query ... SELECT A.X FROM Table2 AS A WHERE not exists (SELECT A FROM TABLE1 b WHERE b.A = A.X)...
  8. EnglishMan

    Sharing DB in exclusive mode with DAO

    Hi lorenzodv, Did you try to set the Access Database to have locking set for all records and not the default (no records locked). To set the default locking level to all records .. Select Tools from the Access Menu bar. Then select the Advanced tab and click on the radio button for record...
  9. EnglishMan

    How do I print a web page object from VBA in Access?

    Rick, I took part of John solution and I got the following to work. Private Sub Command0_Click() Dim myStart As Variant Dim myFinish As Variant Dim IExplorer As Object Set IExplorer = CreateObject("InternetExplorer.Application") '*** Start IE, go to URL With IExplorer...
  10. EnglishMan

    Switching Views in Word from Master to Normal from VB

    Not sure if this will help but I recently found out that Word defaults how it opens a document by checking settings on your computer. Have some else open the word file after you have run your code and see if the word document opens in normal view or master view. I hope this may point you in...

Part and Inventory Search

Back
Top