Hi,
I have an unusual problem. My office has a paper form on which certain fields must be filled. This form only exists in paper format; there is no electronic version. It was recommended to me that the best way to fill out this form is to create an Excel spreadsheet that contains the answers...
Hi,
I have an expense report based on a complex query. The report is called from a form that displays a list of people. How do I call the report and pass to it all of the people shown in the form. I am passing a person id so the report will show the expenses related to that person -- but I...
Hi,
I am building an SQL query string and I need to add a part that restricts field value to be between a start and an end date. Is this right:
If Not (IsNull(Me.txtStart) Or IsNull(Me.txtEnd)) Then
strSQL = strSQL & " AND [Authorized Travel Begin Date]>=" & Format (Me.txtStart...
I have an access form with and ID field and I would like to open a PDF after I click on this field in the form ( I would use a hyperlink). The value of the ID field is the same as the name of the PDF and I have the access database in the same folder as the PDF's. what is the syntax for calling...
Hi,
I have a table with SSN. How do I make it so that everything except the last four numbers appear as ****
And that they are displayed like this in all the forms that use them?
Thanks!
I am creating an MS Access 2013 desktop application and need some help. I have created a continuous form that is based on a query that has five fields. The five fields are displayed in the detail section in tabular style. The header of the form has three unbound textboxes, related to three of...
Hello,
I am creating an MS Access 2013 desktop application and need some help. I have created a continuous form that is based on a query that has five fields. The five fields are displayed in the detail section in tabular style. The header of the form has three unbound textboxes, related to...
Hi,
I need to develop an Access application and I have not done this in about 10 years. I am using Microsoft Access 2013 and developong a desktop application since I do not have a SharePoint server. I would like to open with a search form where the user can enter three pieces of information...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.