Search results for query: *

Hi all, My IT Manager has upgraded some of our machines to Access XP from 2000. This has caused the XP machines to show the database window via a taskbar button which appears on startup. I've checked that the box to allow this in the startup properties dialog is set to 'no'. BTW, some of the...

I found a simpler solution in the end Gazer - I just put a line in the form's on open event changing the data source. Works a treat. Thanks for your help, Iain Robbo ;-)

Sorry gazer, I should have explained a bit more. First point of call was to look at the effect of a) removing qryPlayerSponsors2002 totally. b) rebuilding it, just in case and c) importing all of the objects into a new db. None of this changed anything. This is because the problem lies with the...

Gazer (or should that be Glazer?:-)), The problem is with retrieving the CustomerID value in the first place. Whether I retrieve that from the original table or from a query is irrelevant. I then need to use the CustomerID value to move to the correct form record, and the invoice number value...

Hi Gazer44, When I unload or close the form the data source is changed back to tblContactInformation. So whenever I open the form again the data source is still tblContactInformation - qryRhinosPlayerSponsors2002 shouldn't be involved anywhere. This is why I can't understand why it's asking for...

Hi all, I have a form for which I change the data source on the fly using command buttons. One of the fields on the form is named [company] which unsurprisingly contains a company name. The original data source for the form is a table ([tblContactInformation]). The command buttons change this...

Hi all, Apologies for re-posting, but I can't get this to work and it's making mey head spin! :-) I want to look up a form record for a specific customer using Dlookup via an invoice number which is stored in a field which is on a subform which displays customer orders. I do something exactly...

Hi all, Apologies for re-posting but this is driving me crazy! I have a control in a report which pulls together a set of values from various fields thus: Control Source = "Order Number " & [oldordernumber] & ", placed by " & [placedby] & " on " & [date] & &quot...

Hi Guys, [25Invoice] is a number field. Cheers, Iain :-) Robbo ;-)

Hi all, I want to look up a form record for a specific customer using Dlookup and an invoice number and then move through some subform records to the order which that invoice number relates to. I did something similar using an order number (different field, text data type) which works...

Hi Ecugrad, Try basing your report on a crosstab query. Select the wizard from the 'new query' dialog. You'll need to drag the employee field to the left of the grid and indpoints and teampoints to the top. Access will then ask how you want the data grouped. Then use the report wizard to...

Thanks Namsha, I've tried Private Sub Report_Open(Cancel As Integer) Me.Type.FontBold = True End Sub on the open event for the report, but it breaks with the message: "Compile Error: Method or data member not found" with the text .FontBold = highlighted All of my references...

Hi Namsha, I'm a bit confused here! All I want to do is format a section of the displayed characters in the control. The control is located in the detail section of the report. Example: Order Number is R555 It was placed by John Smith It was placed on 13/04/02 The type of order is repeat...

Hi all, I have a control in a report which pulls together a set of values from various fields thus: Control Source = "Order Number " & [oldordernumber] & ", placed by " & [placedby] & " on " & [date] & " Type = " & [Type] To display an order, who placed...

Hi Teser, You could try the Weekday() function. I'm not too sure of the exact code, perhaps someone can help furtehr but it should run something like this: Private Sub Report_Open() dim intDayOfTheWeek as integer dim strQueryCriteria as string 'not sure what to declare here, I could be wrong...

Thanks for your patience Michael, here's the info: SQL for Crosstab: [/code]TRANSFORM Sum(qryRollingAverage1.Value) AS SumOfValue SELECT qryRollingAverage1.Employee, Sum(qryRollingAverage1.Value) AS [Total Of Value] FROM qryRollingAverage1 GROUP BY qryRollingAverage1.Employee PIVOT...

The weekly sales values are calculated in my original crosstab. I can't at present calculate the averages, without manually setting field properties which reference the week numbers in the original crosstab. If I did that, the field data source property bit would look something like this i...

Apologies for cross/re-posting but I got no joy in the 'reports' forum. Here's my original post: Not sure if I should spread this across two threads but here goes. I report sales from a database I have built, and have created a crosstab, which groups sales value per week by employee. I want...

You could use a crosstab query to display the number of birthdays for each month. Use the crosstab wizard, which is very good in situations like this. Iain Robbo ;-)

Hi Frink, Sorry for the lack of info. The .txt file delimits with the  character if I save as a raw .txt. For each carriage return in the original document there is one of these  characters. Having thought about this overnight, I think that the best way to go about this is: Import the data...