Search results

I wonder if someone could help me with this one..... If i tie a query criteria in 'column1' to the value in a combo box like this.... Nz([forms]![FormName].[comboboxName],[column1]) ...then the query is filtered on the combo box or if the combo box is Null then the query gives all the results...

I was wondering if someone could give me a hand with this one.... I have referenced a control on a form from a function in a module using this: Forms(frm.Name).Controls(ctl.Name).Value The function looks like this: Function(frm as form, ctl as control) The function call looks like this: Call...

I wonder if someone could help me with this one, I have a from which has StartDate and EndDate fields. It also has a WeekBeginning unbound textbox. I want the form to filter on these dates so the form only displays the record if it is... a. after StartDate and before EndDate b. after...

I wonder if someone could help me with this.... I have a table of names with start dates and leave dates, the leave dates may or may not exist depending on if they are still current. How would i go about writing a query to include names that have a start date before a specified date and have...

Is there any way to make the column lengths in an access 2007 listbox the same as in access 2003? Thanks.

Is there any common reasons why record navigation would suddenly slow down to an unusable speed if any records are input or removed? The database is on a network and is fine if nothing is input or removed and will accept a few record changes but then after a while it will just grind to a halt...

What is the best way to compare a table with an aggregate query? The aggregate query has two group byand one sum. The three fields on either side have the same name and data type. Someone mentioned union queries are good for comparing but not with aggregate queries.

Hi all, I have been trying everyway i can think of to sort this out but no luck, if someone could help me it would be much appreciated. I have a textbox then a combobox in a line, the textbox afterupdate event code prevents the combobox from dropping down on first click.The textbox...

Can someone please help me reset the format of the code/debugger window. I clicked something and it put the project explorer on the top instead of at the left side where it used to be. I have tried everything i can think of, it is really doing my head in!

Is it possible to open 2 recordsets. Manipulate the data from the first and use it to fill an 'empty' recordset so i could have the data formatted in a way that i could use it as the record source of a report? If so is there any good material out there to read up on this. Many thanks.

I have 1 text box and one combo box I want the combo box row source to be equal to the text box value So in the got focus event of the combo box i put in the code Invoice_Amount.RowSourceType = "Value List" Invoice_Amount.RowSource = Format(Nz(Cost), "Currency") where cost is the name of...

Hi all, Is it possible to have 2 combo boxes on the one form having the same table field control source but be looking at different rows? I am using the combo boxes to look up setting value in a 'settings' table which has a fields like this: SettingID SettingName...

Hi all, Is it possible to order a report based on a field which has a long string value which has been returned from a function? The function returns a date along with information relevant to that date as a string. Is it possible to extract the date i.e. left(strReturn,9) and then order by...

Hi, I want to pass the name of a form control to a function so the function can check the value of that control (Check box) i.e. If Forms![FormName].[CheckBox] = False then ..... Would you send it as a string or a control or ??? and if so how would you go about using that as a control...

Could anybody point me in the right direction? I want to put code behind a command button to open up windows standard 'save to' or 'export to' destination box and then save the selected path in a table so that i can reference this when i trigger DoCmd.OutputTo function to export reports ready...

I wonder if someone could help me with this. I have 2 combo boxes on a form. One with Month and one with Year. I am trying to get a query to look at the combo boxes and return values from a table and thus generate a report. Table has amongst others, these fields; [Name], [StartDate]...

Would really appreciate any help on this, can't seem to find a solution.

Hi, Is there any way to stop label text on forms from smearing? For some reason the font smears or blurs and generally gets dirty looking over a short period of time using the form. It happens especially if you open up a report etc and maximise it for example and then when you close the report...

Would really appreciate some help on this, cant seem to find the solution anywhere. I have a database dealing with timetables and transport needs. I have 2 different forms (Timetable and TransportMenu) which call another form (UpdateJourneys) via command buttons which filter info via macros...