Search results for query: *

I have several workstations where the switchboard suddenly quit working. On other workstations everything still works properly,  but on the problem stations I get an error when switchboard tries to set up a database variable. Im almost positive there's an mdac or dcom problem but cant...

I need to query on a date field on a forms 4.5 form. This is NOT a sql query. In a sql select its easy enough to to_char the date and trim the time portion. However, I cant seem to find any way to do it on a form so I can do an oracle "form query." The query always fails to find the date even...

I currently use a front end Oracle Forms 4.5 form with buttons that use run_product to submit Reports 2.5 reports. Lets say I have three or four form letters in Reports 2.5 submitted based on a SSN parameter. I want to submit several reports with the same button, for the same employee without...

I have a hospital application where I want to report on demographics of residents (male, female, black, white, etc), the average daily population of the facility, and the average length of stay. I have a person table with the demographics and a movement table which gives me the dates and times...

There must be a secret. Ive been working with vb since version 4 now up to 6. Ive developed several applications including a simple personnel database. But there is one problem I have not been able to overcome, either with vb or access applications. I still can not create an application that...

I have a persons table with a personid. As the individuals addresses, phone numbers etc. change new records are added to the address, phone number tables etc, linked by personid. The addresses, phones tables have sequence numbers to indicate the most recent entry. There must be a simple sql...

I need to scan a large database at least every 10 minutes to identify records that have been added that match a certain critera. The sql statement is fairly simple and I don't need to pull more than a half dozen fields. I expect to find a few dozen records during a 24 hour period that match my...

Does anyone use this application? Im considering using it for a project but can't find any documentation on it. It's pretty straight forward to use but detailed information is not available on it. For example, it appears that if you want to "point" the application to anything other than the...

I need to do a merge to word document from an access database which is actually a front end to an Oracle database. I created the word template with a link to my access query. I can pull up the template and request it to refresh the data. At my development workstation I then get the normal...

I need to run a SQL script unattended on a time/date basis.<br> For example, I need a select script to run every hour to extract a set of records into a delimited text file. What is the best way to accomplish this? Im working with Oracle Pl/Sql but have VB available if necessary. However, I...

We have a number of reports 2.5 and forms 4.5 forms on a large oracle 8 database. Performance is terrible. We are calling the reports from forms with the run_product command. Is there any more efficient way to submit reports? What runtime command line switches are important for performance? Id...

Our company has Developer forms 5.0 and reports 3.0. We are running a vendor supplied application whose forms are 4.5 and reports 2.5. I have not been able to get their runtime bin and our runtime bin to exist on the same workstations. We are therefore forced to develop in older versions when...

I have a fairly large Oracle database and need to provide a certain amount of info through a browser to our intranet and possibly eventually through the internet. For example, I have a database of 100,000 individuals with a multitude of tables containing name, address, phone, and other...

I have an Oracle database with jpg images stored as long raw data. In oracle developer I can display the images fairly easily, but I have not been able to find a way to do that in Access/VB. Is this possible? How do I go about doing it?<br> <br> thanks for any info<br> bob<br> bookor@interserv.com