Search results

Ok, That's interesting, I will use the Date() function then, I don't need the time. Now, for the BF, the idea is to query the DB for all the records that will expires in 1 month. So if I run the query today, Access should return all the records where the modified date is in April 09. The...

Hey everyone, I am looking around for a way to built a Bring Forward system for my access database. I have a Modified Date field and each first of the Month I would like to print a report of records where the month of the field is the month from now() but year(now())-1. Is that possible...

Ok, I can fix it with an autonumber actually you are right. The Pk was a number generated by another system which will start generating number higher than 2147483647 soon, so just trying to be proactive. Thanks,

Hey everyone, I have a problem with the maximum number that we can insert in a numeric field. That field is the primary key of my table. Can I bypass that limitation by using a text field and entering a number in it as the PK? Sincerely,

We should get approximately between 500 to 700 records! Basically the queries are simple one so I don't really know if I should pass lots of time testing 500 records :s I guess I should have more trust and faith!!! Sincerely,

Hi everyone, I have a DB with a sample of 5 records. When running queries, the results are accurate. I know because there's only 5 records and I can check each records and proceed to the validation manually. How should I proceed with 100 records? How can we test the reliability of Access...

Forget it, user problem! Of course a value in cmbExp2 was not selected! So it works, and to summarize, when you are saying "You need to qualify the name of your combo box", if I understand, you qualify the name by calling Controls()? Sincerely,

Ok, I tried and it works for the first loop and in the second pass I received that error msg : Run-time error '94': Invalid use of Null. Any ideas?

Hey everyone, Something really simple here that is giving me some hard time! I guess I just don't understand the way it works! I have 2 combo box on my form -cmbExp1 -cmbExp2 Now, I need to print with a msgbox the selected value of cmbExp1 and cmbExp2. It works if writing the code...

Ok, I will have a look thanks. Now, there's a thing I don't understand with functions and vba and design grid in Access. How does it works! Let's say I have in the criteria line : IN (2, 3, 4). If I put In(functionToFillMyIN()) instead, can I expect functionToFillMyIn() to return values...

Hi, I would like to know if there's a way to "fill" the in() function with values with user's input? Basically, the user needs to search for candidates based on experience(min=1, max=6). To achieve that, the user runs a query and he's been asked how many experiences he's looking for...

Ok, Perfect, thank you very much for your help. Really appreciated. Sincerely,

Ok, It's working! Now, if I want the name of the experience that is in another table, how should I proceed?

Ok, Now it runs but with no results. I only see the headers. One thing is that if I remove the count part, the CountofIDs column is always showing 1 is it normal? Would you prefer a printscreen?

Ok, I have changed some fields name to reflect the dabase but here's the error when trying to run the query : "You tried to execute a query that does not include the specified expression 'idExp' as part of an aggregate function" Here's the code : Select idExp, idCidm,Count(idCidm) as...

Ok, I have tried with the IN operator, but yes, it's the same result as with the OR. Now, for the count possibility, since that I'm a beginner, I don't really where to start. Any suggestions? Sincerely,

Hi, I am new here. I'm having a problem with a query in Access 2003. Actually since I'm a beginner, I think I just don't know how to build the query after all! I have a table named candidatesExperiences. For example, here's some data that appears in the table : idExp idCandidates 5...