Recent content by JPR
-
J
Textbox as source criteria for multiple queries
Good morning, I finally got it to work. I have used Edgar's code and adapted to my db. I appreciate everyone's help on this. There are lot of very useful tips which will be considering while redesigning my db. Thank you -
J
Textbox as source criteria for multiple queries
Hello, Obviously I have tried the queries and they do work fine. No problem with them. I was referring to the records in the list box which does not appear to refresh. Thank you and sorry for not being more precise. -
J
Textbox as source criteria for multiple queries
Hello Edgar, appreciate your help. Sorry for the typo. I now understand the code line Me.lstsearch.RowSource = "qry" & Me.cboQueries.Value I have tested your sample but still cannot display the results in the lstbox after typing the criteria in txtsearch and selecting the qry from... -
J
Textbox as source criteria for multiple queries
Hello, I would appreciate your help in solving this issue. 1I was thinking to redesign a search form and remove the multiple search boxes and buttons and just leave one of each. My form will have: - 1 combo box (cboqueries) which will display the names of the queries - 1 search textbox... -
J
VBA to print Word file and close is
Hello, I have a form with a VBA code that export data to a MS Word template. After exporting I would like to give the user two options: 1) Open the MS Word document 2) Only print the document without opening it I am having problems with the second option as it always opens the document and...- JPR
- Thread
- Replies: 8
- Forum: Modules & VBA
-
J
Date format mm/yyyy
Absolutely!!! No worries. It just made me have a good laugh!! -
J
Date format mm/yyyy
Actually year is Anno. Ano ........totally different meaning.....:) -
J
Date format mm/yyyy
Finally got it to work. Not sure if it's because I use an Italian language of Access. This is how I changed it. Expr1: Format([dailydate];"mm/aaaa") Thank you -
J
Date format mm/yyyy
The query has its record source to table1 and has the following fields: - DateCost - Amount Date cost has the format dd/mm/yyyy This is the code in the new column: DateMMYYYY: Format([DateCost], "mm/yyyy") Thank you -
J
Date format mm/yyyy
Thank you. Yes, the format is only to display data. I have copied the code in a new column of the query but I am getting a sintax or missing operator error. -
J
Date format mm/yyyy
Hello, Is there a way a can show a date field in a query as mm/yyyy format? The query has its recods source to a table with a regular date field (mm/dd/yyyy). I will be always entering data in the correct date format but would like to add ta column to a query with this other format- Thank you -
J
Print Report based on lstbox rowsource
Thank you. Just realized that I had referred to a different query. Correct. I had to walk my code first!!!! -
J
Print Report based on lstbox rowsource
Hello, I have a listbox on a form which is used to view data from different table. The listbox is populated by a combox and each query uses the combo as criteria. I have added a cmd button that should print a report based on the list box row source but only works with one report. Can someone...