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

Is the error possibly came from the version? I use window 2000 as operating system and access 97.

I tried to temporary ignore the error message and continue on checking if the spell checking code suggeted to me by Braindead2 is working. It is working and I like to thank you for the help despite the error message. This code is working and checking all the texts inside all texboxes on my...

Thank you for your brief respond, since I'm new with VBA I would assume that you wanted me to do the following instead? Private Sub SpellCheck_Click() docmd.runcommand accmdspelling End Sub I did not work, I got an error saying: Application-defined or Object-defined error 9536 When I clicked...

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 like to thank Psychpt and Rick Sprague for helping me explain the syntax. I appreciate it very much! Alec