Search results
-
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. -
J
vba to print Word document double side
Hello, I have a vba that export data from a form to a MS Word template. It works great but I would like to add a final code that allows wither to open the file in case users need to modify it, or print is double side. I cannot specify the printer type as the database will be used my multiple... -
J
Extract part of a string
Hello, I have a table with a filed named CustomerFileNo which is made of 10 digits plus one or two characters which identify the customer. ex: 0000000000A 0000000000BB I was trying to create a new field that only shows any digit or character after the 10th digit but can't get it working: ex... -
J
Export data in Work to different folders
Hello, I have a form with a cmd button that exports data to MS Word template. Presently the word file is saved via code too just one folder (C:\MyTemplate). I would now like to change my code to save the word file into different folders depending on the selection in a textbox (txtfolder)...