Search results

Sohaila It looks as though I shall have to stop being lazy! And I shall have to create an underlying query. As you say, no real problems in doing it except for lethargy getting in the way! I had been hoping to be a smarty pants and make myself look all whizzy and clever by doing it in the...

Hi Sohaila - and thanks for a quick response. The 'money' calculations don't actually appear in any queries because the data table layout is extremely simple. Everywhere else in the database - forms etc. doing the calculation live in the current display is working fine - it is usually just...

I'm still plodding on with my database for those that have maybe followed me around. Now I'm trying to finalise the reports bits. Some reports could well end up with no data in them if they do not meet various parameters - like no data for given dates. So far, so good, it should print an...

It's s-o-o-o-o easy when you know how! Thanks Rich, I shall give that a go when I have a few minutes in hand. Sorry to be a while getting back, but didn't see your reply until just now as I was (sort of) passing. Probably won't get a chance until early evening - and then if I'm lucky! Der...

I think I've cracked it. It is probably the most ridiculous, clumsy, stupid and kack-handed way of doing it, but.... I made a macro On Open of the Calendar form that... runs a Delete query to empty the Dates table... and then a subProc On_Close() goes on to open the report when the Calendar...

Aaaahhh. I've spotted why the query is apparently not updating. Up until now, when the calendar form was used, it always replaced existing data in the dates 'table' and, therefore, was always current. However, now it is adding another line of data to the table and still using the first line...

OK, have tried it. Great idea using the close form to open the report. However, the report opening is does not seem to be updating the query. So, the big question now has to become.... How can I make the report update and run the query as it opens? Chris

Thanks for the help Rob. I have been trying to work on the lines you said, but I wasn't 100% sure that the query was running on opening the report - but I may well have been wrong. Where you have given me some food for thought is this idea of opening the report on closing the calendar form...

With a lot of help from people on this site who know a darned sight more than I do, I am trying to build a customer database. I have been given a lot of help to date when I got stuck. And I've been extremely grateful! A lot of my forms and reports etc work well in isolation, but I am well and...

Fornation... You've come up trumps! Many thanks. (I think On Current was aboout the only one I didn't try - but then I was groping in the dark a bit and using the "let's see if this works then" attitude.) My problems are solved. :) :) :) Sorry about slight delay in writing - I had to go...

Mike-O-Phile gave me a lovely solution to my desire to have a form caption in the title bar that reflected the name of a customer and it worked beautifully. I even managed to use =IIf() to blank out a null and felt pretty pleased with myself (shows the level of my ability;) ) However... (The...

Mile-O-Phile... Thanks. It works! I am suitably impressed - let's hope my users are. ps What took so long ;) Chris

Somewhere, in the past, I have seen a form that has a caption giving "variable" information - like a customer's name. I am designing a simple (but complex to a "noddy" like me) database of customer records. My database is more than adequate with defined captions for the basic user form, but...

Sorry to be a bit slow in catching up my thread, but work got in the way. John... Not so much that Der Boss had me working - more a case of keeping my cool by keeping out of my 17-year-old (going on 35) step-son's way. We don't always see eye-to-eye and if I hide in my "study/office", I don't...

John. Very many, many thanks for your help. IT WORKED!! (Yes I know I'm shouting - I want to!) As you say, so close. Just goes to show what looking at it too hard and long does to the eyes and brain. Sorry for slight delay in responding. Der Boss needed me for something else for a while...

My apologies if you already saw this loop. I seemed to be unsuccessful in attaching a copy of the file. I am a comparative novice in Access 'serious' work and not much better at VB! I've currently got OfficeXP - but the attachment is in A97. I found a nice little routine that allowed me to...

Thanks for the help, folks. I am a little wiser now and will take all that has been said on board. Chris

Aha! What a damned clever idea! I shall bear that one in mind! Thnx Chris p.s. - I think we're alternating between posts here between us! LOL

Thanks Jack. Hopefully, my 'downgrades' are looking fine (pls see my other thread). As long as going 'up' to XP doesn't make it worse than I've got, I shall stay happy(ish). Chris

Currently, I'm on Office 2000. My wife's networked machine is on Office 97. I now have Office XP ready to load. Will there be much in the way of conversion problems when I want to make my currently developing database (see my other thread) available in 97, 2000 or XP? Will my currently being...