Search results for query: *

Hi, I have a crosstab query for which the column headings are dates pulled from a table. They are formatted as 27-May-2003. However, when I open the crosstab, the column heads are formatted as 27/05/03. Is it possible to format them the way I want? Thanks, Sarah

Hi All, I have a database with several append queries, one of which has suddenly decided to stop working. The error message I get is that there is a type conversion failure. Can anyone enlighten me as to what this means? I have a few versions of the db kicking around, and I think it might be...

Hi All. I've got a real 'blue-sky' question here. This is what I want to do. I have a crosstab query with various items of furniture as the row headings, Years (2004, 2005 etc) as the column headings, and amounts of money as the values. SO you can see how much to spend on chairs in 2008, for...

Hi all, This may sound a bit daft, but I want to add a field to a recordset, with no values in it. My code loops through each record and will stick a value in the blank field. I don't want to make a table or anything like that, because I don't need the values except for using them in one...

Hi all, I posted this in the VBA forum yesterday and got some good help there, but the problem is not fixed. I have an Access query which, on a button click, is being exported to Excel. However I wanted the Excel sheet to be formatted in a certain way. I've got the code so that it works OK...

Hi - this should be a quick one to sort out. I have stupidly... forgotten to close two public variables - a connection object and a recordset object. I've been running the code a lot to test other things, and suddenly my database has grown by about 30mb in a day.... The recordset is a large...

Hi All, I'm sure this is quite simple but I can't see where I'm going wrong. I'm exporting an Access query to Excel, but formatting the Excel sheet afterwards. Here's the main bit of code - I've numbered the lines so I can explain the problem! (1) xlProjectCosts.ActiveSheet.Cells(currentRow...

Hi all, I have looked everywhere and cannot find out how to do this or whether it is possible. In my database I have a parameter query which is used in several other queries. When I open one of the others (usually with a button on a form), I want VB to automatically put in the parameter, so...

Can anyone advise on the efficiency (or otherwise) of having lots of queries dependent on one another? I know it generally isn't that good an idea, but what are the limits? Currently I have a maximum of 3 before I get to a make table or append query, but then I have other queries relying on...

Hi (again) I have a union query which brings together two crosstab queries. The problem I'm having is that in my crosstabs, the values are all nicely formatted as currency, but when I run the union query, the formatting goes and I'm getting about 5 decimal places with no £ sign! I can't find...

Hi, I don't know if this is the best forum for this question. What I want to do is export a query to a spreadsheet, and then use Excel VBA to format the spreadsheet (put borders around some cells, paste in a title etc.) Can I just paste the Excel code into the code behind my command button in...

Hi, I have a union query which joins two crosstabs. One crosstab is effectively the sum of the other, and I want a query to display the results of both, with the summing one underneath so it looks like a spreadsheet with sums calculated in columns. a) is there a way to do this all in one...

Sorry to be dramatic! I was looking for an answer to something and came across this thread: thread181-166690 I'm trying to colour entries in a list box depending on the value of a yes/no field. Your entry in this field talks about a 'callback function' - can you explain - will it do what I...

Hi, Yet another question - this is probably simple but I just CANNOT find a way to do it. My forms all have different coloured text on the buttons etc., but I can't find a way to format the labels on my tab controls - the properties just aren't there to do it (I don't think anyway..) Thanks...

I have stuck my code at the end. I'm sure there's a simple way to do this. I am using the code to replicate a record a given number of times, changing the value of one field so that you end up with the original plus 1, 2 or more copies, all with different names: ***Temp1, ***Temp2 etc. In the...

Has anyone done this before? If so, help would be appreciated. I have three 'main' tables, Projects, Sites and Rooms. These are joined by two linking tables to overcome the many-many relationships. So one project may have many sites and vice versa, and one site may have many rooms and vice...

I would like to use VBA to do the following when a button is clicked, but I don't know if it's possible. I have two tables which both have forms for data entry. The tables hold information on the details (dimensions, which department etc.) of a room (tblRooms), and its contents in terms of...

I have had a look at a few threads on this and the Access VBA forum (and the FAQ's), and can't really find an answer. I have a switchboard type form on which I want to disable some buttons (6 of them) for one group of users. Can anyone help with some code? I've tried variations on the...

Can anyone help with this one? I have three tables: tblListFFE - is a schedule of items of furniture in rooms tblGeneric - generic items (chair) - tblProducts - manufacturers specific products tblListFFE has a Yes/No field for 'Specific Product selected' (I'll call it 'Spec') It is linked to...

I have created a query with 3 calculated fields. The first is 'TotalQuantity' and is a sum, calculating a value using two fields from separate tables. The second two both refer to this field, multiplying it by other fields in the query. When I run the query, I get a box asking me to enter a...