Search results

Any thoughts on this? I'm still working on the answer on my side. It is driving me nuts. Thanks Eddie.

Hi, The attached database has a report called The Book. One of the text boxes in that report is called Duty. It should relate back to infomation in the table called Container_Vendor_Information and the column named Duty within that table. For various reasons I had to make some changes to the...

I was able to figure it out. Thanks anyway. This is issue is closed. Eddie.

Hi again, I'm not sure if I expressed myself clearly enough the first time. Reading back on it I don't know if I gave enough information. The attached database (see first post above) has a form called Broker Information. Within that form is a subform called 02-28-07Query subform. In the...

Hi, The attached database has a form called Broker Information. There is a text bottom at the bottom of the form that relates back to a text box that sums a column in the subform. For the life of me I can't figure out why is it now working. It looks exactly like every other form I have set...

I was able to figure it out. Thank you for you time anyway. I'm sure I'll have other questions soon enough. Eddie.

That last reply was spam. My post is real. Moderator please don't close it down. Thanks Eddie.

I'm getting closer. I got the query to open and close. The problem I'm having now is with the subform. I can't seem to get it to populate once the Unique Number has been entered on the main form. Any thoughts? Thanks Eddie.

Hi, I'm plugging along on a database taht I have been building for a while. Many of you hear have been most helpful. I'm running into a problem with a subform that I have. The form in question is called Broker_Information_Entry. The details/problems are: 1-The first field BOL_Number...

Don't get me wrong. I am most grateful for your help. I didn't do exactly what you did but your help showed me the way I needed to go. I know have it working the way I want it. I would not have gotten there without you doing what you did. That showed me the path I had to walk. I am most...

Hmmmm. I see your point. I'll have to look into our process. Thank you for you help. Eddie.

That is further than I was able to get with it. However, I want the unique number to populate automatically. I'm not looking for a drop down list. Thank you for your help. Eddie.

Thank you so much for you reply. I will print up your answer and go through it. Eddie.

I'm sorry but I don't understand what advice you are giving me. I'm sure it works but I'm not sure how it plays into what I'm trying to do. If I put the dlookup formula in the text box shouldn't it pull up as long as I have the formula correct? Thanks Eddie.

I'm so sorry I didn't attach. Here it is. I'll look into your comments right now.

Hi, The attached database has a table named Broker_Information_Entry. The second field is named Unique Number. I'm trying to get the Unique Number to populate based on the BOL number entered in the field above. I have tried several different things but can't seem to get the formula to work...

Hi, I'm having a problem with the attached database. There is a form called Broker_Information_Entry. The first field of that form is called BOL_Number. There is a query called BOL_Number_to_pull_up_Unique_Number. Here is what I want to happen and then I'll tell you the problems I'm...

Don't be sorry at all. You helped me. I am more than happy to listen to any advice that anyone has about Access. Thank you so much for your time. Eddie.

Thank you so much for your quick replies. It works great now. Rural Guy, why would I have less problems if I didn't have that field set as my primary field? I'm relatively new to access and always trying to figure out how to make it work better. Any thoughts on why that makes a differnce...

Hi, The attached database has a form called BOL_information_entry. The first entry box on that form is called BOL #. I do not want to be able to enter duplicates into that field. Currently it will tell me if there is a dupe but only when I try to update the record. The subform may contain...