Search results

Nobody said Apple is any better than Dell in this regard :)

But you don't NEED to go to the Cadillac dealer to buy windshield wipers....

Hi, I THINK the problem is that an update/insert query doesn't return any dataset, so you cannot assign this to your recordset. You could replace this: Set rec_set = cmnd.Execute Set ExecCommand = rec_set With something like this: If Left(dbSQLstring, 6) = "INSERT" Or Left(dbSQLstring...

Then I'd just add another column with the province/state and look it up the same way you would do for the date.

Hi, Here is a suggestion: In your TAX table, add a from and to date. When calculating you invoice total, select the tax rate for which the invoice date is in the interval. This way, it will continue to work for future rate changes Simon B.

GTA would be Greater Toronto Area Simon B.

Hi, I have done this with an Excel document using Open Office. I don't know if it will work for Access but you could give it a try. Simon B.

Hi xarxas, And just what do you mean by really big? I actually did this with 100+mb text file... I doubt any module of macro will be that big... From the MSDN website: A string can contain from 0 to approximately 2 billion (2 ^ 31) Unicode characters. Simon B.

Hi, The way I do it is to open the text file in a string. I then do whatever I need with the string variable and then write it back to the file. Simon B.

Hi, Another possibility would be to create a query like this: (air code) SELECT A.FullName, A.City, (A.DaysAvailable - B.SumDaysUsed) FROM tableA A INNER JOIN (SELECT FullName, Sum(DaysUsed) AS SumDaysUsed FROM tableB GROUP BY FullName) B ON A.FullName = B.FullName ORDER BY A.FullName You...

Hi, The easiest solution would be to import it in your DB, then make the changes (as local object), and export it back to its original place... You'll still have to figure out how to edit a module/macro via VBA... And if you do know I'd be interested in knowing how to do it! Simon B.

Hi, You should not store those kind of data because: 1 - It is easily computed. 2 - Data integrity will go wrong if for some reason tableB gets modified but tableA is not updated. 3 - There are other reasons if you have a look on data normalization. Simon B.

Hi, If your DaysRemaining always start at 15, no need to keep them in a table, just run a query on tableB, something like: SELECT fullName, 15 - (Sum(daysUsed)) AS daysRemaining FROM tableB GROUP BY fullName You should not store data that depends on some other data. Simon B.

Hi, How does the window closes? The user clicks the "X" in the report? If so you can add "Docmd.Quit" to the report Close() event. Simon B.

Hi, I suggest you create a string of your query before assigning it to the SQL property of the querydef. You can then print it out to make sure the syntax is ok (spacing, quotation mark, etc, ...). Ex: strSQL = "SELECT ....." Debug.Print strSQL CurrentDB.QueryDefs(query_name).SQL = strSQL...

Hi, CurrentDB.QueryDefs("your_query_name").SQL = new_sql Forms("form_name").Requery (or Me.Requery if you are in the form) That should do it. Simon B.

Hi, Try this: Private Sub Box1_Click () If Box1.Value = True Then Total.Value = Total.Value + 500 Else Total.Value = Total.Value - 500 End If End Sub

Hi, Is you eventDueDate linked to a field in a table? If so, check what is the field type and if it accepts null values and empty strings. Simon B.

Hi Aman, Tools -> Database Utilities -> Convert Database -> Access 2002 The names are approximates as my version is in French... Access will actually create a copy of your mdb file in the new format. You will then have to use this new file to create the mde. Simon B.

Hi, You'll need to cancel the update by setting Cancel = True. You are emptying your eventDueDate field which is possibly mandatory in your table, the reason for your error. HTH, Simon B.