Recent content by bkf7911

The single query worked perfectly... thanks much!

That statement didn't make a difference. I call the function through the following query. The ProductsList field is short text and i want it as memo. SELECT CombineChildRecords("tblAccount","Account","Filler",[Filler]," ") AS ProductsList, tblAccount.Filler FROM tblAccount GROUP BY...

I am trying to use the CombineChildRecords Function to concatenate the many results for one row. Unfortunately, the results are truncating after 255 characters. HOw can i get Access to look at this as a LongText/Memo field and stop truncating...

Thanks for the updates! I'm going with MajP's code.... Appreciate the replies.

I thought i'd complicate it. I can do the unions, but i'm interested in Code or query that can do this so it will be portable for future endeavors.

ASIDE from selecting the data in the original table and then Unioning multiple select statements.

I need to create frequency reporting using existing data and wondered if there is a quick query/code that would allow this. I need to shift from current format below to the desired format below. Any suggestions? Current Format ID M1 M2 M3 M4 Alpha 1 2 3 4 Beta 4 3 2 1 Desired Format...

Is there a way to consolidate Multiple Rows into a single row? I'd like to place all values related to Field1 into a single field, separated by a comma, perhaps, rather than have them as individual rows. I can use Access, VBA, SQL, Excel to accomplish. Any ideas how i can do this? EXAMPLE...

I'm changing the dates to a variety of different dates, based on the current day (prior week begin/end; prior month; prior day). Then i reference those values in a passthrough, run the passthrough and export the results. I need to also record the exact SQL used, so thought there may be code...

I have a query that will change daily and would like to record the current SQL behind the query with every change, and store the SQL for the current day in either a memo field, a text file, or an excel file (Memo Best). Is there any code that can automate this?

I think the problem is that i'm using workgroup security for the database, and as a result the Target in the shortcut addresses three actions: 1) it opens MS Access.exe. 2) It opens the database. 3) It references the workgroup security file, .mdw. I found/modified something in MS help pages...

Remou, i wasn't able to have it open the shortcut or the target of the shortcut. It kept opening MSAccess.exe within access, and seeing it as an error, or seeing it as a DataAccess page and giving me an error on open. Jsteph, I wouldn't be able to use the actual MDB because the database uses...

I have an access database that I use a shortcut to enter, due to security being in a separate .mdw file. How can i launch this database through the shortcut using VB? It doesn't have to be able to login to the menu screen, just open the DB to the prompt where the user can login. I keep...

I have an access database that I use a shortcut to enter, due to security being in a separate .mdw file. How can i launch this database through the shortcut using VB? It doesn't have to be able to login to the menu screen, just open the DB to the prompt where the user can login. I keep...

lol.... no, i'm just stuck with fixing it every time it reverts. such is life.