Recent content by Pete490h

Thanks for that but really don’t want to remove Access 2010 as want two versions until I’m happy with test I’m told it shouldn’t overwrite I’m going to try on another pc thanks

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

Thanks all, sorted and already ran 92 times👍

Hi, I have a routine that has been in use for many years and I’m trying to automate it and I’m 98% there with a macro The last part of the routine opens an existing form and I want to simply click a field, which itself opens up another form where the remaining macro actions run

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

theDBguy & Isaac, thanks for your assistance/comments…… I have changed the form designs and put the Sendkeys within a Function (see attachment) and I’m pleased to report that it works great The operator will be so pleased that all they have to do now is type in the inspection report they wish...

Sorry again, I’m going to have to get used to putting full details for you guys to help you understand Before the Sendkeys, I told it to go to control ITEM, which then only need4 right moves😉 Do you think code could do it? I’ve never used SelTop or SelHeight but still presume the paste issue...

Trying to create a copy and paste routine but make it as automated as possible…. The operator opens form NISFeatureDataFrm and selects the data rows required for copying, which is VARIABLE They would then click a form button which copies the data (Sendkeys “^c”)then opens another form...

Still have the Sendkeys “^V” issue though

Just changed it to uppercase…. Sendkeys “{RIGHT 4}”, False and it worked however when I add next line of code Sendkeys “^V” it doesn’t 😬

No sorry, it does have both, missed it off this message😬 Sendkeys “+{Right 4}”, True

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

Hi Pat, wonder if you could help me again on this…… The GENERATECOMP button is working great however I have noticed an issue and although not really affecting the system, it doesn’t look right I’ll try my best to explain😬 When we click the button, it creates the correct number of component...

Sorry, learning how to answer replies correctly, as sometimes miss info you guys need….. I’d like the button to be disabled (hidden sounds best), after it’s been pressed once for that inspection report number, even when the same record is reopened When a new Inspection Report No is created, the...

Okay, I’ll try to explain….. This main form opens when selected from another project form and becomes a unique record and is given an Inspection Report No The user fills required data in the green cells There are three subforms and relevant data is entered on the Feature Information subform The...