Search results

Oooooo...you caught me. On both counts.

Of that, I have no doubt! Why I'm just a poor, dumb Texan.

Agreed with both. I've done this several times. You're going to want to use the absolute best cable you can get that will fit between the 2, and the quality is much less than desirable...a regular ol' monitor looks better on mine but it matches the monitor quality for my son's computer. One...

I have had this problem and it drives me absolutely crazy. The issue (I think) is that the container (aka subform) on the tab page (or other container) is slightly larger than (or the same size as) the tab page. This is because with Access form development, there is no WYSIWYG editing. Try...

Oh, you have my curiosity up!

You need to look at update or insert queries in Access help. Then you can run a query in VBA (or possibly in a macro). You can get the actual SQL for a query from the SQL view in the Query Builder. Your code would look something like (warning: AIR CODE): DoCmd.RunSQL "update...

Please re-read my post and answer the implied question: how long do you need it stored? Then look up the topic I point to for each option (global variable vs. storing it in the registry). If it is short term (just during this session), store it in a global variable in VBA (see VBA help). If...

There is an un-commented for j... statement here. That shouldn't be the issue.

If you only need it temporarily (during this open session of the database), you can store it in a global variable and grab it as needed. Declare your global variable as public and put it in a module. If you need to remember it between sessions (after you've exited and re-entered the database)...

What is "QrtOrTblDef"? That was not in the code you posted or in the response I sent you. Please check your spelling. Also, don't bother troubleshooting this from the command button. Go directly into the Visual Basic editor and put it in a module to troubleshoot it (use F8 to single step)...

I got the code to work and got the following result (after fixing the obvious problems): <?xml version="1.0" encoding="UTF-8"?> <kml xmlns="http://earth.google.com/kml/2.1"> <Document> <name>KMLTest.kml</name> <Folder> <name>Test</name> <open>1</open> <Folder> <name>KML</name>...

What line is high-lighted? What is this doing/not doing that you want it to not do/do?

It isn't clear what you're asking for. As far as tidying up the code, that's what Adam was talking about. You need to indent your code so we can read it. A couple of things: 1. You can replace all those If...else statements with a Case statement. 2. If you want to use If...else if...else if...

Also, I don't know much about ppt objects but there are times you are working with an "ActiveWindow" object with the dot "." in front of the object and other times you are not. My assumption is that "ActiveWindow" is a property or other member of a "powerpoint.application" and thus, you should...

I was thinking that Colin, but decided that if I changed it, you wouldn't have anything to comment on.

You see, I saw a British comedy show on TV. It influenced my life. And thanks for the vote of confidence!

This is public information. You can get to them via the main forum menu. There are really only 2 active, per my last review night before last.

Why, because we LIKE you!

Create a query in design view, click on SQL view, paste the text I provided above, test it out. Very simple. Or, using your approach, do what you did but right click on the line between the tables and select all tables in tblclients. Then where you have "=null" replace that with "is null".

I wish I were kitty enough to respond. Maybe I should leave the puns to people who do it better.