Search results

  1. A

    display table data into text fields

    Dear Programmers!! I need your instant help. i have to display table data into textboxes on form by clicking button. I m not getting it from net. I haven't found any help link. I know i need to write SELECT query for this. But how to make a connection. and then display data? Please reply me...
  2. A

    Access Run Time error '-2147217900'

    Dear Programmers!! I have a scenario in which there is many to many relationship between customer and movie tables. But there is intermediate table that is transaction. Customer is having fields (CustomerId primary key,NAME,ADDRESS) and Movie is having fields (MovieId primary...
  3. A

    Generate report for current input

    Dear Programmers!! I have a scenario in which through insert query i input some data into a table. Like i have a table customer, Transaction and Movies. There is many to many relationship between customer and movies. but the intermediate entity is transaction. Now one to many between customer...
  4. A

    Run Time Error 'No value given for one or more required parameters'

    Please have a look at the code: Private Sub Command0_Click() Dim name1 As String name1 = Text1.Value Dim conn As ADODB.Connection Set conn = New ADODB.Connection conn.Provider = "Microsoft.Jet.OLEDB.4.0" conn.Open ("C:\Data\SampleDB.mdb") Dim myCommand As ADODB.Command Set myCommand = New...
  5. A

    call user defined function on button click

    Dear Programmers! I want a help, as i m trying to call a user defined function on button call on form but i am not successful yet. Please give me some solution to this problem!! I will be highly obliged to u all!
  6. A

    Query to delete only one record from table

    Dear Programmers! As i m very new to access so i m facing many difficulties. I have a query. I need to know the query to delete specific record from the table. As i have written this query but it is not working properly. DELETE * from Transaction where TransactionNumber =...
    • AunN
    • Thread
    • Replies: 2
    • Forum: Macros
  7. A

    Insert Query - MS Access/VBA

    Dear Programmers!! Here is code to insert record into table. But i neither get any error message nor record is inserted into table. Please help me out. I'm very new to Access Database Development so need your kind guidance. Private Sub Form_Click() Dim dbs As Database ' Modify this line to...
Top Bottom