Search results for query: *

Hi Longhair Turns out that the 2002 version had increased substantially in size over the day, as opposed to the 97 version, hence the performance hit….dooh one of those obvious ones...cheers for your help and for the links, its appreciated. thanks, llafretaw

Hi, I have converted an MS Access Db from 97 to 2002, and everything seems fine except for one type of operation. Basically I have a form that contains a subform (the subform’s recordsource is a temporary table within Access). The main form contains several buttons that alter the data that...

have to thank all of you for this post as well, same issue and have been banging my head against a brick wall till I found this.

Thanks for all your assistance, its been appreciated. Adrian

Thanks for the pointer, realise now in hindsight, I frequently ask questions but seldom give feedback.... Anyway the code uses the itemdata method, but its when it tries to find a match for a non unique code selected from the dropdown that it always pulls back the first key associated with that...

Hi, I used to using MS Access comboboxes, where you can have 3 columns in the dropdown and hide the first column by setting its width to be zero. However I now have a problem with a VB app which references data returned from a stor proc and uses the .AddItem method to populate the combobox I...

Hi, In a nutshell I have a VB application that converts a string passed from a Sybase backend into a date value. This string is a numeric value and is created in the first place by a Roguewave process (which represents a date and time, stored in milliseconds from Jan 1 1901 00:00:00:000). My...

thanks

Hi, I'm trying to copy all the records in a flexigrid onto clipboard without having to explicitly select everything. I've tried using the following syntax which I found on this site and other variations; Clipboard.SetText whichgrid.Clip, flexCFText The best result I have had so far is only...

Hi, I'm using a Microsoft Access 97 VBA frontend to retrieve records from a Sybase backend which get exported to Excel 2000. The problem I'm having occurs when I convert the numeric data (on the Sybase end)to be decimal and greater than 15 in width. This prevents me from using some of the...

Cheers for your help, just got handled the app this morning and thought that the requirement was to return all the rows. This would have meant some serious rework, as the NewIndex property is used all over the shop.In addition VB would not be my strongest point, as u many have gathered. thanks

Hi, I'm having a problem with an application which preloads data into some of its comboboxes. Basically once it hits 32,768 records it crashes out as the NewIndex property used with the ItemData property, goes from a value of 37,767 to -32768, is there any way of resetting its value back to...

This is the code that I have been seeking for ages, and trying to get the datebase to self compact is something that I really needed.Cheers

Hi I'm currently using Access 97 and was wondering how does one explicitly open another mdb just before the calling mdb closes. I have tried using the dbengine.OpenDatabase method but that doesn't seem to actually open the called mdb. The mdb that is called needs to compact the calling mdb...

Thanks for your help. I have 2 databases, db1 and db2. I need to open up db2 from db1 before it shuts itself down, as db2 will contain code to run a compact on db1. I thought using the OpenDatabase function from within db1 would actually open up db2, but it doesn't seems to work. As for the...

Hi, I know the answer to this question may be quite simple, but I'm having difficulty opening another MS Access 97 db through VBa code. Basically the two dbs are in the same folder and I have tried using the Opendatabase function with the name of the sec db as the parameter but it doesn't seem...

I was wondering if there are any know issues between VB6 apps, connecting to a Sybase 11 db using an rdoConnection. In short I have a flexigrid which is populated by a simple query which retrieves records from a sybase table. A sql query is built up and this is passed using an rdoConnection. I...

Hi, I was wondering if there are any know issues between VB6 apps, connecting to a Sybase 11 db using an rdoConnection. In short I have a flexigrid which is populated by a simple query which retrieves records from a sybase table. A sql query is built up and this is passed using an rdoConnection...

thanks you for that.

Hi, I was wondering whether its possible to retrieve the username of the person who is currently logged onto the pc through code? The value needs to be put into an Access table to see who is adding these values. Is their someway of referencing the registry? Any help would be appreciated Thanks