Recent content by JPR
-
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... -
J
Sum Query and text box
Hello, appreciate your help. Unfortunately I am getting a character or syntax error code when copying the code in the textboxes. I am attaching a sample of my db. Than kyou -
J
Sum Query and text box
Thank you for your help and time. I will give it a try. -
J
Sum Query and text box
Works great. Is there also a way I could use a text box to display the result of these two different queries? Thank you -
J
Sum Query and text box
Hello, I am having some problems in creating Sum queries for my db. My db has a table named Clients with 3 fields: - Clients - Paymentdate - Paymentamount My db has also a form form with a combo box (cboclients) used to select the client's name and two text boxes (txtTo and txtFrom) used to... -
J
Default Date in Textbox
Hello, I would like to add two unbound text boxes on a form which indicate the 1st day of the current year (txtFrom) and the current date (txtTo). Thank you for your help.