Recent content by Toolpusher

Access 2013 or 2007

hi Win 10 1903 fully updated Access 2016

Yes as long as I don't change the resolution. As its a single user DB I never bothered to split the database but I will try this to see if there's and difference. As changing the graphics resolution should not corrupt a DB

I have a singe user DB running on a coal business for a number of years . The pc was an old intel and Nivida GPC. Recently the business decided to upgrade to a new PC . They chose a AMD and Radeon PC. All seemed to go well regards the change over. I noticed when testing DB on new PC when I...

CJ No I did follow your advice on the onload event for main form have the following Private Sub Form_Load() frmPatientsSUBVisitstop.Form.DataEntry = True frmPatientsSUBVisit.Form.AllowAdditions = False frmPatientsSUBVisitstop.Form.ScrollBars = 0 End Sub

CJ Thanks for putting up with me here . If I make top form slightly taller I just begin to see the other records on the subform and the scroll bars stay put I also tried mytopsubform.form.scrollbars=0 in the load of the main form but nothing happened not even an error. TP

Hi I can get this to work perfect except the top form shows a vertical scroll bar on when viewed on the main form how do I get rid of this

Thanks CJ for prompt reply but think I am not making myself understood. Yes both subforms are on the same main form. Top form allows dataentry but bottom does not. That works fine. The top subform only shows one line which is the dataentry line which is also what I want but it also puts...

I want the data entry to be at the top of my sub-form so I have used the method of using two sub-forms one with no data input allowed and just above that one the sets focus on new record entry after update and only shows one record. It works fine but for the life of me I cant get rid of the...

Thanks plog not a trick question only looked at access 2013 for 5 mins and did not see these options thanks

Hi Sorry if this has been answered before but I cant find it. Are you still able to create a DB that can be just run by a user from his PC using Access 2013 like we all did with access 2003., not using sharepoint or making it web based. I have dabbled in DB's for many years and have a charity...

Hi I dont expect this is good DB practice but even though i have a form with a memo box on it. When a new record is created a default valve is inserted in the memo box. i just want to add to the default valve not replace it. So if the default value is abcde I dont want to replace this just add...

Hi I have a form with many fields on it but I want to create a rule that if a certain check box is not ticked then at least one value must be selected from two combo boxs I have on the form. If the check box is selected this is not a requirement. Any help appreciated TP

Thanks again guys for the prompt responses problem solved;)

Hi Want to create two query's for using for reports. 1. Need to see all records entered yesterday, using Date()-2 on the date entered field which seems to work sometimes but not always 2. Need to see all records entered today using Date() does not work for some reason? against the date entered...