Search results
-
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)... -
J
Between/And
Hello Pat, "Age 70" obviously is just an example of what I want to show up in the textbox. Thanks -
J
Between/And
This last code works great. Just was I was tryin to achieve. Thank you. Appreciate your help -
J
Between/And
Hello, No, I will not pick up the data from a table. Since it's a simple projection, I would like to write this estimated retirement age via code. I do not expect to write more than 10 lines each of which will refer to a year. Example: if me.txtdob between 01/01/1951 and 12/31/1951 then... -
J
Between/And
Hello, I have created a form with two unbound textboxes. txtDOB in which i type a date of birth (mm/dd/yyyy age format) txtRetire in which I would like to add a text via code, depending on the age range entered in txtDOB. Examples: If me.txtdob between 01/01/1950 and 12/31/1950 then...