Search results

I solved the problem by DLookup replacement of the "," with ";" .

Hello, I've a query [qry_sales], showing the Turn Over [Sum of Expr4] value for different periods [Expr3] and per different [product_category]. I've then created a report with the purpose to show month by month the Turn Over for each Product Category. I was trying to use this query...

It works !!! Thanks a lot !

Thanks again for your help. It works, but the effect is still the same. It write on the textboxes the same column it was writing before on the table. There is for sure a problem ob the bounding column. I adapted this DB example to my purpose taking it from the web, but I've now some doubts abt...

Thanks for the answer. Probably it is better to bypass this problem. Can you kindly tell me in which way I can copy the content of my combobox [Cbo_product] into a textbox ? and where I have to argue the event. Soory maybe for stupid question, I've not for sure big familiarity with Access...

Good morning, I'm new on this forum and it is a pleasure for me to be her to submit my question to you. I need an help on this problems in an access (2003) form. I'm trying to realize a input form able to record the data concerning customer order. In this form, I have two combo boxes connected...

Thanks Honda, I'm not using VBA but I solved anyway the problem with two queries : q1 : SELECT TOP 4 Table2.id, Table2.name FROM Table2 ORDER BY Table2.id; q2 : SELECT Table2.id, Table2.name FROM q1 RIGHT JOIN Table2 ON q1.id = Table2.id WHERE (((q1.id) Is Null)); Maybe somebody could...

I've seen that I did the question in a bit complicated way. I just need a query able to extract all the ID record in a table, with the exception of the last 4 records inserted. Thanks a lot for the precious help

Good evening, I'm building aspx pages. In one of those I've three "datalists" populated by Access DB, called "news". The first one I'm querying just the last (recent) ID, and it is OK. In the second one, I want to query the Top 3 [ID], with the exception of the last one, and it is OK too. In...

thanks dk, now I have the record exactly as I need . The VB code run well in order to send email but in manual way. In which way I can now automatize the email sending procedure? Thanks again

Hi dK, thanks a lot for your help and for the precious links, very useful. Now I can send email from access but not yet automatically. Can you tell me in which way I can insert the code by you suggested -DateDiff("n",[ExpirationDate],Now())- in the following code? :This is my code ...

Good morning, I'm new in this forum and I'm trying to solve since some days a problem. After exploring several forum, I think I can here found the better experts. I have a table which contains several fields with "user names" and other anagraphic data, included the fields "email" and "medical...