Search results

Say - Can you do this with VBA by any chance? Can we import and delete Import/Export specs?

Thank you!

Is there a way to move import/export specifications from one database to another?

Certainly. Here is the "02 Unique Merchants" query's SQL: SELECT DISTINCT [01 Intial Card Results].Merchant FROM [01 Intial Card Results] ORDER BY [01 Intial Card Results].Merchant; The query "01 Intial Card Results" (Yes, misspelled) has the following SQL: SELECT dbo_tbl_CC.Account_Number...

Last question, promise... Is there a reason why this code will only work when I loop through a table's records, and not a query's? I get an "invalid operation" error, whenever I put a query name in this line: Set rs = dbs.OpenRecordset("query name") ~Andrew

Thanks. That was indeed the problem. Posted below is my updated code: Dim dbs As DAO.Database Dim rs As DAO.Recordset DoCmd.SetWarnings (False) DoCmd.OpenQuery "03 Earase Cardholder Profiles", acViewNormal Set dbs = CurrentDb Set rs = dbs.OpenRecordset("cardholder proflies") rs.MoveFirst Do...

Ok...Despite that, I now get a new error: "Object Required." When I go into the debugger, the highlighting is on this line: Set rs = db.OpenRecordset("UniqueMerchants") I've checked, and the Query that I want to serve as the recordset is, indeed, named UniqueMerchants.

Thank you both for responding! I was able to get past that initial error, by adding a reference to DAO in Access (Future readers: In the VB screen, TOOLS --> REFERENCES). I also removed the reserved characters from the object name, and renamed it "UniqueMerchants." I've changed the code a...

I'm having a problem with an adapted VBA script. I just want to loop through the recordset, but Access keeps giving me grief. Dim dbs As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("(02)Unique Merchants") rs.MoveFirst Do While Not rs.EOF MsgBox...

Thanks RG!

Can someone post the updated link that Ghudson posted earlier? It's dead. ~Andrew

I'm sure these problems have been long since solved, but since the thread helped me ID a problem, I thought I'd post an alternative solution: Although "date" is reserved by Access, you can always get around it by using [brackets]. My SQL statement wasn't going anywhere: sql = "INSERT INTO...

Is there a way to put chagne the format of a date in a query to have leading zeros anyway? 4/2/2006 I need to appear as: 04/02/2006 I realize that Access doesn't care, but the software that I'll be inputting the Access outputs does. ~Andrew

Say, here's a development: I was able to copy the View that the linked table was "truncating" as another name, and linked that view without any problems at all. Uh. So. I don't know what to say. Two MSSQL views, exactly the same...One links without a nasty error, and the other doesn't. ~Andrew

I just linked a table to an Access Database from SQL Server. Now, whenever I open the linked table, I receive the error "Scaling of decimal value resulted in data truncation." After a quick Google search (and search of these forums), I found some solutions: So, I guess I found the problem...

I'll look at Crystal Reports. I'm positive we own a copy somewhere. MSSQL reporting services was a bit of a disappointment, since it seemed to require Visual Studio to be installed, a suite that we do not own. Thanks, ~Andrew

Hi, all: Does anyone know of a good ASP or PHP-based reporting service/software suite that I can use to give users of a MSSQL database the ability to easily run and create reports? We need to give non-technical users the ability to easily create reports that support groupings, totals, sorting...

Indeed.... Actually that previous post took several minutes to even to added to the database. I usually open three or "advanced search" pages in seperate tabs, run all my different search requests, and go get a snack while I wait. :) Andrew

I wonder about the health of these forums.... My searches are taking forever to run. I'd hate for the site not to provide these forums anymore. Andrew

...For future readers: For those attempting to use PHP and SQL in the future... I set up an ODBC connection on my web server to my SQL database, localed on my SQL server (Start > Control Panel > Administrative Tools > Data Sources). Then, I used PHP to connect to the ODBC connection. I used the...