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 Chriss Miller 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. bkf7911

    CombineChildRecords Function Truncates the field at 255 chars.

    The single query worked perfectly... thanks much!
  2. bkf7911

    CombineChildRecords Function Truncates the field at 255 chars.

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

    CombineChildRecords Function Truncates the field at 255 chars.

    ...the results are truncating after 255 characters. HOw can i get Access to look at this as a LongText/Memo field and stop truncating? ***************************************************** Function CombineChildRecords(strTblQryIn As String, _ strFieldNameIn As String...
  4. bkf7911

    How to Normalize Existing Data

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

    How to Normalize Existing Data

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

    How to Normalize Existing Data

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

    How to Normalize Existing Data

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

    Consolidate Multiple Rows into Single Row

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

    Write SQL of query to Memo Field

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

    Write SQL of query to Memo Field

    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?
  11. bkf7911

    Launch MS Access via Shortcut using VB

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

    MS Access Shortcut - Launch via Visual Basic

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

    MS Access Shortcut - Launch via Visual Basic

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

    Launch MS Access via Shortcut using VB

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

    acFormReadOnly changes Editable form

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

    acFormReadOnly changes Editable form

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

    acFormReadOnly changes Editable form

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

    VB Automation of Access with Password

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

    VB Automation of Access with Password

    ...but not the.vbs file. The following is my code. What code can I add and where can I add it so that the password is sent at the appropriate time? ******************** dim o set o=createobject("Access.Application") o.automationsecurity=1 o.opencurrentdatabase "C:\DB_S.mdb" o.usercontrol=true...
  20. bkf7911

    SendObject sending as .xls in error.

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

Part and Inventory Search

Back
Top