Recent content by jamesmor

Honestly, if you can spend the money there's a application called MP2 from Infor that will do all that pretty much automatically after you get it set up correctly.

there's that simple answer that I overlooked. Thanks!

How do you guys handle having an error in a nested sub? What I usually do is have each sub have their own error handling that way I can have a variable that tells me where the error happened and use a global error handling routine, which when it's done running it closes access. My current...

I was just merely pointing out that you don't need third party software. Where I work, third party software is out of the question. Yes, they'd rather have me reinvent the wheel than pay $40 for some software so I don't have to. Also, don't know if you meant to come across as condescending...

not really, depending on your proficientcy with VBA. You could check the resolution of the monitor, then resize the form based on monitor size. Here's an example of getting the monitor resolution I found using Google. and here's an example of setting your form height/width using vba. You'd...

Brian, sorry for your loss you'll be in my thoughts and prayers.

Actually Col, this is the first year in many that I'm *not* finding it financially difficult. I will readily admit it was all my wife and I's doing. Won't bore you with details. In any case, hope everyone has a good Christmas

I may have missed something but: When a change record is created, how does the approvers know which record they need to look at? I would assume there's some type of reference number or similar which is stored in the database. Then it would be a matter of parsing the emails looking for that...

Just told this one to my 6 yr old daughter last night. Her response? :rolleyes:

In your error trapping, have a message box spit out the error number like the following On err goto errHandler errHandler: msgbox err.number this will let you validate the error number you're getting. then you can do a "Select Case" on the error number and display whatever message you...

could you possibly put it in a self-extracting zip file? I haven't had to deal with zipping in a long time because I just pass copies via the network, but back when I had to I "remember" using self extracting zip files.

Take a look at either using MySQL or if possible using the free version of MS SQL to show proof of concept and get them to buy. Access *will* work as a front end for both if you need it to.

I think these two lines are both telling your xlApp to open a workbook, the second telling it what sheet to open. Set xlBook = xlApp.workbooks.Add(pA) Set xlSheet = xlApp.workbooks.Open(pA).sheets(1)p basically making your app open twice to do the work of once.

Not to derail the thread, but why wouldn't you lock a record? In a multiuser environment 2 people editing the same record could cause potential problems.

so I set the format to general number, standard number, and fixed number, they all display the same behavior. the only condition set is that if the value in the field is >= 30 then back color is red and font color is white. The only difference is that if I actually set the format then Access...