Search results for query: *

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

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

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

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

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

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

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

Hi, I'm trying to store documents as blobs in an image field on a sybase table by using recordsets and the Addnew method and then once it has looped through the file the Update method. I was wondering if there is a maximum amount of bytes that can be stored in a buffer of a recordset when one...

Hi, I'm trying to store documents as blobs in an image field on a sybase table and was wondering is there a maximum size that can be stored in one field? I seem to be having problems with documents over 2K in size. Thanks

Hi, I'm trying to store word documents in a sybase table, by loading them from an Access frontend. I understand that they need to be stored as data type image. My intention was to pass the document from its converted state where it is stored in a Access frontend table in an field of datatype...

Hi, I'm trying to store word documents in a sybase table, by loading them from an Access frontend. I understand that they need to be stored as data type image. My intention was to pass the document from its converted state where it is stored in a Access frontend table in an field of datatype...

Hi, I was wondering whether it is possible to load files through an Access '97 frontend and store them as a blob file on a sybase backend or is VBA limited in this regard? Thanks

Hi, Currently I have a main form (frmMain), which has one subform (sfrmSubMain), which itself is made up of two sub forms(sfrmSubSub1 & sfrmSubSub2). I'm trying to set it up, so if the user moves to record 5 for example in sfrmSubSub1, the focus in sfrmSubSub2 switches to record 5 as well and...

Hi, I'm trying to specify in SQL to be run within VBA code using the DoCmd.RunSQl command to insert into table 1, all the records from table 2 except records where the first field in table 2 is not equal to the column name and where both fields 1 and 2 of a record are blank. Unfortunatley I have...

Hi I'm trying to do some SQL in microsoft access for a query and am running into some problems. I'm trying to find ensure that all values in a particular field are the same. My first query is a sub query and simply finds all distinct values for this field. The main query should insert all the...

Hi, I'm having a bit of hassle with regard to using the timer interval property.I want my code to go off and check the systime every hour, but can only use the timer interval property to execute my code after a maximum time of 1 min. This however is too frequent and it also uses up to much cpu...