Search results

Thank You Boblarson Great

Hello Dear friends, I use a search code in my form, I modified but it shows me an error: The original code is which is working (it searches the specified field) Private Sub cmdSearch_Click() Dim bkmk As Variant Dim strField As String Me.RecordsetClone.MoveFirst 'Find the first...

Thank you Boblarson, Worked perfectly... Greatest Thanks

Hello I need Your help: I'm using the code : =DCount("*","DATA","Product = """ & [Product] & """ And Brand = """ & [Brand] & """ And Model = """ & [Model] & """ AND Status Not In ('Removed')") It works, but i want to add additional field Dateofpurchase (Date and time field).. I tried in such...

Hi John! Greatest Thanks... This is the Search I needed..... (It is a real Smart and Instant Search) Very Good Sample Best Regards

As Usual, When creating the form with Options and values on it (Combo-Boxes, Text-Boxes Based on a table) has it's Navigation bar with Nav Buttons and "Search" function... I disabled Navigation Buttons, because i did myself with my design and customization (Working Perfectly - No problems)...

Thanks John!

I tested Every variant, but not working correctly it is not synchronized with main table ID

On My Forms Current Event I'm already using another VBA Code, How can I use then... I'm Comfused

Hello! Thank You for the reply, but Getting Error! When I put the code in the default value of the table

Hello Friends I'm making an auto incrementing numbers for my field (In Table Default Value, That to be filled automatically for a new record) I tried this code, but getting errors... Please help what I'm doing incorrectly.. =DCount("ID","DATA","ID <=" & [ID]) It's working from unbound text box...

How to Find unique values in a Table Field from Unbound text box =Dcount [Table] [Field] (Table Name is DATA and the field name is Dealer) Thanks

Hello James Thanks for the reply, but Couldn't understand where to put these codes or how to use them.... I use Command Button (Embedded Macro, Duplicate Record)

Hello Dear friends I have a question about duplicating the records.... I have a database and I have to enter many identical records with simple differences, Is there any way to specify amount of record duplication? for example: I entered one record, but I need it to be duplicated 9 times, I...

Greatest Thanks VBAInet Works Perfectly

Hello Friends, I have a such question.. I have a form on which is filtered records, and need to count: I have unbound text box and put =Dcount function.. Working well counting all the filtered data.. I want also another variant which will display in such format (if the filtered data is 10...

Greatest Thanks, Worked Perfectly................. Thank You Very Much!

Hello, Thanks for your reply... It's very good idea, but how to realize it... Could you explain with examples... Thanks in Advanced

I want to calculate Product Prices based on Dateofpurchase by ears... I'm Using Expression: =DSum("Price","DATA","Dateofpurchase >=#" & Format([Pdate],"mm/dd/yyyy") & "#") ([Price] -In this field are stored the product prices, [DATA] This is main table, [Dateofpurchase] In this field is stored...

I Did The Best: :) It Looks Like: If Me!cmdShow.Caption = "Show >>" Then Me!cmdShow.Caption = "Hide <<" DoCmd.MoveSize , , , 10000 Me.SForm.Height = 3000 Else Me!cmdShow.Caption = "Show >>" DoCmd.MoveSize , , , 7000 Me.SForm.Height = 0...