Search results

Hi Pat In terms of whether my report is faulty or not, I do not think it is. When you are in Access you just select the month & site that you want the data for and SQL interoggates the various, in a fairly efficient manner, it retrieves the info from a number of different data sources and spits...

Bumped instead of double post

Bumped Original Post Right Here Thanks Pat

I have a very involved question regarding the export of data from and Access front end, SQL back end into multiple Excel Worksheets. Where is the best place to post this in order to get maximum exposure to the great minds that cruise this board. Regards

Worked like a charm My sincere thanks to you Regards

I shall give that a go right now Thank you for the very prompt reply Regards

I have a database that contain a column that has box numbers in it e.g. 1 PM, 2 PM, 3 PM through to 20 PM and above. I am trying to find a way to show what the highest box number is that is within the column. However when I sort on Ascending or dexc, it is doing 1 PM, 10 PM, 11 PM and so on...

I have a fairly complex report that is generated with alot of resulting fields in an Access front end from a SQL Server Back end via Stored Procedures. What is the most efficient way to pull a named field from a report into Excel in a specific named Worksheet and specific Cell. For the sake...

I work for a company that deals in property management. Every month, we have a financial report that runs that gathers various pieces of information and formats onto a report. Each report is for one site, and there are over a 100 sites in total. In addition to the paper copies that the DB...

Brian, and there was I thinking you sat there 24/7 waiting for my every enquiry. Yeah, the switchy box thingy could work. Will head off down that road Thanks

Just to throw a spanner in the works. If the value of Null is being searched for as part of the overall search, I have two boxes DateFrom and DateTo that obviously have no value in the them when displayed to the enquiring user. What road should I reserach to make the value of this box display...

You know what Brian, I just fell in Love with you IT WORKS!!!!!!!!!! Thank you so much for all your help. I am going to read through what you have actually typed and try to understand it so that I can at least learn something from this. Kindest Regards

OK. Sorry I missed that earlier on in this thread. I will give that a go Regards

I am fairly sure it is something to do with the use of the Is Null statement in the IF line that is causing the problem. When I go through logical elimination steps, it gives me a 424 Object require error as soon as I put the Is Null element in referencing the txtinvdatefrom box ummmm?

Ok, why does the code go straight to the nottenantsql: irespective of the values in the boxes it is checking on the form? I am so damn close I can almost feel the solution to this problem Private Sub cmdsubqry_Click() Dim myDB As Database, MyQuery As QueryDef, strSQL As String Dim Response...

here is the coding route I am going down, the problem is that I end up with the same logic problem if the user does not wish to specify a date. Fine if they do, screwed if they don't Private Sub cmdsubqry_Click() Dim myDB As Database, MyQuery As QueryDef, strSQL As String Dim Response...

Ok, attached to this is a sample of the data i am querying If on the form the user has selected from individualname the value of 'Tenant', they may also select a DateFrom value or leave it blank to show all the records that are listed as Tenant. if they select any other value other than that...

Perhaps there is another way around this. I remember once writing a peice of code that created the query definition on the fly in VB. Perhaps rather than using wildcard search routines, it may be easier to recreate the query based on a If the value in this box Is Null then drop and recreate...

I have no need to use like now. I have rewritten that part. basically I want this If that search parameter box Is Null, then as part of the query search for Null in that field amongst the other search criteria. If the value of the Box Is Not Null, then use the date that is in there for the...

The IIF statement feels like it should be right. Logically in my head it sounds like If the value of the search box is Null then search for Null, if the value of the box is not null, then search for the date listed Just can't understand why it does not work Regards