Search results

I have a problem here... My PC Regional date format is MM-DD-YYYY and i have been exporting an excel in which i need date column (dd-MM-YYYY) to be sorted desc; inspite of every method its showing mm-dd-yyyy and dd-mm-yyyy somwhere, Please help?

This Will be a help SELECT col1, col2, Count(col1) AS NumberOfDups FROM [Add] GROUP BY Add.[coll1], Add.[col2], Add.[col3] HAVING (((Count(Add.[col1]))>1) AND ((Count(Add.[col2]))>1)); Owise there is a design wizard in Access which will help solve most of the general queries. :)

I have a grat situation here, for which i need a help!!!! I have a table with column BId, LoginId, Label, URL. The table have following entries: BId | LoginId | Label | URL ------------------------------- 123 234 none xyz 123 456 open 123 456...

Firstly what the output you required?

Please explain how should i setup combo set?

It is still exiting out because of null value input in the combobox

That seems bit not possible as the DB is very large

I have applied this code, but still in testing it gives the same value=null in spite of inputing the correct value, what is the possible reason for this error?

combo47.value=null

Yes, Indeed

Private Sub Find_Click() 'DISPLAYING RECORDS FROM MASTER DATEWISE Dim Order_combo47 As Integer Dim rs As dao.Recordset Order_combo47 = Combo47.Value 'On Error GoTo Err_find_Click Combo47.SetFocus MsgBox Order_combo47 Me.Report.RecordSource = "select * from Orders_Processed where order_number...

Currently i hae created a textbox with format as short date in reports, i am unable to view the date picker in the All tab of properties, Please help :banghead: