Search results

Hi Rural, No I haven't played with them at all :( I've not had any experience of them at all. Sad but true. I'm guessing you're suggesting this is the way forward, can you give me some pointers?? :) Cheers, Matt

Thanks for the replies :) Appolgies for not being very clear in my previous posts :( This the table I am speaking of...... SoftwareCode DateAdded ImageCode Completed A 1 1A N B 1...

Thanks for the reply Rural :) I already have a table in this form as mentioned in my previous post. I need to be able to manipulate this data so I can display it in a form where the software code is on one row, with a column for each image code so that for each software code I can simply read...

Hi all, So once again I have bumped into one of the slightly odd and initially very confusing nuances of MS Access/Jet 3.0/VBA. Currently I have a table which holds data about changes that need to be made to our various PC images. The main fields in this table are the Software code, the Image...

Hi all :) I've had a sandwich moment! (You know, settled down for some lunchtime munchies, not really thinking too hard about the problem in hand and voila! The answer jumps straight into my head! Simple really and particularly muppetry of me not to notice! Serves me right for slavishly...

Hi all, I keep getting the following error:- Run-time error '3367': Cannot Append. An object with that name already exisits in the collection. This occurs when I use TableDefs.Append. The situation is this. I'm developing a module to create a table. Passed ot the module is a string with...

Tada!!! Problem Solved! :rolleyes: So this is the deal.....I had 2 Private Subs with the same name and the same code. Not sure how I did it, but somehow the duplicate occured. Deleting either of them immediately returned Me. to full workin order. Madness, total madness! :D Matt :)

Thanks for the replies :) The Unmatched Query Wizard worked a treat. Thanks Rural :) I have a new and very frustrating problem now. For some reason, when i type Me. into the code builder for controls on this from, a list of all the available methods does not appear. It used to, but for some...

Hi all :) Ok, let's say I have 3 tables with the following data T1 T2 T3 1 , 1 , 1 2 , 2 , 3 3 , 4 , 4 , , 5 I'd like to be able to create a query that has the only record as its result as 5 as it is the only data item the does not exist in Tables 1 and 2. I don't just want...

Thanks all, Jon - The code has worked a treat and lead me to an answer. I had no idea you could use True in the criteria field the way you have and it just works :) Here is my code for those who may want a similar solution. IIf( IsNull([Forms]![frmListImgChng]![txtDateComp1])=True And...

Thanks llkhoutx, But I'm somewhat confused. If you put a date into and Access criteria field, it automatically surrounds it with #'s to signify that the data is a date. So i guess I need them. :confused: As far as I'm aware I'm not using PHP becasue this is Microsoft Access which i thought...

Hi all, Should you write an expression the criteria field in a query and use IIF, an interesting little bug appears that I have not managed to get around. Should you want the expression to return a range as the criteria (i.e. Between ... And ... ) it can't do it because IIF tries to evaluate...

Thanks Bob, The idea is a good one :) , but as I said, I didn't really want to change the form everytime I had to add or remove a specific item as I'd have to add the check box, change the code to show/hide it and to save the new records. I had a quick look at the list box properties and...

Hi all, :) Is it possible to add check boxes (or any controls for that matter) hen a form loads. Bassically I need people to select which items will require a change on a change request form (or could a list box do this?) As the number of items available can change I need the correct number of...

Ta daaaa! Ok, so the problem lay elsewhere but is not obvious. The code is perfect. Well, it works anyway! The problem was this. The memo field for Known Issues was bound to an item in a table where as the Comment fields wasn't. In the form I simply used a macro to the value of the Comment...

Thanks for the suggestion Neil, I assumed (probably wrongly) that the section of code: rs.Close db.Close Set rs = Nothing Set db = Nothing would release control of the record. Therefore the second piece of code that updates the second memo field would be starting from a clean slate. I guess...

Whoops sorry, I should have made it clear that the field is a memo field. The code wouldn't work anyway if that had been the case and that wouldn't explain the error I'm getting either. Cheers, Matt

Hi all, In the past in had the usuall bug trying to save data from a text field using a query only to find it has only saved the first so many (256?) characters from the field, truncating the rest. I managed to find some code to overcome this. I now however have a form with two text fields in...

Thanks Brian, Sorry for the tardy reply, but my holiday rather took over. Your code worked perfectly and now everything is cool. Thanks very much for you help. Cheers, Matt

Close but no cigar Hi all, Brian and RV - Sorry I haven't responded earlier but I am on my hols at the mo and don't have easy access to the internet. I have tried both your ideas but sadly to no avail but thanks for the help. :cool: Brian - Query 2 has the problem that when you run a query...