Search results

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...

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

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...

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...

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...

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...

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?

My mistake..tanks a ton

yes its going in the if statement and deleting the qrytemp1

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...

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...

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 *...

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?

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?

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 >...

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

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

i want to display this result in Form

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...

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...