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