Search results

Hello All, I am trying to make an Update Query that will update a table that has the same account numbers and assign them a value....ie.1,2,3,4 and so on. Does anyone know how I can do that? Example: Accout Num Assigned Value 12345 1 12345 1 12345 1 12544 2 12544 2 12568 3 12569 4

Hello All, I am trying to make an Update Query that will update a table that has the same account numbers and assign them a value....ie.1,2,3,4 and so on. Does anyone know how I can do that? Example: Accout Num Assigned Value 12345 1 12345 1 12345...

Gemma-the-husky I have figured out an alternative. I placed a text box (hidden) on my form and used the .selectedItems.count method and am able to achieve the desired results. Here is the final code snippet........again, thanks for your help, you moved me in the right direction with the msgbox...

geeme-the-husky, thanks again for your help. I still can't seem to get this thing to work....lol. This is the code that I added to my project. Data = Application.FileDialog(msoFileDialogOpen).Show MsgBox (Data) Open Data For Input As #1 I am able to have the dialog box show and I can...

Thanks for the reply gemma-the-husky... I have tried what you have suggested, however, I am getting a Run-Time error '53 stating: File Not Found. Any thoughts on what I am doing wrong? I am thinking that I may have to capture the path with code, but I am not sure....... Here is my code...

Hello All, I am trying to open a file from a dialog box and then count the records in that file. I am able to accomplish this by actually hard coding the path, however, I need to be able to search for the file, then have the code look at the file and count the about of records that are in it...

Thanks Boblarson it works.

Hello All, Does anyone know how to count the number of characters in a text box? What I am trying to accomplish is something like this (I have some code): if me.text0=Len([text0].text)=9 then me.text1.enabled=true else end if However, I am not getting this to work. I have put it in the...

Does anyone have any ideas on how to goto the next line in a text document?

I have tried that, however, I am uable to get desired results. I keep getting a compile error.

Hello All, How can I tell the following code to drop down to the next line and retrieve that lines' data? If (Left(ImportedRecord, 12) = " ADV") Then “MOVE DOWN 2 LINES AND CAPTURE DATA” strfund = Trim(Left(ImportedRecord, 15))...

Thanks again for your help PDX……………………….Let me show you what I am trying to accomplish. Here is an example of the text that is being searched. Fund: YUI Account: YUI China 000004321 123456788 002340000 Total: $34,504.20 I already have written code that captures the Fund and the Account...

Thanks PDX_MAN How would I capture the text between line "A" and "D"? Example Line A="TEST"------this has been captured into the tablen already. If line A="Test" then move to line B & C & possibly D through Z and capture the data and stop if any line = "TOTAL". Thanks in advance for your help.

Toal is in the text line. I have isolated this string before with the following: Left(strpage,10)="TOTAL").

Hello all, I am working on a project that requires me to write code to access a text document and import that information into a database that is user friendly. I have code in place already to retrieve some of the information needed. However, I am having issues getting the next line of data in...