Search results

I've tried that, but it doesn't work However I've since accessed the values by scrolling down each form element on the properties window. However I still can't bring them into view, please help

Hi, I have a form in my db which I've put as a startup form. There's a button in the form which requeries the data; this all works fine. I do this referncing the form, not using a me.requery However I've added a switchboard to the database and since doing this, the requery in my form no longer...

Hi there, I'm modifying a report written by one of my predecessors and I'm struggling to view all of the fields in the report. The report is sorted by 3 different values from the query. Each one has their own header. Theproblem I have is that for the 3rd header, there are no fields in the...

Hi there, I have a form which displays data from a combo box in the header of my form. Each row of the detail from the form contains two values from the database.. one is called case ref and the other is a checkbox for completed. Here is what I want to do.... 1) chose which rows I want to...

thanks I've tried that, but it does not enable me to order by the results from the 'like value *' before the ressults of 'like * value *' As a way round I've written this query: SELECT [Cases Textbox Query].* FROM [Cases Textbox Query] order by [Cases].[Case Name] asc UNION ALL Select [Cases...

Hi there, I usually code in .net or asp, but am building a system in pure access. I want to do the following from a textbox on a form.... 1) Lookup all values in a table that match textbox.value * 2) lookup all values that matach * textbox.value * I want to display the values that match...