Search results

Thank you very much for your fast reply! When I split the database do I have to use sql server , mysql or just a shared location where the back end would be located?

Hello everyone! Please tell me what is the best way to share my access database on a small local network ?(3-4 users) Thank you in advance

Ok I managed to figured out what the problem was!! I had to enter the following code: Between Nz([Forms]![SearchForm]![StartDate];"1/1/1900") And Nz([Forms]![SearchForm]![EndDate];"1/1/2100") Many thanks to John :) Cheers!

Actually when I enter the above code on the Dates Criteria (on my query) and click anywhere else the code deletes it self. When I enter : Between [Forms]![SearchForm]![StartDate] AND [Forms]![SearchForm]![EndDate] I have no errors on query but have on the form as mentioned above What is...

Btw I've downloaded your attachement and I'm not really sure where to look for the criteria you entered! There is no query to look for, there are only a form and a subform

First of all thank you for your replies! I ve set [Forms]![SearchForm]![StartDate] and [Forms]![SearchForm]![EndDate] to be general dates on the form so that it gives me a calendar on the right ? Is that perhaps the cause of error? And yes these are my actual fields

I get a message: The expression you entered contains invalid syntax. You omitted an operand or operator , you entered an invalid character comma, or you entered text without surrounding it in quotation marks. I f I hit enter the cursor goes to comma after [StartDate].

I 'm trying to save it on the criteria field under the date in the query but it won't ..

I work on a form where I have four comboboxes for : Category , Product, Month , Year , 2 buttons for search and clear . When I open the form there are all data displayed on a subform.When I choose criteria and hit search the subform filters out the results. Now I have to add 2 more textboxes for...

Thanks that was it!

Hello there! I have a form with 4 comboboxes.The comboboxes look in specific tables so that the user has a drop down menu to choose from. I've also created a button to clear the comboboxes, but this doesn't work ! I 've tried the followin:g On click ->Code builder -> Private Sub...

Thank you for your responses! Is there a way to choose the query (also by dropdown list) the form will search?

How can I filter a query based on several drop down list box so that the user can enter the criteria for the query? I actually want that if he chooses from one box the query returns for that specific criteria. If he chooses also from the second box ,query lists matches from first AND second...

Thanks again!

Ok I think I figured out what the cause was..Products should be Grouped by in the query I queried from ! lol

Thank you very much !(Always wondering why having same table/query on a relationship :) ) I think I should add : Where myquery.month=myquery_1 .month and myquery.year = myquery_1.year-1 AND myquery.product=myquery_1.product but now I have doubled entries.. Why is this happening ? I've...

Anyone please?

SELECT queryBudgetByMonth.Product, queryBudgetByMonth.ProductionByMonth, queryBudgetByMonth.BudgetByMonth, queryBudgetByMonth.MonthBDG, queryBudgetByMonth.YearBDG FROM queryBudgetByMonth;

Hello , I have a query with the following fields: Product , Value , Month , Year So I want to find the difference in value for same month in previous year . Month and Year fields were calculated with : Month: Format([DateP];"mmm") Year: Format([DateP];"yyyy") So I can't figure out the...

thank you for your reply I will try inner join