Recent content by BazLondon

Thanks to all who responded. Pbaldy - you've hit the nail on the head. Pretty obvious really isn't it? yyyy-dd isn't a date. Baz

On the face of it a simple question. I'm setting up a very simple table with a primary key field consisting of a year and month. Attached is an image of the Design View. Also attached is an image of the response when entering data in Datasheet View. I'd be grateful for a lead as to where I'm...

Thanks dcb and Thinh for your responses dcb. Doesn't work. By definition, the same Parent can occur many times so it can't be unique (ie can't be set to "no duplicates"). It's the Child that's unique. Thinh. Your structure is very similar to mine but your database hasn't been set up with any...

Greetings I'm sure this subject must have been addressed in the past but I would be grateful for some thoughts on it. On the attached .pdf file diagram I have shown :- 1. a typical "top-down" tree structure (similar to a Bill of Materials but without the frills of including the number of a...

Thanks to Holger and Brian for your quick responses. Holger. No I don't really want to use VBA if I can help it. Your solution may well work but as I indicated in my original post the VBA is a foreign language to me. Even if I were to blindly use your suggested code I wouldn't have a clue how...

Greetings I cannot find a Function in EXCEL to carry out a specific required task and if there isn't one I'm surprised it hasn't been supplied as standard. I have a spreadsheet in which one of the columns contains cells that have been formatted differently, for example some are 'text', some...

Thanks RuralGuy. Worked perfectly. Still can't find any reference in documentation but no matter problem solved

I wish to create a very simple query but cannot find the correct syntax mentioned in any documentation. The WHERE clause needs to have the effect of ignoring certain records in a table ie WHERE fieldvalue <> 12 AND fieldvalue <> 23 AND fieldvalue <> 37 etc etc for up to an unspecified number...

Hi Stephen Thanks for prompt reply Yes, I do have existing tables (and an existing database). I cleared the table I wished to populate of all data prior to the import attempt and I've even re-tried the import having moved the Excel spreadsheet into the dame directory as the database but still...

Hi I'm trying to import data from an Excel spreadsheet into an empty table using the Import Wizard (File/Get External Data/Import). All's well until I'm presented with the window that tells me that I can "store" my data either in a new or existing table. However the radio button and Existing...

Thanks, guys, for your prompt replies. Eddie - nice try but I think your solution breaks down if the query contains a sort on other than the primary key. Pat - amazing isn't it that something that on the face of it looks so easy is in fact quite difficult. I understand your comments re the way...

Hi there I'm sure that this must be easy, so go gently on an old codger! I have a query for which I wish to add another field containing a running total of the number of records produced by the query (after all sorting etc.). In other words, if my query produces n records, that new field would...

Thanks krunalprajapati for your prompt response. I've tried your suggestion and variations of it (eg using a macro) but have failed to crack the problem. If I could understand why my original method/coding does not work, it might give me an idea on how to solve it. Any further ideas - anyone...

I have a form F_EXTRACT whose record source is a table named T_EXTRACT. The form contains 2 controls, a Text Box named Surname and a Combo Box named Member_ID. Column 1 of the combo box is bound to Member_ID (in the T_EXTRACT table). Column Count is set to 3. In Row Source, I have the following...

Hi everyone - happy new year from an older first-timer I'm not sure whether this should have been posted under Forms or Macros as my problem impinges on both so I've posted it here. I've created a macro which successfully performs the following actions :- 1.Runs a Delete Query to clear data...