Search results

Thank you all very much for your help. Looks like the prize goes to Fizzio. I didn't know it was possible to do that but I got it working great. Thanks a lot everyone.

Sorry that I wasn't very clear in stating my problem. Let me try it again. I have a form with a subform on it with an option group control and a command button control. This command button on the subform runs the event code: Private Sub cmdImportSwitchData_Click() Call ImportFW1Switch End...

I'm using Access 2k and I've created a form ("frmAudits") with a subform ("subfrmImportSwitchData"). I've placed an optiongroup inside the subform that I'd like to pass the values to a module, but I keep getting the error, "Microsoft Access can't find the form 'SubForm' referred to in a macro...

Thank you very much...just what I was looking for!

I want to open a tab-delimited file and lets say search a line for a tab. I looked on the net and found (or thought I found) that the ASCII character for a horizontal tab is CHR(HT). I've tried to use this in my code but when I search the line for tabs it does not find or recognize any. Below...

I think I have it working ok now. What a mess though. I got the update query working for 1 field and then opened the SQL viewer and copied and pasted that into the code and copied it 19 times....each one for all 19 fields. Seems to work well now. I just could not get anything like this...

I'm working in Access 2k and I have the task of of renaming all the data in a table with an a.k.a. names but I'd like to do this globally some how rather than line by line through the use of code. For example my Table1 looks like this: 1 2 3 4 4 2 3 1 2 4 1 3 I have a Table2 that has the...

This is just a wild guess because I have no idea how to do something like that with a query but, I'm wondering if you code write a little code that would do the following: Sub RunQuery DoCmds.SetWarnings(False) DoCmd.RunQuery....... DoCmds.SetWarnings(True) End Sub This very well may not work...

Assuming that your keyword field is something like this: KEYWORD Partners already acquired you could search the string for a space " " and use everything to the left of the space. For i = 1 to len(keyword) If Mid(keyword, 1, " ") then keyword = left(keyword, i) Exit For End If Next i This...

Thanks for the reply. I'll give it a shot.

My database which is about 30mb after compacting ran a program that I wrote which had a nasty infinite loop in it. I stared program and walked away and when I came back some time later I found the loop and corrected it. The problem now is that the file size for my dbase reads just over 2gb...

Not sure if this is the fix but while in the module goto Tools>References and make sure that you have the correct references for DAO, Active X etc. selected. HTH

Thanks Pat. Sorry I haven't responded for a while...was on my honeymoon. The only way I could get it to work and save the import spec correctly was to go into the text file and manually "fudge" the first line of data to create that extra field. Then when I imported it access saw 15 fields. I...

I'm using Access 2k and I'm importing a text file. I click on "Advanced" to create/edit my import specification and I want to have 15 fields in the import spec but whenever I save it removes the Field15 that I added and saves it as only Field1 through Field14. Am I missing some crucial piece...

I would set up and event procedure for the On Click event and put the following code in it: DoCmd.OpenQuery "Query1Name" DoCmd.OpenQuery "Query2Name" DoCmd.OpenForm "FormforTable2" Something on that lines should work or at least get you on track. HTH

Try using Chr(9) instead of vbtab. HTH

If I remember correctly I think I had a similar problem a while back and solved it by either placing the batchfile directly on c:\ or in a subfolder on c:\ but I couldn't have multiple subfolders beyond that. Anyway, give that a shot. As for the cause of the error I have no idea. HTH

Thanks pdxman. Looks like you slid your answer in there right when I was typing mine up. ;)

Ok. I found how to do it. I found this site that says: 1) Select the 'Tools' menu and select 'Options...'. (The 'Options' dialog box appears.) NOTE: If 'Options...' does not appear, click the down-arrow at the bottom of the 'Tools' menu to expand the menu. 2) Click the 'Edit/Find' tab. 3)...

I'm using Access 2000 and when you hit Ctrl-F or use the Find function the Find/Replace box pops up and the 'Match' field is always defaulted to "Whole Field". Is there a way to change the default 'Match' field to "Any Part of Field". It's not a real big deal but it's one of those really...