Search results

I have table with a list description and prices. However, some of the descriptions are the same but with differernt prices. If I create a combo box just want user to select description, how can I make use of this table in the combo box but only showing each descrpiton as a unique option?? Thanks...

2 tables, one is customer table and the other is invoice table. I would like to have a queries for each customer and 12 columns indicated 12 months, with monthly outstanding figure showing per column. Just want to know how to put the condition in the condition row! Thanks!!

Now the ACCESS 2003 said that the third statement Shell32.shell is not being defined!!:banghead: Option Compare Database Public Function getFileMetadata(filefolder As String, filenm As String) As String Dim objShell As Shell32.Shell Dim objFolder As Shell32.Folder Dim objFolderItem...

Call getFileMetadata(filefolder, filenm) Access point to filefolder and complained that the filefolder string in call GETFILEMETADATA is BYREF and the reference type is not match"!!

In the module, it seems I have to inclue the MS office object library. Anyone can help?? I am using ACCESS 2003 but Chinese version, please printscreen and let me have a reference to see where is the Tools/References in order to select the Microsoft office object library. Thanks a lot!! ##You...

I got the following code, but ACCESS complained ...... it should be the shell32.dll. Any idea?? Declare Function SHGetPathFromIDList Lib "shell32.dll" _ Alias "SHGetPathFromIDListA" (ByVal pidl As Long, _ ByVal pszPath As String) As Long Declare Function SHBrowseForFolder Lib "shell32.dll" _...

In order to act as a system, I would like to have a function or windows firstly displayed all the folder names in a drive, and then allow user to locate/select freely a folder among different folders. Is there anything for my reference or for me to start?? Thanks a lot!!

Option Compare Database Public Function getFileMetadata(filefolder As String, filenm As String) As String Dim objShell As Shell32.Shell Dim objFolder As Shell32.Folder Dim objFolderItem As Shell32.FolderItem Set objShell = New Shell Set objFolder =...

I have put more statements and tried to call this function, but ACCESS complained that the filefolder string in call GETFILEMETADATA is BYREF and the reference type is not match", any idea?? Is that I have to predefined something before the Public function!!?? Thanks!! Dim filefolder, filenm...

Sorry! It seems is not what I expected! What I would like to have is the length and width of the image file but not the file size of it!! Thanks a lot and hoping anyone could help again!!

I couldn't open the link successfully, would you mind copy the content to this post! Thanks!!

I got the following codes from internet, but I cannot run it successfully in ACCESS, any one can help?? Thanks Public Type Picture Height As Integer Width As Integer End Type Public Function GetWidthHeight(ByVal ImageFile As String) As Picture Pic.ScaleMode = 3 Pic.AutoSize =...

I saw a demo that the user could copy and paste a JPG format file physically to ACCESS, and then something happened, and ACCESS could read the JPG length and width size (e.g. 1.3 meter length and 1.15 meter width) into 2 individual ACCESS cells which is acted the same as user input to that 2...

For instance, first table export to EXCEL CELL A1 and then second table export to the same EXCEL but to CELL A5! I simply do not know the sytax to tell ACCESS to do the correct export! e.g. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EXPORTDATA", "c:\EXCELSHEET.xls", True

Yes! THis way worked well for the first record in the subform. Now I encountered this problem, I got siubform with records more than one. In this case, how can I update the rest records?? Thanks a lot!!

How to compare 2 strings in Access in order to determine one is biggest or highest than the other?? For instance, T1212345 vs W1212345. Thanks a lot!!

I have insert the subreport from forms, and it seems working! Is there any other way to insert grid line in subreport?? Thanks!!

I am using Access 2003. Is there any way to put grid lines among fieldnames and contents just like in Excel in the output of subreport? Thanks a lot!!

I have a main report / subreport relation, just want to have a fixed length of each printout. e.g the total number of lines of the subreport should be 8 lines. However, lots of subreports contain records less than 8. I would like to know how to insert of blank line in the subreport depending on...

IT SEEMS WORKING AFTER TAKEN OUT THE "dbOpenTable", LET ME EXPLORE MORE, AND THEN GET BACK TO YOU!! THANKS!!