Recent content by azgambit

Thanks jdraw, I will definitely head over and read up. Apologies for the cross-post. Was not aware the forums were linked. Thought they were separate. Completely my mistake and I do apologize for that :o

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...

Sounds logical to me. Would I place the requery in the code for the save button? And, if I am requering a subform from another subform, how would that be coded? Would it be: Forms!MainMenu!DataRecoveryTotal!form.Requery or something different since the code is being run from the...

The Save button is located on the subform 'DataRecovery'. Maybe I need to approach this from another direction. How about this: How would I place a text box or some other object on the 'DataRecovery' subform that would show the results of the sum-query? Right now, I have a second subform...

Keith, I tried to use the Requiry and placed it in numerous locations. Within the code associated with the 'Save record' button, but it wouldn't update. Case you suggest the exact wording on the requiry? I tried something along the lines of: Forms!MainMenu!DataRecovery.Form.Requery 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...

It worked I guess what it took was a shift in thinking. I'm fairly certain I can write some basic code to do this with a command button. Thanks for the idea, it worked and it got me started. Thanks!!!!!!!!!!!!

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...

Disregard I found the answer I was looking for. Instead of basing my report on the form itself, I created a filter query based on the form and based the report on the results of the query. It all seems so easy in retrospect:D

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...

Thanks for the reply, it is appreciated. I have two questions, the first concerns the size of the db. I had heard or read somewhere that it was best to keep the size of the tables small to avoid slowing down the db. I have one huge table with a couple of memo fields. If I am mistaken, I would be...

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...