Search results

I have deleted alowedits and dataentry. I have done that. I did that. It still does not work.

fld2 should be fld1 my mistake sorry for that. The query that drives this form is an SQL select query. I converted it to an SQL UPDATE query but this time it is rejected as the recordsource. I tried to run it with the DoCmd.RunSQL but this time it asks the value of every field instead of getting...

Hello Experts, I have a form consisting of a list box and some fields belonging to a single record. When the user highlights a row in the list box then the fields show the details of that record. Now the whole process is Read only. But I wish to put a toggle switch on the form so that the...

OK Finally I found the culprit. I inserted a test message nearly at every two statements and here it is:fld = Nz(.Fields(findex(3)).Value, "0,00") This is a text field that contains a number of the format 00,00. It is always there. But in this record it is null. Well I did not check for null...

I have done as you said and used "On error resume next". Result the sub terminated as foreseen with good results. I could not find the culprit. By the way are there any plugins or addons on the market that help the developer to spot the erroneous statement with its number? Something like that...

I would like to post the program and database. But both are huge and contains a lot of private info. Now I will try to figure out a different algorithm to use. I'll give feedback. Cheers.

Only one of the recordsets namely ch is used in another sub but after it is opened and closed here. I have commented the rr and rt.close out, but this time it stops at the nothing statement and gives the same error. In fact after the error just the finishing message is issued and program is...

I am close to the end of a module and this error number 94 starts appearing. It always highlights recordset closing. Here is sample code: Public Sub ImportSheet() On Error GoTo Error_Handler Dim rr As Recordset, RT As Recordset, ch As Recordset Dim db As Database Set db =...

I deleted RT.MoveFirst and it works. Thank you.

I deleted RT.MoveFirst and it works. Thank you.

Public ch As Recordset Dim fld As String, Tline As String, Logger As String, Fbuffer As String, tot As Double Dim rr As Recordset, RT As Recordset Dim db As Database Set db = CurrentDb '----------------------------------------------------------------------------------- ' Clear the...

Hello Experts, I was almost finished coding a rather complicated module when I started getting this Error Number 3021. I looked around. It has something to do with the recordsets I am using but what. I cannot find. Could somebody help please? Many thanks.

Changed only one line and it works perfectly. Many thanks to both of you.

As you have suggested I created an indexed table with two fields. The automated number as ID and the Phrase. It worked. I got rid of the duplicates but now the problem is I can not restore the original sorting sequence. I sorted on ID but it does not help because the program deletes always the...

Good idea I'll try that.

I have given sample data in previous post. Program has Option Base 1 Previous post also tells where the data is loaded. If I define the array locally then it is difficult to pass it to a function as a parameter. In fact it can be stored in a variant to pass as a parameter, but I could not figure...

Well here is more info. I have a long field of text which can contain any number of words or single characters or numbers. I placed this long text field as a row in an access table. This row is scanned from left to right. When I find 4 or more adjacent blanks I take this as a delimiter for a...

Hello Experts, I have to deal with string arrays that store text. I need info on copying, comparing, appending arrays. Also on passing arrays as parameters to subs or functions. Could someone please point to the right source where I can get to this info quickly without having to browse through...

Yes I have tried that. But I am still getting 21.6 instead of 21.60 or 59.8 instead of 59.80. I am probably missing an obvious point but what. Also I have another related question which is giving the final result of the program. I shall export these numbers to a spreadsheet. How can I set the...

Hi All, I have been scanning the postings and could find things similar to my problem but not exactly the same issue. Here is the problem. I have a short text field where numbers such as "15.00", "2233.56", "-300.00" are stored. Now I want to convert the text field to numeric so that I have...