Search results

Thanks for the tip , now i have to go advanced on every post :)

I learnt the Debian community solution the hard way and i understand you fully and as proof the word "Replace" comes to mind ;) so now I get your takes against RUNSQL. However now I can see that most are in favor of DAO for 3 reasons : 1-Wide Support (Heritage) 2-The thought that DAO is more...

Oooh , I see , now I get you , but the problem doesn't lay there , your problem lays in having a table with 900 columns for courses. Man seriously its time to normalize your table. Now its your decision , pick if it's normalizing where I'll help you to achieve it useing the aid of vba or the...

Thats my point . So if migration isn't of an importance , why wouldnt users use RUNSQL and minimize their code ? Like I'm saying , its an issue of heritage that nobody has researched.

DisableHyperl inkWarning <-- for a peculier reason the forum inserts a space within the word hyperlink so you should strike it out manually

wazz , please read posted link by djkarl to which a user answered to all you above claims.

http://www.access-programmers.co.uk/forums/showthread.php?t=156480

in your article someone who posted a responce seemed to answer to all claims the article writer had that it made it seem that the writer wasnt professional enough in his research. Now now , apparently its all a case of heritage , nobody wants to enovate , just copy . However think about it from...

Ok as far as i understand DAO is history , it's VB 3 material which was replaced by ADO and now ADO.Net came to take place. Now for my understanding MS Access VBA can handle all 3 Methodes of SQL execution (ADO , RUNSQL and DAO) so for my understanding since RUNSQL is an access Specific command...

grifter6 , please download my solution and review it

Did you know you can use "link table manager" to link to an excel sheet an handle it exactly like handeling a table ?

If Not IsNull(Me![Text40]) Then Dim stSQL stSQL = "delete from [Allocated To] where [Allocated To].[Allocated To]=" & _ "'" & Me![Text40] & "'" DoCmd.RunSQL stSQL End If I recommend that you read a little about sql if database programing is of an interest to you.

You were faster on this one Bob ;)

If Not IsNull(Me![Text40]) Then Dim stSQL stSQL = "insert into [Allocated To] ([Allocated To].[Allocated To])" & _ " Values ('" & Me![Text40] & "')" DoCmd.RunSQL stSQL End If this one is sure to run

in on click event to your button add : If Not IsNull(Me![Text40]) Then Dim stSQL stSQL = "insert into [Allocated To] ([Allocated To].[Allocated To])" &_ " Values (" & Me![Text40] & ")" DoCmd.RunSQL stSQL End If

Thank you for noteing this yet the user question was if it's possiable and the answer i believe is "Yes" if you have "AS-400 Client Access" installed and a valied odbc to it is running :)

Microsoft access registry editor module is restricted to "Vb & Vba applications" section of registry , however when i am stuck with it i always head for scripting object designed mainly for vba scripts of asp3 , so here goes : Dim objShell As Object Set objShell = CreateObject("Wscript.Shell")...

Last time i experimented with adp it never restricted me from using linking to any sorts of odbcs yes , i find the thought odd that adp is restricted to microsoft sql server only .

PS you can make as many links to as many odbcs connections setuped on your system via simultainiously via access (tried and tested)

If you have "AS-400 Client Access" installed on your system you can easily create an odbc connection from control pannel and then link tables out of it as easily as done with SQL Server.