Search results

learnt new thing today...thanks

Dim qrystr, y As String qrystr = "SELECT SUM(Invoice_Log.Total_Orders_Processed) AS NoOrders," qrystr = qrystr & " #" & Format(Invoice_Log.invoice_date, "yyyymm") & "# AS orderMonth From invoice_log" qrystr = qrystr & "GROUP BY #" & Format(invoice_date, "yyyymm") & "#" qrystr = qrystr & "...

I have a date stored, lets say 22/07/2013, and i have a table with entry date, and ordernumber. i want to write a count of all the ordernumbers they were in month of july i.e from taking month and year from current month, from coding. Thanks in advance..

Try using: Private Sub cmdEditRecord_Click() If Me.AllowEdits = False Then Me.AllowEdits = True end if and Private Sub cmdLockRecord_Click() If Me.AllowEdits = True Then Me.AllowEdits = False End If End Sub

You can do it by on property sheet >other tab>pop up to yes.

We know when executing append query in a table if the query executed twice, then duplicate data get inserted, Is there any other best solution to avoid such cases?

Here the upload amt is going to be the same through out all the records that is 100, the table thats why can easily calculate 600, I have got the solution but if you have different solution to it, please tell me

Thanks CJ_London it worked now relieved

Attached Now

Attached will explain most of things...

I have an exe which i use for generating mail tracking number, the exe is independent, can i use this exe to open through my VBA program and what the result generate can directly imported and saved in access data base? Thanks in advance..

Thanks for the suggestion, i know that is true, but i achieved what i required, thanks both of you guys for adding something to my knowledge

Thanks for yor effort, this isn't your code, this is what i tried, as you have formatted a sample code for me, if you can format this at your end also that will be a great help, thanks.

This was previously used which is definitely not a solution....i haven't got anything yet so keeping it in the same way... Private Sub Form_Load() ********************REDEMPTION FILE IMPORT*********** On Error GoTo Err_cmd_vimport_Click: Dim srs As DAO.Recordset Dim srs1 As DAO.Recordset Dim...

Attached is the sample file of my table, there may be typo

Thanks for the response, but the result isn't seem to working

Its a nice idea, but i want it to store in separate column. which is the requirement.

Hi I am trying to display a table records on the form with this code: Private Sub Form_Load() Dim rs As DAO.Recordset Dim str As String On Error GoTo Err_cmd_vimport_Click 'defining the form recordset Me.Form.RecordSource = "SELECT Payment_Log.Ecard, Payment_Log.Ereference...

Yes, you are getting it right. order of records is determined by reference number and that is the only unique number in the table.

Here i want to ask i have a table amt | tax | deduc | Total 12 1.25 3 15 1.25 4 i want to run an update query where i need to take the total of amt, tax, deduc in the total fields, Please help.