Search results for query: *

Still having the same problem. Have no idea how to solve it. Could you suggest a good place on the net where i can read about how to create charts in Access 97 based on a query involving dates. thanx

hey I am trying to make a chart based on a query. I go through the Chart Wizard selecting the relative fields. There is Date on the x axis and i group it with day. when i switch to form view..to check out the graph..i get an error saying "Function isn't available in expressions in query...

yes it is linked.. I tried dbOpenDynaset Now its giving me an error "Type mismatch" How can it be a type mismatch!!!... Set rs=db.OpenRecordset("tableName",dbOpenDynaset) i dont see why this line has a type mismatch!

What I am trying to do is accessing the database from excel and adding a record to a certain table.I am able to use it using ADODB recordsets, but I want to use simply DAO because some VBA libraries are missing on some other test stations so ADO libraries cannot be referenced.That gives a...

I have some code which sends an email from excel... You can maybe change it to ur needs and work it in access... here goes nothing... ' requires a reference to the Microsoft Outlook 8.0 Object Library Sub SendAnEmailWithOutlook() ' creates and sends a new e-mail message with Outlook Dim OLF As...

ok..but i need to get into the database because I have to make a few changes. I havent really worked with read/write permissions before, therefore I am having some difficulty. I made a copy of the database so that I do not muddle with the original data but I cant seem to even view the tables in...

When I open the database through a shortcut,it asks me for a Name and a paswd.Works fine over here. When I open the actual target of the shortcut (the same database ofcourse) it doesent ask me for a name and a pswd.Plus in the first case I am able to open and view tables.In the second case while...

so it works... Thats great...heh... ive just started working with access a couple of months back..theres too much to do..however im still working with access 97 so i dunno how much of a difference that makes in other versions of it... anyways...happy to know..that i could be of help..

try putting brackets around the name of the table,I think the problem is because u have a space between the table name rs.Open "[Reject Count]", cn, adOpenKeyset, dLockOptimistic, adCmdTable all these lil things can be a pain...:) thanx for the drinks hehe... seeya

Thanx a lot. It does sound a lil more complicated than i thot itd be but yes those are good ideas. I'll see where i end up :) thanx

No Problem at all.Amazingly I had been working on a similar thing just last week..heh.. Ok the first error is because some project libraries are not referenced.Certain Objects before use have to be referenced.Anyways When you get the error,press end. Then select tools->references in the visual...

I dunno if this will help but this code can be used to export information from an excel worksheet into an Access database table. Sub ADOFromExcelToAccess() ' exports data from the active worksheet to a table in an Access database ' this procedure must be edited before use Dim cn As...

Hey.. I was wondering if there is a way to open a dialogue box from excel and the user should be able to choose which database to open from that dialogue box. I do not want to hard code the path into the code because different databases might be opened. How do i do that using VBA? Thanx a lot in...