Search results

Do you not get this prompt when you run it? Do I need to buy the distributable version in order to make this automated?

It still comes up. Is there a way I can just automatically make it select "Agree" and hit OK?

It still brings up the prompt, unfortunately

I already have it doing this -- the problem is the point where I am using regsrv32. It doesn't seem to follow through with the registration automatically. It brings up a window with an agree/disagree OK/cancel box and only when I click the radio button/press OK do I register Redemption and...

Is there a way to have Redemption.dll automatically loaded/registered/referenced in Access VBA? Right now I am using: Sub regRedemption() Dim redPath as string redPath = "C:\Redemption.dll" 'or whatever other path shell "regsrv32.exe " & redPath, vbMaximizedFocus End Sub Only...

Say I have the following entities: 1. A separate DBF file that has a bunch of data, rawdata.DBF 2. Make-table queries that take rawdata.DBF and... make tables, say, RawTables. 3. There may be processes that append to tables instead of recreating them. 4. Queries that manipulate RawTables in...

the dowarnings portion seemed to work when I put it in my rs loop. Before I was doing something like this: docmd.setwarnings false while not rs.eof docmd.openquery (rs("blahblah")) rs.movenext wend rs.close set rs=nothing docmd.setwarnings true Once I moved the warning flags INSIDE...

The queries are in the form of "select ______ into (Table Name) from (linked DBF file)"

I have another database where I use similar queries with the warning flags / make table structure and it doesn't prompt me for anything. I am just not sure why this one is.

Yes, I do just that. When I try to use CurrentDb.Execute ("NameOfQuery") though, the query still throws errors at me (table still exists so it'll throw down the warning).

I normally set the warnings equal to false, run some recordset loops that throw down some maketables, and then set my warnings to true. For some reason it isn't working in this particular database and it is driving me crazy. Under what circumstances would setting warnings to false NOT suppress...

Makes sense -- but would this be an issue if more than one database were open at once?

It may be as simple as making schedules with VBA, but my main issue is that I use XP and I can't seem to prevent collision. For instance, DB1 is scheduled for, say, 9:00 and DB2 is scheduled for 10:00. DB2 assumes DB1 has run. But sometimes DB1 runs a bit longer than anticipated and so DB1...

I am trying to code an alternative to the Windows Scheduler in Access that allows me to queue items (e.g. run one after the other without worrying about time collisions), customize its conditionals, etc. While I can run/end programs on other users connected to my network via the Scheduler, is...

Is there code out there that doesn't require Adobe or PDFCreator? I can't buy/install Adobe and PDFCreator is the most aggravating, buggiest thing I've ever tried to use. Leban's code seems to work well for Reports->PDFs, but I need something that does Excel->PDFs. I've scoured the web with...

How do I know which fields to index if a variety of queries use many different fields to join on (like some queries use table field A to join on, others use B, others use C, etc)?

Would I put these indexes in the table itself? Could I have multiple indexes? Could I just index every field? What would an index look like in the table/query?

Thanks for the help -- I think I'm on the right track now

I seem to be able to redim the last dimension but none of the first

I want to be able to have an array defined in this way: nameofarray(,2) where I then iterate through a recordset that I get via a query, and for each new entry, insert a name into the first index, and their email in the second index. For instance: nameofarray(0,0)="James"...