Search results

When I select from a Product combo, the ProductID is stored in the OrderDetails table. The Product combo excludes where Product.Discontinued = True. In time old Products become discontinued. Now when I view an old order, the combo is blank because its RowSource excludes discontinued products...

Dave, Thanks for the reply, will try it. Currently having major probs logging in to forum. Managed this time with Firefox but its very hit and miss. Mike

Tried it all to no avail. Gonna give up and run a delete query. Shame, I'd rather keep historical records. Thanks all ps. always have probs logging in to the forum. after two ot three log ons, I usually get in. this time i get in but when i go to mods & vba, i appear to be not logged in. ho...

Back on the case... Sorry to report that this doesn't work strSQL = "SELECT * FROM PriceList WHERE PriceList.ListID = " & Me![List33] & " And PriceList.[Valid] <> 0" Also this doesn't work Set rs = DB.OpenRecordset("query1") even though query1 does work! Seems that my only option is to use...

Once again boblarson comes up with a different approach and I'll certainly be trying that later. Have to sign off as it's time to join the rush hour traffic so Many Many Thanks to all and I'll post results later.

That's what's weird. Pasted into a query (and setting criteria as ListID 6, Valid True), it works fine but with the DB.OpenRecordset(strSQL) it doen't! I've also tried copying the SQL from the query to the module. I'd be happy to open a recordset based on a saved query but I don't know if that...

CBrighton. Good idea but have tried looping through to EOF with a simple MsgBox and that's where I'm finding too many records. vbaInet. I have tried -1 and will try =Yes. Thanks

Hi all, I do try to resolve my own problems but this one is a mystery to me as I'm sure that similar has been fine in the past. I am trying to open a sub set of table "PriceList" which has 900 records and includes the fields ListID(Lng) and Valid(Y/N) but it's not going well... Dim DB As...

Update Ok, I understand a lot more now. There's a lot of Java/xml involved and I have loads of info to wade through. Probably take months and still not sure about where I'm going but the journey looks like fun. I'll let you know. Thanks again, Mike

Thanks to gemma-the-husky. I still think I want to try. Thanks to NigelShaw. Yes I did intend eventually calling them but before I do I'm trying to understand what would be required so that I don't annoy them. It looks like firstly an output file has to be in a very specitic format so no...

Thanks to Uncle G for the reply. Point is that the stuff I have found looks like a mountain of crap that I doubt you would want to see. That's why I only asked for basic principals. I'll post links to the .pdf's if you wish. I now know that the requirement is for EDI over a VAN so I am...

I'm able to write a payroll application but I don't have a clue where to start investigating the needs for filing electronic tax returns to Her Majesty's Revenue & Customs via their "Government Gateway". They do provide guidance documents but I'm not getting anywhere with them. Any tips about...

I'm no expert so don't pay too much attention but how about using a Settings table in the BE with a field called LockedBy. > If report has not been run AND LockedBy = Null then >> LockedBy = UserID (or something) >> Run report >> Log that the report has been done >> LockedBy = Null > End If...

Glad to help. Mike.

Hope the attached helps. You would not be able to open a 2007 version so I have made it in 2000 and you will need to convert it to 2003. I have used a query because you did, I usually put the query sql directly in the Record Source of the sub. Mike

Bastiaan Thanks for posting the zip. As I said, I prefer to use Access 2000 but I do have 2007 so I have opened it in that. I am a little tied up with a TabCtl problem of my own at the moment but I think I can see what you are trying to do so I will create a small app and post it soon. It...

Bastiaan I would be happy to help you but it is difficult without knowing more about your problem. I am a little confused when you say "from the query I build a form". Do you mean "I use a query as the data source of a form"? I often put a text box on the main form that controls the content of...

I'm not skilled and use 2000 so others will help you better. Could you set a default in the criteria so that it has a starting point? Also you could hide the subform while it has this default criteria and then show it from the AfterUpdate of the criteria field. Mike

Thanks MStef and sorry to waste peoples time. I just found the answer by Jon Holmes in a 2001 thread "Access 2000 date madness" who said "When working in code, programmers whose regional settings are non-US, must explicitly convert all dates to US format." I have changed the (2) Formats to...

I am using DLookUp as the Control Source of a "PayWeek" unbound control and I can see that this fails because of Access defaulting to mm/dd/yyyy but I can't find a way to fix it. I have searched the forum and found lots from Bob, George, Mile-O and others so thanks to all but although I have...