Search results

Not yet. Suddenly I am called by other projects. A very busy period. but I'll get back as soon as possible.

I have to transfer an old dBAseIV system into access 2013. The command Docmd.Transferdatabase used to work with Access 2010. in access 2013 now it gives an error message sasying dBase IV is not ans installed database type. Here is the old working code: DoCmd.TransferDatabase...

Here is the transaction structure:Header:FirstName,LastName,Email,Language Normal:Dominique,Canyon,dcanyon@gmail.com,E - good transaction Normal:Domique",Canyon',,dcanyon@gmail.com - bad transaction because use of double or single quotes in the transaction are not allowed when comma is...

I have a module which reads a CSV transaction file line by line and adds the correct transactions to an access table and places the wrong ones in a logfile. Now some transactions are rejected twice there is even one rejected six times. Whereas one wrong transaction is processed only once. I am...

OK I shall try them and come back.

Yes the event does not get triggered. I placed a debug message just below the line where it says: Private Sub Sbox_AfterUpdate() even that message is not executed.

I have a multirecord continuous form that displays the results of a query. At the end of each row there is a combobox displaying a list of form names. The user selects one of these forms from the list and program fetches the detail data in that selected form corrosponding to the row where the...

Yes that was the culprit. Curiously I never got a message on that line. The program was just refusing to start no matter which button was pressed always the same message. Anyway many thanks. Now it works. Sometimes one looks at the same place hundred times and does not see the obvious.

The expression On Click you entered as the event property setting produced the following error: Procedure declaration does not match description of event or procedure having the same name Now this is the error message that I am constantly getting from any command button I hit on a certain...

Thank you Gentlemen or Ladies as appropriate. During those days before Chrismas I am on multiple projects and not in a great hurry on this one for the moment. So I can wait for a response. But when I have time I'll have a go at the second solution. Many thanks. Now I have got some real trouble...

Yes. If there is no other better way of doing it. Does this mean you are proposing to use javascript from within VBA? Do I need any change in the reference library for that?

Sorry for the late response but I was called in again for another urgent job. What I am trying to achieve is as follows: the user gets a csv formatted text file where there is a field containing names and other data such as dates, amounts, descriptions of objects bought or sold that is free...

Thanks the column addressing is OK. But how can I find the row which is selected?

I have an unbound listbox with 3 columns. Call it PeopleBx. How can I address the item in the first row and first column. How can I address the first column in the selected row and how can I address the item in row 3 and column 2. I tried with Me.PeopleBx.Selected and other possible variations...

I removed the spaces and it worked. Perfect. Thanks.

The query below is supposed to accept some characters from the user and bring up a list of records satisfying the criteria. TelephoneAAA is a table with many columns. The query does not give any error message receives input from user runs quietly and does not give any result. I know that the...

Sorry I was quite busy with other stuff. I managed to sort out both problems. Thanks for the help.

Hello Markk, I did what you said but this time although the listbox is populated the detail record part becomes empty.

Thıs is the query which is the rowsource of the listbox and the single detail record on the screen: Sub Searcher(sterm) Dim ForName As String, Cap As String Dim QryName As String Dim qdf As DAO.QueryDef ForName = "ListNumbersFm" QryName = "SelQy" Dim RowSourceQy As...

Done that. It says recordset is not updatable.