Search results

  1. S

    How to run a query on a column to give a different name

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

    Solved How do I remove a specific character at it's last occurrence in a string, from a query?

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

    Solved Using VBA to import all excel workbooks from a single folder?

    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 =...
  4. S

    How do I prevent duplicates being created from an import of directory listing?

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

    Solved How to cause a checkbox to become enabled when another checkbox is checked?

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

    How to automate re-linking tables from FE to BE, if the location or name of the destination folder changes?

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

    Calculating login username using given name and the first letter of surname?

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

    Solved How to get a startup form to open with blank fields but once in the database it open the specific record?

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

    Solved Navigating through a form using combo box selection?

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

    How to prompt back end database to refresh when record is added to front end database?

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

    How do I fill out this Application Starter for Front/Back end handling?

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

    Solved Do queries belong in the back-end or front-end of a database?

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

    Solved How to fix API declaration from 32-bit to 64-bit?

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

    Solved Is there a way to delay a button from being enabled?

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

    Is it possible to control what records a user sees on a split form? E.g. Only their record entries

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

    Is there a way to trigger an event only once and then disable it until a new record is created?

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

    Solved How do I set Web Browser Control to a default file?

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

    Is there a way to make a Database on startup, prompt the user to choose a form to open?

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

    Solved How can I fix this code, so that the time data are logged to the CURRENT record an user is working on and NOT create a new entry??

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