Search results

I show the code being run through in the video with the forms at My video of the problem - did you see it? It shows that after the recordsource update with SQL code it rerunds the module - it is at this point that the cursor goes back to the top of the middle subform. I don't have any problems...

I do a requery on the top subform and the cursor does not return to top - only when I update recordsource and it re-runs the subroutine as you can see in the video. The cursor change is before the requery. I'd like it to update the recordsource then continue and not re-run the module.

Hi there - I have recorded a short video to explain the problem at My issue with RecordSource In summary when the VBA runs and the RecordSource is updated it reruns the subroutine for some reason and during that process it changes the focus from currently selected row to the top row and then...

It is changing the record selected after a recordsource update and before the requery - would I still use a bookmark feature? As you will see from the video it will rerun teh subroutine after updateing the recordsource so not sure bookmarking will help in this instance. Thanks Paul

I have recorded a video to explain the problem in more depth at My VBA Problem The issue I have is that it runs back through the Subroutine after updating the RecordSource and as a result the cursor moves from whatever line is selected back to the top so the resultant requery is for the wrong...

I have hidden fields on the forms for date which are turned on or off depending on which month is chosen - I'll record a video to show what is happening

Hi there - I have a datasheet and would like it so that when I select an option from that datasheet in that subform then the subform below is updated to reflect details for that line item. I have the following code: Private Sub Form_Current() Set form2 = Me.Form For Each ctrl In form2...

I recreated the database after corruption and this is on the recreated database so don't think it is same issue - just probably slightly messing up the syntax but driving me potty

I already had found this page when trying to resolve it myself - yes seems fairly comprehensive but still struggling.

I have created a new database and imported in the database and forms and relevant queries and worked first time - the only thing I can think of is that I created a new form with a slighly similar name to an existing one - nothing else changed. Most likely it is corruption going by other posts...

This is driving me potty - a couple of times I have had it where can debug past a line so I think it's working then later throws up an error on same code. I have 3 forms currently When I Select something on the first one I want the bottom subform to update so I have code on on current and...

No recent updates - last was end of April and I already checked for broken or missing references. Nobody else would have tampered with it as it's only locally on my laptop at this point I'll try recreating the database and see if get same issue there - bloody Microsoft Paul

I am getting When I try and update recordsource on a subform from VBA - it was working fine yesterday and now not working If I use the same SQL and set it manually it works fine on the subform also happens on lines like this Set frm = Me.FrmMonthDeptQuery.Form which worked fine before - the...

Hi - removing the FA and GL did the trick Where forecast has a value for Feb through December and the user can pick a tab with a matching name e.g. tab 0 is Feb, tab 1 is Mar is there a way I can show the relevant query without having to update the VBA with an SQL line with a case statement for...

Yes I have also explained that field names should not have spaces .. and will work with finance to update their original spreasheets which will be imput into the database as forecasts become actuals..

@Pat as already mentioned the data comes from Finance team and from existing spreadsheets so I have to work with them to normalize the data - not the kind of thing that can be done instantly but I have already discussed it with her and she will be working on it - as it is I'm working with what...

HI there - I have a query as follows: which returns Where the P&L Group is the same I'd like the total to be added together and just show 1 entry so for example C Technology Fees Aff. just show one line with a total of -8,339 + 8015 (-384) and 1 line for C Materials & Services Affiliate...

Thanks for the comments but I'm being guided by what Finance says they want which is mainly with a view to presenting data to the MD in a way he is happy with. Yes, it is frustrating that the data is in totally different formats and would make it easier if it was consistent - I guess it's...

A month is either actuals or forecast so for example January through April will now be actuals and May through December is forecasted. When May finished then the actuals get imported in to the database. You would see the total for each income statement for a particular month and department -...

They were using pivottables already but wanted a better way to display the data to keep the MD happy. I think the database is coming along fairly well - there will be one report and then will detect whether that month is actual or forecast and then display an overview which you can drill down...