Recent content by Roni Sutton

OK - now check for this If you have both ado and dao references delete them both and add them back in the opposite order. I don't know why this makes a difference, but we have occasionally found that 'switching the order' of the references in the list stopped the error. This is really...

Can you draw me a picture? I'm not sure what you mean - but I have had a lot of experience developing weirdly formatted reports for some weird management types. I'll give it a go if I understand what you need. Send me an email... veronica.sutton@wachovia.com

Can you lay your hands on ANY printer drivers? You could install the software for a printer regardless of whether or not the printer was connected. Then access 'thinks' you have a printer installed - even though you don't - and you can create your reports.

Well, I couldn't stand it. And I had a few brain cells to burn. I couldn't find anything except the hysterically funny specification that a table can be no bigger than a gigabyte. If my databases get much over 50 megs they corrupt on a regular basis - which may be a function of the number of...

I have had a similar experience. Except it is a 2k fe w/a 97 be on a Windows 98 ops sys and a Novell LAN. Shortly after they changed our network we began experiencing all sorts of oddball problems with our Access dbs. In this particular case, I did the following - I repaired and compacted the...

We are having an irritating problem. Occasionally, references in Access 2k dbs go missing. We have no idea what is causing it, but it's incredibly annoying. In particular, we seem to lose the dao and ado references OR they get switched in the list and then we get weird errors in our VBA...

I need the ability to go out to DOS and run a program from a vb application. I will also need to send multiple keystrokes after the program begins running until I finally send the exit command. I am very familiar with doing similar things with a Rumba Object X control, but can't find anything...

Thanks. I was afraid I would have to do something like that. You're a great resource here. Thank you!

I have an autonumber field which increments by one set as a unique key id. Nightly, I strip off records by input date and store them in an archive. I DO NOT want the key id associated with those records to EVER be used again. However, I discovered that the old 'compact twice and it starts...

It is not a fixed length text file and will have to have some serious parsing done before being read into the fields. I don't want to use Access to begin the process because this is going to be an automatic job that runs nightly which I will set up with a batch file to kick off. I have used...

I have used VB multiple times to copy data from a mainframe session to an Access table using Rumba Object X. I want to do something similar with a delimited text file. Can someone point me in a good direction regarding how to open the file in VB and how to reference the columns and rows? I...

I believe it would work for you. I had been away from programming for several years and needed to get back into it. I initially used it for reference - looked up things in the index when I needed to know how to do them. But as I looked things up, I began reading the chapters around them. You...

Thanks! I know that would be the most expedient way and next time I do one of these, that's what I'll do. However, it would require changing several hundred lines of code. Someone emailed me and told me that using the Select * without a where clause will cause an entire table to be locked...

I do not know if it exists for 2000, but my 'Bible' has been the Access97 Developer's Handbook by Paul Litwin, Ken Getz and Mike Gilbert. Even though I mostly develop in 2000 now, I still use this book fairly frequently.

I am using Rumba Object X in a VB executable to hit an Access 97 db. We have a mainframe based loan system from wence we basically copy information into the various fields in the database. The problem is that when multiple users are performing the function of 'scraping' the data from the...