Search results

Hello everyone! I have one form with Clear_button that has onClick Event Procedure like this: Private Sub Clear_Click() Me.text1="" Me.SearchForm_subform.Requery End Sub I want to call this function on an other private sub Is there a way on doing this?? Thank you in advance

I m trying to write the following SQL statement in VBA: SELECT ID,Product,Size FROM Products Where Product ='A' AND Size = '1' I want to use the values from combobox 1(cmb1) for 'A' and combobox 2(cmb2) for '1' I know how to code it without the AND Operator like this: "SELECT ID,Product,Size...

Ok here is a tough one!(I don't even know if this might be possible) I have uploaded a sample database to show better what I want. 1.User selects from tbl1field1 a value. 2.He enters a value in ValueToTbl1EnteredFormUser In table3 I have preseted a what goes with what from table1 and...

Ok sorry guys for the continous asking but WHAT IS GOING ? I use a form to pass data in a query's criteria ! I use [Forms]![Myform]![FormCommand] in the criteria row.So when I open it, it prompts for the value of [Forms]![Myform]![FormCommand].Now I closed Access(2007) and when I opened it ,I...

Hello everyone ! I'm trying to figure out how to design a service scheduler based on the date a Product was purchased and date that the Product should be serviced based on Manufacturer recommendations. My problem is that I can calculate the date difference between datePurchased and...

Hello everyone! I'm trying to import data from excel to an existing table (table1) where one of the fields in the table is lookup in other table(table2) which has Number as datatype (bound value) although in excel it is as text, so when I import I get error (unmatched data types).I thought to...

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

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...

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...

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...

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...

Hello I have two tables that have the following fields: tableProd: tableProd.Prod, tableProd.valueProd, tableProd.dateProd and tableRec: tableRec.Prod, tableRec.Ing, tableRec.valueRec I want to create a query where it finds where tableProd.Prod is equal with tableRec.Prod and then multiply...

(I know this might be a silly question...) Is there a way on writing a custom function on the totals row in Access 2007? I mean there is a dropdown with sum , max,min , etc .Can I write something my own?

Hello , I have a table that seems like the attached pic Now what I really want is to have a sum by : product , month , year The problem is that I have more than 2 products (about 60) so I can t do it by hand everytime. Is there a way to achieve this in Access 2007 p.s. I m very new to access...