Search results

This is a guess... Either User.lngUsrId doesn't equal one. Or For some reason the filter on the form is making it return no records... Vince

You've answered your own question... Vince

Similar reply - if you have all the dates in a table, and left join them to the 3x the table one on each date field, then it would/should return three records, and only be grouped on the date. This does mean that you need to add new dates etc to the table :) Vince

Depends on your table layouts... If you have a list of first options (Sex, Mood, relationship, etc) and a list of second options dependant on the first (male, female) all in the same table or in two tables but with a relating ID field then yes you can... Example table ThingID - Autonumber - pk...

Ok, your last question first. IsActive field is so you don't need to delete the record in the look up table. Say over time things change, perhaps the RelationShips descriptions increase, and some are no longer used. If you set the isactive to false, then on the choosing search/entering data...

Hmmm, in Sql statements, not likely. To get first n last possible, as these are always there, but the middle names could or not be there. Its possible in code, and probably wouldn't take too long to write and run the loop to fill a table if required. Vince

Does this mean you are linking the results of a query to the results of another/or table? Or scrolling via a form and next/prev ? - if this is the case set the secondary display to be filtered via a combo/(hidden) textbox (your choice). In the query, I have the criteria set to the function name...

SELECT qrySubProductIDs.prodid, qrySubTotals.ProdID FROM [select tblProdSoldInMth.prodid from tblProdSoldInMth group by tblProdSoldInMth.prodid]. AS qrySubProductIDs LEFT JOIN [SELECT tblProdSoldInMth.ProdID, Sum(tblProdSoldInMth.NumbSold) AS SumOfNumbSold, CDate("1/" & [sMonth] & "/" &...

So you have Access 2003 but cannot create dbs/forms? Re-Install perhaps? The only other thing that springs to mind is access rights, perhaps the mdw is disallowing you editting/update rights to the db? I assume the two dbs are in a folder you have full read/write access or you'd already be...

Question: Was this an Access 2k db? Did you convert it up? If not then thats why it won't let you edit. However if you did convert up and its still not letting you edit, I guess that you need to test by creating a new form, then clicking on the toolbox then on the form, or drag to the form...

You've probably tried this but: - google search - for phone numbers (and others?) max length, possibly think about forcing the user to enter into several fields and concatenate the result together into one text field... EG: Check for brackets (and remove), Check length, if passed then check for...

I don't think I'd use that structure you've posted... But then there are numerous ways to attempt this (more you do the better as you will then see the benefits of doing things in different ways). Look ups tblLUSexes SexesID - Autonumber - pk Sex - Text - 10 tblLUMoods MoodsID - autonumber -...

First is the mde (since this runs but hides all code). Shift lock (a property of an mdb/mde) stops users holding shift on loading the db which stops any forms/macros/code running. This property, when set, always runs the code/form/macro - good for start up stuff. If you haven't utilised the...

using vba code - yes. Via sql statement, not likely.... Select [Field1] & "/" & [Field2] as [newname] From [table] Vince

What Rich is trying to say is that the format function cannot work on nothing, there has to be a date there. So the isdate (you did read the help on isdate function right??) tells the comp if the data is a date. Vince

try: =iif(isnull([datefield],'',format([datefield],"dd mmmm yyyy")) Post up your results Vince

Try Text instead of value - I've put it in above... Post up your results Vince

=IIf(isnull([Offer/Subscription End Date]) OR isnull([Offer/Subscription Start Date]),"To be advised","From " & Format([Offer/Subscription Start Date] , "dd mmmm yyyy") & " to " & Format([Offer/Subscription End Date] , "dd mmmm yyyy")) otherwise it gets tricky, and you'd need to use the NZ...

Hi, I was going to (years back) try to make an office stationary db to track contents of the stationary cupboard etc, possibly for several teams etc... dreams!!!... Anyway, I'd be interested in getting the sort of data you need to hold to do a proper stock tracking db for the future. If you...

Select [table].[id number], max([table].[date]) as [MxDate], [table].[area], [table].[region] From [table] Group by [table].[id number], [table].[area], [table].[region] Vince