Recent content by mondo3

I tried this code but i get an error: Dim strSQL As String Dim rs As New ADODB.Recordset Dim cn As New ADODB.Connection Dim mstream As ADODB.Stream Set cn = CurrentProject.Connection strSQL = "SELECT testid, photo, notes FROM tbltest where testid=1" Set rs = New ADODB.Recordset...

I'm using access 2003 as the front end, linked to SQL Server 2005 for the back end. I would like to store scanned photos (jpg's); I do not want to just store the path name in the record, as the scanned photos are confidential (I dont want residing in any network folder). Has anyone got a code...

I've found that many of our users cant navigate through folders, so I use the desktop as that's pretty simple (and no complaints so far). Perhaps that api is the way to go, but i was hoping for a simpler answer. thx

This command worked for me in access 2003, but doesnt work in 2007 : DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryHistory", "C:\Documents and Settings\All Users\Desktop\History.xls How should it be changed to write to the desktop in 2007?

I was wondering what language they use to develop their languages...ie: is access itself created with a language like c?

If I have a folder set with permissions that only allow a specific user (say "accessuser") to be able to read/write to that folder, is it possible for access to connect to that folder by authenticating as "accessuser" ? I'd like to save photos in that directory, but only allow users of the...

That's a lot of complicated reading and a lot of it seems aimed at access 2007 users (we're using 2003) :( If you had to sum it up, would you say that it would be more secure to go with a SQL Server backend? if so, (and I realize that this isn't a sql server forum), do you know if there are...

I've searched and havent found this... How do you disable the right click options throughout the entire application? These are the options that appear when I right click: Form design, formatting, toolbox, and web. I would like to prevent the users from having any of these choices. I did...

where in this code is the password setup for the connection?

I'm using access 2003 (SP3). I haven't setup any security at all (actually, this is the first time i've had to deal with security within access - on previous projects i handled it with folder permissions). I guess what I really want to know from the forum members is if what I am trying to do...

we're using ANSMTP (google for info). costs about $100. works well

Currently: I have an access front end and back end. The program has a login screen. The program's logic determines what table field information each user is allowed to see. Can access security be setup to not allow the users to open the tables by directly opening the back end (regardless of...

I have a subform datasheet that shows a list of employees, their department, and their supervisor. I would like the supervisor field to be a combobox that only shows employees who are in the same department as the employee on each row. can a query be written for the combobox that refers to the...

bump bump

how many rows appeared when you ran the query? the results should have been something like (say it gave 2 rows): [Item Number], Dimensions, Zero, One, Two, Three, Four, TotalItemValue, GrandTotal 1234,abc,100,200,300,400,1000,2001 1235,def,101,201,301,401,1001,2001 where the grandtotal is the...