Search results

Thanks!! That worked!! Thank you. That worked, is great! Is much appreciated! Chris

Hi all, I need to import several files with a really daft naming convention. An example of one of these is CDR_URW_05_NTS_20030815_20030815_001417_0000000687.new These files are csv files, i know the filename and path and can predict the filename upto the CDR_URW_05_NTS_20030815 which is...

Will give the linked queries a go!!! thanks Yes the start and end date are generally the same but not always, I will give the linking a table to itseld a go. Thanks for the advise, much appreciated!!! I am more comfortable with queries than with recordsets, but thanks for the help. Chris

Hi All, I am stuck with this problem, and could really do with some help. Thanks in advance for any!!! I have a table with the sample data below CLI StartTime EndTime 0161292 01/08/2003 13:56:36 01/08/2003 13:56:36 0161292 01/08/2003 13:45:31 01/08/2003...

Hi all, Thanks in advance for any help. I have a subform which contains the following details, NumberId, Valid_From, Valid_To, In_Use When the use changes the in_use item (yes/no) i want to write the current record to the table with the Valid from_from date entered. Then i want to create a...

Thanks, That was a great help!!! Is working now fine. Chris

Hi All, Does anybody know if it is possible to group by hour then 15 minute intervals in a query. I have date like this booked cost 15:47 9/7/03 £79.00 17:13 9/7/03 £114.68 I would ideally like to see totals of the cost...

Hi All, Thanks for any help in advance, I have some data that needs grouping into weekly totals, but based on Monday to Sunday, instead of the default Sun-Sat used by the datepart function. The data is basically Date Pax Cost 1/5/03 3 £300 8/5/03 5...

Hi All, I have an SQL statement that is generated at runtime in a form for running in a report - "SELECT [TrainingTasks].[TrainingDate] FROM TrainingTasks WHERE [TrainingTasks].[TrainingDate] >= #01/05/2003# AND [TrainingTasks].[TrainingDate] <= #24/05/2003#" When this is run is it selected...

Have managed now, have used conditional formating, using expression is [TextOptionVal] Works perfectly!!! Thanks though

Hi, I have a continious form with items i want to enable/disable depending on an optionvalue on each record. ie. record1: textboxoption=yes textbox is enabled record2:textboxoption=no textbox is enabled the textboxoption is not viewable to the user and will not be changed at runtime. I have...

That is great!!! I can get everything working off that!!! Thanks for your help!!! going to carry on adding the other features, but thanks for your help!!! Chris

Cutdown version attached I have attached a cutdown version. I am using Access 2000. In the version provided, Upon opeing the form, the first item in list box is selected, but the textbox to right of it shows no value is selected until row in listbox is click on. I am aiming for the id of...

I have put the requery command on the afterupdate command of the first listbox, and this does work, but only when i manually click on the row in the first listbox. When i change the item in the combobox which populates the first listbox, the contents change in the first listbox but the contents...

Post question is wrong place by mistake! Sorry posted question in wrong place, which is why have re-posted in forms section!!! Thanks for any help anyone can give me on this

Hi all, I have a list box that is required to have the first value autoselected when a combobox's contents are changed. I have this working using "Me.ClerkList.Selected(1) = True" which works. I have another listbox based on the selection in the first listbox. This is set to requery at the...

Hi all, I have a list box that is required to have the first value autoselected when a combobox's contents are changed. I have this working using "Me.ClerkList.Selected(1) = True" which works. I have another listbox based on the selection in the first listbox. This is set to requery at the...

Hi All, I have built a form for user to export an individual record from a form. the user searches for each record in turn. When the user has found the record i would like them to be able to export directly to an Excel spreadsheet. After exporting 1, i would like them to search for another...

Thank you, that helped, and it is wotking now. Chris

Hi, I am stuck on this problem, i have a subform called "List Of All Agents", which is contained in a main form called "Agent Details". I have a option group which changed the content of the subform, but when the selection is changed, the selected item in the subform does not return to the...