Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ghubbell

    GUI creator for Access

    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...
  2. ghubbell

    Show a paper clip icon when a control is not null?

    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
  3. ghubbell

    Show a paper clip icon when a control is not null?

    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...
  4. ghubbell

    Access 2000 as multiuser back-end DB

    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...
  5. ghubbell

    How to check if a form exists in VBA code

    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
  6. ghubbell

    How to check if a form exists in VBA code

    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...
  7. ghubbell

    How do U include Linked Table Manager in Runtime app.

    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...
  8. ghubbell

    Rounded corners for rectangles on a form?

    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...
  9. ghubbell

    How do I update multiple fields simultaneously?

    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
  10. ghubbell

    Developers 2000 or XP?

    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...
  11. ghubbell

    Access 2002

    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...
  12. ghubbell

    Modify table structure using code

    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...
  13. ghubbell

    Is it possible to add an autonumber field to a linked 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...
  14. ghubbell

    Table structure help

    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...
  15. ghubbell

    Establish a relationship

    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...
  16. ghubbell

    How do I update multiple fields simultaneously?

    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
  17. ghubbell

    How do I update multiple fields simultaneously?

    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...
  18. ghubbell

    How do I update multiple fields simultaneously?

    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 =...
  19. ghubbell

    How do I update multiple fields simultaneously?

    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 &...
  20. ghubbell

    How do I update multiple fields simultaneously?

    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...

Part and Inventory Search

Back
Top