Search results

Background: ======= 1. My directory Name is N:\ASCDATA\ 2. File name will vary but all with have same txt extension (there are 1400 text files) 3. They will all be fixed delimited and same format (which i can write a function and call the function) My Goal: ===== 1. Click a Button 2. After...

quick question... I am trying to import 1400 text files, they are all in same fixed delimited format. How can I do that?

Hi, I have about 1400 text files (fixed text delimited) and all have same layout and they are all in same folder. How can I shot a command in access to import all those 1400 text files information in one table? I dont want to import them manually. I already have the fixed width import design...

reply chkCensusRequired is the name of the subforms > tab > check box name

hmm, that did not work... If [Forms]![frmgroups]![Subform BasicCase].Form![CensusRequired] = True I tried above code and it did not work. There is a tab under subform basiccase and it's called tabservicesandfees. I am lost.................

I have a field on a Subform and that subform has 4 tabs. I just want to reference one field call chkCensusRequired from this subform. All I want to do on my main form is to read a check box thats on a subform's tab. HELP PLEEEEEAAAASSSSSEEEEEEE chkCensusRequired is a check box in the my...

Thanks everyone for helping me. I took 2 steps to do this. step1: form open method to hide and show two diff combo box. step2: change my code little bit. step 1 code ========= Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open If User.AccessID = 1 Then...

On Load did not work... Hi Colin, Thanks for your suggession. I tried it on Load and it did not work. Any other ideas ?

Hi, I am using following code when the form opens so I can set the my combo box row source according to user access. Any idea, why it's not working. Thanks ===== code starts here ===== Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open If User.AccessID = 1 Then...

I can't believe this.... I can't believe this. I have everything working and just needed some advice and NO ONE is willing to give me that.

Hi, Open the Database so you can be on the same page. (Access 97 version) http://www.southernselectbeer.com/database/Log On Cmplx.zip I have a form where I have about 50 buttons (frmReports) Some of the button needs to be password protected. So I created security Table with User ID, password...

Thanks.... Thanks everyone for your effort. I followed Pat's suggession and it worked. Thanks to Pat.... http://www.access-programmers.co.uk/forums/showthread.php?t=10972&highlight=change+memo+field

I am using a query for a report. But the query is total and memo field is not allowed in the total query. Method1: NOT WORKING I used left function on memo field. Notes: Left([note],255), even if i change the 255 to 99999 it only picks up first 255 characters. Method2: NOT WORKING I can't even...

Hi, Here is the MS Access database where I am trying to implement COM version of send mail. 1. http://www.southernselectbeer.com/database/FE-DV_QA_4 20MIN.zip (try this http://www.southernselectbeer.com/database and download the zip file) 2. Go to "frmSearch" 3. Select "Search" 4. Select...

version what version ???

Thanks... Hi Wayne, Actually, the Silicon Chips inside my head was switch to overload and I was unable to think. Can you believe that ? LOL LOL Thanks for waking me up. I am shock myself. Later Buddy.. Thanks for all your help. Moe

try utteraccess.... Hi Michael, Try posting at UtterAccess.com forum, you get a prompt respond to your issue. Good Luck. Moe

here is the sample database attached is the sample database for "Not in the List"..... 1. Click on Add order ( the first button) 2. On the order page, Try adding a new Value for Product. Good Luck Moe

Try this method... The following code is from microsoft and It works like a charm. Private Sub ComboBox_NotInList(NewData As String, Response As Integer) ' Add a new Name by typing a name in combo box. Dim intNewFA As Integer, intTruncateName As Integer, strTitle As String...

Finally it's done Ok, I finally figured it out. I am so shocked that NO ONE helped me or even gave me the good direction. === working version of the code = = = Private Sub Form_BeforeUpdate(Cancel As Integer) Dim NoteBefore2 As String Dim NoteAfter2 As String NoteBefore2 =...