Search results for query: *

Thanks, Peachmelba. Could you give me a hint on how to write this function to convert 04/01 in a full date ? I am not a technical user and am not experienced in programming in Access, although I have some knowledge of very very basic stuff in VB... If you have the time to tell me the way, I...

Hey I put together a database last year, with some queries that ask the user for month and year, in the format "MMM-YY". Until last year it was possible to enter "Apr-01", for example, and the query would work. Out of the sudden, this query is only accepting...

Aivars Thank you for your help, but the question that is inside the parameter from the query is still popping up. That is what I want to avoid... Do you know how I can do it ? Thanks Miguel Oliveira

Hi all I have a form based on a query with some parameteres that pop up dialogue boxes to the user. After answering these "questions", the form is loaded with the records that meet the criteria. My problem is: I created a combo box using the control wizard, telling Access that I...

Jimmy Thank you A LOT for your help. The code worked perfectly. The only thing I had to delete was the line Db.close . When I tried to run with it, although the exporte occured, an error message came up. Thanks also for the feedback regarding the names of the fields. I'm just beginning working...

Jimmy Thank you so much for your time and help. I am providing as much info as I can below, but I definitely don't expect you to take your time writting the code considering all 7 fields that I want to be copied from the form and appended to the second table. I would appreciate so much if you...

This form is based off a query that reads a table with all these products, which prices change every month. So, every new month, when tue user finishes entering the new costs, he opens the form that shows summarized info (total cost for that product family). So, every new month I want this...

Jimmy You asked me to use a key field as criteria in the WHERE statement of the VB code. What can I use, considering that every month the user of the database will be entering new values in the fields of my form and storing these values in the "summary" table ? Can I tell the code to...

I have a big table with many products and prices for each of them. The form I am working on summarizes all costs of the products, on a "product family" level (does not list all the products, only totals). Since the prices change every month, I created another table to store only these...