Search results

Hello Friends, I need your help! I played with it but without any results.. So I'll describe what I need.... On My form i have a text boxes in one of them is displayed (Product model name: for example: hp100EU). I want when I click on it, it must open a Google and search for it... is it...

Greatest Thanks for The Help and Suggestions...

Access_guy49 Thank You for the reply... Of course I will not use this just for a close function, I just wanted to know, because i have more complex codes and needed to save and then to use (Call them)

Hello Dear friends i have a question about saving VBA As Global Module... While working with Access and VBA There are many VBA codes which we use very frequently for example: Private Sub close_Click() DoCmd.Close End Sub How to save this as Module and then call to a button? Thank you In Advanced

Please Help!

Thank You for the reply, but how to do this can you post according to my example above? I have to synchronize about 8 Combos to filter the Data perfectly. Thank you very much

Hello Friends, I need your Help! Yesterday i worked with my record filter form (With Your Help of Course) and did it (Combos are filtering data perfectly), I was very happy, but noticed that they aren't synchronized, they filter data only by their criteria (They filter data independently).. for...

Thank you Bob.... Working Perfectly.... Thanks for the suggestion I renamed it as QFilter, I think it is Normal and will not interfere with Access reserved word :)

Hello Friends, Need Help! I have a form where I filter the data by Combos, all data is filtered except Date/Time (Displaying Error) My filter form is based on Query [Filter], My form is Continuous Form.. I use On Combo After Update : Private Sub FData_AfterUpdate() Me.Filter =...

Thanks Bob

Thank you Boblarson... It works, but if there is not a data it displays error.. I think there must be changed something else: Private Sub cmdSearch_Click() Dim bkmk As Variant Dim strField As String Dim strWhere As String Me.RecordsetClone.MoveFirst strWhere = "Brand...

Hello Friends I need you professional Help.. this mini search is working perfectly, but i need to extend its functionality (I want that searched data to be filtered by its criteria).. When I'm searching the record in continuous form is searches, but not filtering the data, then i need to scroll...

Perfect! Thank You Boblarson, Greatest Thanks!

I'm Counting values in the table field like this: =DCount("ID","DATA","Product = 'DESKTOP'") If in the database is 50 desktops it shows 50.. Now i want to Count Two or more different values (for example if i have 50 Desktops and 50 laptops, it must count as 100) I write another code, but not...

Worked perfectly, Thank you pbaldy Very much

I'll Explain what i need: My main table is DATA with fields: Dealer (entered the companies, from where the products were bought) data type text Unitprice (the price of the product) data type Number dateofpurchase (the date when the product was bought) data type date/time

Getting Error, Not working :(

Ohh, Can't figured out this Expressions........ =DLookup ("UnitPrice","DATA" & "Dealer","DATA", "Dateofpurchase") I also Tried =DSum ("UnitPrice","DATA" & "Dealer","DATA", "Dateofpurchase") =DCount("*","DATA","Dealer = """ & [Dealer] & """ And Unitprice = """ & [Unitprice] & """ And...

Not worked, I tried many variants

Hello Friends, I need your help.. on My form i want to implement smart sum filter by Dealer and Date of purchase (fields are dateofpurchase and dealer) I created unbound text box where i want the sum to be displayed... (I think that I need DSum function) I tried in such way...