Search results

Update - I got around this by severing the relationships and deleting the primary key (Unique ID) field. I then re-inserted the field and re-established the links. So, the database has a whole new set of autonumbered unique Ids and everything works fine again. trouble is, I don't know what...

Yeah, I thought of that too but I have the database set to compact and repair on every shutdown - so no joy.

My database has been running perfectly for months but suddenly stopped recording new entries via my input form. Couldn't find anything wrong with the form but when I tried to enter a new record directly onto the table I realised that Access was trying to allocate a unique ID that had already...

OK, I assumed that the Table was corrupt. I copied it and renamed it. I severed all the relationships with the original and deleted it. I then re-named the copy to that of the original and re-established all the relationships. Hey presto! It now works fine. Chox.

Absolutely! The autonumber is only there to link all my tables and queries. I am not entering anything in the autonumber column. Access is allocating the duplicate number itself even though it is set as 'sequential - duplicates not allowed'. Chox

Hi Folks, I am looking for some hope that my database is not corrupt. The first sign of trouble was when users could not add new records via the input form. No error messages - just lack of a new entry. I tried entering a new record directly into the table but the autonumber allocated...

Hi Folks. I have a select query that has 10 columns which are checkboxes (yes/no) from the original table. I can apply filters for individual columns but I want the query to show records with ANY of the boxes checked and only omit those with NO boxes checked. I have spent the whole atfernoon...

I have an unbound combo box on a form that is used to select a record by surname. The complete record is then displayed in various controls on the form. I realised after completing the project that there are multiple instances of the same surname i.e. 5 Smiths. When any of the Smiths are...

Scratch that. I've got it. Thanks for your help.

Thanks Mailman, I forgot to mention that I'm on the learning curve. How would I implement the function? Is it in VBA or in the Conditional Formatting dialogue? Chox.

Hi Folks, I have a series of textboxes on a form that act as labels for other textboxes that display information. The reason I am using textboxes rather than labels is that they are dynamic i.e. the 1st one is Date(), the second is Date()+1 and so on. They are formatted 'dddd' so that they...

"Go home" is a euphemism. There may be beer involved ;)

Thanks everyone - solved. Following KenHigg's advice I tried to import everything into a new database and got an error message because of a conflict with one of my subform's names. I deleted the same subform from the original database and then re-built it and hey-presto it all works fine. I...

Guus2005 Good idea but no dice. And I set the startup properties from the 'Tools' menu. Chalkie.

Hello again folks. Having spent a week building my database and everything is working as expected - I set the 'startup' properties and now Access won't save or quit from the main form. In order to close I have to select 'form design' and then the 'X' will work. This goes for all the methods...

Thanks Adam, I was convinced it was simple.

Hi Folks. Should be simple enough, but I'm going cross-eyed researching this: I've got a main form that displays records of individuals (selected from a combo box) Part of the data requires that I store 'from' and 'to' dates and as I need to keep a history as new periods are entered, I am...

Thanks Guys, I'll try the Dsum on Monday morning. Oxicottin, thanks, great looking welcome form (which I'll use) but I still need to 'translate' the system name into the users 'real' name. Chalkie.

I am adding some finishing touches to my database. I want a 'Welcome' form shown as the database is opened and a greeting like "Welcome *****". My problem is this: by using =environ("Username") I get the right result except that my network logs everyone in as a staff number, ie 45812457. I...

Neil, Thanks for your help. A lot of messing around but I have managed to get a result by showing the subform as a continuious form. I'm willing to live with that. Cheers.