Recent content by alec

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 see, Thanks for the information. I'm new at VB and I have a lot to learn, thank yo again - Alec

Hi oneshadow , I really appreciate you taking the time to help me. I will try your suggestion and Let you know. The thing with this project, if I used adodc connection, setting the properties from the property's window instead of doing it with the code like I'm doing it now, I get the result...

Hi oneshadow! I tried your suggestion and it is still the same. I did not get the list I wanted to appear on the DbCombo. The only thing I need is to get the list of group from SQL system procedure sp_helpGroup and show it on the drop down list of DataCombo control. If I use the same code but...

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

Hi Larry, The field I'm working on is originally set as integer in SQL server.I only have 2 choices as far as changing the datatype so that it will take decimal entry and they're either float or decimal datatype. Unless there are others that I'm not familiar with. Once I changed to either float...

Hi neufarth, I can't change the field size for the fixed format field. The red note next to it says: "This property can not be modified in linked tables" I can only change the format, decimal places,input mask and caption properties. currently the field size for the fixed format field...

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

Hi Gord! Thanks for the input. Yes, On my access form for that particular textbox, the Format property is set for "Fixed" and 2 decimal. On my code, I set the variable as double. On my sql when I set the data type as Decimal, it shown as "text" datatype in access. When I...

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

Hi Gord, thanks for the suggestion. It've tried it and did not give me any different result. When there is incorrect word, the spell checking do the job first before error message window pop up. Once the word is corrected and I click OK then the error message show up. But when there is no word...