Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Triacona
  • Content: Threads
  • Order by date
  1. Triacona

    Genericise buttons and list calls

    Dear All, Thanks for a great forum. I want to make my buttons generic for all lists in my report forms. I have several buttons and each list has their own, Appeals reports, DC reports ect. The buttons do the exact same thing for all lists. So I have a Run Report button, a Run Query button...
  2. Triacona

    how to make access open in read-only mode using vb to stop the .laccdb file

    Dear All, I have an issue where I need to stop the .laccdb file from appearing when opening access. The reason is that the users open it and leave it open and don't logoff properly leaving that file running. This is a problem as when I need to update the file with the new version, it will...
  3. Triacona

    Why can't I display the index in this task array

    Hi all, [smile] I'm a bit stuck here in terms of how to display the index number for debugging... I want to display the value of each i ( index ) so I can see what the index value is at any point in the loop. It seems to work for the first value each time, but then gives 0 for all others...
  4. Triacona

    How to broadcast data from a SQL server to an IP an Port

    Hi all, Thanks for a great forum. I hope this is the right topic for this query? I have the following issue. I have a server, which has SQL server and a database, for car parking data ( spaces total and spaces left ). I want to broadcast each car parks spaces left to the Server IP and...
  5. Triacona

    Issues With my SQL Having statement in my VBA code

    Hi all, Thanks for a great forum! [smile] I am hitting my head against a wall here, staring at the code, I need a fresh set of eyes. I have the following code: '------------------DC RUN QUERY BEGIN--------------------------------------------------------- '------------------DC RUN QUERY...
  6. Triacona

    How to broadcast data from a SQL server to an IP an Port

    Hi all, Thanks for a great forum. I hope this is the right topic for this query? I have the following issue. I have a server, which has SQL server and a database, for car parking data ( spaces total and spaces left ). I want to broadcast each car parks spaces left to the Server IP and ports...
  7. Triacona

    how can I broadcast an SQL Server Query result to an IP address and port no as text

    Dear All, I do not even know where to start, but have been asked by my director to solve this problem. I have a SQL server that runs a query that outputs serveral rows. Each row has a two results that I want to output, column: Name and column: Number of spaces. I have the SQL, but I need to...
  8. Triacona

    VB function to convert query text from Unicode

    Dear All, Thanks for a great forum! I have a function ( below ) which I plan to use to weed out Unicode character from a string. The query feeds the array a string and then I work with it as below. Function ReplaceUniCode(strText As String) As Variant ' Replace % with the character you want to...
  9. Triacona

    you tried to execute a query that does not include the specified expression as part of an aggregate

    Hi all! Thanks for a great forum! I have an issue that crops up when I try use a VBA function with a query. It works fine UNITIL I add the Totals Row ( in design view ). I had GroupBy and this gave me the titled ( above error ). So instead of GroupBy I used Expression in the Totals values for...
  10. Triacona

    run-time error 2585 - action can't be carried out - while using DoCmd.SendObject acSendReport

    Dear All, Please help. I have been trying to test if a field in my report is EMAIL and then if so send that report to the referenced email address. But I get the error: Fields CusConMeth ( used for the contact type i.e. EMAIL ) CusConDet ( used for the storing of the contact type...
  11. Triacona

    Covert String to Byte[]

    Dear All, Please help this is driving me mad! Thanks in advance :) try { var emailAddr = "etpienaar@yahoo.com"; byte[] emailAddrByteArr = new byte[emailAddr.Length]; string[] emailAddStArr = new...
  12. Triacona

    Problem with Logic / Textbook

    Hi all, This is a bit of a weird one. I came across an example in my textbook and tried it out. It is to do with: Using the ConcurrentQueue<T> Collection Here is the textbook example as provided ( DID NOT WORK ) class Program { static ConcurrentQueue<string> queue = new...
  13. Triacona

    Tab control and page control displaying different fields/controls based on tab page selected

    Dear All, Thank you for a great forum! I have the following problem. I have several tab pages within a tab control. Base on the tab page selected I want certain labels and text boxes to be visible/not visible and enabled/not enabled. The main tab control is called: tabCtlBcMain The tab pages...
  14. Triacona

    count(iif,iif,value) is this and if? if so how do I do or if

    Dear All, Thanks for a great forum. I have trawled the internet and found nothing I can relate to my problem. I have a quarterly report for PS returns. I have the following code to count if [DTYPNUMBCO] = "0013" etc. But I want to count if the [DTYPNUMBCO] = 0013 or if the PPA is Y or if EIA =...
  15. Triacona

    Dcount issues

    Hi all, Thanks for a great forum! [smile] I have a report which has a Data source PerformanceIndicators. And I am using a DCount statement to pull information from another query EnCasesAll. This is done in the Report DcPerformanceIndicatorsMonthlySummary The queries run from the same...
  16. Triacona

    Access Query not pulling through all field characters limited to 255

    Dear All, I have a problem with my Access query. Please see code below. The problem is that the original table UNI7LIVE_DCAPPL has a field called PROPOSAL. When you open the original table the entire contents of this field displays > 255 characters. But when running a query off this table it...
  17. Triacona

    Grouping Addresses

    Hi all, Thanks for a great forum. Please could you help me with the following: I have a query that outputs a list of addresses. The addresses are grouped like so: Addr 1 Albert Drive, Sheerwater, Woking, Surrey, GU21 5JZ 1 Bateson Way, Sheerwater, Woking, Surrey, GU21 5LD 1 Bentham Avenue...
  18. Triacona

    Scaling Forms

    Dear All, Thanks for a great forum! I have a problem that I am trying to deal with regarding different resolutions and screen sizes across my user base for a database I have created. I initially created the forms on a 1080p display in MS Access 2010. I designed them to be on a reasonably...
  19. Triacona

    Appending a single table into 2 separate tables

    Dear All, Thanks for a great forum!! [smile] I have the task of creating a DB and 3/4 of the way they tell me there is another data input to this db from the web. The data from the web is stored in a Postgre database table! The table has a description field, which has name, surname, address...
  20. Triacona

    Appending a single table into 2 separate tables

    Dear All, Thanks for a great forum!! [smile] I have the task of creating a DB and 3/4 of the way they tell me there is another data input to this db from the web. The data from the web is stored in a Postgre database table! The table has a description field, which has name, surname, address...

Part and Inventory Search

Back
Top