Search results for query: *

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

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

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

Bump? Can't merge columns physically?

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

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.

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?

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?

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.

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

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

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

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

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

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

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

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

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

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.

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