Search results

I have several reports setup as individual A4 sheets that I need combining into one single report, all using different sources for their data. I have tried sub reports but the vertical positioning is a problem as each sub report starts slightly further down the report page. Any fixes for...

Will he be the 2010 champion? I say yes.

I have a field called results that I want to format to fill red. It currently checks the value of expr1 field and if greater than this value formats. [results]>[expr1] expr1 picks data up in the query, an iif statement, so expr1 can sometimes have a "" value. My problem is that I also need...

Completely lost on this. I have some code that inserts values into a table, some appear whilst others do not. The code functions correctly, picks up variables and executes. The data that doesn't appear is for fields that have lookup lists to other tables. If I open the table I can select...

Is it possible to sort columns horizontally? i.e. you have 6 columns with 1,2,3,4,5 & 6 as a header number but they are not in sequential order.

Not a sort as you know it. Is i possoble to have six columns each with a random number between 1 & 6 as the header and then move these columns so the headers are in order?

I don't even know if this is possible, can you get one report with say half of its layout in portrait and the other in landscape?? I was think sub forms but that I think takes on whatever setting the main containing report has. Is there any VBA tricks? Another way would be to run 2 reports...

I am trying to produce a report that totals and averages but I am having some problems figuring out how to show one of the totals. For example, orders of fruit, I can get all of the many sided data such as Boxes, Weights etc (the individual order details) but can not get the total orders as...

Is there a way of changing the link connection string when you have linked tables from an sql server so that they don't use a DSN? The problem I have is when you allow access to upsize the db to sql it creates the connection as DRIVER=SQL Server;SERVER=......... and so on... all I can do them...

I have a query based on several other queries that fetches data from a SQL server. When I first run the query it can take a minute to fetch the data however once it has ran once and I change the criteria it fetches the new data in seconds. Does anybody know why this is? Please

How can I remove the pound and the millions from £2.5m to leave me with 2.5 Can't see how its done with, what I know of left, right, mid they woudln't acheive it as they are not always in the same position for example the £2.5m could be £2m or £10.5m.

Anybody come accross this issue and have any idea how to fix it. I have parameter in a query forms!frm_whatever!txtwhatever When I run the query its fine, I close the db when it opens again it pops the parameter box up as though the name of the field is not recognised. If I change the name...

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 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. ??????????

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...

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...

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?

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.