Search results

Hi, I am having a problem running a make table query which is based on the same tables that I am using in a sub form. Basically, the user selects certain records in the subform (which is in datasheet mode) using a check box, then once selected he hits a command button where there is some code...

Thanks Doc_Man, some great tips there. Do you mind if I ask what you meant by single table queries in the FE? Do you mean create a query linked to just one of the tables in the back end and then call on the query to edit / add new? Also when you say frequently opening and closing all...

Thanks for the tip but I had already tried this. I put the requery in the Ontimer event of the main form. But it still has to fire 2 or 3 times before the new data shows. Also the problem isn't just with the pop up. I also have some code that runs directly from the main form but it still doesn't...

I am doing a rebuild next week and trying a different structure to see if this solves the issue. But if not then I'll post a striped down version. The only thing that seems to cure the issue to not split the database. But lets see how I go on after the re-build. :)

Sorry for the late reply, been away for the week. Yes I did try the DoEvents but it didn't work. Thanks anyway.

Just as an update, when I add the split tables back into the front end, the problem goes away. ????? So it must be something to do with spliting the database into a back end and front end.

Ok, thanks for the advice. Sounds like a split it is. :) As for the problems, I made a post here: http://www.access-programmers.co.uk/forums/showthread.php?t=277450 Basically after I split the database it caused a problem with the main form not refreshing /showing new data after a user entry...

Hi, I am just wondering if there is a rule of thumb about when to split the tables of a database and when to keep the tables intact? I have a database I need to put on a server. Only one user will access the forms, but many users will need to query the data. So in this case I thought it best to...

I normally do use word for long post and spelling checks! Especially as with these new overly sensitive touch pads on lap tops it is really easy to wipe out whole paragraphs just by catching the touch pad in the wrong place. And there is no undo on a web page. But to be honest, I didn't think...

The procedure is to exit the sub if the user cancels any inputs. In which case there is no update so no requery needed. I also changed from full references to Me, so thanks for that. I have looked over my code a dozen times, even if I strip away everything and just do an update via code, the...

Hi and thanks for that. I did change my code, but it didn't sort it. But thanks anyway.

Ok, thanks for that, makes sense. As you can probably tell I am self-taught so there are a lot of gaps in my knowledge and I always appreciate advice! Thanks. For now I have got around the problem by putting some code in the ontimer event that requires for the first 4 times the timer event is...

Ok very simply, I have two tables which have a one-to-many relationship, tblProductionData and tblProductionEvent. They are linked on the ProductionDataID field which is the primary key in the tblProducitonData. I summarise and display the data in these two tables in a query which is the...

Yes it is. I try and avoid using me in case I move the code at a later date into a module. So don't know which is best.

Hi Doc_Man, thanks for the reply. The backend is an access database, it is the same database I originally made, I just spilt the tables out as eventually the FE and BE will sit on servers. The query in the main form's record source is based on the same tables that are updated in the recordset...

We don't need to go through anything else, the code I have detailed causes the problem, so solve this and we solve the rest! No it does not display the changes. After I update, the new data does not show in the main form unless I manually requery using a Command button or I put a me.requery in...

Yes, that is the obvious fix :) But I never tick these things in genreal out of habbit, so will have to remember. Although I do know other sites that copy the data and repost it in case this happens. Just a thought :D

No, the form is called 'FrmMain'. It is a bit difficult to post all the code, as I have 4 different modules as well as various other code in some of the pop up forms. But below is an example of some code I run directly from the main form. There are a couple of varibles passed to this code...

Thanks for the reply. As I am updating the tables directly using code, e.g. DAO.Recordset method, I assumed rst.update would update the tables immediately. The pop up form is just for organising the data input and is unbound. I just think it is strange how I can put the requery code at the end...

I have a continuous form who's record source us a query I use for summarising data in the form detail. In the form header there are some controls for the user to add new data. Usually this opens a pop up form, where the user will add the new data then I updates the underlying tables using code...