Search results

  1. A

    VBA barcode code generator not working

    Hi all, I used to generate a barcode font in MS Access 2010 normally with no issues even with the same printer, but when our company changed my desktop PC and upgraded to Windows 10 and MS Access to 2013 it's no more working I do not know how to fix this issue. I tried the same application at...
  2. A

    Extract specific data from one text field

    I have got a text field called [Address] contains the whole address of the customer which has been extracted from an XML file with the below result: I would like to extract the value only of the address field and populate them to specific fields like: How can I create a query or VBA to...
  3. A

    Extract Smart card reader data to MS Access table

    Hi All, I have got an MS Access database works in a multi-user environment, I would like to extract data from the Smart card reader device and then insert it to my [Customers] table. The card reader provides an XML file called: eRevealerGcc when you insert the card into it located in the %temp%...
  4. A

    Interactive QR Code in MS Word 2013 template

    Hi All, I have a MS Word fillable form template that has many fields I wold like to have an interactive QR Code to incode three fields [Account Number], [Form Name] and [Date] that once the user fill out the form the QR will capture the data entered and generated like pdf forms. I have...
  5. A

    View pdf in Microsoft Access 2013 From

    Hi All, I would like to view pdf files in the Form window not outside the form it's viewed only jpg files.`` I tried arnelgp sample in the below link but it's same not working in my MS Access 2013 version...
  6. A

    View pdf files within the form in MS Access 2013 Not working with Adobe Reader

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

    Open and pass values pdf form or MS Word Forms

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

    Query with Three Arguments

    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"...
  9. A

    Return Seven working days excluding Fridays and Saturdays

    Hi everyone, I have got two fields [Opened Date] and [Due Date], I would like to return the due date of 7 working days excluding Fridays and Saturdays from current date. How can achieve this by macro and the same by VBA too afterupdate event? Thanks in advance! Sent from my HUAWEI NXT-L29...
  10. A

    Connect back-end to front-end other than shared folders

    Hi, I have got a Microsoft Access split database in a local network through shared folder. I am wondering if there's a way whereby I can connect the front-end to back-end without the shared folder through localhost? Because I am getting deficulty to normalize all the users in a one partition...
  11. A

    Filter Datasheet Split Form

    Hi, How can I filter a split form with datasheet type depends on the department login to the application? The department login ID is returned correctly but the filter is not working at all. I think I missed something in my code. Your kind assistance would be highly appreciated. Private Sub...
  12. A

    Move Typed value from field to another field

    Hi All, I have got two fields in a form one called [AccountNo](ComboBox) and the other one called [ActualAC](Text) I want to move the typed data from AccountNo to AcrualAC field if the value typed not in the list of the Combobox. How can I achieve this? Please find my code below: Private Sub...
  13. A

    Multi Approvals Task Management (Dashboard Control Form)

    Hi All, I am working on a Multi Approvals Task Management database and trying to set up a Dashboard Control Form which will allow me to predefined each task (Combobox) and it's concerned department. How can I achieve this form of control? As an example: 1. Task 1 should be assigned to four...
  14. A

    VBA code command not setting focus on a specific field

    Hi All, I've got a VBA code on a field called [ActualAC] it should trigger in a specific condition but the issue is, when it triggers it returns an error message and then the cursor should set focus on another field called [AccountNo], but it not setting the focus. How can I overcome this...
  15. A

    Automate file dialog process

    Hi, The code below is working perfectly to upload pdf files to a predefined folder in our local network. 1. How can I get the user confirmation to overwrite the existing file with the same name in the uploading process? 2. How can I auto rename the uploaded file to the field [RefID]...
  16. A

    Add text into a pdf file within a form in MS Access

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

    Dynamic Target Path of MS Access Front End file

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

    Stuck when press enter (Instant search form)

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

    Limit one selection combox values in a session

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

    Move folder content depends on Listbox selection in MS Access

    Hi All, How can I move folder contents usually are pdf files to another folder depends on a listbox selection? The listbox populates the folder contents as a text. When I type my code manually working fine as the below: Name "D:\FOR REVIEW\02-JAN-19-AAA-001.pdf" As "D:\WORK IN...
Top Bottom