Search results

I have a db with some DAP’s, they run fine when I access them through IE using say \\servername\inetpub\database\page1.htm with useremoteprovider = false I then change them to useremoteprovider = true try to access them using the above but with http: and nothing happens, page cannot be...

I found that the report was missing some of the fields that are in the underlying query. When I added these it didn't happen. Doesnt explain why but a fix.

I am getting this error when running a report, when I create a new report (just a quick on with the wizard) it doeant happen. Has anbody got any idea why? Underlying query runs fine. ??????????

Thanks, i figured it was Or Is Null thing. I tried that and it screwed things up because it was altering the query to have Or Is Null on the end thus creating the wrong query. What I had to do and if anyone knows of a better way was copy the whole Where clause and stick this in the IF...

I have a piece of code that builds a query passing some variable from combo boxes on a form. Generally works fine but for some reason when I pass Like”*” it returns all of the records from that field that are not nulls, I was expecting it to list everything. This is the code I have, any help...

They are not seeing the tables, it is accessed through a form, the only way without messing with my head was to produce it this way, which I did ask about. http://www.access-programmers.co.uk/forums/showthread.php?p=821185#post821185 Just seen your signature, thats pretty funny :)

I agree. Not so much bad design (I thought I was doing pretty well to get it functioning). I would say bad practice in a relational database. Although it was driven by the desire to have the output look like excel (not my choice).

Its to do with the table structure, it has a similar data structure through out such as day1, date1, day2, date2, day3, date3 all on the same table record. It appeared the best way to pick out querying these dates was to setup individual queries to queriey each date and union each set of results...

Thanks, I don't do lots of coding, although this is pretty simple in this case. It is something I can work with thanks. I was hoping to build all of this away from VBA, if anybody has any ideas on how it can be done? For now I will put in some code. Cheers

I have been lookinig at it too long hence the jibberish I wrote. What I actually want is for the date field control to update when I change another fields value, its a status complete field I will be changing to Yes and I want the date field to auto fill.

Anybody got a simple way to do this. I know you can set the control source of a control to be lets say Now(), but how can I pass this into a date field in the underlying query, the only way I know is to change the control source of the date fields control to refer to the Now() control but then...

Good man. Looks to have done the trick. Cheers

I have a few queries getting the same data from a table, each individual query runs fine. I then union them together but what I am finding is that records containing the same data are being ignored when unioned together, how can I prevent this?

Bob, yes, spot on, that is the problem, it is coming from a spreadsheet. I can't stop people thinking in an excel world where all the cells adjacent to one another appear related but actual have no relation to one another other than in their visual conception. JSV, I had put something together...

perhaps the wrong title. What I would like advice on is seting up a continuos form that can be continuous in both the X & Y and have a series of extra fields to log data aginst them. For example if you have a set of data that has, lets say car models in the X part of a standard continuous form...

Is there an way of protecting the database?? Been looking for ages. DB passowrd not secure enough (and pointless), making the file into accde is OK because it prevents editing code (if you are using code), accdr runtime, creating runtime shortcuts, tried all of them. Hiding ribbons and...

anybody got any idea what the comparison in size would be for storing a file as a txt and storing the same data in a database.

Sorry, figured the last one out, me being stupid. The real problem now is handling the text, I have passed the contents into an Insert sql statement to insert into a memo field. However when you come accross ' or " in written text it obviously thinks this is part of the statement and fails to...

Not three bad thanks. still having a bit of issue with it. when you first run the code you get prompted that the file is locked for editing by ' '. and have to make a selection to open as read only. Any ideas? Does the file actually have to open?

Not sure this is possible. Anybody know of a way to extract a text string from a word file and import into access? The string would be the same in every document e.g. DOB ##/##/## but may not be in the same position within the document. :(