Search results for query: *

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

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

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

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

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

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

The requirements for the form I'm creating had too many objects, so i'm going to have to go with sub-forms shown on 4 tabs of a tab control. Since this is my first time using the tab control layout on a form, i'm testing what issues i'll have. So far, one has arisen. How do i get the thing to...

Multi-level security has been a bear for me in the past because not everyone here has the same drive letter assigned to the server that houses the database. I want to simplify my database security, but still have it strong. Is there a way to prevent linked tables from being edited if I only...

I'm using an autonumber field in a table to generate the "Record #" for each record added to the form that uses that table. I'm getting corrupt records (chinese characters and/or boxes) about every week or so, and think this may have something to do with the auto-number field. Is there a...

I've got a database that contains a macro I'd like to put on a scheduler to have run overnight, but my current code isn't set up to get past the "Oracle ODBC Driver Connect" prompt that i'm receiving. The following is the code i've rewritten to work with my current project. How could this be...

Okay, this is probably very elementary, but its something i've not picked up yet, and would prefer to know. Lets say i have a table, Table1, with 3 related values: DataA, DataB, and DataC. Lets say that I have a form that would display these values as 1 combo box and 2 text boxes. Combo1...

I have data in the following format: Month Q1 Q2 Q3 Q4 Q5 Q6 Jan 20 21 22 23 24 25 and need it in the following format (table or query, not form/report): Month Question Volume Jan Q1 20 Jan Q2 21 Jan Q3 22 Jan Q4 23 Jan Q5 24 Jan Q6 25 Is there a way to...

I'm working on Top N queries, and need to have a number field so that I can limit the results to 5. I know i can change the properties of the query to be a Top Values, but in the event of a tie, the results include the tied values, making it more than 5. Is there a formula I can add as a field...

I have a text box on a form that calculates the value of other text boxes on the form, and displays the value. Currently, the control source of this text box =...

I'm using a macro and the SendObject to export a report to LotusNotes as a rich-text-file. On my PC, the format looks fine when the file opens. On other's PC's, the format is shifting data away from alignment under the column headings of the report. I think the problem is this: The...