Recent content by spence27

Thats a lot slicker than i was able to put together, but they both give the same output when using the command line SQL-PLUS, though i think i might re-evaluate ;-) some of mine. I was just wondering why is there no output when using SQLDeveloper I get script succeded but no results? THe only...

Here is the proedure i am trying to get to run basically by passing a variable in it brings back any data matching it, but it just wont compile create or replace PROCEDURE VIEW_PRODUCTS_SOLD( Start_Date in date, Finish_Date in Date ) AS BEGIN SELECT PRODUCT_ID...

Thanks HarleyQuinn I knew their was some way to do it. I'll definatly use one of you ideas i have just tested the frmListStyleOption suggestion and it does the job but i'l;l give the other a go especially if it means i can place the check box at the other end of the line. Again thanks all for...

It would if i havge to go down that route. I was just trying to make in a bit more intuative rather than have people holding the CTRL key as well a checkbox makes it very streight forward as to what is selected and what isn't. I have seen checkboxes in listboxes/combos in the past but i can't...

Two questions 1) Is it possible via VBA to add a check box to a listbox for example list all the days of the week on each row and have acheckbox on each lin e so someone could choose their favorite days. 2)If possible, how is done. Any help on this would be greatfuly recieved. Thanks#Spence

This might be one option http://www.mvps.org/access/modules/mdl0030.htm with a bit of code tinkering

I understand what you are saying and true it makes sence but i cant changes the field names and the user can choose to as many fields as he or she wants, The code i posted is just a very small sample in general use i expect 10 options minimum to be selected. I have found reference to a kind of...

Sorry for the delay in getting back (personal stuff etc..) Below is an example of the sql string. The Select clause can have any number of elements from 1 upwards this is the sql generated that needs to be sent to an access database but there looks to be a limit of 255 characters. So I need to...

Thanks i have re-posted to the given forum and clsoed this thread

i have been seting up a front end to work of access using ado and i have hit a brick wall. My font end builds a SQL string using the limits and grouping useres select. Once this SQl string is pulled together i send it against the db for the results. In simple testing everything was fine however...

i have been seting up a front end to work of access using ado and i have hit a brick wall. My font end builds a SQL string using the limits and grouping useres select. Once this SQl string is pulled together i send it against the db for the results. In simple testing everything was fine however...

Found the best answer and that is to put some code in the onStartup event of the document and open the document through brio but holding down the ctrl key

HI I have set up a brio document to retrieve a set of data and then export it and finally close down all when the document is opened but i would like to be able to stop this automatic process from happening in some cases when the report has to be run manually. I was think the best wa to do...

Thanks for the reply but could you give me a little bit more infomation i.e. what is filtering (in this context) and how would i use it. I have been doing a little bit more leg work since i posted originaly and have found it is posible to create disconected recordset, which would give me the...

Just a quick question to you most knowledgeable people I know who to create a result set from a data source, and 99% of the time things work as they should, but what I would like to do is hit the data source once and then create a result set which I can then create additional smaller results...