Recent content by Adrianna

Unfortunately, I'm using MS Access as my intermediary, as the two SQL databases are no connected. One is SQL 2000- supporting our live customer base, the other is our SQL 2005 server which we are preparing for our new .NET web interface, but took the opportunity to completely alter and improve...

Okay, I've searched and found a lot of unasnwered questions. I've been using DAO and not ADO forever, so bare with me here (also been away from VBA for a while). I've created an adp file (access 2003) linked to a SQL 2005 database. I would like to loop through tTableNames and pass the...

I can't remember where I got this file...but thanks and credit to the person who put it together. I used the attached to develop something similar. More like what you are aiming at. I allow addition of items from one list into another, but the group is represented by an intermediary many to...

Yes...using an input mask will work. Try "06"000;_

cedtech, I assume that you want it to disappear when there is no data in the subform or not to appear until the user has selected something from the main form. I asked this questions that tried several things. Eventually I ended up setting the CAN GROW and CAN SHRINK properties to Yes and...

You're wonderful :D THANKS.....setting that up as we speak! We're only using MS Access for our internal office reporting because it's easier to format things into other MS Office product then to publish them to a web page and then transfar them back down to a spreadsheet or other format...

FoFa, OKay...I'm missing the obvious. I see where I can establish user accounts. I do need to make a group account for the office. Then I should be able to attach the ODBC using that userid.....etc Not sure why I didn't think about that before. I guess now I have to...

:) FoFa What utility would I use to establish these accounts on the SQL server? We're using MicroSoft Active Directory, so I would assume that I could still add users into a user group. Do you have any reference links on this? A

The ODBC would be set up with my user name and password and the adp would be set up the same. Either way I need to set up access for the user's to the SQL databse and the only way that I know how to do that is by either creating as Access database using an adp file or an mdb with an ODBC...

Limiting access based on login is not an issue. The issue is when you create and ODBC, user's can develop their own interface to the ODBC, allowing them access to EVERYTHING. I believe that I might be able to acheive the security I desire through the use of an ADP file instead of creating a...

I'm using Access to run VBA scripts in order to generate reports for my coworkers. I've been doing this all from my desk, but would like to be able to create a switchboard to allow them to create their own form driven queries and push button reports. The issue is that I'm actually using an MS...

:confused: How do I get this to send a double mouse click into another application? I declared the Private Function at the beginning and then in my OnClick() I have this: Dim stFileName As String Dim WshShell As Object Dim oApp As Object Shell...

Okay....I'm frustrated with NetViz....what a terrible program. Anyway, I'm try to send a Dbl Click or a right mouse click to the program from access. I can nagivate all the way up to the page that I want to see, but then I can't open it because the program only allows initiation by double left...

Wow J4mie, 160 refreshes sounds crazy. I use my Call to Export for several things....the original use is a "Rollup" of data by "Location" for each "IT Asset" in the database. So in essense, it loops through a predetermined "Location", looping through each IT ASSET, but Asset Category ( I...

Roy is right on the money with declaring your parameters upfront. I kept getting the No Record or To Few Parameters Expected and I was pulling me hair out. I'm using queries that are predefined, but I send 28 of them out to separate worksheets within one workbook, naming the worksheets...