Search results for query: *

Yes HarleyQuinn. There is a subform on the form, which has master/child links with Category (has them with an unbound text box which stores the categoryid for the selected category). I didn't mention this as I assumed that any change would make a difference as the links are with the unbound...

HarleyQuinn, the tabs might work. Can you, on open of the form say, make a number of tabs dependent of the number of categories? So say there is 5 entries one day, when you open the form it makes the 5 tabs and populates the name with the category, and the next day theres 6 entries, so a new...

I also want the users to be able to just click the category name, not have to open the combo box and click the category, thats why I wanted a list box originally. A messy way that could work is to have 5 list boxes, and set the rowsource to "select cat from table where catid = 1" on first list...

Hi everyone, The 5 entries are categories from a category table. At the moment there is a next/previous category button, and the category is displayed at the top of the form. What I want is to remove the buttons and let the user click on the category name instead (with them all being listed)...

Hi, Im using Access 2003. I have a list box on a form which pulls data out of another table. There are 5 values, but 1 or 2 more may be added in the future. What I would like to do is have the list box not list the 5 entries downwards, but going from left to right instead. Is this possible...

Thanks Duane, i'll take a look at that tonight and over the weekend.

Hi, This thread can be seen as a follow on from an earlier thread i made, but that thread was how to make the chart in question (thread703-1442834). I have two boston charts in Access 2003, with row source set to a query. What I want is to be able to have some sort of IF statement in the...

Hi Terence, In response to your queries on how to upload files on here, go to this site http://www.mediafire.com/ . Simply click the browse button to find where your file is (if you have more then one file, choose a number before this, although I have ever done one at a time), click "upload...

Hi nobull613, Apologies, if you are using the code I put up, you will also need this in a Module: Public Sub RunProgram(strProgram As String) Dim lRet As Long ' Execute the API call lRet = ShellExecute(0&, vbNullString, strProgram, vbNullString, vbNullString, vbNormalFocus)...

Hi missinglinq, As this is a commonly made mistake, should this be made as a FAQ? Andrew

Awesome, thanks Ken.

Hi, I have two list boxes, one a single select and one a multi select. I have a button which unselects the item in the single select list box, but it wont work for the multi select list box. Here is the code I have for the button: Private Sub cmbUnselect_Click() Me.lstGrouping.value =...

Thanks PHV, got it sorted with the Union query, here it is: SELECT Corporate3rdParty.Corporate3rdParty as ListName from Corporate3rdParty union select CorporateCommercial.CorporateCommercial as ListName from CorporateCommercial union select CorporateTechnical.CorporateTechnical as ListName...

Hi, I have 9 tables (each with 3 columns) that are all similar to each other. Want I want to be able to do is select the data from the 9 tables (the middle column), and have them all put into one list box. So something like this: Listbox Tbl1 MidCol Tbl1 MidCol Tbl2 MidCol Tbl3 MidCol etc...

Have you asked MS where to download them from? Ask them to specifically tell you where they are, or to send a link to their location. Andrew

Hi, Im not sure about the settings part, but I have a button on one of my forms that opens up a word document, and it also opens a pdf file as just tested with a pdf file on my pc. Here is the code: Private Sub cmbOpenFile_Click() RunProgram "Enter path name here e.g. C:\Documents and...

Does Forms![Vendor Information]!VendorID.SetFocus work? Also I assume there isn't a full stop after the '!' before VendorID in your code. Andrew

Are the 50 or so fields all the fields in the table? If so you can just do SELECT * (which is select all). If not, and there are only a couple fields you dnt want to select say, then im not sure if theres a way of not selecting a field from all (for example 'select * but not field48') if you...

I think TheAceMan1 was saying about preventing users from being able to open the date time properties (double clicking the time in bottom right corner, or date/time from control panel). Andrew

Woohoo its working now. I made one that combines the currency and decimal, as I found that if you put in a decimal number in the currency, it doesn't give the right answer (puts in extra zeros in place of the decimal point, and decimal figures). Here it is: Function denomWork(lngField As...