Search results

For instance, I got some dynamic length path with filename as follows: F:\OUTDOOR\9-8\W1250832 ABC\working 1.3-0.6 BOARD 720.tif Is there any easy way to get only the "working 1.3-0.6 BOARD 720.tif", which is the desired filename. Thanks a lot!!

Under ACCESS, I would like to locate a filename or filenames from any directory like what I do in Windows environment (My Computer or MY PC icon). For instance, under directory ABC, I got 3 Files, A1, A2 and A3. THen, if I only selected/highlighted the A2 and A3. Then I press a button in the...

Thanks! In fact, what I want is to import the selected filename(s) but not the file content to a table!! Any idea??

How can I selected some filename(s) from a selected directory in Windows environment and then import those selected filename(s) to a ACCESS Table!? Thanks!

Anyone!!?? Please.........and THANKS!

Thanks! How can my Access system VBA coding detects the error and show error message as part of the system instead the ACCESS showing error message and force the user to end the system?? Thanks again!!

In a internat environment, PC1 and PC2 is "front" and PC3 is "end" with database stored in it. How can user know the PC3 is switch-on or else error-message such as database not found or invalid path may appeared. For the time being I am already using hyper link to link front with end. For...

OK! I will try tonight!! Thanks a lot!!

Yes! You are right, I think the problem is that I have to do the following: Dim P1 as STRING P1 = PATH & "*.TIF" IF LEN(DIR(P1)) = 0 then ..... I suppose the P1 should be bounded by "", but it seems it shouldn't be!! Thanks a lot!!

For the present moment, I don't have a unique field to do so. Is that, I need such a field?? Cause right now, I only insert record to that file with custname, material code and unit price only!! Thanks!!

Path is a reserved word in ACCESS?? However, If I changed to PATH1, the LEN still given a zero value in one way or another!!

DIM PATH AS STRING PATH ="F:\ABC" If Len(Dir("PATH & '\*.TIF'")) = 0 Then MsgBox "NOT FOUND" Else MSGBOX "FOUND FILES!" End If] SORRY! No matter the ABC got files or not, the len function always = 0!! Any idea?? Thanks!!

I would like to have the subform displayed as a Excel sheet like format, and the display is pointed at the last bottom record! For instance A BOY B GIRL C BABY The ACCESS pointer is pointed at the Last record which is "C BABY". So that user can immendiately input a new record at the end if...

In Access, how to determine a directory with given path which is empty?? Thank a lot!!

SOrry! The thread just given the above advise!! I simply don't know how to make a call from the main form!! Thanks a lot!!

I got the following from another thread, but I simply don't know how to call the command from main form!! It always telling me "=" is missin! Any idea ?? THanks!! In your subform add a public sub like so: Code: Public Sub GoToLastRecord() 'Go to the last record in the subform...

I got a form / subform relationship. Just want to know how to locate the bottom record, when the user after some queries input at the main form. I desire to display the bottom end record (EOF), instead of some sorting and display the last record at top of the subform!! Thanks a lot!!

Re: You pass it to the second sub as a parameter . . . 1) What's aParam?? 2) It seems no linkage between SUb A and B!! THANKS!!

THANKS! ANOTHER PROBLEM, WHEN I put the following code in the module, even I have press the <CANCEL> key. The dialog box still appear once more. So, every time, the dialog box appeared twice, and I also need to press the <CANCEL> key twice before I cancel the action. Any idea?? Me.COUNT =...

How can I define a variable which can be used by another Sub and of course the value stored in it?? Thanks!! For instance: Private SUB A () DIM A1 as String A1 ="ABC" END SUB PRIVATE SUB B() PRINT A1 END SUB