Search results

Hi, Just wondering if anyone has encountered problems in actually installing Access 2021 my current version is Access 2010 I try to mount the img file using setup32.exe and it just locks….. Any advice would be greatly appreciated many thanks Peter

Hi, does anyone know how to Sendkey a mouse left click within a macro

Wonder if anyone can help me with this code I have in an Event Procedure Sendkeys “+{Right 4}, True the shift element isn’t working as the cursor just moves right 4

I have a command button on an entry form that only has to be pressed once To ensure this, is there a setting and/or code that can either hide or lock the button after it’s one off pressing

Our current Access database operating system has the standalone full Access 2010 on my PC, which has both front end and backend installed The other users have Access 2010 Runtime installed on their PC’s which then allows them to use the front end only If I look at upgrading to the latest Access...

I currently use Access 2010 for my databases, however I’m looking at developing another similar database for someone and they want to use office 365 This will require me copying a database and upgrading it to the latest Access version and they also want it to be fully secure Can you please...

Hi, I have a main form INSPECTION which has a field COMPONENTQTY With each Inspection, the ComponentQty is totally variable, 1 off, 2 off, 10 off, 100 off etc On the same form is a single form subform COMPONENTDATA and this has a field COMPONENTNO along with other fields of data What I’m looking...

Hi, Attached are details from a table NISInspectionData which I’d like to produce a report, in landscape as attached sample spreadsheet I’ve tried a cross tap query but I can’t get it to include the notes colum any ideas thanks

Please see attached photo I have two questions thanks Firstly, on datasheet subform (Feature Information) to action as follows..... The first field (No) in the first row wants to start as #1, then I need the second row LineNo to be #2, third row LineNo #3 and so on Currently I enter these...

Hi, I need to run a macro several times based on a starting variable number Would a good method be to create a counter starting at that variable number and reducing after every macro run Examples would be good if you could assist thanks Truly hope I’ve described my issue clearly😉

Hi, Wonder if someone can help me with a vba Do While Loop..... Even though I’m quite experienced in Access, I’ve not done anything like this I’ve attached a screenshot of a form which has variable results I need some code that will change the WOClockStatus field from TRUE to FALSE Presume the...

I live in Lancashire, England and have been using Access for over 15 years, self taught and have wrote three different operating systems used by companies within the Engineering group I used to work for I am now retired but still work for one, when required, to modify/improve their system Access...