Search results

I had been trying this: Sub test() Dim a As Database Dim varItem varItem = "C:\pathtomydb\mydb.mdb" Set a = OpenDatabase(varItem) For Each refItem In a.References If refItem.IsBroken Then strMessage = "Missing Reference:" & vbCrLf & refItem.FullPath Else...

Alright, I think I have the right code to open database with shift-held. How might I iterate through its application.references and update them?

Is there a way to open/get the object without kicking off any startup processes in that database? I just tried it and it just hung there until I realized it was beginning to run the automation of that db.

Is there a way to do this with a database that opens/updates/scans other databases? The problem is that when I open the offending database, it throws an error immediately.

I understand the differences between early/late binding but I don't have the time to go through all these databases and code and uncheck all references/change the code from early to late. I can do that down the line, but not now.

e.g. I want to update reference X from missing-path A to correct-path B. Some references don't automatically know where to look, so they go from A to B, but all that manual tweaking requires time I don't have.

I have a bunch of databases. When I port them over to a new server, they break on open due to two references. Is there a way to update these references without needing to go into VBA Tools References manually for each one?

That did it -- thanks!

Say I want to take a string but EXCLUDE the left 60 characters. How is this done?

Is there an easy way to do this? Can't I just change the imported report's recordsource to instead point to the remote db?

I have a process that plucks out various reports from other databases and outputs them in pdf format. However, for some reason, when I import the report object, it tells me the recordsource doesn't exist (since it exists in the other db) How do I correctly import/copy the report into my db?

Problem: Sometimes I run into the error "System resource exceeded" exporting SQL through this method even though I have plenty of system resources. What's going on?

I think that worked -- thank you very much. Is there a limit to DAO recordsets in terms of size or processing? Sometimes the queries I process are quite large.

I don't know how to properly open DAO recordsets -- I was using it before but for some reason I ran into errors

select office.branch, office.zone from office where (office.branch not like "*South*") order by office.branch

officeTemp is a query. Even when I write it rst.open "OfficeTemp," I get the same result.

I have the following dim rst as adodb.recordset set rst = new adodb.recordset rst.open "select * from officeTemp", currentproject.connection But the problem is that rst now possesses a set that is, say, 50 entries long. If I open up "select * from officeTemp" manually in Access, it shows 42...

What would be the code for doing the following (I've tried all sorts of ways and I can't get it to quite work right, so I'm just starting from scratch): 1. Check if destFile exists 2. If it does, save current sheet destName in new workbook labeled destFile 3. If destFile exists, check if...

ChrisO: That's probably why -- I'll give it another shot. Gamma: Because I am interacting between my internal tables and an Excel source file. I need to store the unique row values somehow and then use this to compare against the table and, from this, generate criteria to filter the Excel by...

This is all I want to do: I look at a file. I notice it has a list of maybe 3-4 branches. I then compare it to my full list of branches and areas, and get a unique list of all the areas associated with my branches into a new array. Then, I loop through each Area in my array and filter for...