Recent content by aroth

I have a brain teaser for you guys: Right now, I have a module in Access that creates and sends an email to recipients as they appear in a recordset. I'm using an Outlook form as the template for this message. Set olObj = CreateObject("Outlook.Application") Set olNS =...

Unfortuantely I'm stuck with Access for the time being. You answered my question, though, so I'll have to be a bit creative to make this work. Thank you DevastatioN, for all your help.

My structure would be more like the second one, but instead of 1000 records in a parent table, it would be closer to 30,000. I plan on having 40 parent table (client tables) with on average 30,000 records. Each will grow on a monthly basis. Is this still going to make the back-end too heavy?

Thanks. The 1M records is actually a stacked table of multiple clients' data for which I would run a select query to pull the client data I'm looking for. If it would run smoother to have each client have its own data table then what would be the easiest (automated) way to retrieve this data...

If I may ask a related question: I want to build a table that will ultimately contain over 1M records, each with about 30 columns. I was planning on splitting the database to a front-end/back-end, but would a table that large be too much for Access to handle efficiently? At what point does...

Thanks gemma. I made the page setups match (legal to legal). I even tried to use a different printer with a larger resolution. Neither of these troubleshots worked. Do you think the monitor resolution may play a roll in messing with the layout?

It was built with Acess 2003 (Full Version) using the Access 2000 file format. The End-User is running Runtime (not the Full Version) Access 2000. All of this is using XP Professional.

Hi everyone, I hope someone can help me with this bizarre problem I'm having. I have built a report and formatted it to have "Data headers" organized in columns, yet for some reason, on some computers (not all) the headers for the columns get cut off or overlap as if there is no space. I...

I'm in a bit of a bind here. We are rolling out a database that will have the potential of 200+ employees accessing it simultaneously. It's basically a form frontend with a basic data table backend. The set up is simple, but now when multiple submit, there is the possiblity of overlapping...

There's a lag. After to click in the newly enabled field and then move to another field, the color updates. This is fine for me, since I know the conditions, but this can be rather confusing to the end-user.

They are actually Text Boxes and Combo Boxes.

Hi everyone. I have built a form with many checkboxes and Option Groups and have set up conditional formats to Enable or Disable certain fields based on what options are checked. I have the logic figured out and the conditional formatting does what I want it to...sort of. The fields update...