Search results

I have tried this, as the event is on the option group, i have to use [Forms]![Agent Details]![List Of All Agents].Refresh. This does not work, as the method is not supported. Please help, i have been working on this for ages. Cheers. Chris

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

Further Information- The exact error message is "To few parameters. expected to", this is an error no 3061. It occurs on the line Set rs = db.OpenRecordset("Top 16 Destinations", dbOpenDynaset) I am pretty stumped, so any help would be greatly appreciated. Thanks Chris

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

I am trying to allow the user to search the database by selecting multiple items from a list box. I have tried code from microsoft using instr or inparam and neither of these work, they compare strings but items which only contain part of the full string. I need exact matches. I have tried using...

I have a form with a multiselect list box, this is populating a text box with a criteria so search on in a query. The criteria is formated with or's in it, ie. selection1 or selection2 or selection 3 When I reference this text box in query is works with only 1 selection, but multiple brings up...

Hi everyone, I am having a problem summing a text box in the detail section, in the report footer. The text box contains a complex formulae, but is named. I can sum the fields refered to by the text box using sum([Main Operator Earnings]), but if i refer to the name of the text box using the...

Hi everyone, I am looking into having a log of record changes in an Access 2000 database. I have looked in different sites and have discovered the currentuser() function, but I know staff in this business would abuse this. Is it possible to reference the logon name for nt/2000, and if...

That would work on a text box, but not in a combo box. The default value needs to be one selected from the table containing the month names. Hence I think it would need some kind of select statement, but I can't see how to do it. Chris

Hi everyone, It would be a great help if someone can help me do this. I have a combo box, for selecting months in. This is based on a table containing a unique id, month name, month start and end date. I would really like to be able to have the current month displayed as the default value...

Does anyone know how you can change the "AllowAdditions" property of a whole form at run time in Visual Basic. Thanks for any help given. Chris

I am not trying to change the recordsource of a field though, I am trying to change it for a complete form. This can be done from within the form to be changed, using Me!recordsource="Select * from blah blah", so can be changed at runtime. I need to be able to change from the main form though...

I have just tried this, and i can not get it to run. The record source of the form is changing between two queries, the expression builder lets me select fields of the query, but not change the recordsource of the form between the two queries. How can I do this?? Please help Thanks Chris