Search results

The publishing suites have a control like this. I wonder why you couldn't just use one of their activeX controls? I'm sure there's at least 1 public domain/freeware publishing suite, right?

Does this give you something closer to what you need: SELECT name, Levels, Subject FROM Pupil_Results WHERE ((Pupil_Results.Subject)="Maths") GROUP BY Levels,name;If not, why not? In fact, what exactly do you need? Just use the query builder to get what you need...it should all be there if...

LOL. You sound just like 'im.

As far as being on the right track, you're getting closer. As far as the table design being correct, "no". There is no reason to include the Division foreign key in the junction table as you already have that from the Sub-division. As far as whether it is overall what seems right: <personal...

Always happy to help out.

I'm not sure what a division or sub-division is, actually. Is it a geographic boundary? A sports team classification? At any rate, if it is a geographic boundary, wouldn't a person be in one or more sub-divisions? When I consider the motion of people, I see them move 10 or more miles in a...

How stunningly accurate of you! Now see, you caught on that life imitates art. Nowadays, JR and Bobby are like paupers. We all have estates much larger and better than Southfork and we're not nearly as well educated. And our women are twice as treacherous (as measured on the highly...

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...