Search results for query: *

Hmmm, Are we forgetting ActiveX? You have at your disposal right now, access to a ton of wonderful controls. Most are standard issue with Windows, and if you're a developer you should be using a developer’s edition which ships with even more (and samples). Besides being ultra efficient, these...

So close to the North Pole... LOL This winter's been a piece of cake (and now watch me eat my words!)... Ok, try this: reverse your display conditions: Instead of painting out the zeros, have CF paint them in? Would that work for you? ;-) Gord gord@ghubbell.com

Hello Gus! First off congratulations on your birthdate and your 50th anniversary! Two wonderful occasions - and with my best wishes! Using 2000, you have the wonderful feature 'conditional formatting', which when used on a continuous form would allow you to say, turn a checkbox on or off...

Geeze...I'm sorry but I have to meddle here and say a few words regarding your question and some of the replies: Access 2000 is as different from 97 as good is to bad. 97 being the bad. I've seen more corrupt 97 databases than 2000's and the corruption occured 'from within'. Using 2000 you are...

Good morning and thank you beamerman. Actually thank Microsoft for including probably one of the most indispensable little functions you're ever going to use! ;-) Gord gord@ghubbell.com

Hi Beamerman, This is from the Northwinds sample Db that ships with Access. It lives in a standard module: Function IsLoaded(ByVal strFormName As String) As Boolean ' Returns True if the specified form is open in Form view or Datasheet view. Const conObjStateClosed = 0 Const...

You're much better off to write in your own code within, to do this task: Guessing this is an app that requires your linked tables or entire linked Db and therefore I'd advise against allowing the user to have the choice to 'pick and choose' the tables. Either way, you can build in your own code...

Hi Gus ! ;-) As above, if the field is not allowed to grow, theres no reason you couldn't draw a rounded cornered rectangle in some other image program, then place this image 'behind' your field and have your field borders white or transparent. If the section has to grow, you'll have to do it...

Thank you Adrian, and of course you're welcome! It's great to hear it's been successful and it's also great to have it all here for everyone to use and enjoy. That's what makes it all worthwhile! Till later, ;-) Gord gord@ghubbell.com

XP developer contains everything you would get with 2000 and much more: Visit Microsoft's site to get all the specs, but it is now bar none, the one to have if you are really 'working' Access, or if you are going to be doing anything web-related. When run within Windows XP it's an incredible...

Hi Doug, I've found a handful of little bugs or glitches in Access 10 that will probably be ironed out within a couple of months or so...Try CTRL+X to cut, CTRL+C to copy and CTRL+V to paste. These 'old fashioned' methods seem to work much more consistently than the toolbars...(Teething problems...

Hi evalesthy, In F1 VB Help (search for CreateField Method) then 'see also' and you should find this: ALTER TABLE Statement Modifies the design of a table after it has been created with the CREATE TABLE statement. Note The Microsoft Jet database engine does not support the use of ALTER TABLE...

Hi foundryqa, Here's a couple of options seeing as it's possible you're pulling in data from a flat table with no unique record id: Rather than linking, you might consider to import the table and using either a saved import specification which would add a unique ID, or a group of queries and...

Hi again Charley, I have developed similar before, and although the queries after the fact are a little more difficult, your whole system will work well if you do choose to seperate each sub-section level in to their own tables. Just like the typical 'tree view' we are all used to seeing within...

Hi Charley, You will actually need a third table. Here's the whole scheme: Contractor Table ContractorID (unique- no dups) 1 Contractor Name & other fields Section Table SectionID (unique- no dups) 1 Section Description & what ever other fields you might need. ContractorSection Table...

Adrian, Please make me another little zip copy of exactly where you stand at this moment. Please leave me one or two records to test with. We'll beat this devil! Gord gord@ghubbell.com

Good Morning Adrian! That's pretty odd as the code above was copy/pasted out of a compiled and tested db...here: I've removed the Access created brackets and tested again here with Access 2000. Works fine: Db.Execute "UPDATE [Daily Metrics] SET [Daily Metrics].DocumentsCurrentlyAssignedto...

Helllllloooo Adrian! Please excuse my absence as I really messed up my computer today at work. XP...why's it gotta be XP?!! This works: Private Sub CmdUpdate_Click() On Error GoTo Err1 Dim SQL As String, Rs As Recordset, Db As Database If IsNull(Me.Assignedto) Or Me.Assignedto =...

Hi Adrian, Well, keep trying the choices till you find one that agrees with your datatypes... Let's run it like this: Do Until Rs.EOF 'loop the temp tables entries. SQL = "UPDATE [Daily Metrics] SET [Daily Metrics].[DocumentsCurrentlyAssignedto] = " & Me.Assignedto &...

Good morning Adrian! Here's a couple to try: One line ok?! There's so many quotes and such that it will be easier to understand if it's spread out flat. BTW you can change your VB format to something like Arial size 8 or 9 using Tools-Options-Editor Format and on a 1024/768 screen you'll have...