Search results

kawi6rr, This works for me in Windows 7: strConnection = "Driver={Oracle In InstantClientx32};" & _ "DBQ=ORCL;" & _ "Database=EWDS_2012;" & _ "Uid=xxxx;Pwd=xxxx;" Wayne

David, Thanks for letting me know. There seems to be a lot of that lately. Wayne

n90, Your two middle clauses have the order reversed. You have Between "newest" and "oldest". Wayne

Jon, When Access names/numbers your objects for you it generally gives you something like Text0, Text1, Command0, Command1. There is no problem with changing the name after it has assigned it. The one thing to look for is, if it generates code, you will find some code like: Private Sub...

Dick, What would help here is to have a table of States. tblStates ========= id autonumber Abbreviation Text(2) FullName Text(50) Then you can join your qryFindState to tblStates using the two-character abbreviation and you will have the full name available. Then you won't need If or Case...

John, I don't see your original query. There is nothing in the posted code that would restrict results to the current year. "whereClause" is referenced, but we don't get to see what it is. It would be the Where clause that restricts data. We also don't get to see firstop and secondop. Can...

You can use DSum in queries. NewColumn: DSum(...) But it is probably quicker and easier to join to the table that has your info. Wayne

John, It would really help if you showed the dateClause code and your query. Wayne

h, The data in an Access table is NEVER guaranteed to be in any order. When you view the data on a form, report or query just sort the data by the date field or whatever. Don't waste your time trying to "store it" in any order. Wayne

How about: SourceSubFrmParts = Replace(SourceSubFrmParts , "subfrm", "qry") Wayne

Alexander, I don't know if you have your final answer here: http://www.dbforums.com/microsoft-access/1699189-how-do-i-write-code-type-any-combination-letters-serve-me-letter.html But it might save someone some unneeded work here if Sinndho's work completed your task. Wayne

Michael, I've never experienced that, but the following link (Post #9) shows an API call to flush the keyboard buffer. http://www.mrexcel.com/forum/excel-questions/254206-flushing-keyboard-buffer.html hth, Wayne

Michael, You can make a view: Create view dbo.GetAveragePrice AS Select Avg([Number] * [UnitPrice]) As AveragePrice From tblMovementsdetails Group By ArtID Then you can always join to the view to get the current AveragePrice. Select a.ArtID, b.AveragePrice From tblArticles as a Inner...

Bart, After you've BACKED up your data, then just put the part starting with the Mid statement into the "Update To" part of an update query for the [Inspector] field. Wayne

BartK, This looks weird but should do it: It extracts all characters prior to the 2nd space. I append two spaces to Inspector to account for value of something like "JOE". Select Mid([Inspector] & " ", 1, InStr(InStr(1, [Inspector] & " ", " "), [Inspector] & " ") - 1) From YourTable Wayne

LAgnor, You could also --> Select Top 10 Percent ... Wayne

Sue, Sorry, been away for a while. This should be a simple process. Make a Query ("YourUniversalQuery") that does whatever its supposed to do AND use a where clause for any one of your Forms. Then on EACH of your forms, put the following command button and code substituting the name of each...

Neil, Try referencing --> "Drop Table [" & rs("Agency") & "_" & rs("Customer") & "]" You are overwriting the Agency table for each customer. Use the above for the "Into" and "From" clauses also. I don't know why you need to create the tables, a query will do. Wayne

Mihail, Sorry, I forgot a part: Query1: Select ID_Product, PriceDate From tblProductsPrices Where PriceDate < Forms!SomeForm!TheDate Query2: Select ID_Product, Max(PriceDate) As TheDate From Query1 Group By ID_Product Finally: Select A.ID_Product, B.TheDate, C.Price From tblProducts...

If you do not specify a Sort Order in your query, Access will try to "help" you and will generally behave as you mentioned. I would never depend on that though. If you do specify something in your ORDER BY clause, Access will enforce it. If it doesn't appear to be doing what you want its...