Search results

  1. D

    Check is someone has linked to a database

    Afternoon All Not sure this is possible, lets say: - I have a backend database (local tables) - Someone links to the table so they now see the data in the local tables Is it possible to see if anyone has linked to them? I understand the database can have a password which can put a stop...
  2. D

    Building the process

    Looking for some advice and hoping this is the best place to ask. I work on a team where we have over 70 applications spread out in the company, we receive emails to the inbox reporting faults, or problems and our team put these right. We are now looking to reduce traffic to the inbox by...
  3. D

    Data not visible to other users

    Morning all Hopefully I am posting in the right area for this. Go easy on me in case I use the wrong terminology when explaining my issue, I will try to break it down in points for ease of understanding. Example: - Both me and another user has an access database open - I complete a form...
  4. D

    Excel commands through Access

    I've had some trouble all week sorting through my code to update an Excel document This time, this is my trouble: Set xlSh = xlWB.Worksheets("ID") Set Selection = xlWB.Worksheets("ID").Range("B2") With xlSh .Range("B2").Value =...
  5. D

    Vlookup and Indirect through VBA

    Okay so I thought I was on a roll today (not needed to post all day, ha) Im transferring an Excel formula from Access-Excel, however VBA thinks I am using the ' to comment out part of the code. The Code: ActiveCell.FormulaR1C1 = _...
  6. D

    Putting data in to a set excel file

    I am trying to open a pre-saved excel file then put data in to it from an SQL query. what's actually happening with the code below is that it opens the pre-saved excel as intended, but the it opens a new workbook and pastes the data in to it. How can I paste the data only in to the pre-saved...
  7. D

    Using VBA to change the selected Excel tab

    I thought it would be easy, I must me missing something simple. Im using the below to populate data in to excel, once the data is in I want to select the 'ID' tab and put a test comment in cell C5. Public Sub ExportQuery(ByVal Query As String, ByVal ShowToUser As Boolean, ByVal TabName As...
  8. D

    Looping through list box controls

    Morning All Im seriously confusing myself What my code currently does: The code checks the values in 3 listboxes, the user adds items to the list box to check, the query then looks for data associated with each item and exports it to a new excel if it does NOT match. It will then check the...
  9. D

    Using a query to group

    I am trying to group together a list of manager. The query works, its showing the managers name 3 times (3 people also on the team). I am clearly grouping incorrectly and would appreciate some help. My Code: SELECT DISTINCT [_tbl_Structure].Supervisor...
  10. D

    Pulling data depending what form is open

    Morning I have multiple userforms - From all the form users can click a button that will open another form called frm_complaints_manager When the frm_complaints_manager form opens I want it to detect which form is open and pull some data from it. I had no idea how to achieve this so came...
  11. D

    Counting based on dates

    Afternoon I have a query and need to achieve the following: - Count number of calls from agents from tbl_Genesys_Weekly - Count number of times agents appear in tbl_ReferralsYTD based on the week commencing date from tbl_Genesys_Weekly + 7 So far I have this and its not going to plan at...
  12. D

    Converting query builder SQL to VBA

    Morning I am trying to put query builder SQL in to VBA but struggling. Current code is: SELECT [_tbl_Structure].[User Name], tbl_Genesys_Daily.Field7, tbl_Genesys_Daily.Field12, Count(tbl_plans_yesterday.[User ID]) AS cntUID, ([field7]+[field12]) AS calls...
  13. D

    Trying to calculate data from two tables

    I am using query builder to pull some figures. The following shows the data I need: SELECT [_tbl_Structure].[User Name], tbl_Genesys_Daily.Field7, tbl_Genesys_Daily.Field8, Count(tbl_plans_yesterday.[User ID]) AS [CountOfUser ID], [field7]+[field8] AS calls FROM (_tbl_Structure LEFT JOIN...
  14. D

    Morning All

    Morning I am Dave, from the UK Still learning Access and have used this site a while to read up on posts that have helped me so thought it was time to get stuck in myself and post my self, as well as answer.
Top Bottom