Search results

Hello, I have this function that search for .jpg files: Function Filecount(strLookin As String) Dim file As Variant With Application.FileSearch .FileName = ".jpg" .LookIn = strLookin .SearchSubFolders = True .Execute For Each file In .FoundFiles Next...

Hello, I post the anwer here, so someone can correct me if I'am sending you in the wrong direction. Your demands: If form 1 has a record with number 1 then you don't want form 2 to have a record with number 1, but with number 2. And so on.(For clearity) The first table must be autonumbering...

Hello, (I am not sure if I understand your problem) If the forms are based on the same table, it should automatically generate a next number. If you open form1 and it shows a 1, then the 1 is stored in the table. If you open form 2 then autonumber generates a 2. If they are not based on the...

Hi, just a guess... If you update the tables by a form, check the RecordsetType. If it is snapshot, you can't update a record set. Change the recordsetType. Albert

Hello, You also can put the setfocus stuff in the 'On change' event. So if the text you are typing matches, it will automatically moves to the other control. (If textbox.text = "mytext" then othercontrol.setfocus.) Greetings, Albert

Check out this topic: http://www.access-programmers.co.uk/ubb/Forum1/HTML/005912.html Albert

Hello, I have been thinking the whole day, but no good solution came along. So I ask it in this forum. How can ik reach the following: I have several directorys with files. In a dir there may not be more than 150 files. I dir 1 are 123 files, in dir 2 are 145 files in dir 3 are 100 files. Now...

Works great! Thanks. However, can I also count the number of (sub)directorys in a certain dir? Thanks. Albert

Hi, I need to know how much files are in a dir. There may be no more than 150 in a dir. How do I count the files in a dir?? Short question, big trouble..... Thanks, Albert

Already found the solution! I'am not complete awake i think. Found it in the help....

Hello, Is it possible to change the properties of a file? I.g. I have a file called 1.jpg, but it is read-only. If I want to delete this file with the KILL-Statement, access says: error by entering the file. (No access to the file) How can I change this, so I CAN delete read-only files...

The last sentence: forms![formname]![controlname] = property_id I'am not sure about this. Albert

Hello, (I searched the forums, but didn't find what i was looking for) I have a question about error handling. If I -in the top of my module- write 'on error goto errhandling' and in the middle -in a WITH-statement' I write 'On error resume next' , why is the first error handling working and...

YOOOO! I have already solved the problem. It was a very, very, very, very stupid mistake... And it was the 'maximum = maximum + maximum' part... Thanks for the reply, Travis! Albert

maximum = inputbox(......)Maximum files in a directory. rc = recordset with info about images to be copied. ("SELECT * FROM PHOTOS WHERE DELETE = -1") archief = Target recordset. (Info of rc must be copied to this table!) **************** Here is my code: If Archief.RecordCount >= 1 Then...

Hello, I have a little counting problem. My code writes a file to a directory and everytime a file is copied to a dir, a record is inserted into my table. It is not allowed that a directory contains more than 150 files. So everytime a file is copied, my code count the records in the table. If...

Aziz, I used the following sql statement in my code. It get's a value from a form and it works great: ("SELECT * FROM " & afdeling & " WHERE verwijderen = -1") another example: ("Select * From tblnaam Where vaknummer Like '" & forms![formname].[controlname] & "*';") Hope i understand your...

Hello, How can I roud down a integer (With VBA)? I.e. if I type 3,7 I want it to be 3 and not 4. Thanks Albert

I can't use c because the application i'am workin at, is completely access-based...

Thanks, ed. You pointed me on the right direction. I hope i can figure it out myself now! Thanks again.