Search results for query: *

I have a VB6 form into which users enter data which is saved to an Access 2002 db. At a later time it will need to be edited since there are several date fields that will need to be updated. I don't understand what the syntax would be to identify which component is updated, or do I simply call...

I have a VB6 program w/ several forms, one of which is the main input form for data which is then stored in an Access 2002 db. The other forms display the stored data depending on which fields the user uses to search by. Several of the fields on the input form will be left blank when used. As...

I have several text boxes in a VB6 entry form that take short dates and save them to an Access 2002 db. If I fill them all it works fine. If I leave any one of them empty I get the following error message: Syntax error in date in query expression '##'. The code used to Enter and Save them...

I have a VB6 form with bound ADODB dc which needs to query (adcmdText sql SELECT)an Access 2002 db table date field in order to match a user input textbox entry (TxtCtrtYear) on the form and then display matches. The Access date field (Start_Date) is formatted as short date and so is the display...

I have a bound control that works fine if I use the adcmdTable, but I want the adcmdText so that I can use an sql query to limit the return. Cannot get it to populate the display form. I've tried several variations. Can anyone help me see the issue? I've been unable to find examples that...

I have a VB6 Form1 w/ several Textboxes into which the user enters data which is stored in an Access db. I have been able to use a sql statement (not an ADO Data Control) to search for some individual recordset in the db by a certain field value and to display the result on another Form2 which...

I have a data entry form that saves data to Access db. I can read and display it via an ADODB control on Form4, but don't want to move one by one through all the data stored. I have attempted this sql statement on Form3 to select the particular data to populate Form4. Can't get it to work...

I've built a VB6 form to enter data and store it in an Access 2002 db and have that working. The form made use of cbo and txt controls. I have created another form, modified the cbos and txts all to txts so that when someone searches for data by a contract ID# from a search screen, the saved...

I received some help about how to populate form fields from an Access table and then save data to another table. Thanks. Using those tips I have been able to include several form fields in my "save" process, but have come to a "date" field which will not behave the same way as the other text...

I have a VB6 cbo that I want to fill with data from a field in an Access DB. I get the connection and the first field displays in the box, but I want the whole column to show up as the drop-down items so that one can be selected, then when saved, populate and/or update another Access table. Can...