Recent content by bigdars

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...

Thanks for the reply. I will try it out tomorrow morning.

I don't know how to link, but this is the thread I received the calendar from. It works great. thread702-19300

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...

Yes there are...here is a link to symantec's web site that documents one of them... http://securityresponse.symantec.com/avcenter/venc/data/25275.html

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?