Search results

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...

I have a web browser control (wbFile) that will display a file on a form. The control source of the WBC is to a text field (txtFileLocation) that will contain the file location. I have a button (cmdBrowse) that is used as a browse function to open file dialog. I have created what I wanted...

Just wondering if there is a way to make a database startup with a welcome message box and button to open a certain form. This means there is no form set to default open on startup. Let's say there are only 2 forms for now. Will it be an AutoExec / Macro / VBA thing? Or is there a simpler...

I have a database that has been created for the purposes of file indexing. What this means for me is, an employee scans images and they will input various details (e.g. Their Name, Client/Requestor, Date Scanned, File Bar-code, Number of Images, Comments, etc) into the database form. This...