Search results

Hey Mile-O-Phile - thanks for answering, that was fast! The fields are very rarely over the 255 mark, and it doesn't matter if the query takes a long time or not. My problem is that I can't seem to write that function - it's like I totally forgot SQL on the weekend! Basicly, I'd like my...

Hello all, I simply need to know how many sentences there are in this particular memo field (many records) - it would be safe to say that whenever there is a period "." that that is the end of the sentence - so I would just like to count all the periods but I'm having trouble (too early I...

Hey Brian - I have seen the "dbname_July31_2003.mdb" thing many times so I can sympathize! :) The line of code I posted earlier does allow you to rename the db! **start code** Dim db As Database 'you might not need this line Dim strOldDB As String Dim strRenamedDB As String Dim strPath As...

Hey Brian, Not sure if this works in 97 or not, but it does for 2000 and XP. DBEngine.CompactDatabase (use this in VBA) or you can -> Tools - Options - General (tab) - select "Compact on Close". It really depends on what you're trying to accomplish. Let us know because there may still be...

Hello - don't know if you all are still checking this thread, but I just saw it now. About licensing - I agree with Pat that developers should get their money and that if nobody pirated that prices would (in theory - but I doubt it) go down, but I've always felt that software prices punish...

Hey Prashant - you can do all of that! Help will help you figure out the attribute names. 'test for age 22 Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If txtage.Text = 22 Then txtfname.FontBold = True txtlname.FontBold = True txtage.FontBold = True Else...

D-OH!!!! Thanks for answering everyone! - Looking for ldb instead of idb did it! I won't forget this one any time soon! Cheers, -Sean

Hey jfgambit, thanks for replying - it didn't work though! Does it work for you? -Sean

Hello forum, I wrote a little procedure that works only when the target db is closed - so, I would like to make sure that it's not in use before I run it. For some reason though (and I would be interested in the explanation if someone knows why), this won't work - even though it seems to for...

Hey Rattlesnake, Here was my first thought - you can write a "make table" query (in the db that has the data you need) to create a table in another database. Next, use the code like this (in the other db) to open the target db and run the make table query. Private Sub GetTable() Dim dbs As...

quick thought before I have to go... Try: id.Value = Int(GoodStr) or id.Text = GoodStr (could be data type conflict) -Sean

Also - you can use the lost_focus instead of using the button which would be after all other info is inputted (that's probably what you want). So instead of: "Private Sub cmdReturn_Click() " put: "Private Sub txtBarCode_LostFocus()" and remove the .setfocus line. I'll email a demo to you to...

Ok here is some sample code, mostly provided by the MS knowledge base - http://support.microsoft.com/default.aspx?scid=kb;EN-US;q138774 (thanks to Jack Cowley for pointing it out in another post) cmdReturn is the button you press to process the entry, and txtBarCode is the text field where...

That is a good trick - thanks! -Sean

Good one Harry! The reason why I suggested a new database with linked tables was because I couldn't think of another way to make sure that the code would run when the batch opened it. Cheers! -Sean

Thanks guys - some interesting feedback to think about! I've been playing with the trial version of SQL Server over the past couple of days (re-creating micro versions of what you both described) to try to get a better understanding for all this (I chose SQL Server and Access because I figured...

Hey Wayne, sounds like you know about this! When it says "performs migrations", I thought that it meant either exporting the tables or just updating an Oracle db from an Access one. Wouldn't that be the case if the Oracle db was already set up and working properly (with triggers set...

Hello everyone, I was reading some job postings (trying to figure out what skills I should get) and a couple of the terms used are throwing me off. For example: "performing migrations from Access 97 to an Oracle platform" Is "migration" just another way to say "exporting tables"? I have...

Thank you Tim - worked beautifully! Much appreciated! -Sean

Hello forum, I need to be able to delete a table. It's the result of a make table query which I use for reports - but could never be uploaded on our website (presently, I open the database, delete the table and then upload it). I was thinking that I could link the table in question from...