Search results

GHUDSON...! Yes sir. I will try this for our MS Access 2000 version. Great tip and thanks in advance. I've made a backup copy of the problem database just to help prevent any further corruption and I'm going to this site to give it a try. I did try the normally undocumented "decompile" option...

Condition critical too! Sorry to hear Newman...I'm having my own stress over the same messages but using; Access 2000 Pro running on Windows 2000 as a split database. The fe will compact but trying to compact the be doesn't work; I've tried compact/repairing it from an empty shell, from the...

Hey Pat! Thanks...as soon as I entered the next nested IIF (the And condition...), the value returns #Error but the formula works through the point just prior to that. I'm going to try one more thing and then give the VBA code a try.

Monster Calc almost solved... Re: the Monster [txtEarnRes] calc...I'm able to get the results I would expect through the following level of this sucker but it blows up when I try to add any additional nested IIF conditions... It works through...

Hello all! :cool: Here's one for ya... On a form, I've added several calculated controls. Originating from an Excel sheet, I would think the same or similiar formulas would work in Access but no luck...check it out and see what you think. [B][txtMonElap][B] = working; a field that calculates...

Degreed or not, it comes down to the specific need and opportunity with the employers in your area or in the perimeter of where you'd most like to work...it makes no sense because it's not supposed to... I've found the best opportunities by being that unique enough of individual that offers to...

Hey HockeyNut! Here's how I broke into the IT vault of opportunity: From within Public Education, I applied for any IT/SYS Administration positions and accepted every opportunity to take on extra IT-type work... Beginning with record proofing and editing, I moved up to technical writing and...

...yes...and one step better...:D There is a full color User's Guide that I wrote and printed for each user...steps through each screen, all facets of both switchboards, applications, etc... fun to write! When I worked for the Denver Schools, I wrote a novice/intermediate level User's Guide...

Hey Rich! ...that's a little GIF, huh?...!@#??!#!? I had this as a screen print in Word that shows much better but only zip's to 293K...to big to post here...

As promised...earlier...sorry...but still, here's a sample screen of one of my favorite switchboards, as it relates to this thread on buttons... :cool:

Hey, make that bank, that's right! How about "ACT" but customized to meet your client's specific needs?...just an idea. My office uses ACT and some prefer it to Outlook. Customizable, I'm not sure...I prefer Outlook for the spam and virus control/security and exporting (backup) features...

MS Outlook?... MS Outlook is the best way for entering and printing monthly calendar notes. From the Calendar screen, just enter the events for each date and then send the calendar to your printer as normal. You should be given a choice from daily, weekly, monthly, or tri-fold printing as...

...Ping?$?@??!...! I just checked with a "network" guru friend of mine and he suggests to "PING" the address as well. Restart your computer in MS-DOS mode and type <ping> followed by the address you are testing. If it is live, it will return packet information, proving it works. i.e.: <ping...

ghudson: Thank you sir! I'll post a screen shot of my switchboard tomorrow morning (2/24) so you (ghudson), Vassago, and everyone can check it out if you like... as you'll see, I like contrasting colors... I think this is just, design wise, something end users appreciate. All of my clients...

Ripper/...Betelguese...Beetlejuice...Beetle..."come on just say it?!@$?$%?#@?! Check out: <www.Freebuttons.com>:D I've used these buttons to enhance my switchboards and all of my clients like them...so far...?$?$??! Hey, check them out and let me know how I can animate them; so they depress...

Only1Abhi: Yes, please do post your search facility for me and everyone else who's interested.:D

With so many books and training guides out there, I've come across the following as being some of the best: by Prague/Irwin - MS Access 2000 BIBLE; Gold Edition: ±$55. Includes a free 3-month trial of SQL Server7! All code from book! Very detailed and easy to follow! One of the best...

Jathayer: I used to work for the Denver Public Schools and they have a very good and reasonably stable Master Student Database called SaSIxp... It features record data for all 86+ schools, every student (86,000), all demographic data, all admin. data, all curricula, etc...pretty...

If your department does decide to use MS Access faithfully, I would suggest that you offer the most user-friendly designs and development possible; i.e. Switchboards. All of my Access databases feature user-friendly and resourceful switchboards that include various forms and administrative...

Compact often; daily, especially if you are adding so many objects but one thing from my experience...only develop and add those objects that the database will really need and call on...don't create "dead" or a lot of unused objects that just hang around. Also, when sending it over email...