Search results

I searched the forums, but was unable to find anything that matched what I was looking for, so I opted to start a new thread. If this is already out there somewhere, I apologize for this thread :) Anyway, here is what I am looking to do: 1.) Generate a random number between 1 and 100 and...

I have looked and looked through the forums and while I found references to my issue, I was unable to locate a workable solution. Doesn't mean it isn't there, I just couldn't find it. Here's what I have - I have a form named 'MainMenu'. 'MainMenu' is linked to a table named 'Pending' (this...

Hi everyone :D A friend just came to me with an Access related questions that has me curious. I think that I have seen what he is trying to do before but couldn't puzzle it out myself. Here's the basics, he has two items on his form, the first is a drop down box and the second is a text box...

I'm looking for a really simple way to do this and I didn't see anything through my searches of the forums. So, here goes (if I missed a post covering this, please don't kill me ;) I have db with two tables (Action and Archive). The Action table has over 1500 records, but the records come in...

Howdy folks, I've got an annoying little problem that I could not find an answer to searching through previous posts. I've developed a rather extensive report that contains several sub-reports and several fields configured 'to grow'. For the most part the report looks great; however, every once...

I've checked through the forums multiple times for something that will work, and so far, nothing has worked. I have a db with a single table and a single form (for data entry). However, because of the amount of data and the required format of the report, I have had to create a report with 3...

Good evening (OK, it's evening here, now) I have a simple db that I created to make a reporting process easier. Within this db I have two tables, a main table and an archive table. My thought process is that when a report is finished the user can click a command button and the record...

I'm trying to find a way to merge or combine severl different reports based on the results of a filter. For example, lets say I have 4 tables: Tables A, B, C, D Each table contains different information and has multiple records. The primary key field for each table is the same. Each table also...

Report and queries, aaarrrrggggg I am currently working on a database to assist with the reporting of various incidents. Since all incidents tend to be different, I have had to create numerous different tables, some or all of which may be used to report a single incident. Anyway, my problems...

I know this bulletin board is for Access database programming, but the level and quality of the information here is better than anywhere else I've seen, so I thought I would post my question here, even though it pertains to an MS Word Macro. I am working on a document that contains numerous...

Is there any way to program access to run a macro once a year on a set date?

Working on a db for use by, well, idiots. I've developed a form with a command button that executes a filter based on entered parameters and sends the results of the filter to a report and closes the form. Here's my problem, after clicking on the command button, the parameters box comes up just...

OK, I've got two questions regarding filters, more specifically, criteria for filters: (1) Is there any way to make the selection from a combo box the criteria for a filter? (2) Is there any way to set the criteria so that it will return similar words. For example, if I want to filter for...

Hi folks, I posted help in this area previously and still can't get things to work. I did change my approach somewhat, but aarrrggg!!! Here's what I am trying to do: Create a field the creates sequential numbers starting with 1 and increasing by 1 for each new record. Then, when the year...

I am attempting to develop an Access database to track reports and paperwork. All these documents have a unique report number attached in the form of the year-## (example: 2001-15, 2001-16, etc.) In addition, when we enter a new year, the number reverts back to 1 (example 2002-1, 2003-1, etc.)...