Search results

Hi there, i'm trying to create a running total in a report for each unique ticket number. attached is a an example of what i would like to do..create a running total in a report that is grouped by incident number. Thanks Mark

Hi there, when i copy and paste Access data into Excel, and then want to sum the data it does not "sum up". i have to double click into the data to sort of activate it into life!!! Help please

Hi folks, I hope you can help: In VBA macro i have worked out some ranges that i want and this works fine Set rngNSS = Range("A" & intSRow & ":B" & intNSS - 1 & "") Set rngEast = Range("A" & intNSS & ":B" & intEast - 1 & "") I also have loads of cell calculations on the sheet that...

Hi folks, In code i have built a string variable called strRAG which is a combination of text "Me!lbl" and another variable called intSiteID, which forms for example label name Me!lbl51. I have a form with loads of labels on it and what i want to do is use this string to set the BackColor of...

Hi folks, i have created a string variable called strRAG which is a combination of text "Me!lbl" and another variable called intSiteID, which forms for example lable name Me!lbl51. What i want to do is then use this string to set the BackColor of the label using the below, where lngRAG is...

thankyou very much

Hi Folks, i am using the sql below but i am having a little syntax error: i am trying to refer to a variable called strRAGCol strSQL = "SELECT tblSite.SiteID, tblSite.SiteRAG, tblSite.Active " _ & " FROM tblSite " _ & " WHERE (((tblSite.Active)=Yes)AND((tblSite.SiteRAG)=...

Hi Folks, i am using the sql below but i am having a little syntax error: i am trying to refer to a variable called strRAGCol strSQL = "SELECT tblSite.SiteID, tblSite.SiteRAG, tblSite.Active " _ & " FROM tblSite " _ & " WHERE (((tblSite.Active)=Yes)AND((tblSite.SiteRAG)=...

Hi folks, I have created a recordset and what i want to do is check the field value "SiteRAG" to see if it matches some criteria and if so do some action where the field "SiteID" = the same as a label on a form. Please see CAPS in middle of code: Dim db As Object Dim rs As Object Dim...

thankyou and i now have some ideas

Hi folks not being pushy but has anyone got any ideas on my post?? much appreciated.

Hi folks, I have 50 locations spread over the UK and each site has a red, amber or green status based on several criteria. What i want to do is have a form with a map of the UK and have each location represented on the map with it's red, amber or green status based on coordinates in the...

Dear all, Has anyone come across a database where I can store a sports hall bookings by 1/2hr periods, which will also provide daily, weekly an monthly booking printouts. A form like the example would also be great, if not some help with DB structure please? Thanks Mark

Thanks as usual Pat.

I have a linked table that holds Change Controls call tblCC. What I want to do is refresh the linked table and then copy all the data in tblCC into tblServices and overwrite any duplicate records thus only adding new ones. My thoughts were to run a delete query to remove all the Change...

=Rtrim([city]) & " " & Rtrim([state]) & " " & Rtrim(cstr([zip]))

I am now ok at sending a single SQL string to access and returning the data to Excel BUT I now need to join three queries together in access to get the data I want. The easy option is to just hard code the queries and call them in one SQL string but I would like to know how to string SQL...

I've sorted it out thanks..

Folks, Tried out the code and it works fine but I have one more problem I can not crack. Using the SQL below I want to only return data where the the project id in Access = a number that I have stored in a variable called intPID. 'Set SQL string strSQL = "SELECT tblProduct.ProjectID...

Byte, Thank you for the reply. I will give it a crack and let you know. Thanks Mark