General
in [Access]
|
SELECT @@IDENTITY in A2010 with Triggers Over on StackOverflow someone was asking about how to get the last Autonumber value, and I suggested SELECT @@IDENTITY in the same connection as the insert is made, and said "just like SQL Server." Someone responded that in SQL Server you should use the SCOPE_IDENTITY() function instead, so I looked it up: h... 21 Apr 2010 14:40
Option Button Question Hello, I am designing a simple form to acquire a data. I have following table for which I am designing a form. Table Name: tblSecurities Market: Text Security: Text SecurityDescription: Text The market column can have values CAN or US only and I would like to have option buttons for this column. The p... 10 Apr 2010 17:55
Adding Data to a lookup column in a form I have a lookup column I am using in form pulling data from table. When I add data into the lookup column it only appears in the table I am using in the form. I also want it to be added to the table that the lookup column is pulling the data from. How do I get it to be add to the lookup table in addition to ... 11 Apr 2010 15:42
Help in all matters of life Astinishing Results! Call Now 1-900-990-7189 --- frmsrcurl: http://msgroups.net/microsoft.public.access ... 12 Apr 2010 00:31
How can I merge all my emails in outlook How can I merge all my emails in outlook ... 14 Apr 2010 17:49
extract part of email after @ How to parse email and extract part that after @ sign? ... 12 Apr 2010 15:55
Number Format in Chart Datasheet I have used a query as the row source for a chart. The query generates a number with multiple decimal places. When I edit the chart I can format the number in the data sheet but when I save the chart and view it the number format is lost. I can format the number in the query using a formatnumber expressio... 10 Apr 2010 00:30 |