Search results

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

Thanks Pat, I’ve looked at your sample database but sorry to say I don’t fully understand the coding Attached is my table in design and a couple of manual sample entries Dont know if it’s possible for you to show what my coding needs to be thanks

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 again Pat, please ignore my previous message, I just searched on the site and found previous question and answer(y)

Hi Pat, just about to try the two crosstabs but can you help what settings i use for the NOTES on as the field is text thanks

Pat, I’d really appreciate that thanks btw what’s PK & FK, probably obvious but maybe a brain freeze😉

It’s so difficult to show the exact scenario required but I need to obtain a report that shows the feature data along with the component data to its right, all in line etc See photo

I’m not sure if it can work with one table as there could be multiple components from 1 to 100 per feature

Hi Pat, Yes 1.1 thanks