Search results

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...

It opens another form in the background and fills some data, then closes the background form Don’t want to duplicate this data

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

Thanks I thought about a stand-alone version of latest access then install runtime on other user's PC’s That’s what we have now as don’t want 365 on the users

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...

Append query sorted with macro ditched, so pleased, so easy and so quick, would never have considered this if I hadn’t contacted this group and so, thanks again Pat Sometimes I find it hard to fully explain and detail what I need, so I appreciate you may find it vague, but my database is quite...

Hi Pat, Brilliant, copied your coding with my relevant tables, fields etc and it works a treat thanks I’ve now moved to hopefully the final stage before this module can start to be used, namely applying the copy and paste macros to each of the component records by using the FOR NEXT coding I’ve...

Thanks so much Pat, can’t wait to have a look and go tomorrow morning I’ve been looking and reading up on Tally’s most of the day and still a little puzzled😬 I’m off for so shut eye as my eyes are worn out but will be up early doors to try out your sample Thanks again Peter

Wow Pat, now I’m in very new territory😉 Can’t be exactly sure what the maximum quantity would ever be but suppose if I set it to 1000, I’d probably be on correct side Where and when would I run the required copy and paste macros I mentioned as they need to be run when the component number...

Thanks so much Pat, I have to admit, I didn’t previously look at the Details sample form but I certainly have now and successfully used it on the FEATURE INFORMATION subform, as shown on the attached form and design views of my Inspection Report, which is brilliant I have also tried it on my...