Search results

I solved this. Turns out I was making too much work for myself. I just created a function that performed the random calculation and used that variable in my code when each record loaded.

This article seems to focus on returning random records, and those records appear to be randomized based off their field data. I need something that will be a coin toss each time, and not consistently the same. I already was able to randomize my records, what I need, however, is to insert...

Hey everyone, I'm having a pretty hard time creating what should be a pretty simple query. I have a field called "Random" which I want to populate the fields with either a 0 or 1. The problem is I use this query: UPDATE words SET words.Random = Int((1-0+1)*Rnd()+0); Which obviously changes...

Interesting. I never would've thought about doing it this way in a million years. You're like a genie.

This does help me a great deal! I'm trying to wrap my head around why this works. Thanks, though!

Greetings: I am working on an application that converts various formats into text files after they've been OCR'd for parsing. One thing I need to do is find something in the text file and then go to the next line and combine that line with the line i searched for. Is this possible to do...

Yeah, it's a valid tif. It crashes at the OCR line, the create line works fine. I noticed that MS Office 2010 doesn't support MODI, but I still don't understand how I'm able to get functionality with everything except the OCR method.

The value is the file path... (eg: "c:whatever.tif")

Im testing some code to automate OCR in Access. I'm using this: Dim MiDoc as MODI.Document Set MiDoc = New MODI.Document miDoc.Create TextBox.Value miDoc.OCR Set miDoc = Nothing It keeps crashing MS Access. I'm not sure what I'm doing wrong. Any ideas?

Interesting. This may be more what I need. I'll look into this a bit.

Thanks for the tip. I'll look into this a bit more. His work is done on what seems is a grid, I'm not sure if it can be replicated with tiff files.

I was wondering, and I'm not sure if this can be done, but it's worth asking... Is it possible to use VBA to "Map" pieces of an image based off the user's mouse dragging selections. So the user would open the tif, drag/selection pieces of the certificate he/ she wants (each selection can be a...

Nevermind I figured it out! I had the SQL inside my loop which was displaying it 183 times. Whoops! ...sometimes it pays to take a break. Thanks for all your help.

I think my SQL statement is correct. strSQL = "INSERT INTO Temp ([CarrierName], [InsuranceCompanyA]) VALUES ('" & CarrierName & "', '" & InsuranceCompanyA & "');" But I'm still having issues getting the information to appear correctly. I think it may have to do with where my End IFs are? Any...

Re: Example of SQL INSERT using ADODB.Command and ADODB.Parameters objects I believe my SQL statement is correct now. strSQL = "INSERT INTO Temp ([CarrierName], [InsuranceCompanyA]) VALUES ('" & CarrierName & "', '" & InsuranceCompanyA & "');" But I am having issues getting the information to...

I tried doing that, but it returns nothing. I then DIMd them to Variants. Still nothing. They both work separately, however. Here is the code. CertEnd = FreeFile Open Text1.Value For Input As CertEnd Do Until EOF(CertEnd) Input #CertEnd, TheCert CarrierPlace = InStr(1, TheCert, "insured") If...

Greetings: I am trying to create an application that pulls text from a pdf and displays it into its applicable form fields. I will be extracting over 40 pieces of data from these certificates that get sent. I want each certificate to act as one record set, yet when I put in a request for the...

Nevermind, I fixed it! I wasn't declaring the proper field. Thank you very much. I never would've gotten this without your help!

This fixed it! My only issue now is that the other fields aren't corresponding to anything other than the first field. For example: Error Description repeats 4 times, while Expr1 changes.

For some reason, this code doesn't seem to be working for me. I've never really had a problem with MoveNext until now. What I'm trying to do is display all the applicable values form a query recordset into an email, but it's only displaying the last value. Here is the function I made: Public...