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...

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...

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...

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...