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 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...
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).
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...
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...
I have four tables: (all information consolidated into one table named tblAll
TblHouse
House_ID
House_Descr
House_Type
Image_Loc
Loc_ID
Combo_ID
TblLoc
Loc_ID
Location
House_ID
TblOwner
Owner_ID
Owner_Name
Owner_Addr
House_ID
TblCombo
Combo_ID
Combo_Name
House_ID
Loc_ID...
How can I pass the parameters of a single field (tblCombo/Lg_Desc)based on the selection from a combo box? The form is being used as a pop-up.
This is the situation. I have a form with a subform. The subform is being populated with a lot of stuff via (tblCombo). A selection from an option...
I have about 500 97 dbs that I need to convert to 2k. Can I do this programmatically? That is, is there a macro (or some other code) I can use to do the conversion all at once. I really do not wish to do this one-by-one? Thanks for any guidance?
I don't know if I am wording this correctly, but this is the situation. I have a popup form that pops-up in the middle of a form. How can I get the popup form to appear in a specific location on the form; for instance, the bottom right hand corner of the form? Website? Previous thread dealing...
I want to use a form as a popup based on selection from a listbox. I already have it working, but I have to create a different form for each selection. Can I, based on the below table, pass the parameters of LgDesc and SubMenuName to a single form and have that form change based on listbox...
Can someone look at this and see why I keep getting a syntax error on my code. Thanks!
This is the error:
(Run-time error '3075': Syntax error in string in query expression 'MenuName="Details1'.
This is the sub it keeps blowing on:
Private Sub lstSubDirectory_Click()...
Can someone explain to me how I can get the selection from a combox to display in a subform. A web site or something. I've been trying to get this to work for three hours. Thanks!
Subform Name: tblResultsSubform
Combox Name: cboChoice
Display Info (for subform): FileName, FileDescription...
Here I go again. I have form which includes a Option Group, dropdown list, an image and a listview/grid display.
If I select a file from the dropdown I get the listview to populate with the necessary information, but I can't get the image to change or the option group to change.
This is how...
Can anyone tell me how I can alter the attached Explore97.mdb (http://www.mvps.org/access/modules/mdl0013.htm) to display on certain directory on a PC. Presently it displays every dir on the system. I have files located on v:\web\tools\files. If I only want to display those files located...
Can command buttons perform two functions at once. I have two command buttons. One opens a text box and the other pulls information from a table and displays it to a list box. Both buttons pertain to the same thing. The text box is giving a description of the information being displayed in...
How do I make an access form automatically resize itself depending on the screen resolution of the monitor? I think there is an API function to do this but I really don't know. Any ideas and samples would be very useful.
I found this code on mvps.org (reports section). It's supposed to allow you to print only the current (or one page) at a time from a report. I keept getting this error "can't identify or find RunID in expression". Does anyone know what the RunID in this code means?
Thanks!
Dim...
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.