Recent content by Insentive

Need some help, in the following code i want a input box to pop up and request the user enter a valuee that will replace a previous one (amending). Currently after a press "ok" on the inputbox it askes me for the parameter value of the value i typed into the inputbox (not the variable). i dotn...

It doesnt specifiy the line of code it just says something about expects a action t be fired and problems with the OLE server. I will get oyu the EXACT error is necessary.

What is wrong with this code Private Sub Command161_Click() On Error GoTo Err_Command161_Click Dim num As Integer Dim Test As String Dim MainVal As String Dim varInfoID As String Dim varAppealID As String Dim varAppeal As String Dim strSQL As String varAppeal = Me.Combo4.Value varAppealID =...

RowSource is a query and therefore the rowsource type would be table/query.

I am seriously stuck on how to delete an item form a list box, Basically i want on the click of a button for selected item to be deleted from the list box. My first thought just simply do .removeitem then .itemselected but obviously that didnt, what was i thinking, Can anyone help me out here?

:o so how am i gonna put that together?

How do you count the amount of rows in a specific table using VBA ofcourse.

Hi Im trying to create some dynamics into my database, ive been trying to get to grips with most of the VBA functions. Can you guys explain how i could execute swql queries using vba or link me to any tutorials.

Jus ta quick one. Can you tell me the functions to add records to table and such. Im not 100% how to use the recordset functions at the moment.

Yerr thats what i was thinkign instead of over complicating things :D

okay i will explain to you what im going todo. The user searches into a text feild an organisation name, once found the user clicks and a list box is populated with employess to that organisation. Thats "ultimately" wha ti am trying to acheive.

Hmm... Im not sure how im going to loop the results of the search and display it in a listbox..

Im totally confused on how to do this, therefore i am here to seek help and advice. Bascially i want to search a table, get the results from the search to populate a list box. And also to select aresult from a list box and then get results to populate another list box. My VB skills are...