Search results for query: *

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...

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]...

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!!

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...

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...

I made a simple search where I can search titles. I've made it so that "fat cat" will pull up "fatal catastrophy" or "fatal incident catastrophy"..... The search works as long as the title is in the order of the keywords to search by. My problem is the words...

I'm creating a keyword search and have been able to search fields with a one-word search. Now I'm trying to have multiple word searches. Anyway, I'm trying to manipulate a piece of text so that all spaces will be changed to "*" So this sentence will be: So*this*sentence*will*be...

I have a crosstab which puts years across the top: 1995 - 1996 - 1997 - 1998 ___________________________________ If there's no info for 1995, that year doesn't show up & I'd like it to to keep the report consistent. Is there any way to do this???? (suppress empty rows and columns is...

I have a crosstab report with years in the columns and NameType in the Row followed by Name and amount in the summarized field. Is there a way to begin a new page when the "NameType" changes? (So all the NameTypes will be on different pages and not broken up?)

I'm trying to add some reports created in Crystal 8.0 to an Access 2000 database. Are there any good (quick) references on where to begin? I have been having problems creating a Crystal Report through Access and would rather use the Reports I have already created. My goal is to let the...

Hi. I need to move a record from tableID into a ChangedtableID to track changes made by users. I cannot add a 'deleted' field to my tableID because I cannot have duplicate records. Thanks for the help!!!!