Search results for query: *

As I said, I'm not sure how it would work in DAO. However, if you search around, I'm fairly sure I've stumbled across a thread on this or one of the other Access forums that gives you quite a good audit trail. Basically you add a memo field to your table, and every time someone makes a change...

There is a way of using vb to duplicate records. Are you using DAO or ADO? If ADO I can give you some code, but I'm not sure how you'd achieve it in DAO. Post back with a few details (field names etc.) and I'll get back to you tomorrow.

Have you tried locking the text boxes rather than disabling them? That way they look like normal boxes, but cannot be changed by your users.

Hi Michael, Thanks for the help - that sounds like it will work - how do I use the two fields separately for the pivot and column headings? The query grid won't let me. I presume you have to use SQL, but my knowledge is pretty basic - what would the syntax look like? Sarah

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

There have been loads of posts by people a lot more knowledgable than me, but for what it's worth I had the same problem and was very alarmed, but find that compacting on close seems to more or less stop the growth. I think it is still getting bigger over time, and when it's used, but really...

Hi! Thanks for all the replies. Must admit I overlooked the Null values thing, but (without actually checking) why would the previous version of the db (which had been working fine) suddenly stop working, when I hadn't added any more data to that version? Sarah

Hi, Thanks for replying - no I haven't changed any data types, and the db compacts every time it closes. I additionally did a compact and repair to see if it would help. I had been messing around with some other queries but not the one that it's getting stuck on. Nor do any of the ones I'd...

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, thanks for getting back to me. A Project is a building or group of buildings, with furniture in each room. The table that I've made from the crosstabs looks like this: ItemName 2002 2003 2004 2005 2006 2007 ..... Chairs £15 £20 £0 £0 £10 £15 ..... Tables £42...

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

One more thing - as someone who was very recently in the same position! Don't be scared of things you don't instantly understand - for instance I spent ages ignoring the Domain functions. I was writing huge long bits of code, when if I had used a domain function, one line would have done...

If you want the ADO syntax, try this (or something similar) Dim cnCurrent As ADODB.Connection Dim rst As ADODB.Recordset Set cnCurrent = CurrentProject.Connection Set rst = new ADODB.Recordset rst.Open "Your SQL Here", cnCurrent, CursorTypeHere, _LockTypeHere Then your code THen...

OK. Are you using option buttons within an option group? Where you have the frame and the buttons within it? or are you using individual ones (like a check box)? Have you dimmed the variable correctly? If you are using an option frame, plus buttons, then each button will have been given a...

Tom, That should work fine! Have you tried it and it doesn't? Sarah

Great - thanks! I haven't been using Access for even a year yet, and before that I'd never done any programming, so I'm grateful for any thoughts on my work. It's entirely possible that you'll tell me I'm mad trying to do this!!! Big picture is that the database is used to store and assemble...

Thanks both for the replies. I'll give Andy's suggestion a shot today. mstrmage - the variable would be fine, but for the next step I need all the values produced as the code loops through. I need to add them together and find the Net Present Value of them.... is there a way of doing this...

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

what are you trying to display instead of '@'?

I'm not sure about using combo boxes in excel at all, but this bit of code might help you figure it out - I use it to format a range of cells: .ActiveSheet.Range(.ActiveSheet.Cells(7, 3), .ActiveSheet.Cells(R, C)).NumberFormat = "$#,##0.00"