Search results

Doh! I am curious why it wouldn't work on the pageheader though.

I have also tried setting the height and width properties to 0, but I still can't get this to work in the pageheader.

I have all the main functionality of my db working now. In my documentation I have created links to the solutions I found in this forum. That way there will be a history on how the code was developed. I have about a thousand records to add before I proceed with new development (something to...

Does anyone know why this doesn't work on the pageheader section?

Finally got it working - thanks Bob.

OK I will have to take a look at this tomorrow - thanks for your guidance.

What do you mean by a whole bunch? There are five tables: Company->Contacts->Transactions->Sites and ECEmployeeInfo->Transactions. These are all simple 1 to many relationships. I need some details from each table in order complete a transaction. What have I missed?

Perhaps the appearance of the tabs is misleading - the two forms Qe and NBCC ARE subforms. They call the same query, and they have overlapping information, but they also have some information that is unique to both forms. Do I have to use separate forms for them then?

I realize two wrongs don't make a right. Eventually everything will be converted to autonumbers. My immediate task is to get this up and running before I retire April 1st. BTW I did a demo of the stuff that is completed for my manager and I think I blew him away. His expertize (sp?) is...

I am combining data with an old dbIII project that had an entirely different structure to it. All the ID fields were text fields. This way (and with some other modifications) I can get the original data into my forms. But this shouldn't affect the form's behaviour. Why can I enter data into...

Part 1: Most everything on this form works the way I want it to, except for one minor detail - I can't enter any data in any field except for the CompanyID field! Could someone take a look and see if they can spot anything? (Yes I know my PKs are text fields - I have a reason for this.) Part...

It more than helps - it works. I was wondering what the units are and I have played around with various lengths. It fits what I need perfectly.

Now that Wayne has solved one issue for me, I have another. I have a text box txtCustomerProjecNumber that appears at the head of a report and at the top of each page. Not every customer has a project number, so I want it to be invisible when there is nothing to show. The following code works...

Cool! Thanks. Now - how does this work? I did look at Lebans MakeFit, but that was forcing the font to fit the fixed width of the text box (at least how I understood it). This is EXACTLY what I want!

That explains what I'm getting. I want the width of the label and the text box to change as needed - not the height. Do you know if that can that be done? Re Stephen Lebans - been to his site many times. I will take a look at his utilities.

This didn't work either

BTW I did do a search on this, but the results were all about mailing labels (not surprisingly). Looked promising, but didn't work. This is what I tried. Private Sub Report_Open(Cancel As Integer) Me.lblTransactionsID.Width = Me.txtTransactionsID.Width End Sub

I am using can grow in a text box. How do I get the associated label to grow by the same amount? For example the width of the label is 5 cm and the width of the text box is 5 cm. With can grow the text box may expand to 8 or 10cm or more, depending on the content. But the label doesn't...

As an FYI - I finally got my manager (he knows VB - just not Access) to look at the code. What happened was I made a false assumption - when I closed the form I thought the code was being saved. Once I saved the code AND the form (as he pointed out), everything worked the way I expected it...

Hmm..logic in programming - what an odd concept. Thanks for your help. I was doing a demo of the db for my manager yesterday when this thing tanked again. Murphy's law.