Search results

Hey buddays, So, I've got this report, and I'm pulling the top 10 costs of orders in the source query using the TopValues property. (10 records. Easy.) But the execs want to compare across years. So... What if I want the report to show the top 10 orders for two years? In other words, group...

Hey buddays, I'm not sure what the definition of this type of concatenation is, so I'm having trouble searching for it. I have three tables - one is tblNames (with ID, first_name, last_name) with 25 records, and tblStates (with StateID, state_name, state_abbrev) with 50 records, and the...

Hey buddays, We recently sent out a questionnaire/suggestion list to a bunch of employees (several hundred) and are expecting responses soon. The questionnaire is in Excel format with two worksheets. The first sheet is locked/protected and only contains instructions for users. The second sheet...

Hey buddays, I have a contract-tracking database that has been in use for about a year. It used to be that every contract had the same number of periodical "applications" with it - the companies we worked with would send in 4 applications over time. So, I had this set up: tblCompanies (the...

Hey buddays, I have a form with a bunch of Count totals in the footer. There are 12 different areas with a number of projects in each area. So, I'm counting the total projects, and then I'm counting the instances of an area in the area column...12 times. In the query, I have 12 different...

Alas and woe; I have been stricken with the "Cannot find the object MSysDb" error. :( (Note: MSysDb is not to be confused with MySysDb.) My DB is unopenable. The objects cannot be imported into another database. The Jet Compact Utility from Microsoft's website cannot compact the corrupted...

Hey there buddays... I have a rather large database that is split into a frontend and a backend. The backend resides on a shared drive while the frontend is on individual users (about 5 or 6) desktops. I can't do any administration on the shared drive, i.e. I can't hide the backend from...

Hello buddays, I'm almost sure I've seen this problem addressed here before, but I wasn't able to locate a relevent thread. I've got a calculated text box ("txtTotalScore") in the footer of a subform. The subform contains a a tab box with three tabs. Each tab has another subform, with yet...

Because my users like the standard safety net of "Do you wish to save these changes?", I used some code from this post in the Before Update event of many of my forms. However, many of the users, being proactive, conscientious sorts, like to Save on their terms. So I put in a command button...

After poking around the forums and looking in Access help under "specifications", I see our pals in Redmond say that Access can handle 255 concurrent users. (I spit out my soda with a chuckle.) After poking around some more, I see that the consensus is that Access will begin to choke depending...

Hey buddays, I recently started working for a large (!!!) company and successfully managed to switch my department over to a DB management system (using Access, since that is what I know) after years/decades of using spreadsheets. My higher-ups have been so amazed at my parlor tricks, that...

Oh, buddays. I have a hefty database with a series of full-size forms which act as navigational menus. The VicePrez has asked for some dropdown menus which will further open particular forms (to cut back on the number of buttons per screen). I tried using the combo-box dropdown wizard to put...

As someone who's worked with Access since 95, but only started developing in earnest a year or three ago, I often find myself spending an inordinate amount of time going back and fixing silly mistakes - correcting naming conventions, correcting forms built on tables instead of queries...

After lurking around the forums for a couple weeks, I've decided to undertake some DB redesign, and I could use some guidance towards achieving my goals. At my company, we send out a contract (consisting of many exhibits) to our consultants every year, while tracking correspondance with those...