Search results for query: *

Hi all, Just in need of some help in creating a variable number of export files from a database. The reason is i have a limit of the number of rows that each file can contain. in this case 3000 rows per file. I can create the file ok, but im having trouble dropping 3000 records into each...

Hi all, im just i need of help with splitting a file The file looks like this ------------------------------------------------------------------------------- OrderID|BillFirstname|BillLastname|BillCompany|BillAddress 1143658|Chris|Bell|Strutt & Parker|13 Hill St 1143659|Chris|Bell|Strutt &...

Im just a little stuck with some code. I have a grid which I populate and can update fine using the .selbookmarks. But say for exmaple I re-sort this grid then try an use the .selbookmark property. It still holds the old bookmark position instead of the new re-sorted position For example...

Hi, Just wondering, i have a grid that I update "one row", but I dont want to rebind/refresh the whole grid, can I just refresh the highlighted row somehow?? Thanks

Hi All, Just wondering. I will have my Certs Fully upto date shortly and wanted to know where should I go next???. I could keep just doing more certs, but I think maybee management is where my skills could be better used... What im thinking is looking at doing a IT Managment Course (if such...

Hi there, I have a table with Order Detail Lines, which I would like to add a picture to using a DSR from within crystal reports. There can be 1 or more detail lines, so I would like to display 1 or more images for a record. I can successfully get the code to access the first record and show...

Hi, Im just needing some help in storing the variable "picfile". The problem is each time I loop through the recordset it resets the "picfile" variable. But I would like to save this! Im thinking a for/next loop or an array??. But Any help would be very appreciated...

HI All, I have a fact table which contacts one field called QTY. This field contacts both credits and debits like ISBN QTY 12344 1 12344 -5 12344 10 12344 -2 12344 1 How can I create a measure or a calculated member of this to break it out into two columns like ISBN Debit Credit 12344 1...

Hi All, Ive beenusing crystal v8/9 for a few years now and have done some basic web reports in V8/9 via asp I wanted to now move to VB.net/ASPO.net web based reporting,and im after some decent books on the subjects. ive found one wrox book: Professional Crystal Reports for Visual Studio.NET...

Hi, I have a VB app, which creates multiple workbooks in one folder. I would like to take each workbook (they ony have one sheet in each) and combine them into one workbook. So far I have found this code from another site.(http://www.exceltip.com/) It seems to work fine if I use it in...

Hi, Im hoping someone can please help me here!!! I have a vb app that creates 3 separate xls files. They all reside in the same folder. For example: FileA.xls (contains worksheet named :"200") FileB.xls (contains worksheet named :"400") FileC.xls (contains worksheet named :"600") What I...

Hi im hoping someone can help me here please. I have a datetime picker which returns a selected date like: 01/12/2004 I need to convert this to a julian number. In excel its easy you just change the format to number an boom you get 38322 So how would I change it when I select a date. Its...

hi im just i desparate need of some help here, I have a MSHFlexgrid and im adding new records to the Database. I cannot seem for the life of me get the grid to refresh unless I close and re-open the form. which I dont want to do! I can see that the data has been added to the SQL table but...

Hi im just in need of some help on how to populate a combobox "dropdown list" type. I know I can easily do it using a standard combo, but I wanted to use a dropdown list as it stops the end user from editing the entry to something other than the list in the combo. When ever I try and load the...

Hi, Im just seeking some advice on best practice to Secure Telnet Connections. I have an ADSL Router NT4 Server I have an ADSL Router which I can setup to forward connection on port 23 (Telnet) to my NT4 server which hosts an application which can be run via a small telnet program. I have...

hi Can someone help please! I have an order entry app that I would like to show the new OrderID after I insert a new record on the form. Currently the database has an Autonumber field, and when I add a record, it creates this new OrderID on the fly. Which is cool. But how Do I grab that New...

Hi, I have an array of text boxes (50 of them) I would like to, instead of having to type each one in loop through them: My current code is this: With ObjRecMaster .AddNew .Fields(0) = txtFields(0).Text .Fields(1) = txtFields(1).Text ............ .update End with How could I just get loop...

Hi Im just a little stumped. how can a pass a form name to a module? for example: at present that has the form name hard coded like: frmorders.fOptBegins.Value But Becuase I want to use the same module on a different form how can I make "frmOrders" a variable of which ever form it was...

Hi, Ive been playing around with the ms datashape command, and have no problems with editing an existing record, in either the MASTER or DETAIL tables. I have used the VB wizard to create via ADO code. Once I overcome this hurdle I'd like to then modfiy it heavily to suit my application. Which...

hi, Im been searching through loads of posts to see how I can do this, but Ive nearly cracked it.. I want to have a progress bar based on the current recordset. (See code) But everytime I run it I get the following error: run-time error 380 Invalid Property value. Now i think this has...