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!

Register Log in
  • Congratulations derfloh 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. BotCow

    Is there a way to merge columns (Excel question as well)

    Well Willir, I don't really understand your example but I fixed it by manually merging the entries (it was only about 400 entries of copy and paste no big deal) but for future reference, in case I have 10,000 entries, here's what I was asking. Basically this is a document database that some how...
  2. BotCow

    How do you just update a form and not the data?

    Need to transfer my form to another computer, don't want to revert to old data though.
  3. BotCow

    How to make the database customer oriented.

    Okay here's the dilemma. I'm not really making the database for a customer but rather my boss. He's more of an Approach user and likes the slimline, "not a lot of background and toolbars", kind of user. I made him a form that creates document records and generates reports based off...
  4. BotCow

    Is there a way to merge columns (Excel question as well)

    Bump? Can't merge columns physically?
  5. BotCow

    Refresh subform with a click of a button?

    Ahhh very nicely done and explained eupher. Thanks a lot.
  6. BotCow

    Is there a way to merge columns (Excel question as well)

    What about physically merge the three columns into a new one in the table? So instead of having three columns queried to one, put them together into one universal column.
  7. BotCow

    Is there a way to merge columns (Excel question as well)

    Oh hehe I'm sorry, let me clarify. They're text fields but the name of the field is "memo, memo2, and note". So it can be done?
  8. BotCow

    Is there a way to merge columns (Excel question as well)

    I have a note field, a memo field, and a memo2 field that I need to merge together into one column. They're essentially the same thing (just notes). Is there a way to do this in access and/or excel?
  9. BotCow

    Is there a way to code copy and paste?

    One word. Wow. Very nice, I knew it was complicated, so I'm glad you were up to the task. Let me fiddle around with that. Thanks Doug.
  10. BotCow

    Is there a way to code copy and paste?

    I have to create a new table with a certain type of structure. Usually I do this by copy and pasting and then selecting "structure only". I want to now streamline the process and make a wizard-like form to do everything for me (prompt directions, copy paste tables, take input to name...
  11. BotCow

    Storing values in subroutines, creating default values from storage

    Ahh okay, that's very cool. Thanks Fancy. You get a star!
  12. BotCow

    Storing values in subroutines, creating default values from storage

    Okay I'm a C++/Java guy so I might have the wrong idea on how subroutines work. Anyway I have a combo box drop down menu that is assigned to a string variable 'tblName'. I want to "pass" this string into a function for storage so when the form containing the combo box closes, it will...
  13. BotCow

    Refresh subform with a click of a button?

    Well I got the close/open form to work and I think that works okay. So if you don't feel like sorting through all that junk above, then don't worry about it. In fact, closing and opening the form to get the results has the effect of the form actually "refreshing". This might work...
  14. BotCow

    Refresh subform with a click of a button?

    Public Sub cmdSearch_Click() 'Declarations' Dim strSQL As String, strWhere As String, strOrder As String Dim dbNm As Database Dim qryDef As QueryDef 'Assignments' Set dbNm = CurrentDb() tblName = "tbl" & Me!cmbsource strSQL = "SELECT [Page], [Date], Subject, Company, People...
  15. BotCow

    Problems with Asus P4C800-E Deluxe Motherboard

    Lock ups could be a hard drive issue. Sounds a bit rough but did you try a format yet? It's cheaper than replacing parts. Those parts are normally compatible with each other; Corsair being one of the most compatible pieces of RAM ever. It might just be a bad installation of WinXP. Or if you...
  16. BotCow

    Casing choices

    Looking for cases depends on your budget. It really depends. For instance, Coolermaster and Lian-Li Aluminum cases run from $79-200+. They make quality boxes though (slide out motherboard tray, excellent paint finishes, rolled edges). Lower end steel cases are heavy. However they still do the...
  17. BotCow

    Memory and XP2800+ CPU

    I would exchange it. Upgrading to a lower end memory isn't really an upgrade. Basically you just spend money on something that will get outdated quicker that what you had before. For your purposes, it shouldn't be so bad. But if you're going to overclock you might want better memory. If not, I...
  18. BotCow

    i can't hear sound and i have a sound card on my system `

    You need to be more specific. Are you saying this virus took out your sound card? I think that's unlikely but could happen. What you should do is check your drivers and make sure they are properly installed. Next you need to check if it's installed properly. When was it working last? What'd you...
  19. BotCow

    Difference between Asus A7N8X and A7N8X-X

    Performance difference is not only minimal in some cases, but in other benchmarks, I've seen the single channel ddr nForce2 chipset outperforming the dual channel. There was a review on one of these boards at anandtech.com. Very thorough. Good board, I would pick it up.
  20. BotCow

    Send SQL to query, update subform while open. Possible?

    I stand corrected. When I send the SQL statement to the query it works. But the darn subform won't update to reflect the changes. I've tried everything, Me.subformname.Refresh (which gives me an error: Object doesn't support this method or property), Me.subformname.Requery, Me!... and finally...

Part and Inventory Search

Back
Top