Search results for query: *

Hi, I have a company that delivers skips to customers. I input the data on a subform for the delivery of the skips which includes the date (Taken from the main form), address, skip type, type of job(deliver/collect/Swap) etc..... Is it possible to duplicate that entry (if it is a delivery or...

It's a record source for a subform.

Hi, Thanks for your help with this. Unfortunately it did not work, but what it has highlighted is if i take this out of the statement the query runs and returns data. Now i am even more confused!!

Hi, Thanks for this. SQL code is: SELECT tblMainData.Handling_Unit, tblMainData.Material, tblMainData.SUT, tblMainData.Blocked, tblMainData.Type, tblMainData.WCS_Qty, tblMainData.SAP_Qty, tblMainData.WCS_Location, tblAisle.Aisle, tblSide.Side, tblLocation.Location, tblLevel.Level...

So why did this work in 2003 and not in 2007 and are there any solutions on how i can make it work in 2007?

I have 4 which are text and one which is a comparison of one field against another to see if it is greater than the other. So 4 x Text and 1 x Number

Hi, I have a query that did work in Access 2003 but i cannot get to work in 2007. The form where the query is used has several checkboxes that filter a subreport when they are clicked. Like IIf([Forms]![frmAllData]![chkBlocked]=True,-1,"*") This is the code i have in the query for each...

Hi, Thanks for getting back to me. Looks like i have solved it with the code below. With xlRange .FormulaR1C1 = "=SUM(R[" & 8 - lngLastRow - 1 & "]C:R[" & lngLastRow - lngLastRow - 1 & "]C)" End With Probably not the best way of doing it, but it seems to be working. dazz

Hi, I am using code to extract data from Access into a spreadsheet. I am having problems inserting formula at the end of certain data columns that totals the column above. The first row will always be row 8 but the last row will always change. Am i missing something in my formula code below as...

No reason, just my lack of knowledge. :) I moved it to the format area and it works, Thank you. Dazz

Hi, I have two text boxes on a report that i show and hide depending on a value of a tickbox. The code below works for every record apart from the first record if the value is true. Both boxes properties are set to invisible, but if i enable them they show all the time on the first page. Do i...

Hi, Thanks for the reply. I would like the option to be able to display more than one day when looking at the chart. Choosing one day at chart creation make the chart a lot less busy and easier for users to understand.

Hi, I have got the code to create a pivot and a chart from the source data. The problem i have is there is far too much data to be displayed in a chart. Is there a was of deselecting all the entries, in this case date, and only display the first date that is in cell A5 in the pivot table? At...

No the form closes.

Hi, I have a report that is run by selecting dates between a range on a form. A different page for each customer is produced in the report. I also have a textbox on the form where the user inputs the date they want printed on the report. I can get the date to print on the first record of the...

Edit to a above 4 - I have an outstanding amount that is not stored in the table. This is what is used for the calculation. So, Amount_Payable - Amount_Paid = Amount_OutStanding Checkbox to be ticked if Amount_OutStanding=0 Sorry for the confusion. Dazz

Hi, I have a subform (Datasheet View) which has, amongst other fields,: 1 - A text are where i enter the amount paid, formated as currency. Stored in the Orders Table. 2 - A total amount payable which is a calculation of other fields on the form and cannot be changed by the user, formated as...

Any other ideas? I am stumped!!

The check box is in the subform and is ticked when the amount paid is equal to the amount due. Each record has a checkbox of its own.

The form in question is a Datasheet Subform.