Recent content by ordendelfai

Hmm, I may repost in the VB forum, however, can you elaborate on the binary string? Is there a command I can run from query analyzer to dump a file into an image field, and another command to export it out? Is it even possible to export it out and open it as a editable word document? The...

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

Just to throw my two cents in, if you have a boolean field (true/false), it can never be null in a linked SQL server table. If you create a record without setting a default value of false or true for the field, you will run into record lock problems (don't know why, but this along with the...

Hi Steve, thanks for the input. I ended up having to update the Oracle SQL directly to make dynamic date ranges. I basically used the Trunc function with "sysdate" to make it work. I do not handle the universes at all, so if you do not mind, could you elaborate on what a Calendar table would...

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

Well, I messed with the TransferSheets method, and used number 5, which is Excel 7, instead of 8, which is Excel 97. When I use the Excel 7 version, this problem does not occur, but when I use 97, it does. I suppose this is a fix, but if anyone has any clues why this would happen, I would...

Ok, this is wierd. This has been working fine, then all of a sudden, I am running into problems with multiple tabs. What happens is that I export the first query to a named excel file (C:\AccessOutput.xls). Then I output the second query using transfersheets to the same file. It creates a...

I just clarified with our database team, it is an RDB database. I am trying to connect to it from Access 97, but using a DSN-less connection. If I use the DSN, it works fine, but it would be very helpful if I could avoid using the DSN so I don't have any problems when distributing the .mdb...

THANKS! ;-) ~Joel As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.

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

Hmm, good question. I believe it is an RDB (not sure about the difference). I know that only the RDB driver works to connect to the server. ~Joel As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.

That is helpful, thanks a lot ;-) ~Joel As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.