Recent content by Angello Pimental

Nevermind...... I just had to be creative! Create a txtbox with ="*" as the control source. And then just fool around with the properties.

I have a form that displays various information about the records in the database. I would like to have bullet points on the form to help display the information. I have searched Microsoft Support, Access Help and the previous posts in this forum, but I have found nothing. Could someone tell me...

In the future could you please refrain from posting in your questions in multiple forums. Pick one forum that seems relevant and you will be answered. Multiple posts of the same question cause confusion and are deemed not proper forum edicate. Thnx If you could please write back and give us...

Ian: I tried combining the queries, as they are both based on the same table and fields... But it then brings back a random melody of records that don't relate to what I asked for. Is there anyway that you know of that you can use the combined query method, but tell the query it ignore one...

THanks for the reply Abby, But it seems that Access thinks that it is too complex... Whatever that means.. Oh well, I will have to try something else... Thnx

Is it possible to have one form based on two queries?? The reason for this, is that I have given the user the choice of searching for renewal dates by month and year, but I also want to be able to have a query which brings back all renewaldates from the present date. I have both queries...

Abby, HOw would I adjust this for the European date format?? Thnx

Greetings everyone, I have a query that is used to pull records for a certain month from my table. I use the following criteria, as the user selects the Month and Year from comboboxes on a form. The form is based on the query. Field: Year([Renewal]) Criteria: [forms]![renewalform]![year]...

John, In the future could you please only post to one forum. As when you post to multiple forums you cause confusion, and its not proper forum edict. Check your post in the general section for my reply to your problem. Thanks, Angelo

Well..... After all the different pieces of advice, and all the failed coding attempts, I have finally succeeded in getting my query to work. In the query that I have based my form on, I have the following: Field: Month([renewaldate]) Criteria: [Forms]![renewalform]![month] Field...

Rich... Are you suggesting using datepart to extract the month and year from all the dates in my records? How would I code that? Angelo

JWindon, THanks for your reply. I have had a look at your code and I understand what you are trying to do. I will have a go at getting the code to work. Could you please e-mail me that "quickie" database to have a look at... ampimental@hotmail.com Thanks, Angelo

OK, I am still getting no love from Access..... The code: Like "*" & "-" & DatePart("mmm",[forms].[tryrenewal].[monthdate]) & "-" & DatePart("yy",[forms].[tryrenewal].[yeardate]) Does just not want to do anything for me. Instead I have reverted to Chris RR's idea, I get no errors, but the...

Doug, This is the code that I have now..... as the criteria for the query. Like "*" & "-" & DatePart("mmm",[forms].[tryrenewal].[monthdate]) & "-" & DatePart("yy",[forms].[tryrenewal].[yeardate]) But it still won't work for me, any suggestions???

I believe you need to define x, somthing like this: Dim x as integer put that at the top of the code HTH