Search results

Yes, Colin is correct, the lack of a sort order in the report sorting and ordering will overwrite your original on-load setting. I have had this in the past and despite the lack of logic, I found that giving in and setting the sort order in the correct place makes everything work fine.

Could be completely different but I also have a similar problem. Using Windows 10 my systems do not always connect the network drives on start-up, you can occasionally see a red x against them in File Explorer. If you click on them the system then notices that they are there (and always have...

What you need to do is store the price with the order when you enter it but to take this price from a table of current prices. Basically have a table of current prices which you can update as and when prices change. When you add an order, you can enter the item on the form and default the...

Thanks for all the comments and advice, pretty much what I thought, just hoping for one of those hallelujah moments when somebody said 'just do this', I did suspect it wouldn't happen though. :cool:

After much head scratching, this seems to be a network issue, I am thinking that the maths is done on data not yet received occasionally:mad:

Is it possible to make the standard switchboard multi-column? This may sound a strange question but I find using a switchboard as an entry page for a database for too space-taking. As the switchboard takes the full width of the form, is it possible to split it into two columns to reduce how...

The vba setting of this is in the load event and that triggers but gets it wrong randomly.

Hi Missinglinq, It is not a continuous form, Just similar items stacked(as attached). It is used as a calculator so a quantity of hours (default value zero) can be applied to the hourly rate (controlled in a table) and calculated as a cost. Minty, The default value is 0 (not "0"), I can now...

Interestingly you cannot set it in vba (me.textbox.value = 0) as this errors.

Hi Minty, As the default value of the text box in the property sheet.

Hi, I have some form fields which a calculation is based on when a form is loaded, unfortunately it works randomly. As per the attached examples, the consultancy rate (unbound) has a quantity (defaulted to zero), the next box is an hourly rate (looked up from a table) and the third box is the...

Hi Colin, I do like to understand what I am doing rather than just sticking code in so hence my curiosity. A bit of confusion set in here as I think what I was seeing occurred when there was no If clause. It went to the last record as you state with no scroll bar but then attempted to move...

So it would seem, this was all done on the assumption that the sub-form was the active form. I now have it working: Me.test.SetFocus testresults DoCmd.GoToRecord , , acLast If [test].Form.Recordset.RecordCount > 14 Then DoCmd.GoToRecord , , acPrevious, 14 Although this works, I think it...

Now things get interesting: Private Sub tBlade_AfterUpdate() Me.test.SetFocus Debug.Print Me.Name testresults Debug.Print Me.Name DoCmd.GoToRecord , , acLast Debug.Print Me.Name DoCmd.GoToRecord , , acPrevious, 14 Debug.Print Me.Name End Sub This gives the result as the main-form on all four...

If I add Debug.Print Me.CurrentRecord anywhere in the sub it returns nothing at all in the immediate window, I am guessing that this is the problem.

Private Sub tBlade_AfterUpdate() Me.test.SetFocus scanresults DoCmd.GoToRecord , , acLast If Me.CurrentRecord > 14 Then DoCmd.GoToRecord , , acPrevious, 14 End Sub Error 2455 :banghead:

Private Sub tBlade_AfterUpdate() Me.test.SetFocus scanresults DoCmd.GoToRecord , , acLast If Me.Recordset.RecordCount > 14 Then DoCmd.GoToRecord , , acPrevious, 14 End Sub Well this falls over with error 91

I have been playing with the record number but cannot get a value anyway, any clues? I am a little scared of using Dcount unless I can use it on the form as the query is too complicated and would probably double my processing time.

Now for the problem. Private Sub tBlade_AfterUpdate() Me.test.SetFocus testresults DoCmd.GoToRecord , , acLast DoCmd.GoToRecord , , acPrevious, 14 End Sub I just found a way to have less than 15 records, are there any suggestions for avoiding this. Basically I want to check if testresults...

Thanks Colin, hope it's nice in Somerset, belting down here in Gloucestershire:D