Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 414
Search took 0.20 seconds.
Search: Posts Made By: Tieval
Forum: General 02-22-2019, 01:03 AM
Replies: 5
Views: 122
Posted By Tieval
Re: Intermittent Start up issues

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...
Forum: General 02-18-2019, 02:41 AM
Replies: 8
Views: 187
Posted By Tieval
Re: Price auto value

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...
Forum: Forms 12-07-2018, 12:43 AM
Replies: 13
Views: 610
Posted By Tieval
Re: Switchboard - Odd Request

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:
Forum: Forms 12-04-2018, 04:14 AM
Replies: 9
Views: 227
Posted By Tieval
Re: Form Field Calculation Errors

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:
Forum: Forms 12-04-2018, 04:06 AM
Replies: 13
Views: 610
Posted By Tieval
Switchboard - Odd Request

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...
Forum: Forms 12-03-2018, 07:25 AM
Replies: 9
Views: 227
Posted By Tieval
Re: Form Field Calculation Errors

The vba setting of this is in the load event and that triggers but gets it wrong randomly.
Forum: Forms 12-03-2018, 06:56 AM
Replies: 9
Views: 227
Posted By Tieval
Re: Form Field Calculation Errors

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...
Forum: Forms 12-03-2018, 03:12 AM
Replies: 9
Views: 227
Posted By Tieval
Re: Form Field Calculation Errors

Interestingly you cannot set it in vba (me.textbox.value = 0) as this errors.
Forum: Forms 12-03-2018, 03:09 AM
Replies: 9
Views: 227
Posted By Tieval
Re: Form Field Calculation Errors

Hi Minty,

As the default value of the text box in the property sheet.
Forum: Forms 12-03-2018, 02:53 AM
Replies: 9
Views: 227
Posted By Tieval
Form Field Calculation Errors

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...
Forum: Modules & VBA 11-28-2018, 03:06 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

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...
Forum: Modules & VBA 11-28-2018, 01:09 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

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...
Forum: Modules & VBA 11-28-2018, 12:24 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

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...
Forum: Modules & VBA 11-27-2018, 09:11 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

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.
Forum: Modules & VBA 11-27-2018, 07:55 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

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:
Forum: Modules & VBA 11-27-2018, 07:37 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

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...
Forum: Modules & VBA 11-27-2018, 06:41 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

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...
Forum: Modules & VBA 11-27-2018, 06:25 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

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...
Forum: Modules & VBA 11-27-2018, 06:02 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

Thanks Colin, hope it's nice in Somerset, belting down here in Gloucestershire:D
Forum: Modules & VBA 11-27-2018, 05:47 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

Rather embarrassingly, the following works perfectly:
Private Sub tBlade_AfterUpdate()
Me.test.SetFocus
testresults
DoCmd.GoToRecord , , acLast
DoCmd.GoToRecord , , acPrevious, 14
End Sub
Many...
Forum: Modules & VBA 11-27-2018, 04:57 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

I cannot get VBA to recognise the recalc method, but logically this will only recalculate fields, I am loading rows of data and my change to the main-form may bring in more entries which recalc...
Forum: Modules & VBA 11-27-2018, 04:14 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

I am trying to open a continuous sub-form from a query that interacts with items on the main-form, hence when I change something on the main-form I need to re-load the sub-form. This may seem painful...
Forum: Modules & VBA 11-27-2018, 03:00 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Re: Requery Method

Yes, that is the point. I am doing a major action query and the requery method does this perfectly and as you say resets it to record one, I would like to then move it to the fifteenth from last as...
Forum: Modules & VBA 11-27-2018, 02:21 AM
Replies: 31
[SOLVED] Requery Method
Views: 579
Posted By Tieval
Requery Method

Hi,

I have a sub-form with a load event as follows:
Private Sub Form_Load()
testresults
DoCmd.GoToRecord , , acLast
DoCmd.GoToRecord , , acPrevious, 14
End Sub
This runs a complex query of...
Forum: General 11-05-2018, 01:05 AM
Replies: 6
Views: 142
Posted By Tieval
Re: Requery Form when Activated

It is normally because you are still in the record and it hasn't saved yet. One easy check is to put a button on the form that requeries the data, this will confirm this.
Showing results 1 to 25 of 414

 
Forum Jump



All times are GMT -8. The time now is 02:57 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World