Search results

An attempt to explain the problem better, here are three examples of input... 1048:2628-3186(1-280) 1056:2628-3186(281-560) 1064:2628-3186(561-840) 1136:2628-3184(3070-3348) 1144:2628-3184(3349-3627) 1152:2628-3184(3628-3906) 1160:2628-3184(3907-4185) 1168:2628-3180(4186-4464)...

Hey, I was just curious to see how other people would approach the problem. Looking to share ideas. This is what I had imagined doing: for each spreadline in split(spread) spreadline = (replace(spreadline,":"," ") spreadline = (replace(spreadline,"-"," ") spreadline =...

Yes, the string can change in length. Any one of those numbers could range between 1-99999

I'm adjusting to visual basic after using Perl for a few years... it is difficult. I'd like to parse this text... 1200:3012-4130(1-560) 1208:3012-4130(561-1120) 1216:3012-4130(1121-1680) Into this table rline fstat lstat fchan lchan 1200 3012 4130 1 560 1208 3012 4130...

Okay, thanks. I'll try it out.

I am filtering using three separate fields.

Ahh, so instead of... CurrentDb().QueryDefs("testquery").SQL = modifiedsql Forms!testform.recordsource = "testquery"I could put... Forms!testform.recordsource = modifiedsqlThat is simpler. Thanks.

Yeah, the reason I modifying the query is to add a WHERE based on user input. If I don't modify it I will be dealing with recordsets of around 40,000 records. After it is modified I only have two or three records.

Ahah! If I reset the recordsource of the form (even though I'm setting it to the same query name that it was before), this results in the form reflecting the changes I made to my query definition. ? forms!testform.recordsource testquery CurrentDb().QueryDefs("testquery").SQL = modifiedquery...

I have a user enter some parameters into text boxes on a form. Based on those parameters I redefine a query. userparam = textbox1.Value newquery = "SELECT * FROM shottable WHERE ffid = " & userparam CurrentDb().QueryDefs("formquery").SQL = newquery Now I want the user to see the results of...

I have a form that I view in datasheet view. The record source for this form is a query. When I change the definition of this query, the change is not reflected in my form until I close and reopen the form. I have tried the requery function on my form but it did nothing. Any idea why this is...

Well... one step at a time. If you have any ideas about why FindFirst would not be utelizing my table indexes that would be helpful.

Yes I did see that warning... but lucky for me, I'm not working on a linked table. I will keep it in mind for the future though. Thanks.

Ahh, good idea, thanks. Also, using DAO.RecordSet.Seek works a lot faster than DAO.RecordSet.FindFirst It seems that rs.FindFirst was not using my table indexes at all... strange.

A snippet of code for future forum readers: Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("RawShot", dbOpenTable) ' index UniqReq(jd, sline) is defined in my access table rs.Index = "UniqRec" ' ...

As I said before, I tried defining an index for those three fields and it did not speed up my DAO.RecordSet.FindFirst function at all. This is strange I think?? However, I tried it again using DAO.RecordSet.Seek and an appropriate index. This time it worked wonderfully. So problem solved...

I have been using the DAO.FindFirst function in order to find records in my database but it seems to be very slow. I am confused because it seems to perform at the same speed regardless of the indexes on my table. That is... rs.FindFirst (tape = 160 and ffid = 32451 and sline = 2286)...

I am importing large datasets into my database from text files. I would like to add records in a manner so that if they are new, a record is inserted, but if they duplicate of one of my unique indexes, they update the existing record. In MySQL I run the following query for each record and it...

So, I ended up trying a different approach. I was worried about reading my entire text file into one string because the text file is very large. With some help and inspiration from this link: http://www.excelforum.com/excel-programming/599280-line-input-for-linux-generated-files.html posted by...

By reading the file twice I meant reading the file once in order to convert it to dos, and then reading the converted file in order to input it to the database. Anyway I'm gonna give the converting and then reading a try and I'll report back with how it goes. Thanks for the help. Selah