Recent content by BotCow

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