Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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