Search results for query: *

Thanks BobStubbs, but I got it working. I had my joins, joined incorrectly - go figure. I finally got something that Access liked and like magic it's working. I am sure that your post will benefit some else in the future. Right, I need to have the reports previous days activities printed and...

The problem I am having is the data does not display when I run the query. I need a "Where" clause, but I can quite figure out what where clause to give it. The information is already in the table I am just trying to display it in a report. This is the SQL that was generated from my query...

I already have a table sstructure (4 tables): I need to extract all this information from the tables and with a push of a button create a report that I can email to my manager daily. Any help you lend with be most appreciated. Thanks in advance tbl_filename filename_id dir_filename...

Absolutely BobStubbs that's what I want.

Has anyone ever heard of software (COTS, or otherwise) that tracks the movement of individuals logged into a database. I have a database extracts files from directories. Users have to log in to use it. I have to be able to track what files they used or copied to other directories.

I have the form and the tables setup. I am trying to (also) capture the name of the person that is transferring the file from one directory to the other. I have not been able to do that successfully. Can someone help in this regard? This is my table setup: tblFileHistory FileName...

Beginner - Wannabe Intermmediate. Yes, I have the user logging on (into the database), but how can I capture when they transfer a file from one place to the other in a table. I need UsrName, date/time file transferred, Name of file transferred.

I have a form that allows the user to transfer a file from one directory to another. The information about the transfer (date, time, etc) is displayed on another form. How can I collect that information in a table and also include the name of the person that transferred the document to in the...

Thanks, I know. Has to be done programmatically

Does anyone know of an application (or something) that allows you to copy the contents of a database table to a different format? For instance TableX contents copied into an excel spreadsheet or text document (comman delimited).

Okay I have a few hundred dbs in this folder. That code seems specific to one db at a time. Where do I put this code in the AfterUpdate event of the form?

How does the shell command work and where do I find it? I am not exactly making a copy per se. I want to move older databases from one folder to another. The other folder is to be used for archiving. 'Moving' physically removes the file from the folder (I think). If I make a copy I'll...

Hello Experts I would please like some assistance with the following problem. I have a lot of databases in a file folder on my hard drive (F:\mdbs) I would like to create two buttons on a form that: Button One 1. Copies (move) the files that are in (F:\mdbs)to a new folder...

I don't know if this is the right forum, but here goes. I have two command buttons on my form, one I want to be able to transfer a database that is located on my hard drive to another location (copy to disk) and the other I want to just transfer the database to another folder located on the...

I got this code from Candace Tripp's website. It's used display images from a folder in a from - storing the image in a relative path in the table. The code worked with her desgin, but she used a single form. I have a form and subform combo. Choice from combo box (cmboChoice)displays the...

The pictures are located in a folder on my hard drive. If I pass the db to someone else, I get a warning stating that "it can not locate c:\mypic\myfolder\whyme.jpg". The program is looking for the pictures on my machine. The files folders on other machines are set up similiar to...

I am not familiar with the CurrentDb.Name property. Is this similar command in Visual Basic's App.Path in MS Access? Public Function GetDBDir() As String Dim sDBName As String sDBName = CurrentDb.Name Do While Right$(sDBName, 1) <> &quot;\&quot; sDBName = Left$(sDBName, Len(sDBName) - 1)...

I can't have everyone having access to the files. And wouldn't that work only if I were on a network?

I am not sure of the terminology, but how do you 'create relative paths' for pictures in a database. Presently I have the full path (c:\my\picture\you.jpg) to the image stored in a text field within the db, but when I distribute the .mdb to others I have (or they have) to change the directory to...

I am not sure of the terminology, but how do you 'create relative paths' for pictures in a database. Presently I have the full path (c:\my\picture\you.jpg) to the image stored in a text field within the db, but when I distribute the .mdb to others I have (or they have) to change the directory to...