Search results

MikeD - Glad to hear the advice worked for you! The question is - would it have also worked if you had simply converted it using Save As? Or, what might not have worked? Need to know before I process the next database if I should go back and redo the few that I have already done. :eek...

While this might be an old thread to some, to me it is new. Yes, we are FINALLY converting to a newer version of MS Office. :D Bob Larson - I have already converted 3 databases from 2000 to 2007 using the Save As option and (knock on wood), everything seems fine, so far. You recommend...

This has been the MOST helpful Access site. However, I work for government, have to make my case for other expenses - not sure if they would go for a membership fee for this site. Might have to pay for it out of my own pocket. :eek: If you do go that route, then I favor the suggestion that...

What SPARE time? A LONG time ago when my first child was born, I asked 'what was the best thing that I could do for her?' The reply was to get involved with whatever they were doing. I now have 2 in college and one headed there shortly. Currently, I am the organizational leader for a 4H...

Happy PI Day! The Math teachers @ my kids school starting celebrating this day (or the school day closest to it) a few years ago with pie. My daughter insisted on baking an apple pie for class, complete with a 3.14 made out of crust and added on top of the existing crust (not lattice). Of...

We recently got in some new PCs with Windows 7 Professional on them @ work. I work for county government and we have been stalled on MS Office 2000 for a while. MS recommended upgrading to Office 2010, but we don't have the money to do that - so I tried installing and it looks like it works...

RETIRED! :cool: Good Like colleges today, high school classes available on-line. Bad Earth's resources plummeting as population continues to grow and more people expect a standard of living closer to what those of us posting on this forum have.

As someone who has been involved in the interview end - sometimes a company WON'T hire you if your are OVER qualified. That's where the grad degree could hurt you. Have to agree with experience over master's degree and certifications with experience over master's degree. Biggest problems...

LOL! Re - Eleven tips. Best advice - Was a card that I got with my diploma @ HS Graduation. Turns out it was the last 4 lines of a poem (I just Google it) called "Stepping Stones" by Mary Brooks Picken. Below is the entire poem: Isn't it strange that Princes and Kings And clowns that...

Catchy title! Many years ago, we had a lightning strike hit a tree which was directly over some tunnels that carried our dual coax cable and telephone lines. Luckily, it mostly just fried some of the coax cable and telephone lines. Most of our equipment at that time was dumb terminals. Some...

Rural Guy: Thanks for the response, but I had found that post and already tried using the appropriate bits - just for luck, tried again with same results.

I inherited an Access 2000 Db with an attached menubar, called mnuMain. I can open the Db with the Shift key to see the normal Access menus and I can select Tools, Customize and select it on the list. I have already checked the Tools, References in the VBA module - nothing was marked as...

I finally cracked the last piece this morning. Not sure if this is the best way to do this, but here is one way. In order to get the filter into VBA, it had to be saved. So, while on my form, I ran Filter by Form, then File, Save Query As and called it qryFilter. Next, I setup a macro to...

I work for County Government - which means LOTS of State and Federal forms to fill out and/or info to track. So, yes, there very well could be 100 fields on a form - not in one table Rabbie - but a parent table linked to child tables. For example, imagine a daily ticket tracking the work on a...

So, if I had 100 fields on this find screen, then I would need to put in SQL code for each one? :eek:

I have a form on which I find vendors. The form is called frmVendorFind and the record source is qryVendorFind. I have many fields on the form, which I might use to filter the form, such as a vendor type (vendtype) and mailing city (mailcity). Once I have filtered the form for the records...

FORTRAN - Formula Translation Language, used more for scientific data. I started my programming using Fortran on punch cards. Assembler - Yep, boy wasn't it fun to enter computer commands in hex on a tiny keyboard? :D We usually had to figure out the answer on paper first or else enter the...

LOL Had a few minutes at the end of the day and saw this thread. First, glad it worked out! I have to say that I bought the sexy as well as the practical (gets cold here in Western New York) - but I rarely see her wear ANYTHING that I bought her. I even went so far last year as to have my...

For example, filenames were as follows: hwydlpo;001.ldb hwydlpo;002.ldb hwydlpo;003.ldb etc. and hwydlpo_be;001.ldb hwydlpo_be;002.ldb hwydlpo_be;003.ldb etc. As soon as I saw it, I KNEW something was wrong - but it took a bit to figure out what. In a weird way, it makes sense - since it...

multiple access lock files About 2 weeks ago, we replaced a server at one of our sites. I went to update a program on Friday and discovered multiple lock files for my Access databases. Searched here, found this article. Halted that department from using databases while I researched the...