Search results

You have a Null "DateSubmitted", as Bob had suspected, for a record in Innovative. Also, of you remove the format of "Short Date" at the Table design level for DateSubmitted, you will see that your DateSubmitted does indeed have times associated with the record (as I suggested in an earlier post...

... Also, understand that parameters that are not specifically given a datatype, will be first interpretted as Text. Most often, Access knows how to coerce the text into a the data type that the user wants, however, Access is not always successfull. So ... along with Bob's example of using...

>> it is a date/time field , but i have no times associated withthis field << Times are ALWAYS associated with a Date/Time field. The value of a date/time field is stored as an 8 byte floating point number (ie: a Number/Double). The whole number portion is the number of days away from the...

Yes ... I know this is an old thread, but a discussion over at UtterAccess between Banana and myself had prompted a re-visit to this thread. In short, if you don't want to read it all, its seems that Banana and I were able to conclude (in separate tests) that Access's Yes/No datatype (Jet/ACE...

Hey ... that code looks familiar! .. :) .. ---- I used your db in A2010. The db size stayed right at 13mg after about 20 opens and closes ... with the FlexGrid and me selecting different nodes on the Tv. ---- Also ... with respect to the side bar discussion about the difference between...

Does the debugger take to you a specific line of code? What version of Access are you using? --- The error text you have indicated seems to point to an issue with ADO. It may be worth going into VBA and checking the references in order to ensure that the MS ActiveX Data Objects library is...

>> Do you know the reason why it worked on some computers but not on others? << The comparison method that VBA uses is often indicated at the top of the Module with a statement that looks like this: Option Compare Database What that means is that text comparisons are based on the locale...

I am unsure of the specific code contained in the Sum() function that the Jet/ACE database engine calls upon. It is likely that no one really does, outside of MS. So, to help us assume the process that Sum() uses, I derived a test using a local table with 668391 records in it, and a small code...

post to "bump", so the change to my previous post is noted by the OP.

I know I am late to the party, but I will add some info that does not negate any of the fine advice received by Bob and vbaInet. A SubForm control DOES NOT have its SourceObject property set to a Form object. You can set the property to a Table or Query object as well. When that is done, MS...

>> and the other is frozen << And what does that mean exactly ... >> What do i need to do to get both working? << You are really not giving us much to work on to guide you effectivly as you develop this assignment. --- Also, your title indicates vb2008 (makeing me think VB.net and the...

>> #1 - my pass through query is referring referring to a table per below but it is giving me an ODBC error. << Your Passthrough Query has no clue as to what Access Objects are, so you can not refer to them within your PT queries SQL statement. If you PT query records records, you CAN use the...

Well, a pivot chart is an form of an aggregate query, so if you know your values will be repeating and you just want that value, you may be able to use the First() aggregate function.

What type of files are you working with? If you are working with Excel, Word, PDF's and such, you can use the VBA methods: FileCopy() Kill() And if you try to manipulate a file opened by Word, Excel, Adobe, etc. you will get a trappable run-time error (I beleive it has an error number of 70).

Any reason why you want to use the FileSystemObject library? Public Sub LoopFiles() Dim strPath As String Dim strFilename As String strPath = "C:\Windows\*.dll" strFilename = Dir(strPath) Do Until strFilename = "" Debug.Print strFilename...

>> it won't open due to 'syntax errors' (where it keeps changing ( to [ for the nested stuff) << If the Query objects SQL does not change, you can write the SQL Statement with the nested stuff in parenthesis ... So this (statement A): SELECT * FROM [SELECT * FROM someTable]. AS vTable...

>> Last edited by boblarson; Today at 09:46 AM.. Reason: disable smilies << LOL! .. I put it in code tags at the same time to attempt to fix! ... thanks Bob! PS> Hello! ... and good to 'see' ya!

You do not have a delimiter to separate your JET OLEDB:Password argument. To help me not forget that little gem of a character, I will often lead a new line with each argument: cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0" & _ ";Data Source=" & App.Path & "\users.accdb" & _ ";Jet...

Yes ... First ... create a query of contiguous dates. There are a couple of ways to do this. One method can be found by clicking here. Or from a more generic mindset of always needing a series of contiguous values for something, I will often create a single table in my db's called...

First in foremost, you do realize that you are trying to build the same relationship twice in your "CreateRelationships" code right? -------- Assuming you did realize that, the second thing I see is will be just reinforcing what Dave (the one with the husky dog named Gemma :) ) said --- you...