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!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
chart trouble help plz
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...- hysteria
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Recordset objects HELP!
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...- hysteria
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
read/write permissions in Access 97
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...- hysteria
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
opening an access database through VBA in excel
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...- hysteria
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
