Search results

Any help on how to do that? Brain's gone dead and I really cannot see it. Also, co you do the OpenForm command based on each value in the list box, as that's what I'm after?

Hi All, 2 questions; Firstly, is it possible to hide unchecked values in a listbox? I have a user with several roles and I want to only show the ticked roles in the listbox. Secondly, can you create a hyperlink on listbox values? i.e, if I click on "Manager" in the roles listbox, it...

Sorry you were right the first time, I mistyped something in the code. The NZ-999 code works perfectly, thank you!

This returns the result when the combo is selected but when nothing is selected, the query is blank.

I've used this before but it doesn't return blank results if that field hasn't got a value in the record, and it also means you have to specify another criteria to get that to work. I'll give this a try.

The criteria I'm using is Not Is Null And Like "*" & [Forms]![formname]![comboname] & "*" How do I do that?

Yes my search is from a form, I specify various criteria from text and combo boxes and hit search to open a report.

Hi All, Having a very odd problem with my Autonumber ID. In my database there is a table of customers which drives a combo box in a form, and there are nearly 2500 customers in this table. I searched for a specific customer and I got 2 different customers come up, and I've found the reason...

My current expression is this HOURSCALC: FormatDecimalTime([TOTAL JOB QTY]/[RUN RATE]) However I still can't set the totals to Sum on the PivotChart view, it only gives me the option of count. The code for FormatDecimalTime is this; Function FormatDecimalTime(DecimalTime As Single) As...

I tried something like this but then I ran into the fact that the calculation is also based on another field, so how would I go about that in a single column on the query?

Hi All, In my form I have a calculated field that works out the time elapsed for a job, worked out as the QTY/RUN RATE which gives me the time in hours. However I couldn't format the box as a date/time, as it is a calculation and the times may go over 24 Hours which results in the date/time...

Fixed now, used the acCmdPasteAppend command in VBA instead.

Hi All, I've rebooted my copy record button and just used the macro wizard for now, it seems to work as far as I can tell but there is something strange about it. I've added in some text boxes so I've got some confirmation, but when I click this copy button I get the following error; "The...

What's the difference between this and Compare Database? In all honestly, I have no idea what either one do, but access automatically puts it at the top of every module.

I just tried this and it didn't work so I set it to Form_Dirty and it works now! The idea behind this is that a user can't accidentally edit something, as it's a bound form, without knowing as it forces you to save if you've changed something and try to change record or close the form. EDIT...

Hi All, I have built a save button into my form, with the following code; Option Compare Database Public txtClicked As String Private Sub cmdSave_Click() If Me.Dirty Then txtClicked = "Yes" 'SAVE button has been pressed If MsgBox("Do you wish to save?", vbYesNo, "DST...

I can change it but only when all the users are out of the backend, as it's a design change. I've made a copy and changing to a number field definitely works, I'll try the other method now if it means I don't have to go and make design changes and kick all the users out. Thanks guys EDIT...

On my report I have it grouped by something called running order which is quite literally 1, 2, 3, etc. I'm wondering if it's because it's a text field, but when I group it, it goes 1, 10, 11, 2, 3, 4, etc whereas obviously I want to go in order. Is it because it's a text field or is there...

Got it, thank you guys!

Hey all, not sure if this can be done but worth a shot. Currently, the navigation buttons on my form go to the record based on the record ID. Is there anyway to change the order of the records it navigates to? Ideally I'd like to have it sorted like this; Date 01/01/14 Customer A Date...