Where do I go for help?

[mustbemad]

After being on holiday I've come back to my beautiful database (ok it was only slightly attractive but it had personality!) not doing anything it was asked.

Search for a record button works once then doesn't work for finding the next record. ie king A, but not king B, King C etc.

Reports are screwed up with new titles and confusing layouts.

I don't want to start over but I don't know where to begin.

I don't have a copy of the database preholiday as I needed to have it updated weekly while I was away. I did have a backup copy but it's also been overwritten, (I gave my laptop to my fill in) So can't go back to a copy that was working perfectly.

stupid I know but I thought we were safe.

Is there somewhere I can go where someone will look at my database and not cackle like scrooge mcduck? but give me a fair idea where to start fixing this up.

I have to be a little discrete as the db contains details not everyone wants put out there in cyberspace.

The reports I can delete the lot and start over but the search buttons pffft I can't begin to get my head around them.

:banghead:

 

[The_Doc_Man]

First question: Did your version of Office get updated? If so, your references might be the problem, perhaps badly broken.

So if you have code anywhere underlying anything, open in design mode, look at the VBA, and in the toolbar do Tools >> References and scroll through that to see if any of the references now show up as broken. If so, then you need to repair your references or find their replacements. Sometimes the difference is merely like the DAO35 library got replaced by the DAO36 library - or something similar - after an upgrade.

But of course, if your fill-in mucked your laptop, you also need to find a nice medieval mace for that person's skull.

 

[mustbemad]

Thanks Doc I'll have a look where you suggest, and see what I can find bwhahaha a mace sure has more ooomph than the rusty spork I was contemplating.

 

[Joe8915]

Try this as well

http://www.datapigtechnologies.com/AccessMain.htm