Search results

Thank you for all the support you provided me this weekend, it’s greatly appreciated. Tomorrow will tell me whether it works under pressure when everyone starts using it.. [emoji16] Sent from my iPhone using Tapatalk

The output and file name is great and exactly as I wanted, however i had noticed an issue with the PRE-ORDER form. When closing the PRE ORDER form and reopening the form, it opens with the previous record information and i am then unable to change anything or create a new record. Or Was it left...

Brilliant, thank you for that, greatly appreciated. Am i able to look at the end result, as there appears to be no attachment :)

Morning Isladog.. [emoji2] Is there anything I can help with on the above or is it something you would need to complete for me? Stuart Sent from my iPhone using Tapatalk

This is great. Appreciate the support. Sorry could you do the excel name of file to.. Pre-order document - [CPQ Quotation] - [Customer Name] - [Main instrument] Thanks for the closing idea. Never something I thought of so might be good.. [emoji848][emoji2] Thanks again Isladog.. [emoji3]...

Sure. Yep this is what i would rather, the combo box always showing the last 5 records in the DB. in regard to the "new" field, long as the user can select the PN reference and the Quotation and then DB fills the rest out then all good. In the SFDC all records will start with PN Not quite...

Great, thanks Isla. It is the SFDC Opportunity. Attached screenshot for reference. I would prefer a new value always, that means when the team open the form its already selected to "new" but only if it is easy to achieve. 4. not sure if i have confused you? it was more the name of the...

Hi Isla. Thanks I didn’t see the other part. There are some empty fields in the actual data it’s being retrieved from as we don’t always have it available. In regard to row course I don’t know what this is or how to fix. Sent from my iPhone using Tapatalk

Did that Isla and it didn’t work [emoji20] Sent from my iPhone using Tapatalk

Excuse the number I put but it was trial and error. I tried 5 and didn’t work.. Sent from my iPhone using Tapatalk

OK, so the limit to list didn't appear to work for some reason.. i attach photos of what i mean. (Hopefully I've done nothing wrong)

do you know if this shows the last 5 records or starts from the first record in the DB?

Hi all, Sorry another question from me :( In my DB i have combo boxes that returns a value from a particular field, however i wanted to limit the number of results that the Combo box shows, this is because my DB has alot of records and it ends up showing a long drop down box. It would be...

Hi CJ, Thanks for restoring my post, saved a lot of time me having to explain things again. If you like you can delete the newer one I created, if it prevents confusion in group.

Hi Plog, Thanks for the reply!. my knowledge of advanced features in access is lacking, but learn quickly with the right support and advice. I recently built a few other databases for the business but nothing on the scale of what is being requested this time as I think a lot of it will be...

Hi all, I have been tasked with trying to come up with an inhouse approvals system but I am not sure whether Access is the ideal solution? The management team would like me to develop something that can be audited, time stamped and dated, but also has the ability to leave comments if they...

Hi Isla. Thanks, and again for the patience. I attach the outcome :) I have added to this outside of what we had discussed.

Thanks all, i think I have grasped it now. However to me it still don't seem right? There is a date of the 03-07-18, surely this should be red?

Hi Isla, Thank you, and for being so patient. I have viewed this several times and tried different bits and get the following (attached) Stuart

Hi Isladog, Sorry, I had not followed it correctly previously. I have made amendments, find attached. Am i asking it to do the wrong thing, when I say I would like it to always show green, orange, red etc? Stuart