Search results

Hello, I have a little problem: I have a report with data, but the data is somtimes to much (big) for one label. Acces comes up with this stupid message 'Some data may not be displayed.....' Does anyone know how to disable this 'information dialogs'? Many thanks! It took me hours and still I...

Morning! I have a little problem, but big enough for me to play with it for hours, and still I haven't found the solution. Time to ask help. This is my SQL-statement: sql = "SELECT * FROM Music WHERE artist = '" & sArtist & "' AND title = '" & sTitle & "';" The problem: when a ' (apostroph?)...

Hello, I have a little mp3 database and i want to play a song when i click on a button. I can open winamp, but the song won't start. If i open winamp mannualy with a shortcut, I can play a song automaically, but in access it wont work. Any ideas? Thanks. Albert

Hello, I have a little problem. My field contains the following kind of data: 100b1 100b2 100c 100d1 100d2 1a 1a1 1b 1000a 1000a1 1000b I need to split this field into two fields. All the numbers before the first character must be a field and the remaining characters/numbers must be the...

Hello, Maybe a stupid question, but I have BIG troulbe with a report. I want a report, based on a form. I filter the form to find specific data and from the filtered form I want to make a report. I can't make it working! Does anybody know how to make a report based on a form? Thanks! Albert

Hi, i was wondering if it is possible to write code (vba) with vba. I need to build some kind of wizard, to add a command button to a form and behind the command button in the 'on click' event must come some code that the 'wizard' generates. Does anyone know if this can be done? greetings...

Hello, I have the following, simple code: Dim From As Integer Dim to As Integer From = InputBox("From Date") to = InputBox("To date") Me.Filter = "[Year] between from and to" Me.FilterOn = True Access can't pass the value I entered in the inputboxes to the filter syntax. When I click on...

Hello, Does someone know the SQL-Statement to count howmany fields are in a table? (count the colomnames) Thanks, Albert

Hello, I have the following, simpel code to create a commandbutton: Dim cmdTest As Control DoCmd.OpenForm "frmcopy", acDesign Set cmdTest = CreateControl("FrmCopy", acCommandButton, acDetail) DoCmd.Restore Now I want to assign a caption and a name to the new control, but I don't know how. I...

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 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...

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

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...

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...

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...

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

Hello, How can I check if a directory exist? I.e: I have a directory c:\database\photos\0. I want to check if this directory exist and then create a directory, called c:\database\photos\1. Can VBA create a directory? Thanks in advantage for helping me. It's becoming a serious problem for me...

Hello, I want to delete a file (several files) with VBA. But i can't find anything about deleting files. Only copying files. Does someone know the code to delete a file from the harddisk? Thanks a lot! Albert Romkes

Hello, I want to search in a table. In a textbox the user had to type the name of the name of the person he is looking for. In the table is a person called "Marinus". I want, when the user types "Mari" that "Marinus" is found. My SQL statement looks like this: Dim rstthumbs As Recordset Dim...

Hello, in Access97 I'm using this statement: dim db as database In Access2000 is doesn't work! Does anyone know what the right statement is? Thanks a lot. Albert