Search results

Assuming [GI1] is in a table called 'tblData'. UPDATE tblData SET tblData.GI1 = "A " & Right([GI1],Len([GI1])-2) WHERE ((CDate(Right([GI1],Len([GI1])-2))<Date()) AND (Left([GI1],2))="B ");This will update any row that starts with "B ", anot not "B". Just in case you had any other text starting...

Creating a querydef (i.e. stored query) with VBA Code using DAO

It sounds like you trying to use the (Previous Record) row in (Current Record) row, correct? If so, you may want to take a look at this, Previous Date & Sum of Month/Year to-date using a correlated subquery.

Here's a link to an article on VBA Error Handling and Logging, which also has some links at the end of it.

Try something like CDate([lngWholeNumber]/60/24). Be carefull though, the result will include a time AND date.

You will have to call the query using VBA code. DoCmd.SetWarnings False DoCmd.OpenQuery "qryUpdateQuery" DoCmd.SetWarnings True Alternatively, Application.SetOption "Confirm Action Queries", False DoCmd.OpenQuery "qryUpdateQuery" Application.SetOption "Confirm Action...

You need to put it in a module, so that it becomes a function you can call from a query. e.g. SELECT PK, strString, RndSQL(PK) as RandomNumber FROM tblData; Be sure that whatever you pass to the function is unique, whether it is a primary key of a concatenation of fields.

One of the first things I was told when I moved to Oklahoma was this :)

File Name, File Path, And Microsoft Access Version Number Of Current Database File And Microsoft Access Application Hope that helps! :)

When you use Rnd() in a query, it is optimized to only call the function only as many times as is needed. So used by itself, Rnd() only gets called once. If you were to multiple a numeric field by Rnd(), it would only get called once for each unique number. That is to say, for each query...

Thanks for the tip! I check their RSS feed on my website often but never realized they had a forum. :o In looking around on Amazon.com, a lot of the docking stations with speakers seem to habe unfavorable comments or are just very limited in functionality. May just be better to plug it into...

Thank you all for your replies so far! Very interesting!

File Name, File Path, And Microsoft Access Version Number Of Current Database File And Microsoft Access Application Hope that helps! :)

Can anyone recommend a good iPod docking station with speakers thats under US$100? A little over $100 is OK but I'd rather stay under $100.

Vassago, Not an answer to your question but I thought it might be interesting. Microsoft Game Studio Express (Beta 2)

Maybe this will help? Concatenating unique field values for records matching a query's GROUP BY clause

You might try http://www.rentacoder.com/ to see if you can find anything.

Jet drivers do not support bitwise operators

I am curious to know if anyone here is a full-time Microsoft Access developer? I've seen a few postings on dice.com for such people where the only requirement was knowledge and expreience with MS Access. More often than not the requried skills extend beyond just MS Access: - UML - SQL...

Happy Birthday, fellow Tulsan! :)