Search results for query: *

I am shooting myself on this one. I can't believe it was that easy. I was going down the path of using the hWnd code by setting up a Declaration like: Option Explicit Declare Function apiGetActiveWindow Lib "user32" Alias "GetActiveWindow" () As Long Declare Function apiGetParent Lib...

Probably a simple one, but it's been a brain fart kind of day. I have code that is able to export a report (SendObject) through email (Lotus Notes), but when the vb is over it leaves Lotus on my screen and I want the code to bring be back to my application. I've done it once before but that...

Thanks. I figured it had to be something simple. You really helped me out.

To Skip's point, if you want to make a range that adjusts to the table's length, you will need to set up two ranges. Per my previous example, if column B is cost and column C is Approved, AND lets say the worksheet was named "Data" then you would do the following: Insert>Name>Define in the...

I have never done VB in Powerpoint (just Excel and Access). I'm building a slideshow that prevents people from moving on to another slide until I have given them an access code. I have a textbox and a button on a slide. Goal - make it so that when a number or phrase (like "go") is input into...

I use sumif for this one. Assuming the following columns... A=Initiative B=Cost C=Approved And the data is between A2 and C101 (you said there were 100. Here's the formula that you would put in an easy to view cell (like B102): =Sumif(C2:C101,"x",B2:B101)

Big question of the day is that this DB has been running fine for the longest time...I wonder why it's having problems now?

Yep. Did it twice.

This is a first. There are three queries that I am trying to modify. When I right click and select the design view (or even highlight and click the icon), the entire database shuts down. No warning or anything. It doesn't do this on any other query, just these three. Any ideas? Thanks...

Worked like a charm. I've never run into this before. I wonder why this would cause such a problem. Thank you VERY MUCH! Will

Have you tried importing from the new database, rather than exporting from the current one? If it lets you, you can do a select all when doing an import.

I have not run into this before. I wrote some code to export and email some reports in the Rich Text Format. It was working fine for two weeks (since the program was developed) and then yesterday, no matter what the code says, it changes the name of the report and puts a .xls on the extention...

I will. Thanks again for all your help. I really hate working with Notes....I really do. Will

Hmmm...still not working. I am going to get this, even if it kills me. Thanks for all your help. I think you are steering me in the right direction. Thanks, Will

I ran that code as well and I'm still getting an error. I did find a way to get it back to my app by doing a sendkey "%{TAB}}" command. Given that it went from PROGRESS to Lotus Notes, the Alt+Tab just brings it right back, but I would much rather call the application by name. When I look at...

If I go into the properties of my app (currently on the desktop), it says: PROGRESS CMS.mdb If I go into the startup, it says: PROGRESS CMS If I look at the development area (tables, queries, etc.), it says: PROGRESS I also have tried running with: strCaption =...

Did you mean: AppActivate "Microsoft Acces - [Progress]" (closed bracket at the end)

I put in: AppActiveate "Progress.mdb" (my application is called PROGRESS). When I did this, I got an error. The application is open, so I'm not sure if I am supposed to input a path. This is a challenge because many people use the front end and they could have it filed in different spots...

Okay.. this should be an easy one but I'm having one of those days. I am running some code that outputs a report through lotus notes. When it is over, lotus notes is what shows on my screen and I'm trying to get it to come back to my application. I tried the "DoCmd.SelectObject "Switchboard"...

Will do. It might take a couple of days. I'll probably get a chance to work with it on Thursday. Thanks again.