Search results for query: *

I know all the advantages of USB, but as I have a baby on the way I cannot really justify any additional expenditure on gadgets, much as I would like to. Plus, it's intensely frsutrating that what used to work no longer does on a supposedly superior system.

I have emailed Shuttle (now SCM Microsystems), who provide the same driver on their website as is available through Windows XP. So far they have not responded. I have tried all the different potential drivers to make the connection utility work, but to no avail. to explain something a little...

I have recently upgraded to Windows XP from 98. I was running a CD RW through the parallel port of my laptop, using Shuttle Technology's connection utility to connect it. With XP however, I can't seem to get it to work. I've tried installing the SCM Microsystems PPort ATAPI and SCSI Adapters...

nabiS2K: Thanks for the help again. The code immediately above did not work; Access came back and said it was too complicated. However, simply putting the <= operator in front of the code you had given me previously seems to work a treat. Thanks again; another star!!!

nabiS2K: Thanks for all your help above. That database is now done and dusted, and the code you gave me I have found very useful for a new database I am designing. IIF(nz(Forms![MyForm]!MyBox.Value,&quot;&quot;)=&quot;&quot;,[MyField],Forms![MyForm]!MyBox.Value) needs modifying slightly for a...

I have a form that selects the criteria for a query. One of the fields [Marketing type] is in the form of a combo box, that takes its data from a field of the same name in the table [Marketing Activity]. There are several duplicate entries in this field. How can I get my combo box to look up...

I know. Sorry

tlvChennai: Thanks for this; I should have thought of it before!

I have created a database that was originally supposed to be merely a modification of a previous one. however, when I went into it, I preferred to delete all tables, forms, queries, reports and macros and start again. The only thing the same was the database name. Now, whenever I open the...

I have constructed a database with a big overall query [Overallquery]; the criteria for which are selected from a form [Overallqueryform]. I am now trying to design the report to go with this and am wondering whether it is possible to select the grouping an sorting levels each time the report...

I have created a database that was originally supposed to be merely a modification of a previous one. however, when I went into it, I preferred to delete all tables, forms, queries, reports and macros and start again. The only thing the same was the database name. Now, whenever I open the...

Mike, The above discussion also relates to me, I have just discovered! I have tried putting the 'Or is null' into the criteria statement, but to no avail. I have also tried the copy and paste option you outlined, and that didn't work either. Is there anything else I can do, or could you show...

Mike, Thanks for the offer on this problem. I have managed to solve it by simply incorporating all the tables into one big one and juggling things around to fit with that. The problem I'm having now is that the expression you gave me for the criteria cell works fine for combo boxes but not for...

Mike, Thanks a lot for all your help on this. The criteria seems to be working fine... you are a star. The problem I am now having is that when I set the query to run with two of the tables in, it is fine and returns the correct results. As soon as I add a third, it causes me problems. Namely...

OK, I've messed around with it some more and stopped the adding query entries to table problem. The criteria you gave me above: IIF(nz(Forms![MyForm]!MyBox.Value,&quot;&quot;)=&quot;&quot;,[MyField],Forms![MyForm]!MyBox.Value) is working fine for the two combo boxes. So, if I select 'Male'...

Mike, I'm back in and trying to work my way around this. I've got a small test form (Detailsquery) and query (Details Query)going. The form has fields [Gender] (Combo box), [EthnicOrigin] (Combo box) and [University] (Text box). I've just discovered that when I put in entries on the form, it...

Mike, Thanks for this. I'm jsut on my way home, but will certainly look at it tomorrow. Cheers for your help. Ted

Mike, This certainly seems to be closer to what I need; but it doesn't appear to be ignoring the areas where I have not entered anything. Is there any way I can get it to ignore those fields where I don't select anything? Cheers Ted

Thanks for your help! It works fine on checkboxes, but for combo boxes and text boxes, it doesn't seem to work. I'm just doing a small query to trial the different criteria, and it works fine for the two checkboxes I have on the query (and form). However as soon as I enter the same criteria...

Oh, yes. I should have mentioned I did that; but it did what I described. I was just using the same generic examples as you did. Sorry! Ted