I have a procedure that is going through and checking to see if a file exists in a destination directory and if not then copying the file from the source directory. The problem that only happens very occasionally is that files are constantly being copied to the source directory. Occasionally I...
Hi all, I have a program that I am doing to help a friend copy files without having to do it manually, in VB 2K5 Express that I need to incorporate a timer but have not had any luck as I am not very familiar with this control. I think what I need is fairly simple. I have a button on a form...
I need to copy files from one directory to another. The problem is that while I can use the folderbrowserdialog to get the folder paths, and I have a source and a destination variable, I need to copy only files that are not already present in the destination and there will constantly be files...
I am trying to automate the Summary Title for files. How can I do this? Here is some code that I have put together Just to see if I can Display the Summary Title for a file.
This works for the file name but I need to work with the Title property of a file.
I have:
Function SummaryTitle()...
Thanks for the help guys.
Here is the code.
Form beginning date is Forms!FrmCombo24
Form Ending date is Forms!FrmCombo26
The SQL for the query is as follows
SELECT UPC_PRODUCT_HRS.Date, UPC_PRODUCT_HRS.UPC, UPC_PRODUCT_HRS.Type, UPC_PRODUCT_HRS.Prod, UPC_PRODUCT_HRS.Ovt...
Thanks for the help guys.
Here is the code.
Form beginning date is Forms!FrmCombo24
Form Ending date is Forms!FrmCombo26
The SQL for the query is as follows
SELECT UPC_PRODUCT_HRS.Date, UPC_PRODUCT_HRS.UPC, UPC_PRODUCT_HRS.Type, UPC_PRODUCT_HRS.Prod, UPC_PRODUCT_HRS.Ovt...
Thanks for the help guys.
Here is the code.
Form beginning date is Forms!FrmCombo24
Form Ending date is Forms!FrmCombo26
The SQL for the query is as follows
SELECT UPC_PRODUCT_HRS.Date, UPC_PRODUCT_HRS.UPC, UPC_PRODUCT_HRS.Type, UPC_PRODUCT_HRS.Prod, UPC_PRODUCT_HRS.Ovt...
Thanks for the help guys.
Here is the code.
Form beginning date is Forms!FrmCombo24
Form Ending date is Forms!FrmCombo26
The SQL for the query is as follows
SELECT UPC_PRODUCT_HRS.Date, UPC_PRODUCT_HRS.UPC, UPC_PRODUCT_HRS.Type, UPC_PRODUCT_HRS.Prod, UPC_PRODUCT_HRS.Ovt...
I have some reports that step through a recordset (Table) but would like to narrow the recordset down by using a query as the recordset instead. My problem is that when I use a parameter query that gets the date range from a form it bombs out creating the recordset. I dont think that when it...
Thanks for the help everyone. Works like a charm!
Here is the final code
Private Sub List4_DblClick(Cancel As Integer)
Dim song As Variant
Dim volume As Variant
Dim row As Variant
row = Me!List4
song = Me!List4.Column(0, row)
volume = Me!List4.Column(1, row)
MyHyperLink.HyperlinkAddress =...
Hi,
I have an MP3 archive db that contains a list box control. I would like to put some VB in to lauch then player and play the song when the "Listbox" is double clicked. I only need to know if there is a statement that will do this. I can come up with the code to determine the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.