Replies

Okay, try this sample. I have left the departments to show ‘All’ (I thought that was a neat trick), and now you have two combo boxes for the Account #’s. A start and last. The Last will refresh whenever the ‘start’ is changed, to show only account numbers lower (or equal) to the start.

Hope this helps.

This was interesting, so I thought I would post it to the lounge. My Dad is taking a VB course, so naturally he is calling me for help here and there. Last night he had a wierd one. He said that the menu Access keys weren’t showing up underneath his menus. Today he called me and said that someone pointed out they had the same problem, however, when you press the Alt key, the menu ‘shortcuts’ showed up, until the focus when back to something else. (By shortcuts and access keys, I am talking about the underline under the letter that will open the menu. (ie, &File as a menu’s caption/name will show an underline under the F. Thus, hitting Alt-F will drop that menu).

I finally found what caused this. It’s wierd. I have noticed that some software displays them automatically, and some don’t. IE 6.0 displayed the same behavior as my Dad’s VB issue. I discovered that in your Accessibility Options (in your control panel), under the Keyboard tab, there is an option – “Show Extra keyboard help in programs”. If that is checked, VB’s (and everything elses) menu’s display the underline all of the time. If it is not checked, then the shortcuts only display after you hit the Alt key.

Just thought that was something interesting to note.

I’ll take your word for it, you didn’t have to show me!

I think we are going to get punished by a moderator soon!

Another FYI, if you switch the ‘view’ in Windows Explorer to details, you can sort your files any which way you want.

That could explain the nightmare I’ve been having lately with DSL providers!

Gotta love computer lingo sometimes. Breaking a mirror is not as bad as inserting your floppy!

I have ‘copied’ shortcuts before, and the situation where I was doing so was when I had made a ‘custom’ shortcut, like a shortcut to a secured Access mdb file, that had command line arguments in it, to point to the correct workgroup file, and possibly even a username and password.

Just a little warning. I know this is the Windows 98 lounge, but when you start copying shortcuts in Windows 2000, it’s a whole new ball of wax. Windows 2000 ‘marks’ its shortcuts, so that if the file they are pointing to moves, the shortcuts adapt. It’s slick, but it has issues if you send someone a shortcut. One issue, is that the shortcut actually points to the machine that made the shortcut. Not a problem if you have access to that machine, but if it is off, the shortcut won’t work.

If you are in Windows 2000 and up, just use Disk Management. Do not partition the 20 gig, just right click on the 8 gig partition, and select ‘Add Mirror’. It will prompt you where you want the mirror added.

I did something similar a few months ago, to replace a hard drive on my server (a glorified desktop….hehehe), I just mirrored the OS drive, then broke the mirror and booted from the new copy.

Since a system DSN is available to the machine and everyone that uses it, it should be in the Local_Machine root. Where as a User DSN, which is only available to THAT user should be in the Current_User root.

Not exactly sure what you want to do.

If you just want the current date to show up in a field, go into the table design, and put Date() in the Default value.

If you want to increment the date by one (say to enter several entries in one setting), then use the DMax function. This will need to be put in a form’s textbox though, because you can’t use DMax in a table’s default value. So in the textbox’s default value, put DMax(“MyTableName”,”[MyDateFieldName]”)+1

Also, you can tell your users to use Ctrl ; for the current date and Ctrl : for the current time.

Here ya go. I modified the stripped down version you sent. When it opens, you’ll get your form. That form has 2 combo boxes. Department and Account. Both will initially say All. (Yes, they are query driven, but All will show up as the first and ‘default’ value every time.). When you select a Department, the Account combo will requery (and start by showing all again, but if you drop it down, you’ll find only the accounts for that department).

There is also a button, that opens qryData, which is the query you originally had, changed to handle the two combo boxes as your means of criteria. If both boxes show all, then you get ALL of the data. If only one says all, it only filters by the other (either Department or Account), if both are selected, then it shows only the selected data for that department AND that account.

I think my original sample was backwards, putting multiple departments per account, what you posted is opposite of that, multiple accounts per department.

Just an FYI, hitting the ‘Show Query’ button will show the query, but it will not ‘refresh’ the query. Either close the query, or hit Shift-F9 to requery it.

AMEN!

Aha….don’t program in Word very often, so I am not going to be much help on this…..

I agree with Patt. There are only two macros worth using, AutoExec and Autokeys.

Can you post a sample of what you currently have, I’d be happy to take a look. (I just don’t know how caught up the last one is.)

It’s having problems finding your structure.cnf file. I think the ‘site’ you are working on is a subweb. It should have it’s own structure file, so open that php file in FrontPage, and got to the HTML tab. Go to line 82, and remove the period before the slash. If that doesn’t work, you’ll need to find that file. Check out post 217511. Read the three methods of finding that file. Post back with the file structure to where that file is.