Search results for query: *

Hello. I have a mainframe report that I have imported into MSAccess. The mainframe report lists the company code at the top of each page with all related records list below. Once imported into Access, the company code is on one line with related records on subsequent lines. I was wondering if...

That was a good idea Bullsandbears123. However, I have multiple items being received on the same form. And the user can only add records and cannot see the previous days record (unless they have permission) - it's a data integrity issue. So, when the user opens the form, there is only a blank...

Sorry about not posting the code. I've tried so many things with it that it's all screwed up now. Thanks Bullsandbears123 for the tip. It does seem a lot easier to do it that way.

Please help! I have a form that captures the Beginning Balance, Items Received, Items Processed, and Remaining Balance. For each new record added, I want the current record's beginning balance to be the previous records' ending balance. I have tried using MovePrevious and Find Previous, along...

I have a base query where the criteria is based on a form control. I have a 'sum' query built on top of this query. The click event on a form will drive code that looks up a value from the 'sum' query. The question is, how do I reference the form controls in the query criteria if I want to use...

Thanks mbarron, it worked!

I have a spreadsheet where I need the comments to be displayed in the next column. I know you can print and/or display the comments, but I need the comment in an actual column. Have any ideas? Thanks in advance!

TonyJollans, Thanks so much! That was EXACTLY what I needed! This was my first time to use this site for my own thread. You've been very helpful and I really appreciate it.

Thanks, RoyVidar. You have a point. But this db is very simple and I didn't want to go too in-depth.

I think I understand the question. And I've run into something similar. The me![field] is not stored (or saved) in the table until the record is "saved". "Saved" by adding a new record, going to a different record, etc. In my case, I wrote a couple of lines of code to...

Thanks in advance for your assistance. I am performing several actions in an event procedure. One is opening a "HOLD" form, informing the user that activity is on hold until the actions are completed. My problem is, since the actions perform one right after another, my form does not...