Search results

I attach an MDB that the has the multiselect listbox control. I would however, like to include on the same form a criteria for a date range; start date, end date and then build that into the sql when I run the query. I woiuld also like to make the "All" stay at the top of the list box. Can...

Openform Hi mtairhead Thanks for that but that doesn't tell me how to achieve that from clicking on the list box. Could it be something like this DoCmd.OpenForm Me.ListBox.Item2 then Forms!MyForm=Me.Recordsource = "Query1" or could it be that I need to use the case statement or something...

I have a list box on a form with 10 items to choose from. When a item is chosen I want a form to open (OnOpen or OnLoad Event ??) with a recordsource depending on one of the 10 items chosen in the list box. The recordsource is an sql statement which will change/depend on the item selected The 10...

Hi Skea Yes, I saw your post. But I need to reference the new file names from a field in a table and your example is for one file only and not hundreds.

Skea Nothing happens. Doesn't work Have you tried it ?

I need to rename files contained in a folder. The new filenames are held in a table along with the corresponding old filenames. Example Table1 Field1(OldFileName) 100026578.jpg Field2(NewFileName) Pic6589ST.jpg Is there any VBA code that can use the NewFileName to rename the files in the...

Caption Hi RuralGuy Yes, that did it. Thanks for that. It looks so simple

I have a form with a subform. The subform displays records in datasheet format but is not linked to the main form. I am attempting to get the hightlighted record on the subform to appear in the main form's caption bar. If I isolate the subform then that subform caption shows the current record...

Is it possible to align text inside a multi column list box. For example, currency field is always aligned to the left where it should be right aligned. Kappler

I have the following Sql statement which will append to a table called Times. Before it does I want to test that the value of Log.Field2 after SELECT has a greater (date) value than a field called Start in another table called DateChanges. DoCmd.RunSQL "INSERT INTO Times ( Tel, DateLog...

How to create a number sequence in a query that changes when a value in a certain field changes. For example: ID City No Sequence 121 London.....1 121 Oslo.........2 121 Berln........3 122 Paris.........1 122 Rome........2 124 Moscow.....1 125 Madrid.......1 125...

Number sequences Hi WhizzKidWallace Are you still around ?. Would like to know how you got around the problem of number sequencing M Kappler

Number sequence WhizzKid Wallace You said you found a solution to the nuber sequencing. Would you kindly let me know what you did ?