Search results

Hi all. I have a database that retrieves the metadata properties of a file: Path, Name, Size, Owner, Date Created, Date Last Modified, Date Last Accessed, Type. Now I'll be getting people to run imports on a directory every morning. The idea of that is to: 1) Import new files into the...

Hi all, I've got some code here for File Listing. Which will go into "tblMetadata". Now I've been trying to figure out how to incorporate the File Owner data into this, but a little stuck. After some browsing, I realized there are slightly different ways to do it. But not sure how to make any of...

Hi. I am trying to create an access database that will perform file backups for me. So I'll need to use code to do this. Okay, let's breakdown what I need to do into steps: 1) Set the UNC path of where all files are located (they will all be found in one main folder that contains sub-folders...

I have a main form (frmFileMetdata) that uses a query (qryFileMetadata) as it's recordsource. This query is simply two tables with a foreign key that matches the tables together. In my form, I have a button (that is supposed to open a file using the UNC path of that file (from one of the two...

Hi, I need to run a query to get the 'OriginalName' column to return back the 'RequiredName' column. I've actually done this in Excel as I'm experienced with formulas but not quite strong in the Access query department, anyone know what to do? Thanks. And if possible, to return another separate...

I want to be able to remove the last occurrence of "/" from data I have in a query.. like below: Original Data Example: X/Y/A1/ X/Y/B1/ X/Y/B2/ X/Y/B4/ X/Y/B7a X/Y/B8a X/Y/B3/ X/Y/B3/ X/Y/B9a X/Y/B4/ Required Data Example: X/Y/A1 X/Y/B1 X/Y/B2 X/Y/B4 X/Y/B7a X/Y/B8a X/Y/B3 X/Y/B3 X/Y/B9a...

I have the following code but it isn't importing the excel sheets into the specified table: Sub Import() Dim strPathFile As String, strFile As String, strPath As String Dim strTable As String Dim blnHasFieldNames As Boolean blnHasFieldNames = True strPath = "C://Documents" strTable =...

I found this very helpful bit of code to 'import' the filename and filepath of files into an access table: Option Compare Database Option Explicit 'list files to tables 'http://allenbrowne.com/ser-59alt.html Dim gCount As Long ' added by Crystal Sub runListFiles() 'Usage example. Dim...

I have a list of items that have a range of checkboxes to be checked. I have two specific checkboxes; 'Required' and 'Completed'. I need the 'Required' checkbox to enable only once the Completed checkbox has been ticked/checked. That is, I need one of the checkboxes to stay disabled until...

I've had a doubt for a while now, not sure if this has already been answered in a different context or thread. If in the event the location of a BE changes or the folder structure that contains the BE and/or FE changes, how could I avoid having to manually re-link the tables again? As in is...

I have a table of contacts that has the first and last names of employees. I want to use the full given name and the first letter of the surname to create a login username. For example: Wondering if I can make the username field as calculated and create an expression to use the names to...

Sorry for the confusing title. Let me explain. I created an issue register type access database to have better communication between staff and technicians. I found a template that I have tweaked to better suit my requirements. The startup form that the staff interact with looks like this ...

I want to navigate to records on my form, via combo box selection. In the afterupdate event of my combo box, I have the code: Dim rs As DAO.Recordset If Not IsNull(Me.cboMoveTo) Then 'Save before move. If Me.Dirty Then Me.Dirty = False End If...

Say that a user adds a record to the front end database. Is there a way to notify/prompt a message box in the backend database like: "This client version of the database has been updated, please refresh to see the latest records."? And then the user clicks OK and this automatically refreshes...

I don't know if any other threads have talked about this program. http://www.peterssoftware.com/aps.htm It's an application starter to automate handling of front/back end (Fe/Be) database startup requirements. Just wondering if anyone has used it before, and if it works well for them. Also I...

So I have a query that is running a delete blank records on form_open. Should that query be on the front or back end file? Also while I'm here, same question for Modules.. do those go back or front end? Thanks.

Hi. I have a bit of code that is designed to disable an user from closing the database via the top-right corner "X". Instead they follow the method setup in my own database to Close the Database. I've done this as there are some data that may be left in limbo if the database isn't saved...

Just really curious. Like I know there is no Sleep/Wait/Pause functions in VBA. But is it possible to maybe try a DoEvents with While loop to delay a button from being enabled? Because say I had the following code which has a button disabled from another event. Say that once I click on New...

Just wondering if there is a way to set permissions or some VBA that will render records viewable and editable only to the user that has created it on the split form? Currently I have it set as a single form. But surely there's a way of doing the above mentioned? My goal is that I don't want...

So I have a particular button that starts as disabled when a New Record is created and also when the form is opened. The button only becomes enabled once a certain text field has been updated. So I added an AfterUpdate event on the text field to enable the button. But obviously doing this means...