Ok here is what I know.
ADO is part of Access 2000 and up, if you have calls to DAO you can open the database and go to design view of a module choose tools and references, scroll down to Microsoft DAO 3.51 Object Library. Check it....click ok...reopen the references, now move it all the way up...
A dot matrix has two modes of printing graphic and normal.
If the report is made using a windows font or has a graphic the printer tries to paint it.
Not only slow but noisy and uses a lot of ink.
Make sure that the native fonts for that printer are installed and the report that you are...
try this one
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = "[RefID]=" & Me![RefID]
stDocName = "rptprintsingle"
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
Make a command button on your form. Put this code in the onclick event...
Access keeps tabs on the records you delete that way there can never be a duplicate number.
Did you try and delete the autonumber field? then save the database and make a new field that is a autonumber? that might do the trick.
I had problems with the whole sendobject thing, I too received the "The action SendObject isn't available now." I checked all my references. Turns out the access installation was out of wack.(office 2000) I ran detect and repair....and presto!.
You might want to keep an eye on the...
Dlookup() expects you to give it three things inside the brackets.
Look up the_____field, from the_____table, where the record is______
Each of these must be in quotes, seperated by commas.
=Dlookup("CompanyName","Company","CompanyID = 200")
or...
I thought the way to put two strings together was
[field1]&""&[field2] or
="String"&""&[field2]
if you want a space between the field and string seperate the quotation marks with a space
hope that helps
The problem is looking at all those records, if you want to filter the records, let oracle do the work not access. There are two ways that I know of create a SQL statement (query) and connect to that, or create a view and connect to that, I do not know which one is faster. But I know from...
Joey,
We have a Oracle here at our shop. The answer is yes, you can obdc to a view. We do it here to create reports using access.
This is the best way I know to connect to a oracle table that has lots of indexes, or to large for Access. Create a view and connect to that.
fred
I have not been able to find much on the subject myself. Type automation in the help section (access)
Microsoft Knowledge base has an article that you might find handy
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209882
this should give you enough information to get you going...
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.