Search results for query: *

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.

Close guess. I'm using a single front-end and single back-end. My customer doesn't want a copy of the front-end on every PC.

I have a form that is opened in either Edit mode or Read only mode, depending on the user's level of access. For some reason, when the form is opened in Read Only mode, acFormReadOnly, it will change the "Allow Edits", "Allow Deletions", "Allow Additions" entries on the form to "NO", so that...

Thanks, but i figured it out on my own. I replaced: o.opencurrentdatabase "C:\DB_S.mdb" with o.OpenCurrentDatabase "C:\DB_S.mdb",,"password

I'm using a scheduler to launch a .bat file that then triggers a .vbs file that launches an MS Access database and runs a macro. I need to add a password to the MS Access database and i need to modify the .vbs file to send the database password so that it will automatically login. I can get it...

I'm using the SendObject method in a macro to send a Report from MS Access to LotusNotes as a Rich Text File. On my PC it works fine. On another user's PC, it HAS worked fine, but today it started sending the file as an Excel file instead of Rich Text. Nothing has changed about this database...