Search results for query: *

That did it (save password) - what a weird thing. Funny that it's sitting on the network and works for some people and not others. (Now it's VERY slow, but better slow than not work at all) Thanks for all the help!!!

No, it's definately not a "user id" error. There is only one user id for the oracle connection. As for the PC's, I doubt it, all PC's are configured exactly the same. Going to have to look at the VBA that cmmrfrds posted (That was a helpful post). Very strange - the ODBC connection works...

I'm really not sure what it is - I just moved up to Access 2003 (from 2002). Also found this article from Microsoft, almost seems hopeless: http://support.microsoft.com/default.aspx?scid=kb;en-us;325835#kb3 from microsoft: "Microsoft has confirmed that this is a problem in the Microsoft...

I have an Access db that uses Oracle linked tables. Very strange, the connection works once and when I close the app and open it, I can't connect to the Oracle table anymore. (this also happens in a brand new Access database with only an Oracle connection). I've tried deleting the DSN and...

I'm trying to save Access data to Excel. I will need to have spreadsheets with each name: (there is a field in the table with each name in it) Bob Joe John Each spreadsheet needs to be named their own name. In this example, I'd have Bob.xls, Joe.xls and John.xls -- each with their own data...

Thanks for your help. Here's what finally worked... I tried the single quotes and couldn't get that to work.. CurrentDb.Execute "DELETE FROM tblCurrent WHERE [Year] = " & """2005""" & " AND PID = " & """" & Me![PID] &...

My 'year' is not really named year - it's baseyear, but to be more clear in explaining, i used the term 'year'-- sorry for the confusion. Also, When i change to single quotes, it's read as a comment out. Yes, it's my goal to delete a record from a table from an opened database that meets two...

Both of the deletes work individually - not sure if it's possible to do this or not... tried makeitso's code - thanks - (but didn't work.)

I'm trying to delete from a query where there are two fields that must be matched. This works with one variable (or the other), but when I add the second, it doesn't work - I get a Run-time error 3061 - Too few parameters. Expected 1. CurrentDb.Execute "DELETE FROM tblCurrent WHERE [Year]...

The files open fine - I've tried the ones the errors happen on, I notice that someone else had the same problem about a year ago - it wasn't resolved. I have no choice about the type of file because there are a lot of pics in this system (with the query it's narrowed down to about 18000 in the...

I've used this code for images (tif) - works great except about the 10th image (not always the 10th - not always the same file) is loaded, I get an error message: Run-time error '2114': database doesn't support the format of the file -path.tif, so it can't load the picture. Thanks

I'm looking to e-mail a report once a month to several people (and would like this to be automated). Do I need Enterprise for this or is there a way to write a program that will do this for me? Thanks!!

In case anyone has this problem, my form was set to a pop-up (and it was filtered). I took the pop-up off and everything was fine.

I have a database that has windows security (wizard) added. It runs perfectly on my hard drive, but when I move it to a network drive, my printing functions don't work correctly. My form has a tab control on it. I need to print Page 1, and Page 2, so I used: docmd.goto Page 1 printout...

Is there any way to hide the path in a shortcut --- or create a shortcut without listing the path? Thanks!!

I'm going to be putting together a web site. I'd like to develop the main website and the company to have access to another page (with password) where they can enter and update data which will be viewed and searched on the 'public' page. What will I need to do for the 'private' page? Am I...

I got it!!! Thank you SO much.

I've used the subreports. Now I have two variables being passed to Group 2 - once a value shows in a group it continues to show until the numbers in that group change. Also, I'll need the total my two variables to be combined for Group 1 for a grand total. Thanks for all the help so far!!

Ok, I tried to simplify my problem and was hoping there was a simple answer. I need to include all customers from both OrdersOnHold and Orders - So I needed to add a 'dummy' Customer table to link to one. I also need to read all records from OrdersOnHand and from Orders - so I changed the...

This is going to make me crazy: I have 2 tables (as an example): tblOrderTable, tblOrdersOnHold (same fields in both tables) CustomerID, ProjectID, CostOfItem. The other table is tblCustomer: CustomerID, Name, State Here's what I'm looking for our of my report: In short, I need to combine...