Search results

  1. D

    form recordset

    CJ_London, its pretty simple thing to know or in understanding, that if i am asking the name in different format i.e full First name and full last name (have in table which will be displayed) and with a condition, it should be initial of First name and full last name. If you see clearly in the...
  2. D

    form recordset

    here after 6th entry i need the name need to be given in different form, eg my name is Abc Xyz, after 6th entry it need to be A Xyz i.e inital fname and surname due to order formalities the amt should not exceed certain amt
  3. D

    form recordset

    Thanks for response Card|Orid|name|amt|telno 123 12 aa 20 123 124 12 aa 20 123 125 12 aa 20 123 126 12 aa 20 123 134 12 aa 20 123 125 12 aa 20 123 127 12 aa 20 123 This is...
  4. D

    form recordset

    have a table of name, order id, amount I need to generate a form such a way of the name is appearing 6 times the name should be initial fname and last name for 7th name and ahead and also appears 12 times then it should be divided as initial fname and lname of more than 6 and fname and initial...
  5. D

    Excel Export

    I have a situation here, i am having a table in access from where specific columns need to get exported in excel. these things i need to do: 1) Excel where the data is exported, some cells have formulas which is needed by customers 2) The column names are different 3) and at the end of all the...
  6. D

    Making Table Query

    Here i have a situation i have a table where like below Name | orderno | mail no | contact No | --------------------------------------- a |123 |5555 | 553453 | b |321 |8569 | 52353 | a |123 |2344 | 553453 | c |143...
  7. D

    Email Writing

    I want to write a email where there are 2 or 3 different ordernumbers for same email, i want to include the email in the mail part as single column table. how to do it? also can i use result of one recordset for other recordset?
  8. D

    Code not working

    My mistake..tanks a ton
  9. D

    Code not working

    yes its going in the if statement and deleting the qrytemp1
  10. D

    Combo Box Problem

    Hi All, This is bit lengthy to explain i hope i can make understand. I have a combo box whose row source is order_number, when i am typin a number it gives me the any full order id started with the keyboard input number and when i enter next digit it takes value after the full order ID. For...
  11. D

    Code not working

    Hi i have written a query: Dim fdate As Date Dim tdate As Date On Error GoTo Err_cmd_Details_exp_Click frdate = from_date.Value todate = To_date.Value DoCmd.DeleteObject acQuery, "qryTemp1" If (from_date.Value <> "") And (To_date.Value <> "") Then 'Me.Form.RecordSource = "select * from Master...
  12. D

    Error 2391

    hi I have written this code: On Error GoTo Err_cmd_vimport_Click Dim f As Object Dim srs5 As DAO.Recordset Dim fname As String Dim str2, usrname As String Dim str_qry As String Dim Vname As Field Dim Vch_count As Integer Dim dupvchrs As Variant DoCmd.SetWarnings False DoCmd.RunSQL ("Delete *...
  13. D

    Date variable

    I have a form where i input a date which is used by current form, i want the same date is used by another form, how can i do it?
  14. D

    Date Collection

    I have a already made mdb where a report is getting generated by now date, i want to include date which i want, what will be the best way to do this?
  15. D

    Date Range Problem

    I am trying to get the records on start and end date, still showing error no records found, Please help. My code is like this: Private Sub Command90_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Dim strReport As String Const strcJetDate = "\#dd\/MM\/yyyy\#" If (Text86.Value >...
  16. D

    Displaying Records

    Thanks its been solved now, as i had set it on single form i changed it to continous. :o
  17. D

    Displaying Records

    Its working , but showing only one records for order_number where as there are cases where there are more records for one order number.
  18. D

    Displaying Records

    i want to display this result in Form
  19. D

    Displaying Records

    I am on code want to display records on the form by order_number, but i am unable to do it. Please help me if i am going wrong anywhere: Private Sub Combo63_AfterUpdate() Dim rs As DAO.Recordset Dim intcount As Integer On Error GoTo ErrorHandler Set rs = CurrentDb.OpenRecordset("SELECT * FROM...
  20. D

    Forms Condition

    I have a situation here, My table have orderid along with other columns, i want to create a form where i am having a textbox for order id input by user. Firstly when user sees the form its only with the textbox and table fields, when i put the order id in the textbox the listing should be...
Back
Top Bottom