Search results

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

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

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

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

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

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

Hi, I have a subform whose contents are changed based on an option group. When i change the selection, I have the subform being requeried. When this is done, if in the previous selection, the second item was selected, the second item remains selected with the new contents. I need the...

Hi Everyone, I have a list box in a option group. Depending on what option is selected in the group, the contents of the listbox changes. I have the listbox linking updating the form to show the item selected using the findfirst method. This works when the form opens, and when you click on a...

Does anyone know of a way (eg active-x control) where a user can choose the path (like explorer) to save data. This would need to be embedded in the form. I was hoping there was something like the calender control, but don't know one. Please let me know if one exists and what it is called...

Hi everyone, Thanks for any help in advance. I am trying to change the recordsource of a subform at runtime, i know this can be done but cannot get my syntax correct in my vba. The line needs to be in the main form, as a search utility is held there. The main form is called [Campaign Search...

Hi everyone, Thanks for any help in advance. I have a subform containing to items, unique is (join to main form), and destination name. I am trying to get the contents of this subform, ie HGJ HGF HGF HGF into a recordset, i can get all the data from the table the subform is based on, but not...

Hi everyone, I have a database, with a one to many join, the one side is correct, but the many side i could do with merging into one record in a query. ie. 1 side: campaign, code, id many side: destination code currently the many side contains data in the format MAN LPL GTW I...

Hi everyone, Thanks for any help in advance. I have a list box which has a different row source depending on a condition selected in a option group. When changing the option group, the list box updates, but the form remains on the item selected in the previous selection, even if it does not...

Hi everyone, I need to loop through the values in a query to create a new complex sql statement off it. (Merging three crosstab queries) The query has a maximum of 16 records, so I have to join the three crosstab queries together for each of the individial records. The new sql statement I can...

Hi everyone, I need to change a query at run time in a form. In one condition it will have less tables, so will need to seperate queries. Can you change the queries sql at run time, whilst keeping the same query name. The query will then be used at the foundation of a complex report. I do not...