Search results for query: *

lol OK cheers! I'll muddle along as it's working ok with my workaround. I just figured there should be a better way of doing it.

the sql statement was made by: Creating a New ODBC Connection Example of SQL command: select address1 from clients where clientid = {?ClientID} I dont use a table just the results from the SQL Statment its looking at a DSN connected to a MYSQL base The Clients table in the database has an...

Hi Turkbear I'll try again :) In the Field Explorer it shows me the fields which are available from the SQL statement I've made. Each field is listed and shows the Field Type for example: address1(14) which means that when i last verified the data i had an Address1 of size 14. My problem is...

It's not the length of the field on the actual report I want to grow its the problem that the field type will never grow when new data is being used. The actual lenth of the text box on the report is fine as i've manually made this large - but I dont seem to be able to specify what size my...

Hi I'm new to using Crstal Reports and am having a problem with field sizes. I have a Vb 6.0 Application which uses MY SQL as the back end database. I've started using Crystal to create various reports. The problem is whatever field length the initial data i use to create my report is - the...

Hi,Does anyone know how to connect a Pocket PC to a MYSQL base located on a desktop PC? I'm new to Pocket PC's but I'm writing an Embedded Visual Basic application and want to send data from the Pocket PC into a MYSQL base using Wireless. Cheers.

Thanks Harleyquinn, Exactly what i needed.

Hi, Is it possible to allow users to resize a textbox (vb 6.0) when the application is running? Im allowing users to move a textbox around a form, but also want them to be able to resize. Thanks in advance :)

Hi, I've got Sage Instant Accounts and am trying to insert data from a VB application into the Sage tables. I've tried using ADO MDAC 2.8 using the Sage ODBC version 10. Does anyone know if this is possible or if any work-arounds are available. Viewing the data is not a problem just inserting...

Thanks for that It's great as a work around! I hadn't seen this problem before with 2000 versions, so it bugs when you know (think) it should be fine!

Hi guys can anyone help, I'm trying to use a mail merge in MS Word XP linking to a table in an MS Access 2002 database. All is fine except when merging a date field. If the field has a value it comes across OK but if it's blank it displays 12:00. I've tried to change the format of the date...

Can anyone help? I've created a new table using ADO and I need to add a specified number of records from existing tables. I can't use the TOP command in SQL as this adds extra records if duplicates are found! Must use ADO not DAO!