Link the remote server and then refer to the view using server2.databas e.dbo.view syntax.
http://www.db-pros.com...
dbpros
Last Activity: Jun 23 '08, 11:32 PM
Joined: Mar 10 '08
Location: Boston, MA
-
Yes... if you use a stored procedure with multiple delete statements, use begin trans and commit trans to ensure the entire batch processes together.
DELETED URLLeave a comment:
-
You can usually get around these problems by adding more ' (single quotes) until the parser is happy.
http://www.db-pros.com...Leave a comment:
-
This is usually an indication that a query can be optimized. Are you running any queries that take a long time to return results? If so, they are good candidates for optimization/index tuning.
http://www.db-pros.com...Leave a comment:
-
I agree with Stewart, sounds like your references might be lost.
Open a module and go to tools, references and ensure your DAO and ADO libraries are checked off.Leave a comment:
-
I would probably do this with a VBA recordset function.
You can use recordsets with criteria to select the desired records to get your calculations.
You can then use recordsets and the rs.Edit and rs.Update commands to update the desired records.
Hope this helps
http://www.db-pros.com...Leave a comment:
-
I always do a "rs.movelas t" followed by an "rs.movefir st" before executing the rs.recordcount.
It always gives the correct number of records in the recordset.
good luck
http://www.db-pros.com...Leave a comment:
-
I've never seen one of the standard Microsoft list or combo controls show thumbnails, though I suppose its possible. You might want to search for a custom 3rd party control to do that. Let me know what you find.
http://www.db-pros.com...Leave a comment:
-
You can display a Name field, but internally use the ID to store within the database. Try setting the column count property to 2 on the drop down list, but bind to the first column (the ID).
http://www.db-pros.com...Leave a comment:
-
If you use the Access import wizard, it will let you build/create an Import Specification, which tells Access how to interpret each field (as number, string, etc) and where to put it. I believe you can create an Export Specification as well.
hope this helps
http://www.db-pros.com...Leave a comment:
-
I prefer to avoid nulls whenever possible. Operations (math, compares etc) with nulls require more work than if they are 0's.
It may be a little more work to restrict nulls initially, but I feel it pays off in the long run.
just my opinion.
http://www.db-pros.com...Leave a comment:
-
Leave a comment:
-
A "Delete from [table]" command for each of your tables is all you need.
If you have foreign keys you will need to delete the child table before the parent tables can be emptied.
You can get some scripts to output all the tables etc, but I find it useful to do this myself, if I dont know the structure will enough, it is a good learning exercise.
You'll get a relational integrity error if you do not execute...Leave a comment:
-
Can you access the Image control in code?
If so, try looking at some of the methods and properties of it, and find which one is the path to the image. Try setting the path on an image control (using the Properties options in design mode). Then access the control at run time (using a button) and try manipulating this file path to one of the ones in your database.
You should just need to modify this value to change the image...Leave a comment:
-
Does the subform have its "master" and "child" link field values set?
Can you open the subform on its own without an error?Leave a comment:
No activity results to display
Leave a comment: