Search results

  1. T

    Happy birthday BrianWarnock

    A quick thread to wish Brian Warnock a happy birthday. A very helpful and genunie member of AP.
  2. T

    Wildcards with Form Filters

    Hello, Dead simple one i'm sure... I'm using the following code to filter a subform depending on the contents of a text box: If Nz(Me.SrchDescription, "<All>") > "<All>" Then 'Invoice Description If Len(Nz(strFilter)) > 0 Then strFilter = strFilter & " And " strFilter = strFilter &...
  3. T

    Filtering related data on a subform

    Morning all, hope everyone is dandy. I've implemented some code taken from this old post http://www.access-programmers.co.uk/forums/showthread.php?t=121662 I am using Access 2007, and I have this working fine, however I now want to filter on a field that is related to the data in the subform...
  4. T

    ActiveX Calender Control not requerying Subform

    Hello all, I have a table called 'Tasks', where a date is entered along with a short description of the task. I then created a form with an ActiveX 'Calender' on. I also created a subform, this is a datasheet view of all records in the 'Tasks' table. When i click on a new date on the...
  5. T

    Percentage calculation

    Hello. After a few hours of tearing my hair out, i'm afraid i have to ask for some of your valuable time in helping me... I have a table with 3 columns; Site, Live, Target. The Live and Target fields are both integers. I have a stored procedure which creates a temporary table and totals the...
  6. T

    Kilimanjaro Trek - August 2012

    Hello all. As the thread title suggests, i am climbing Kilimanjaro in August 2012 for the Nightingale House Hospice charity. Considered the highest free standing mountain in the world, and the highest mountain in Africa, Kilimanjaro stands at 5895m. Suffice to say, this is a big challenge...
  7. T

    Blank row below data in singular data field

    Afternoon all! I hold cross reference data in a table, in a singular 'Text' field. An issue has arisen when performing data exports, it seems that some data has a 'blank line' underneath the actual data. Apologies for the vagueness in my explanation, i'm not quite sure how to put it across...
  8. T

    Return value of a Frame into an Append Query

    Good afternoon, hope Christmas and New Year went swimmingly for you all. I've got an unbound form which on select a Command button, appends the data into a table. This works fine. However, i've now added an unbound frame into my form, and i'm trying to append the selection in this frame, but...
  9. T

    Calculation in Parent Form on data in Sub Form

    Hello all, I have created a purchase order system, with a Parent Form containing data from 'PHeads_tbl' and a subform containing data from 'PLines_tbl'. Financial information is held in PLines_tbl, and it has now been requested to have the Sum of all records in the Sub Form to be displayed on...
  10. T

    UPDATE/INSERT data import query

    Afternoon all. I've got an interesting one for you... I have a product table, which i want to update using either SQL query, store procedure, or the SSIS import routine. ProductTbl ProductCode XRef ABC ABC123 XYZ XYZ123 MNO MNO123 I have...
  11. T

    Invoke form if field meets specific criteria

    Good morning all, I have a field called "BookingStatuslbl". When the word "Cancelled" is entered into this field, i want a macro to run that will open a form to enter a Cancellation reason in. I've entered the following code into the AfterUpdate event for the "BookingStatuslbl" field, but it...
  12. T

    Invoke form if checkbox is -1

    Good morning all, The title pretty much explains my query, but just to clarify... If the checkbox "PQE" is ticked (-1), invoke the form "PQEFORM". I thought about using the OnClick option, but i do not want the form to be invoked if the checkbox is unticked (-1 to 0). I'm sure it's just a...
  13. T

    Export pivot table data to Excel

    Morning all! Probably a very easy question, but how do i export the data in my pivot table to Excel? I understand that i can do this via menus etc, but i want this to be hardcoded into a button. I've tried using the TransferDatabase/Spreadsheet option, but i can't seem to get it working. Any...
  14. T

    Refresh form to first tab

    Afternoon all. Very simple one i'm sure... I have a form that's using the TabStrip function. I have three tabs; Details Tasks Attachments Along the bottom of each of these tabs are "Next Record" and "Previous Record" functions. However, when you select one of these, instead of the "Details"...
  15. T

    VB Code in invoke "Get External Data" window

    Morning all! The title explains it all... I have designed a database that's being used by people in my team, however we have an issue with people using compatibility packs. Menus don't show up for some users, and these menus are vital as they need the "Get External Data" function. Does...
  16. T

    SQL server with CRM Dynamics 4.0

    Hey there, Just a quick one.. Has anyone here ever used MS CRM Dynamics? I'm testing it at the moment, and wondering whether i can link external SQL tables into the CRM? I've done some research, and there isn't a clear answer. Thanks in advance :) Tom
  17. T

    Field Criteria, need to add an allowance of xy

    Hey there, My query validates the Total from the Hold table against the Total from the grn table. I've got this working fine using <>[grn]![Total]I want to now add an allowance of (lets say) £1.00 either side of the Total. i.e. If a total in Hold is £25.00, and the total for the same...
  18. T

    Run 1 query if results from another query meet requirements

    Hey there, The title might not make much sense, but thanks for viewing, i'll do my best to explain with as much detail as possible. I am currently creating a database that has two tables. Hold OrderNo Total Goods OrderNo Total I have already created a query that validates the OrderNo...
  19. T

    unmatched records for multiple reasons query/report

    Afternoon All! I have a slightly confusing question regarding a query/report. My database has two tables: hold order These two tables have one related field. In hold, this field is called "PO". In order, this field is called "DocNo". I have built a query to show me any record that do not...
  20. T

    sql statement to remove duplicates

    Hey there, I'm trying to remove duplicate records that have the same ID and Total. These records are in one table. I've just using the following code, however it returns no records. SELECT First(test_order.OrderID) AS [OrderID Field], First(test_order.Total) AS [Total Field]...
Top Bottom