Search results

Hi, I have a switchboard that points to other switchboards (sub switchboards so to speak). I'm looking to change header title depending on what I group on that switchboard. However, when if I change one of them I change them all. Example: The main switchboard has a header of "switchboard"...

Outstanding. That works. Thank you very much Bob.

Thanks so much for the quick reply Bob. I'm looking around in the query where the field is. Where would I switch from Long Interger? I don't see that option. Thanks Eddie.

Hi, The attached database has a query named qryInsuranceReport. I'm trying to update the column in that query named Broker Charge PCT. I'm using the update query named qryUpdateBrokerChargePCT to do this but it isn't working. The formula is qryInsuranceReport![Broker...

Hi, I have a report that I'm trying to add something too. I want to count each time a unique container number is on the report. I have the count function =Count([Container_Number]) in the report footer. That counts every container on the report whether it is duplicated or not. Right now it...

Ha Ha. I was just about to post I found it in Output To. Thank you as always for your help Bob. Eddie.

Hi, I want to export a report to excel. Can I do that with a macro? I'm looking through the choices and the Transfer Spreadsheet option is asking me for a table, not a report. Thanks Eddie

Hi, The attached database has a report called The Book. There is a column called Duty. I'm having a huge problem getting it to subtotal and total. I have tried everything I can think of. I'm looking on this site and all over the net for what am I doing wrong but I figure it out. Any...

Hi, You seem to have piggy backed onto the back of an old thread of mine. Not that I mind but you might have a better result if you start a new thread. Eddie.

Thanks again Bob. That led me down the right path. Eddie.

Hi, I hope I posted this in the right forum. It didn't seem specific enough for the other ones. I have a select statement in a form that reads as follows: Select [Port of Origin] from [Port of Origin] It works great. It does exactly what I want it to do. I want to add another field to...

Hi, The attached database has a form called The Book. There is a column called Duty. The data in that column is being pulled via Dlookup onto the form. The problem I am having is with the subtotals and totals. I have several of them set up in the various footers and they are working but not...

Thanks so much Bob. That makes sense. I never know if I need a technical or theory answer. This time it was theory. Thanks again. Eddie.

Hi, I have some forms in my database that pull run various queries. They usually give the user two boxes to enter dates (start date and end date) of queries. They work great (thanks to much help from the people on this board). Is there a way to have to enter something into the form that...

Thank you for your very quick reply. I set the calculation to the default field. It now comes up blank. I can enter manually into it but I want the calculation to appear all the time. Did I hit something wrong? Thanks Eddie.

Hi, The attached sheet has a form called BOL_information_entry. The third field is named ETA date. It is a calculated field. Is there a way I can manually enter into that field after the calculation has been run? I unlocked the box but it is giving me the error message Control can't be...

Thank you both so much for your quick replies. It works now and I see what I was going wrong. Eddie.

Hi, I'm getting better at this access stuff and wanted to thank all of you in advance. I wouldn't have been able to come as far as I have if not for your time and efforts. The attached database has a report called The Book. There is a text box named Duty. That text box should return the...

You are so correct about the naming standards. I'm fixing them as I go along where I can. In the future I won't name things like this. Eddie.

Thank you so much Gary. I knew it had to be something easy like that. I didn't realize that you could add names to the field options. All is working good now. Thank you for your help. Eddie.