Search results

Hi All, I have got a Microsoft Access db to view pdf files within the form but it does not succeed is there another suggestion to do so? I tried to upload my db in this thread it's allowed, below is my code: Private Sub btnBrowse_Click() Dim file As FileDialog Set file =...

Yes, sure go ahead I am waiting. Sent from my HUAWEI NXT-L29 using Tapatalk

Thank you so much for all what you provided to me I will use them and I will let you know accordingly. Sent from my HUAWEI NXT-L29 using Tapatalk

OK ignore what I said and I am so sorry for that, I know if I search the net it will be vary hard to me to get my needs, but I don't want to make you tired with me. This forum and it's members like you helped me a lot. If it's fine for you please go a head and provide with a VBA sample...

I see that's a good option but another thing is that I've got many fillable forms in Adobe Acrobat with a very nice layouts and the users are happy with it. When I export the report from Access then is it possible to have the empty fields can be filled up by the users? Sent from my HUAWEI...

It's a template Microsoft Word form with a labels protected and fillable fields, each fields has it's own name. If it's possible to provide me with a code sample if you could or I will search the net. Thanks for your prompt response. Sent from my HUAWEI NXT-L29 using Tapatalk

I will work on it and I will post my feedback. In my Access database I've got a field QR code image type can I pass it Adobe too? Because the one available at Adobe when I send the file to be filled up with a user who has an Adobe Reader the QR Code become gray and it will be printed as it is...

Happy new year, thanks for your response. Can I give a try to pass a records from MS Access to a predefined MS Word fillable form through VBA? Do you prefer to upload my Access db or it's fine without it? Sent from my HUAWEI NXT-L29 using Tapatalk

Happy new year, thanks for your response Yes, it's a fillable forms and users do have an Acrobat full version too. Sent from my HUAWEI NXT-L29 using Tapatalk

We have got in our company a Microsoft Office 2013, I would like to create MS Access database to control our forms that created in Adobe Acrobat and MS Word. When I create a new record in Access then save it I want to automate opening a specific form template let say: Form 1 under a pdf format...

I am sorry for that because my mother language is not English it's a bit difficult for me to define my thoughts. I have tried the code you provided to me it's working fine the shortcut is opening the front end file from any drive, but let us assume that I want to share the front end file to a...

It's working but to create the shortcut in the first time I must open the front end file in the drive D then I can use that shortcut to open the file from any drive. Sent from my HUAWEI NXT-L29 using Tapatalk

Sure why not! How can I make the Desktop shortcut to open the Front End file as a dynamic path? Like there are some users they don't have a 'D' Drive they have 'F' instead. The below VBA code specifying the D Drive is the target folder to open the located front end file, how can I make it...

Thank you so much. Sent from my HUAWEI NXT-L29 using Tapatalk

Thanks for your prompt response, I modified the Function as you suggest but unfortunately, it creates the short cut in the desktop but even not opening the front end file.

Hi arnelgp, I have tried the code you provided to me firstly: I got an error in the Function in this line: [ getPath = d.Path & "" & FileName ] then I have added in the declaration [ Dim FileName as String ] I do not know if it's correct? Secondly, it opens only the "D" Drive not the target...

Thanks a lot for your response. It's working as I expected. What a nice forum! Sent from my HUAWEI NXT-L29 using Tapatalk

Hello theDBGuy, thanks for your prompt response. It's working fine thanks a lot. Just to for my info, is nested means only to use the true condition in the IIF statement? Sent from my HUAWEI NXT-L29 using Tapatalk

Hi All, I would like to return the account type if three scenarios are met: 1. If the [CustTypeID] = 1 and [CCNo] = "N/A" the result should be: Account File. 2. If the [CustTypeID] = 2 and [CCNo] = "N/A" the result should be: Facility File. 3. If the [CustTypeID] = 2 and [CCNo] <> "N/A"...

Thanks for your clarifications, that's exactly what I want, unfortunately, I am out of my country now, once I reach I will let you know the progress of my application. Sent from my HUAWEI NXT-L29 using Tapatalk