Search results for query: *

I have 4 tables, each has the exact same PK and FK If I do join to all of these tables I will get one huge table. Now that I need to delete some records (from my CF application), for example from table 1, consequently I also need to delete from 3 others table otherwise I wil create some ghost...

I need to create simple application using Visual basic 6.0 and I have a problem with the syntax as far as how to use exec method and where to place it. I appreciate any help! thanks First I set up: Microsoft Common Controll 6.0 Microsoft Tabbed Dialog Control Microsoft ADO Data Controls...

Hi everyone, I posted my help here, got few responds but still haven't found any solution so I decided to repeat it again. I'm working with an existing application created with Access and a back end SQL server. originally the application was working fine with an integer value for this...

I successfully created an update functionality to my form using Access'97 and VBA. But once I clicked on the "Save" button, I got the following message: "The Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at...

I have a form created with Access'97 and VBA. It's been in production since 3 yrs ago. Currently I need to do a little enhancement that is: In one of the textbox for credit course, the datatype that is used to be set for an integer in SQL is now need to be changed to float since user want to be...

I have a form created with Access'97 and VBA. It's been in production since 3 yrs ago. Currently I need to do a little enhancement that is: In one of the textbox for credit course, the datatype that is used to be set for an integer in SQL is now need to be changed to float since user want to be...

I have a column called "Credits" on my table ( on my SQL Server), the data type is set to TinyInteger. So far user has been using this table to enter and edit data. For 3 years user has been entering number of integer type using the front end that is created using Access form. Now I...

I posted this question last week, got several help tips but did not help, I still appreciate all of you who have tried to help me. I thought I found the answer but still don't know how to fix so I need help again from you. I have a form with several textboxes. I need to create spell checking...

Hello All! I am new to VBA, have only few months of experiance coding with this VB 6.0, need help, thanks! I have a form created using Access'97. It's working well for years. Now user wanted to have a spell checking button add to the form. This form is a simple form consisting of several...

I'm new o VBA, I used to program with coldfusion, I need someone nice to help me out with syntax so I can continue make sense of the codes in front of me, thanks! 1. If IsNull(Me!txtBudgetID) Then MsgBox "You must enter a BudgetID!", vbExclamation, "Missing...