Recent content by HelenWy

Yep, all working now! As I thought the backup copy I have is older than ideally I would have liked but it's not the end of the world. Ho hum... will just have to put all the changes back in again then!

Thanks guys - I do have a backup but it's not completed as a scheduled task by me so I don't actually know when it was done. Not that long ago but before the recent work I've done, which is the most annoying thing! I'll try importing from the backup and see what happens...

I hope I've posted this in the right place - apologies if not! I appear to have a corrupt form within my database, and it will take forever to recreate it from scratch so I was hoping to try what a few people seem to have suggested, which is to use Application.SaveAsText to export it, then...

Didn't know quite how to word my title, and hopefully have put this in the right place! I am running a query which has now decided to tell me that "The record source "SELECT [RECEIVED BY].ID, [RECEIVED BY].[RECEIVED BY] FROM [RECEIVED BY];" specified on this report or form does not exist."...

Ah, I see (I think). Well, I can't do anything with the database now so will have to wait for ICT to get their finger out and restore to backup. Will look into the BE and FE bits for when that's done!

I'm not aware that I'm using DLookup as this is an inherited database and I didn't set it up. I know however that I didn't change anything before we got the problem, so really not sure what caused the issue. Here is the code behind the form, if this is what is needed. Might help! Option...

Thanks for your replies - I have tried looking at the code using Alt+F11 (can't open the form in any way, not even in design view) but nothing looks odd, and I don't know if I would see any problems if there were any anyway! I have Access 2002 on XP - what we're dictated to work with here...

Hi guys - no idea if anyone can help but we have a database at work that we use daily to input data (using forms) but the main form we use now won't open. I have tried every way I can think of to get at it, but it almost appears that Access can no longer "see" the form. You can copy and paste it...

Somehow, I've managed to solve it. I don't know how, but I have! Thanks guys for trying to help - must have been gremlins in the system :-)

OK, have just checked another table in my database and a query of the same design brings back the right number of records - it appears to be a problem with this particular table/these records.

Brian - I was actually just thinking the same thing. The funny thing is that I ran the query yesterday and it worked perfectly, bringing back all the records. Sounds like the date issue is a red herring - as I said, it's not been a problem until today. So, ignoring that bit - what else could...

No, hadn't done that - didn't realise I had to until now! Have tried it with both the format inputted (already had short date selected, but changed it to dd/mm/yyyy) and also with the input mask. Sadly, nothing seems to have changed and I'm still only getting 14 results. The SQL statement keeps...

No, hadn't done that - didn't realise I had to until now! Have tried it with both the format inputted (already had short date selected, but changed it to dd/mm/yyyy) and also with the input mask. Sadly, nothing seems to have changed and I'm still only getting 14 results. The SQL statement keeps...

I have tried the medium date format in the query and it still gives the same results. Curious. I tried changing it in the SQL statement and it continues to revert back to the short date format, and transposing.

Hi David I enter 01/04/2009 (i.e. 1st April) and 30/06/2009, and this format hasn't thrown up this issue in the past (when there have been other records on the database). I will try the medium date format and see if it works though! Thanks for your help.