Search results for query: *

I found an article from Microsoft that talks about storing Word docs in the server by using the Image type. http://www.microsoft.com/sql/techinfo/tips/administration/importword.mspx I have seen applications that let users store documents in a grid (row by row) and allow the user to open the...

Hello, I have 2 formulas that when used solo, work ok. But when I add them together I get a number that is too small (just a little larger then "RXONLY" formula when used solo). I am using a second data provider in a table, and the second formula does not work without Multicube. I am still...

My company is trying to determine what platform to build a fairly complex application for about 60 users. At any one time, all 60 might be logged in. I have a lot of experience building an Access 97 front end linked to SQL Server 2k tables, but only for small user groups (10 max who almost...

My company is trying to determine what platform to build a fairly complex application for about 60 users. At any one time, all 60 might be logged in. I have a lot of experience building an Access 97 front end linked to SQL Server 2k tables, but only for small user groups (10 max who almost...

BO 5.1.7 I have some reports that I use to do in MS Access with dynamic date ranges that I would like to run using BO. So far, I cannot find a way to use dynamic date ranges in the query panel unless I use a prompt. However, I need to use the Broadcast Agent (this is a jumbo sized company)...

I am referencing a text box on a form that is very tall (or I could use a memo box as well). I am passing a string to it's control source, as below: MyTxtBox.ControlSource = "=""HI There""" What I need to do is display the text on two lines in the text box (or memo box): "Hi There" Instead...

Access 97 I was looking for a quick and easy function in Access VBA (like excels Replace() function) that will look at a string value I pass to it, and replace all searched for values with another value. I couldn't find anything, so hacked the below code together real quick. It does the job...

I am trying to use the below code to link a table from an Oracle server, using the Oracle ODBC Driver for RDB. The code below will pop open a login request, and after I enter the correct password I get: "Run-time rrror '3000' Reserved error (-7778); there is no message for this error." This...

This is a strange request, but I need to find a way to extract the top initial SQL code (text) up to the "FROM" portion of the statement, then extract the FROM SQL until the WHERE statement, and then extract the WHERE SQL text until the ; (cannot include the ;) For example: qry_SqlExtract...

BO 5.1.7 I am just starting to use BO, and I have a report that I want to only display two dimensions and a custom variable that sums on <Total Eligible Count> only when the <Mbr Relationship Code> = "C" (the MBR Relationship Code is not in the table) In the table: 1. <Calendar Year+Month> 2...

I want to be able to dynamically set the attributes property "Hidden" of a query through VBA code. So far, my research shows that it can be done for TableDefs, but I am having no luck with QueryDefs, nor any other method to change the Hidden value for a query. Anyone have a way to do it...

Just a quick question. If I have 4 criteria's for a single field, and am trying to determine what function to use, In( ) or OR. For example: ="A" or "B" or "C" or "D" Versus In("A","B","C","D") Which one is faster, and why? ~Joel As common courtesy and to help other members who might...

I am trying to export multiple queries to the exact same Excel filename, just with different tabs. If I click on a query in Access, then go to File -> Export, and find an Excel file, then Export, Access exports the query into a new tab of the Excel file with the name of the query. I am trying...

Access 97 I am using code to create/change queries in VBA, and need to change the query description (property). If you know a way to change a query's description, I would really appreciate the information ;-) ~Joel As common courtesy and to help other members who might find your thread...

I have a combo box that contains all of the field names of certain query. Up to this point, I have created a seperate table to hold the field names of the query. However, I now need a way to dynamically grab all the field names in a query, and populate the combobox with them. The main problem...

I know that you can use hyperlinks to a worksheet and even a specific cell in the same workbook. However, I want to put some embedded word docs in a tab, and then use a hyperlink to open them. I have tried Sheet1!'object 3' This didn't work. I also tried using quotes " " and no quotes at...

I am working on some code to change between my development and my production server with a click of a button. I have many pass through query's that must have the ODBCConnectStr changed. The problem I am having is referencing the ODBCConnectStr property of my queries in VBA (never had to...

I have a sub report on a master report that is not linked (independent). The sub report has a group header that prints with the data on the master report when their is data in the sub report. When there is no data in the sub report however, nothing prints at all. I need the group header to...

I have a query that I have tried to run three ways using a passthrough query from Access 97 to a SQL2k server. When I run either of the queries in a standard Access query, the results have no dups, but when I run them in a passthrough, I get dups. I cannot figure out why this would happen...

Access 97 I have a strange one, not sure if I should post it in the VBA forums, but I'll try here first. I have an advanced reporting system that uses code on forms to dynamically create the SQL, then a query. This dynamically created query is filtered and sorted with dynamically created...