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...
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????
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...
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...
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)...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.