Search results

  1. G

    Time difference for leave application

    Please let me know what is syntax to get the total time used in hours and minutes: 1. Start time: 9.30 am End time: 5.00 pm I need to get used time as 7.50 ( that is 71/2 hours) 2. Start time: 9.30 am End time: 5.30 pm I need to get used time as 8.00 Thanks for your help.
  2. G

    Unable to move down page footer

    Hi I am designing a report and I have content only 2 1/2 pages. Now I am not able to move the page footer further down so that I can add more fields in the details section. Please help. I am struck. Thank you.
  3. G

    Date Format

    Please let me know how to convert a date format from 6/11/2020 to June, 11, 2020 in a text box field in a form and also it get saved in the table in the same format. Thanks for your help.
  4. G

    Jpeg picture size

    I have a pdf form with the size of U.S. paper (8.5x11 inches I think). I will convert this pdf into Jpeg and I wish to paste this picture on an access report in the same size. I will be placing controls like text boxes on this picture. Please let me know how to paste this picture withe the...
  5. G

    Text Box between labels

    Hi, I am placing bound text box between two labels. How to adjust the width of the text box dynamically based on the length of data in the text box. Can shrink or can grow property is not helpful. Please help. Thanks
  6. G

    Avoid null values in a query

    Hi, I am creating a report which will be exported as a word document with the values from a query. The user will have a questionnaire form with check marks. There are around 100 questions. The user may check around 25 questions with check mark. I want to have the report generated only with the...
  7. G

    Outlook Task Error

    Please help me, I am getting this error for the following code: Run time error: 91; Object variable or with block variable not set Thank you. ************************************** Private Sub SendTask() Dim outlookApp As Outlook.Application Dim outlookTask As Outlook.TaskItem Set outloopApp...
  8. G

    Filter Forms Record Source based on Computer User Name

    I have a form with a text box with control source to "Assigned By" (name of the person assigning the task ). It's default value is the User Name of the computer. I am able to do this. After that, I wish to have the form's record source criteria with the user name of the computer. In other...
  9. G

    Converting desktop database to web

    I am not familiar with this. I need to publish ( if this is the correct word) one of our forms in the website so that the clients can have access to that. Is it possible to convert to web? Or it is a complete different environment and everything has to be redone for the web? Thanks for your help.
  10. G

    32 bit or 64 bit

    I installed access in 64 bit windows computer and when I open the database I get the error message as it is 32 bit. Please let me know how to fix this. Thank you.
  11. G

    Getting file created date

    I am able to get the files names from Windows Explorer using http://allenbrowne.com/ser-59.html function. Is it possible to get the file created date also? Thank you.
  12. G

    Drag and Drop Outlook Emails to Form and Save it Windows Explorer Specific Folder

    Kindly let me know whether it is possible: 1. Drag outlook one email or email attachment alone from outlook folder to access form container ( Text box etc., ) 2. Windows explorer specific folder opens up automatically ( I have the folder link in a text box called txtLink ) 3. User saves...
  13. G

    Adding Date Values in Text Boxes

    I have to calculate a person's number of dates he is out of office. It is for calculation purpose only. I have 16 unbound text boxes (date) in a form. 8 for Exit date from office and 8 for entry date back into office. I need to calculate how many days he was away from office in a month. He...
  14. G

    Tables and Relationships

    I have five tables, one for beneficiary's biographic info and other four are for spouse and three children biographic information. The beneficiary's primary key is the foreign keys for spouse and children. And also Spouse and children have their own primary keys. 1. Am I doing correct? 2. And...
  15. G

    Referencing pdf Form Fields from Access

    I found the names of the form fields in a pdf form. Is it possible to populate this form with the data from access? Thank you for your help.
  16. G

    Adding Existing Numbers with Auto Number

    I have a table (Table A ) with 3000 records. Primary key is auto number. The company already has another table (Table B) with around 6000 records, with primary key -Numbers. The numbers in Table B are manually entered, not auto numbers. The company wants to retain the existing numbers in...
  17. G

    Run time error '6' Overflow

    Please let me know what I am doing wrong in this code. I am getting overflow error. Thank you for your help. Dim myPrecentge As Long Dim Total As Double Dim Used As Double txtTotal = Total txtUsed = Used myPrecentge = Round((Used / Total) * 100,0) If myPrecentge >= 15 Then MsgBox Some...
  18. G

    Opening Subfolder in Windows Explorer from access form

    Please let me know how to open subfolder from access form. I am able to open MyDocument but not able to open MyDocument /Cases/2020 Thanks for your help
  19. G

    Creating a folder in Windows Explorer

    Please let me know how to create a folder in Windows Explorer from access form command button if possible. My folder name will be in a text box named txtFolderName. The path will be: s:\\cases\2020 Thanks for your help. Let me take this moment to thank all the genius in this forum who are...
  20. G

    Populate one Combo box based on the value from another combo box

    Please let me know how to populate one combo box with the field from a table based on the value selected in another combo box. I have two combo boxes, one for States and another for counties ( which is a field in a table) Please let me know how to populate the county combo box based on the...
Top Bottom