Search results

thanks for the suggestions I have managed to come up with a way of doing it which is short and sweet, dim strabbmonths as String *10 for j=-1 to 2 strabbmonths(j+1)=DateAdd("m", j, Now) strabbmonths(j+1)=Format$(j+1), "MMM") next j I tried it out, and lo and behold it worked !

I am trying to do a search for dates in the three letter format. That is I need the database to look through a memo field and find strings such as "NOV", "DEC". It needs to locate the positions ( using instr function) of these strings on the condition that these months are close to the current...

Have you got the link handy ?

as long as the tables are linked to the back-end part it should be a problem.

you could try the transfertext option.

There is a program which produces .txt files for various records in a database. How would i import this into my database as a memo field. The id of the record is contained in the filename e.g. 6tYUE.txt thanks

I am trying to write some code in VB which will go through a block of text stored in a record and pick out a special 8 digit no. in each record the number appears on the following line phone 001 3digits/4digits/8digitnumber of course each time the letters vary but the format is always the...

I have a subform, stuck in my main form, which I have been trying to order by one of the fields in the subform but to no avail thanks in advance regards Johnn

thanks for the above suggestions, it's working now. The reason was that I was putting the box in the page footer and not the report footer.

How can I produce a report that counts the number of times particular variables appear in a field. The field is called "Types" and I have set it so that each record can take on 1 of the following three values: "C/N & INV" "IN & OUT" "C/N" regards

Thanks for the advice. I tried it out, but when I ran the report,the following appeared: #Error Are there any solutions?? Thanks John

Hi everyone I am quite new to the World of Access(3 months) and I am encountering problems with one of my reports. I have one column containing prices of invoices. How would I go about adding a Sum total at the end of the report. I need to do this for two columns/variables. Thanks John