Search results

Hi All I have a parent Form with two subforms. SubForm1 is a listbox and is unbound. Subform2 is bound to the parent form. What I want to do is click on the listbox and it filters subform2 by column(0) which is the same in both subforms. Any suggestions/tips/good programming etiquette are...

I was hoping to gain some knowledge/assistance as I'm not experienced with Access. I've simplified the code but I'm getting a type error. I was hoping I could pass all 4 parameters through the function but if not, if you can explain why I'm getting a type error when I try and subtract...

Hi All, I'm struggling with amending some code, if anyone has time to look at it, it would be greatly appreciated. Basically, I have 4 dates. Date 1 and Date2 return the number of working days in a period (public holidays are passed from an array) What I want to do is if date 3 and 4 are...

Hi, I found the performance related issue. I was using a domain function on a large Recordset. thanks

Hi All After traversing the web for 6+ hours and finding no solution, I'm holding my hands up and asking for assistance with a problem. Is it possible to read in records from a parent form and then do a group by these records on a subform that is continuous? If I make the query directly to...

That is exactly what I'm looking for! Really appreciate your help with this. Many thanks to all who contributed.

Is it possible to load up the parameters from the record source and then apply the function to these parameters in the after update event? So Query A is the record source that contains parameters A and B, so using your example as Me.RecordSource = "select " & Function(parameterA, ParameterB) &...

thanks for the reply

Thanks for the reply once again. As the record source in the combobox - is it possible to add a function to the SQL statement? similar to SELECT Function name(parameter1, parameter2) as Name from Sometable where.... These are probably elementary questions but I literally have 20+ hours of...

thanks for the reply.

CJ, thank you for the reply. I have worked around it by applying the function to an unbound text box. I know wish to filter the values either using a filter method or a combobox. I have tried the latter but I am not seeing the unbound textbox as a choice of column. any help would be greatly...

I tried this method in the query design and entered a value to filter by it's still taking a considerable amount of time to filter (10 minutes later and the results still haven't returned). as in put Nz(paramater, 0) - not changed it to an expression. to provide some info on the function - it...

Thanks for reverting back to me. This is sample data (the only sample database I had at hand) - the actual function is a lot more complex. Is it possible to store this data in an array or a record source and then use these in a sub form? I'm not technical enough to know how (if) it can be...

Hi All, I am calling upon your expertise once more. I have what may be a very quick question to answer. I have a main form where the record source is run from a query - within this query there is a function that performs some calculations (the actual calculations are not bound to any field in...

This was the issue...thanks.

Thanks :) Do you have any suggestions on why the code above isn't working? I've posted the run time error that I'm getting. I'm just trying to pass the value in the listbox to a textbox in another form. the other form has an unbound textbox in it.

Thanks for the reply, I have it in the on click event. There's something I'm obviously missing! These are elementary questions but I'm a vba novice. Thanks

The last question on this if I may. I want to pass the value from the first column within the listbox (on Form 2) to a text box on Form3 (Form 3 will be open) . The code I was trying to implement is Me.Listbox0.Columns(0) = [Forms]![Form3].TxtBoxName However, I'm getting runtime error 424...

Thanks all for the various solutions - the Listbox examples were very useful.

Thanks for the reply - is there a way to populate another form from a list box based on which record is clicked?