Search results

yep, and changed it and it still threw up the same error. Don't worry guys, i've spent 1/2 hour on crystal reports and have got more done than i had before so no worries, thanks for the help however, it is appriciated :)

It's posted from before, To be honest, i'm now so fed up with access not doing simple things and having to go around in circles loading in wizards because I can't find a decent guide on doing it the manual way that i'm just going to go ahead and do the dam report in crystal reports and learn...

after spending a week locating the disks I've finally got the wizard installed (despite mentioning otherwise) so could someone tell me why I still cannot do what I want to - which is run multiple queries in a report which all are based off the same table.

Prt Screen as requested

Don't suppose anyone could point me at a decent guide, I'm still having a few issues with this and it recognising the fields used

we lost a load of disks when we moved office's - nothing so exciting! besides, we will be upgrading at somepoint in the most likely very distant future - but at the moment we're all stuck with what we have on the computers - it's at the point of it something comes in too new a version we have...

not installed at all - i've checked the file directory before - it must have been a skeleton installation.

Unfortunately not, I have no wizards installed - at all - I've been told by IT that we do not have the disk to reinstall the wizards so this is a no go as well - hence why i'm having to do it all manually. If it's too much of a pain & long winded essay to explain etc, do not worry, i'll...

There's a query builder??? The instructions I had was to go into the properties of the report - recordsource ... and add in the queries I wanted. I didn't realise there was any other way of doing it! FYI I'm access 2000 and there are no installed componants (rolls eyes)

SELECT FROM [NON PUBLIC], [PUBLIC], [PUBLIC CUL]; Having never done a multiple query report before I have no idea what I'm doing - I just found a guide which told me to keep adding the queries I wanted to use. Thanks for the help :cool:

Hi Guys, This is probably a really stupid question, but I can't seem to find any information about it on the web, I'm attempting to design a report of which there a multiple queries as its recordsource, but I keep getting this error; Help!

Ok, so i've read up loads on normalisation and i understand the concept, but baring in mind this is the first database ive ever done this with, I have no actual real idea on how to split it down into various tables. I'm finding it quite annoying that "guides" also use lots of other language...

ok, fair enough, but then if i remove a client, isn't this going to effect the previous data? also wouldnt mind some information about the form setup to whoever reads this!

Hi Guys, I could do with a little help in sorting the correct design for a database i have to build. I'm in a bit of a rush with it, and only have a few days to get it all sorted, so all information would help. I need to create, what we will term, an ORDER COUNT. Basically, batched orders...

Hey all, I’m probably asking a really stupid question, I’m a little lost and out of ideas at the moment. I want to create a control centre of sorts to overview 3 databases live where i can see who is in them, whether new records have been added, possibly how long they have been in them and...

Hi all, So guess i best introduce myself, my handle is colenzo, but im also known as Em! I live in the wild and wildness of the far far far southwest of england and I thought I knew a lot about access and excel until i joined up here cos i couldn't do a damn thing with my database. I also...

Alas, I have hit a hurdle once more. The search results box (list box).. is there anyway of being able to sort this. Ideally I would like it sorted by the RCID field, descending. This way, the most recent record is at the top of the box when filtered! Again, any help to point me in the right...

Please ignore me.. I didnt change the bound column! what an idiot! oh well.. live and learn!

Ok, i've fixed the previous problem, however, when use the pop up form from the list box, its not matching the record I select, and i'm getting an enter parameter box and nothingness. Private Sub SearchResults_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria...

Great form, and great help from the search point of view. The one thing I'm missing is the ability to double click the record, and open up another new for (like in the example), but to be able to edit the details or add bits in to this form. It seems in the example that it is used only as a...