Search results

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.

So sorry - here it is! SELECT COMPLAINTS.[COMPLAINT NUMBER], COMPLAINTS.YEAR, COMPLAINTS.QUARTER, COMPLAINTS.[DATE COMPLAINT RECEIVED BY SSD], Divisiondata2.DIVISION, [Service Area2].[Service Area], Area2.Area, Cluster2.Cluster, [Type of Service 2].[Type of Service] FROM [Type of Service 2]...

DCRake - thank you! That is exactly what it is doing - do you know how I can fix it? Strange that it hasn't happened before...

Well, obviously I "make" something wrong, MStef - thanks for that! I was asking if anyone had any idea *what*... DCrake - thanks for a more sensible suggestion! I will check the SQL statement.

SOLVED: Select query not working... only showing 14 records out of 48! Hi all - I'm stuck. I have (currently) 48 records in my database, and I am running a query to bring back all records since 1st April - it just happens that everything in there only goes back to 1st April. For some reason...

I realised after you said that, that I had already tried that and it hadn't worked - went back to check it and realised why - I had my IDs out of sync! I have another query off the back of this though, now that I have my combos working as I want - I need to add a further field, but I ONLY...