Search results

I have successfully used the calendar system in an Access XP database design and am (so far) pleased with the results. Now my daft question... I used an ActiveX control to call this up - and registered it. If I pass the database that includes this ActiveX calendar to another user - one that...

Yes, I know I can't do that (as far as I can see). But I want to do it on a report in A97. In a grouped report, I count the number of messages (in the detail section) each client has received that day. This value is put in the Group Header. The count is done simply on the message table field...

Working A97. I am trying to use unbound boxes in a form to give conditional status messages about field entries. These statements (to date) are checked as part of the form's On Current property. I get good messages when the statement depends on a yes/no box or on detecting if a particular...

I've been through the search and can't quite find a match for what I want. Working on A97. Two tables. The main table is tblCustomerDetails and a lesser table tblTariffs. I have created the forms for the two tables as frmCustomerDetails and frmSubTariffs. In the main form...

Shay helped me beautifully in my quest. Little did I know the path I was walking! Great, I can open a form as Filter by Form. So far, so good. I can also call up a filter criteria. However... (the dreaded word) 1. I made a command button to apply filter. It stays greyed out and unusable...

I shall have to catch this thread later when I get in from work - so sorry folks, no instant reply from me. I am trying to build a (hopefully) idiot-proof database, with simple search facilities. In my Access XP version, I have used a neat idea I derived from the M$ sample 'Customer Database'...

One or two of you may have noticed me popping around the forum asking for help with a database I'm building. To all those who wanted to, and did, help, many thanks. I'd be in deep trouble and well out of my depth if you hadn't. Thinks... I used to thing Access was fairly easy in the old days...

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

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

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

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

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

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

I'm not, by any means an expert or experienced Access developer! I will need answers to be in words of one syllable - or less. I am creating a customer records database in Access 2000 on a m/c with Win XP loaded. This database will also need to run on 'older' versions of Access and Windows...