Search results

  1. G

    PHP Library visibility

    I'm having difficulty with a PHP library which I have used successfully (flawlessly?) on my development Windoze machine. When I ftp the library to my GoDaddy linux server, I get a series of errors that look like a configuration problem. GoDaddy support said to "use php5.ini", which I did after...
  2. G

    Unique Index

    I've run into an oddity using a unique index. First let me review the rule. Let's assume a simple thing like a person's name: ID - Surrogate Autonumber key FName - Text MName - Text LName - Text Just for argument's sake (not because I believe it), you should not be able to store information...
  3. G

    Assigning queries to forms as recordsets on the fly

    Sorry I haven't posted in so long and am showing my laziness by asking this instead of figuring it out myself. I would like for my users to be able to write a query and then assign the query as the recordsource for a form. This will allow the advanced user to re-use already designed...
  4. G

    Automating search for Word mail merge data sources

    We are updating our SQL Server this Wednesday night and a last minute issue has cropped up to threaten our implementation. We are changing all of our Access front ends to use DSN-less connections and won't be updating the DSNs on the client machines. We did a pretty thorough check of all the...
  5. G

    Cannot access AWF

    MSAccessRookie tells me that he has not been able to access AWF since last week from his work. Here is one of the PMs I received from Rookie on my FB: BTW, the thing I recommended he do is to put AWF in his hosts file. This might explain why the traffic on AWF seems to be lower than before.
  6. G

    Downsize to Access

    I am working on revamping a SQL Server database with an Access 2002 front end. I'd like to set up the environment on my computer at home but I really don't want to mess around with SQL Server variants on my computer (I am using Vista). Is there a quick and easy way to downsize a SQL Server...
  7. G

    Chinese product quality

    Am I the only one who wonders why we continue to purchase products made in China? http://www.foxnews.com/story/0,2933,429466,00.html I particularly like the reason for the melamine in the milk: "to deceive quality tests for protein". How clever of them! And how stupid of the consumers in...
  8. G

    I like Ike (or not)

    Looks like everybody in Houston is closing up shop for hurricane Ike. I've got to leave work at 1 (it's 11:30 now). Fortunately, they're leaving the servers and my pc on until Friday afternoon so I can get some work done from home. I just talked to ShaneMan and he took his wife and daughter...
  9. G

    How to determine maximum record length

    I'm using MS SQL Server 2000. The previous developer thought nothing of creating humongous tables with no thought of normalization and I've inherited that. To make matters worse, my user base has learned to create their own updatable queries in Access and they don't want to lose that ability...
  10. G

    Mike & George's normalization exercise

    Yes, it is what I do. However, to SOLVE your issue (somewhat different than normalizing a design), you'll need to elaborate on: Why not? If you can make me understand that, I can propose a solution that is both normalized and works. Start a new thread (or re-open your old one) and PM me...
  11. G

    ShaneMan's daughter

    ShaneMan is one of our long time members. His daughter has had cancer for over a year. She has recently had a problem with moving her legs and they found a tumor on her spinal cord and in one of her lungs. They just finished removing the tumor from the spinal cord about an hour ago. They...
  12. G

    Tip Interactive Command Reference

    It drives me crazy going from an environment I know (<= Access 2003) to an environment I don't know (Access 2007). Same problem with Excel. I ran across an excellent tool at the Microsoft Office site that interactively shows you how to do tasks in 2007 that you knew how to do in 2003. For...
  13. G

    Interactive Command Reference - For 2007

    It drives me crazy going from an environment I know (<= Access 2003) to an environment I don't know (Access 2007). Same problem with Excel. I ran across an excellent tool at the Microsoft Office site that interactively shows you how to do tasks in 2007 that you knew how to do in 2003. For...
  14. G

    Pretty little sub-forms

    I don't have a very good "eye" for GUI design. But when I saw Pat's quote (above) in another thread, I thought of a couple of places I could use this to solve an unusual problem and make my user's experience better. So I tried it out. I have been unable to make a small subform "blend in"...
  15. G

    Why are Americans so stupid?

    Thanks to Barry for suggesting this. I'll start: Americans are so stupid because we're being kept down by the "man". We is sew stoopid cuz wir frum the bahbull belt. Come on, some of you guys are much better at this than me...you know who you are.
  16. G

    ADO filter problem with spaces

    I am trying to filter an ADO recordset and I keep getting an error when I use a filter criteria with a space (" ") in it. The indicated line below errors out with: The immediate window shows: Before the failure, the filter had successfully been set to everything before the space (i.e. "w"...
  17. G

    Banana & Sudo

    From this forum's user Banana's siggy: sudo make. sudo make install. sudo make me a sandwich. I spent a couple hours reading all the cartoons at this site and literally banged my head against my monitor several times 'cause I was laughing so hard. If you love geek humor, you gotta check it...
  18. G

    Using VBA to split a database

    I'm pretty sure someone on this forum said this can't be done. I want to split a database into FE/BE using Visual Basic code, even if it can't be done. I'm convinced that, since I want it so bad, it should be doable. So I researched and found: DoCmd.RunCommand (acCmdDatabaseSplitter)...
  19. G

    Vista rant

    I just bought a new PC with Vista installed. Against my better judgement, I didn't immediately format it and install XP. I started installing stuff. My wireless NIC card doesn't work with Vista. Not too big a deal 'cept it took me 2 hours to figure out. Windows/Vista certainly didn't help...
  20. G

    Wrap text, multiple columns, and misc reporting issues

    This is my first post to these forums, please be gentle with me. Also, I know very little about Access reporting, having avoided the topic for all these years. My company wants to mail a listing of work sites, by state (i.e. geographic region), to all of our living clients. This is important...
Top Bottom