Search results

anyone? before print my text boxes are 0.4cm high. on the report, they can grow to anything between 0.4 and 1.2cm high I need them all to change dependant on the height of one box in the section.

Hello, I'm wanting all txt boxes in my report to be the same height. 2 of my 24 side-by-side text boxes can grow, because there can be between 1 and 4 lines of data in them. One method i have to make them all the same size on format, is to calculate solid figures on one line and multiply it by...

Legend. Thanks for your help!

Bump. Sorry again but i have a deadline soon and i can't figure this out.

Please note... i'm a young developer and it's all test data. Some records are not for the easily offended :D Cheers Kempes

Hmm.. I don't seem to be getting much luck. I need all records to show up before filtering. I've attached a screenshot of the form. Please note that all text in the combo boxes are actually labels in the background, so there is no "default value" set in any combo box. Private Sub...

bump. Sorry.

Hello, I have a form which gets it's records from qryCompleted. The form shows all records with selected fields in a list. Each title of the fields is a drop down box which need to update everytime any of the other drop down boxes are updated. For example, if cmbCompanyName was updated, then...

Cheers. I looked at your code and i slapped my head thinking "i'm so stupid!!" Thanks.

Hello... I have 2 forms that are being bitches! I have a main form that holds all the data entry info for records except "notes" (which is just general internal notes) and "Observations" (like "notes", but client friendly) Instead of having the text boxes for these fields on the form, i...

create a query which counts the information and just use this as a record source, or refer to it in a DLookup.

Can i suggest using difinitive names for text boxes and combo boxes? This is so that when other people need to edit your project for whatever reason, they wont need to do much work to find out what this bit of code does So if the combobox included a list of colours, it could be called...

Thanks. the project's nearly done actually... this was the last thing to fix before i mass produce a lot of queries and reports etc.

Thanks for the help.. with your info and a few tweaks i got it sorted! Thanks!

ok... dimmed it as string. The other error i'm having is that Percent3 is returning 0. In my test data: percent2 is 24 percent1 is 78 Percent3 should return 0.31 (to 2dp) Why is that happening?

Legend! Thanks.

there's no screenshot. So... if co-worker1 has numbers in 3 of the textboxes, you don't want 'X' entered. But if a co-worker has all 6 numbers in the 6 textboxes, you want 'X' to be added into a different column of the table? If Textbox1 <> "" and Textbox2 <> "" and Textbox3 <> "" and Textbox4...

I'm tearing my hair out here. Public Function IsThereEnoughNumbers() As Boolean Dim Percent1 As Integer Dim Percent2 As Integer Dim PercentResult As Integer Dim Percent3 As Integer IsThereEnoughNumbers = False Percent1 = DCount("[company name]", "tmp_sheet") Percent2 =...

well... the problem with this, is that it needs to be: COMPANY % region % region % region % COMPANY % region % COMPANY %

any luck? Can any one else assist?