Search results for query: *

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

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

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

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

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

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

Does Excel have a user form collection, and if so how would i loop through each user form Excel 2002 VBA XP SP2

I have a report designed that uses a subreport to generate a list on contents on the second page of the report. Everything on the report runs really well but the icing on the cake would be to add some hyperlinking from the contents to the specified section in the main report I'm using CR9 with...

Im a bit of a newbie to CR, but i'm using CR9 and trying in basic sytax to enter this formula "CALL DETAIL DATA FOR APPLICATION(s) " + arrayToString ({?APPLIACTION_NUMBER},", " ) + " ON TODAY." But i keep getting a error mesage saying "A Statement Expected Here". Can someone point out what i...

i am just wonderibg if you can help a new coder out with the following problem. I need to create a reference to an existing form from a fuction in a module. i then want to pass this object reference into other functions to do this and that. e.g. function makeobj(existingFormName) //create the...

HI I was wondering if someone can help point me in the right direction. I am building a few reports in access(2000) and the querys they are based on need a parameter to be passed. I can do this manualy but he idea is to have these reports run in batches. So i need a way to pass the...

Hi - I hope some one can help with this I have set up a webserver on my local intranet on my fire wall "Smoothwall" i have entered the IP and host name 192.168.1.2 www.vh1.sar-tec.net vh1.sar-tec.net when i call up the address from a browser it finds the IP goes to the server but...

hi I am running Excel 2000 and need to . The MS Query editor does not do the job as i will need to 1)create a temp table 2)fill it with data 3)Run a query & return the results 4) drop the temp table. i.e. it is really a collection of Procedures. I can do all the SQL stuff. I just don't know...

hi I am running Excel 2000 and need to connect to a SQL database. The MS Query editor does not do the job as i will need to 1)create a temp table 2)fill it with data 3)Run a query & return the results 4) drop the temp table. i.e. it is really a collection of Procedures. I can do all the SQL...

hi I am running Excel 2000 and need to connect to a SQL database. The MS Query editor does not do the job as i will need to 1)create a temp table 2)fill it with data 3)Run a query & return the results 4) drop the temp table. i.e. it is really a collection of Procedures. I can do all the SQL...

Hi i'm a bit of a newbe trying to load a text file in to a table. I can do it throughQueryman using INSERT INTO businessdbtemp.WARRENTIES VALUES (?). However i am prompted for the file location each time but i need to script it from excel. So my question is is their a way to pass the file name...