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

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

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

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

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 have the code below to connect to a access database but I am having trouble creating the recordset and placing it in Excel...any help would be appreciated. Dim intPID As Integer, i As Integer Dim oConn As Object Dim oSheet As Object Dim oRst As Object 'Dim strSQL As String, strRAGLoc As...

Dear all, I have a sub form in contineous mode. Each record on the form has a uniqueid number. I have all fields disabled except one combo box. What I need to do is enable the current record based on the combo box value. Currently if I enable the fields I get the whole sub form to enbale...

Please look at the attached. The form is a subform filtered by projectid. What I want to do is select the Type and then filter the form where all the selected type for that projectid are returned and if there are none then msgbox them?

Dear all, I have a tabbed control with many subforms on. The main form is filtered by ProjectID. One of the subforms in datasheet format stores history of project issues, constraints and dependencies. What I want to do is select the field, which is a combo box holding text issues...

Dear all, I have a form with some text boxes on with the properties as gen number and dec places set to 2 but i still get data such as 1.22223333 or 1.7766335 What is going on?

Dear all, All I am looking to put a database together that lets a user create a contract using the db forms and I was wondering if anyone had any examples of contracts or questionnaire table design/example db? One other main thing I need to do is store calculated vales and then write them to a...

Dear all, I have a cross tab query that returns monthly data by year. There is also a field where users place a one off project cost. What I want to do is only show the one off cost once in the query basicall if the report runs more than 1 year i only want to show the one off cost in the last...

Dear all, I have a cross tab query that returns monthly data by year. There is also a field where users place a one off project cost. What I want to do is only show the one off cost once in the query basicall if the report runs more than 1 year i only want to show the one off cost in the last...

How can I alias: PIVOT tblFinancials.FY In ("1","2","3","4","5","6","7","8","9","10","11","12"); where 1=jan, 2=feb...........