Recent content by AunN
-
A
display table data into text fields
Privateer! Thanku for the reply. But i have to write code in VBA editor in access and on clicking the button that code should be executed..how to do that? -
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... -
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... -
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... -
A
call user defined function on button click
Thanku programmers for the inputs it's done!- AunN
- Post #9
- Forum: Modules & VBA
-
A
Run Time Error 'No value given for one or more required parameters'
It's done Boblarson!! You are great..thanku.. can i get ur email for further corresponding..as i m learning basics and i need to take some genuine help.. -
A
Run Time Error 'No value given for one or more required parameters'
@Boblarson actually this is my first code in VBA and i don't have full understanding about your statement "You don't need......." secondly i have applied: Dim conn As ADODB.Connection Set conn = CurrentProject.Connection as it was the same project but now i m getting error at... -
A
Run Time Error 'No value given for one or more required parameters'
@ Boblarson You are right! As name is text field and i tried this: myCommand.CommandText = "INSERT INTO Table1([name]) VALUES(" & Chr(34) & name1 & Chr(34) & ")" but now i m getting "Run Time error - 91 Object Variable or with Block Variable not set" at line "rs.close" and one thing... -
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... -
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!- AunN
- Thread
- Replies: 8
- Forum: Modules & VBA
-
A
Query to delete only one record from table
Its Done!! Thanku..u were right!! One thing more once the delete message box appears asking for yes or no, on selecting yes i get another message box which states Resume without error. I click ok but it doesn't disappear. How it can be resolved? -
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 =... -
A
Insert Query - MS Access/VBA
Alan!! I have tried this command as you stated but no way out..neither the record enters the table nor i get any kind of message by dbms. Please re-look my problem!!