Recent content by divanalle15

nope its a simple access parameter query, only that is bound to a form to get its criteria from..... and other parameter queries that do not get its criteria from a form work just great....

hello to all i want to lock the tables and queries of my database in access so the users cant modify any information

hello i am using a linked table from a sql server , in access i create a simple parameter query adn it works just fine, but when i create a query that gets its parameters from a form and run it with a command button, i get a : ODBC Call failed message... i dont know what im doing wrong..

he contacted the information technologies manager to set me up access to a sql server( i dont really know what this means but ke asked my computer user id), so i just had to change "a little" (he said) the code of my access database, and the IT manager send me a database example with one query...

Hello! Im making a microsoft access database for a log, using VBA programming, queries, forms, etc...basically it is about saving information in a table, and then quering it, now that i am about to finish the database, my boss told me that he want me to use a SQL server to store the...

hi there how many columns is the maximum in a query?, because i have one that has 26 columns , but i need some more... what can i do?? is there a way to add some empty columns to a query?? thanks

it worked!!!!! thank you sooo much..!!! :D:p;):)

hello, i copied that syntax on a new column in the query on the field row, is this correct?? or i have to put it on the criteria row in the field column ? because it keeps poping up a window that says that i have invalid syntax, and the word "between" is highlighted thanks =)

hello.. i have a parameter query that gets its parameters form a form, on that form i have 2 text boxes to provide 2 dates between whom i want the query results, but i want to be able to leave them blanck if at any time i dont need that information, i have this on the expression builder but...

thank you very much!!! i love you!!!

Re: i've done that already, but what i need is for example to create a query with all the fields of the table, and with the expression builder bound them to the combo boxes in a form, one of them for each field, in this combo boxes the user will choose the criteria for the query for each...

hello!this is my first time in this forum i hope you can help me with this... i created a database wich has one table with many fields, what i need is a parameter query to sort the information on that table, the problem is that i want the user to decide wich fields he needs, and if he want to...