I got it! Thanks a bunch for the help!
SELECT tblMetrics.*
FROM tblMetrics
WHERE (((Month([tblMetrics]![Month_Year]))=(Month(Date())-1)) AND ((Year([tblMetrics]![Month_Year]))=Year(Date())));
:-) :-)
It works fine...but I am getting multiple years. I appreciate the assistance. I am working on adding the year but appreciate any further input. Thanks a bunch:-)
I am having trouble with this. I have a table that contains a column named "month_year". I have pre-filled the column with dates, ie 01/01/03, 02/01/03, 03/01/03...and so on. I have a form named "frmMetrics" that contains a field named "Period" that displays the...
The memo fields are actually from two different databases. I only display one of the fields via the query/linked tables. One database contains active cases and the other contains closed. If the case is closed, it pulls from one table and visa versa...never from both tables at the same time...
The field comes from a query which pulls the data from two different tables. The table columns pulled are both Memo fields. Is there something in the query that would cause this maybe?
The code works up to the same point...but it stops at the same spot. When I paste the text after clicking the button, it only pastes the limited characters and not the entire field. I recounted the text and it stops at the 255 character mark. Obviously it is interesting because it is the size of...
I have a zip file that I received from someone via this tek-tips forum. It has several samples of a calendar. You just click on a calendar Icon and a calendar pops up. When you click on the date you want, it automatically inputs it into your form. It doesn't look exactly like the calendars on...
I have a database that I have inherited, so I am not very familiar with it. Someone has shown me something that I do not have a solution to. One of the fields in a form contains data from a memo field. When you try to highlight the text with your mouse, it will only let you select about the...
The user may not tab following the date entry, so that method will not work. In addition, I need this to be either invisible or locked when the user goes beyond the first record.
Unfortunately with the way we do business, they want a default date, but the ability to change it also. Maybe I...
It seems simple, but I am having troubles. I have a form that captures information. This information has a "requested by date" field that the user will enter whenever they complete the information. What I want to do is have the "requested by date" text box appear on this form...
Thanks for the input...I have it working now...I just have a little manipulation to get the two digit year and two digit month into the table name when I import and I will be done. Thanks a lot for your input!
It still does not recognize the file name. I have tried several variations and no success. The code works fine for a messagebox, but it isn't working in a macro or a module when I program it in. It gives me the error that it can't locate the file. Any additional comments or suggestions?
I don't see anything that links the two tables together, but if you do have a column that links them together, you can create a query to join the two tables and then create your report from your query. Another option may be to set up a subreport of the description data and insert the subreport...
Just a little help if anyone reads this for assistance. I solved this problem by opening the report in preview mode, sending it using output to, then closing the preview. I then started the process again with the next report and so on until all 5 were sent. not the most effective method, but...
We have users that are saving filenames with a date at the end of the filename, for example c:\file0207.txt. The 02 is the year and the 07 is the month. Is there a way to have Access 2000 in a macro or module allow me to import the file for the current date? For example, if the month is July...
very helpful. I used Rob's code in a process to prevent the user from using the tab key to transmit to the next record on my form. I just replaced the vbKeyPageDown with vbKeyTab on the final tab stop.
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.