Hi, thanks for the reply.
I'm using Visual Basic 6.0.
I also need to read file properties of jpeg and other image files as well. Does this work with them too?
Thanks,
Wayne....
waynetheengineer
Last Activity: Jun 5 '07, 07:15 AM
Joined: Mar 27 '07
Location: Vancouver, Canada
-
Thank you, I will try it out :)
Wayne....Leave a comment:
-
waynetheengineer started a topic Reading filenames and file properties in a directoryin Visual BasicReading filenames and file properties in a directory
Hello everyone :)
I am trying to write VB code for reading filenames and file property values in a specific directory.
For example, I have a directory called C:/Bears and in that directory are three files: Brown Bears.txt, Black Bears.txt, and Orange Bears.txt. Each of these files have text descriptions in both the Title property field and the Comments property field of the each file (when you right click the file... -
The .Quit command works perfectly. Thank you very very very much! :) Case closed.
Wayne....Leave a comment:
-
Can't open Excel file after running VB program
Hi everyone,
I have a program that opens an Excel file, reads data from it, then closes the open workbook. But when I exit my program and go to edit that Excel file, it won't let me open it. When I double click it, the screen blinks for a fraction fo second but nothing opens. I have a suspicion that VB isn't properly closing the Excel file, eventhough I put the following statement at the end of my code:
...Code:ApExcel.ActiveWorkbook.Close,
-
Thanks for the reply,
I'm still fiddling with this issue, to no avail.
Anyone else have any suggestions?Leave a comment:
-
Thanks guys! :) I got it.
This is the code I ended up using:
...Code:Dim frm As Form For Each frm In Forms If frm.Name = "frmProjectsTotal" Then Forms![frmProjectsTotal]![cboCity].Requery Else If frm.Name = "frmProjectsSearch" Then Forms![frmProjectsSearch]![cboCity].Requery End If End If NextLeave a comment:
-
Ok I tried some more stuff... Here is what I came up with so far:
In my module I wrote:
Option Compare Database
Option Explicit
Public Sub WhichForm()
If Forms(frmProjec tsTotal).Curren tView <> 0 Then
Forms![frmProjectsTota l]![cboCity].Requery
Else
Forms![frmProjectsSear ch]![cboCity].Requery
End If
End Sub...Leave a comment:
-
Hi Mary, good to hear from you, as usual,
Since I'm an Access noob, I'm not sure what you meant by pass the form name to a global variable. I read up on this, and apparently global variables are defined in modules that run at startup. So I created a module called WhichForm. Then I defined a string variable called:
Dim WhichForm As String
I'm not sure how my form would call this module.
...Leave a comment:
-
hmmmm still workin at it. I did some error checking with error dialog boxes that pop up telling me which conditition the program entered. No matter which form is open, the program will always enter into the first condition, it never enters the else condition (even when frmProjectsTota l is not open). hmmmmm......... ....
hmmm
any more suggestions?Leave a comment:
-
Access not recognizing if one of two forms is open or not
Hi,
I'm trying to write code for a form when it closes. It's supposed to requery a combo box depending on which form is currenlty open in the background behind the current form, shown below:
Private Sub Form_Close()
If Forms(frmProjec Total).CurrentV iew <> 0 Then
Forms![frmProjectsTota l]![cboCity].Requery
Else
Forms![frmProjectsSear ch]![cboCity].Requery
... -
Printing to a printer or pdf file
Hi all,
I'm trying to set up two buttons on a form:
one to print a report to my printer (which happens to be set as default printer in windows) and,
another to convert the report to a pdf file (which is not set as default)
Is there a way to write code in the buttom click event to change which printer it prints to (either \\W1\HP Color LaserJet 1500 or Adobe PDF)?
The code that I have right... -
Check out Mary's solution, it works great.
Thanks again,
Wayne....Leave a comment:
-
I replied to your last message as you made this message, so yes it does work :) And what are you doing up so early in Ireland, get back to bed!...Leave a comment:
-
Again! Mary, you are two for two with my postings. Your code works perfectly. I should alert Rabbit of this code.
Thank you! :)
Best regards,
Wayne....Leave a comment:
-
Hi Rabbit,
Yeah it is strange. I even tried your Me.Refresh in my code. I put in in my click event on my combo box so when I click to open the combo list options, it should refresh the list immediately. hmmm, what event are you linking your Me.Refresh to?
Wayne....Leave a comment:
-
Yes, you were correct. Your suggestion works perfectly. I'm using MS Access 2002 and the table I created doesn't have the Short Date option selection form the Format field box. But when I downloaded an inventory template from the net, the table there did have what you were speaking of. All I did was just paste this template table in and use it instead. I don't know why the table I created originally has different option types than the template...Leave a comment:
-
Combo Box Requery Not Working
Hi,
I have a combo box on a form with a list of cities in it based on a single field city table. I also have a command button on this form that opens up another form that allows the user to enter in new cities to the city table. Now, after i dd new cities to the table, and when I go back to drop down the city combo box, the new cities I added aren't in the list. I researched tutorials and found that combo boxes need to be requeried... -
Hi,
Thanks for the reply,
I set the Input mask field to short date using the input mask wizard. It outputs the following in the input mask section:
00/00/0000;0;_
but it still won't restrict the number of days to 31 and the number of months to 12
Any other suggestions?
Wayne....Leave a comment:
-
date format not being applied in table view
Hi everyone,
I am trying to set up a date field to only allow users to enter in a date in the following form:
03/26/2007 (month then day then year)
I have this in my General tab for my date field:
Format: mm/dd/yyyy
Input Mask: 00/00/0000;0;
According to tutuorials I've read, this should work. It should not allow users to enter in months that are...
No activity results to display
Leave a comment: