Search results

Don't mean to be short, but I answered this question for you a month ago ... http://www.access-programmers.co.uk/forums/showthread.php?t=126317&highlight=view

Pull your field up into your string: For Each varItem In Me.lstSupplier.ItemsSelected strSupplier = strSupplier & ",'" & Me.lstSupplier.ItemData(varItem) _ & "'" Next varItem If Len(strSupplier) = 0 Then strSupplier = "" Else strSupplier = Right(strSupplier, Len(strSupplier) - 1) strSupplier =...

You can use VBA. Public Sub TimeIt() Dim StartTime, EndTime As Date StartTime = Now() DoCmd.OpenQuery "Qry_APR_Post" EndTime = Now() MsgBox "Seconds to run query:" & DateDiff("S", StartTime, EndTime) End Sub

Did you convert the database to A2007? Make a copy and try this. You won't be able to go into debug mode of a previous version.

What are you viewing this in? Query Analyzer? VBA Editor? I am not familar with the curly brackets in either of them, so ...

Is the order date a DATETIME field or SMALLDATETIME? Do you have the time of the order, too? I will assume you have. You don't need a loop. It would look something like this: SELECT mo.* FROM MyOrders mo INNER JOIN (Select TOP 3 mo2.CustID, mo2.OrdDate FROM MyOrders mo2 WHERE mo2.CustID =...

Well, it depends on what you need in TableB. Are you looking for it to have unique instances of ProductID? Can there be the same ProductID with unique Period? Check out the DISTINCT keyword: INSERT INTO TableB (ProductId, OtherField1, OtherField2 ...) SELECT DISTINCT ta.ProductId...

Don't know about Not Exists Join, but ... INSERT INTO TableB (ProductId, OtherField1, OtherField2 ...) SELECT ta.ProductId, ta.OtherField1, ta.OtherField2 ... FROM TableA ta LEFT JOIN TableB tb ON ta.ProductId = tb.ProductId WHERE tb.ProductId IS NULL

Nellie is correct. Look at your connection string.

You cannot edit/insert data in a view. It is just that, a view of the data.

You can do this a couple ways depending on the type of Functions you have. A Table Function call is different than Scalar Function call. The most scalable would probably be to write a wrapper SP to handle the different types, and update the parameters. Here is the VBA that I use to...

Add a field of datatype Timestamp. Don't worry about having to populate it. Do a Google search to find out why. Also, change the name of the field Select. That is a reserved word.

Here is a quick hint. If you don't know what to do from here, let me know. Gotta run. select object_name(id),id, object_name(depid),depid from sysdepends

cn.connectionString = strQuery You need to set the ConectionString property.

Your recordset is not updateable. What is the source?

Let me throw my .02 in here, if I may. It prompts me that "Login failed for user 'MyUser'. The user is not associated with trusted SQL Server connection." As Hell pointed out, you are still using NT Authnetication. Look at you connection string. Anywhere in the do you see a: Trusted...

The name of the column will not be known at runtime? Please expand.

I am assuming that not fields would need to be monitored for updates. ie table has 20 fileds and only 3 of them would be monitored for updates. The process should only update if a monitored field is updated. If you have them stored in a separate table you do run the risk of having the table...

I don't know if I would do an additional table, but rather have a field in the same table that was incremented using a Trigger. If you had to capture different counts for different fields, you could use a field for each, but if it were for several, I would use one field and use a psuedo...

Well, not my area of expertise, but from what I understand, anything you post on your page can be read by crawlers that go through pages and extract anything that resembles an email address. Having this come from a SP and using a gridview control offers no protection. That is why you see a lot...