Search results

Hello, Like a small transperent image has a data from the form past it into the pdf file while it's open, and once it's done can save it to a specific folder D:/Work in progress. Sent from my HUAWEI NXT-L29 using Tapatalk

Hi All, How can I open and add text or movable stamp contains data into pdf file within a form in MS Access? To clarify my aim, within a form I can press a button and navigate to an existing pdf file and add a movable time stamp contains a record reference into the file. Thanks in advance...

Thanks a lot, arnelgp for your help :)

Thank you so much arnelgp for your help I owe you a lot. :)

Thank you arnelgp for your earliest response. You mean now I can place the front end file in any drive? like F or S and it will create a shortcut on the desktop automatically?

Hi, How can I make the Desktop shortcut for Front End file target folder 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 how can I make it dynamic? FileName = "MyShortcut" Set...

Dear arnelgp, Please find attached my db if you could get the opportunity to adapt your recommendation to have the temp table and function to get the seq DocID. I know it's too hard for me to implement your suggestion. I am sorry to request this from you, but you get time please do it for me...

Yes, it is. When two users press the Save button at the same time it should catching the error 3022 and provide the next sequential DocID to the other user. Sent from my HUAWEI NXT-L29 using Tapatalk

It's to avoid duplication in the concatenated sequential [DocID] field(I set it from the table) it's a hidden field but when the record is comitted it will be visible to the users that will be used as document reference for dispatch purpose between the departments within the organization. Sent...

Thank you so much theDBGuy I have an issue wirh other database for multi users SubForm data entry form that the users still getting a duplicate [DocID] the sequential document ID please find below my code. The Error 3022 should work but it didn't...

It's solved. But I do not know how to mark it as Solved[emoji51] Thanks Arnelgp for your help. Sent from my HUAWEI NXT-L29 using Tapatalk

Thank you so much [emoji817] It's working [emoji122] Sent from my HUAWEI NXT-L29 using Tapatalk

Private Sub txtSearch_Change() DoCmd.Requery "qrySub subdormDC" End Sub Sent from my HUAWEI NXT-L29 using Tapatalk

Hi All, I have got a Microsoft Access Datasheet instant search form. When the user type in a text box called [txtSearch] (on Change event ) the form will filter the records instantly. The problem is that when the user press Enter (as a normal practice) the form is getting stuck. Any...

Thank you so much it's working fine. Sent from my HUAWEI NXT-L29 using Tapatalk

Let us imagine that I have a data entry form with a combobox which has a three values Red, Blue and Green. When I select Red and save my record then I can see the Red but when I select it will prompt me with a message box says "this record already selected" then I can select Blue and Green for...

Hi, arnelfp thanks for your prompt response. I define the session by a query returns the FID and userID and check box set to YES once the form unploaded then another update query will run to set the the check box to NO. For sure to all of you experts there is simpler way to handle this data...

No, it isn't. I don't know I am using Tapatalk mobile application to post my questions, the SOLVED check box selects automatically. If you could solve my issue of the combox. Thanks in advance! Sent from my HUAWEI NXT-L29 using Tapatalk

Hi, How can I limit my selection from a combox values once only in one session in a Data entry form with a return message box of duplicate selection? Sent from my HUAWEI NXT-L29 using Tapatalk

I have just checked it works perfect [emoji106] Thank you so much! Sent from my HUAWEI NXT-L29 using Tapatalk