I need to be able to find a Word document on a web domain, edit it and then save those changes, ideally without downloading and then uploading. Is this possible?

So within Access I will select a file from a table that has that file's exact location, such as "www.mydomain.com/files/myDoc.docx". Once I have selected that file, the Word document will open, and then I will make my changes. Still in Word, I will then Save the document and it will be saved in its original place.

hi,

I want to store and read a small text file directly within a VBA module.

I could assign it as a variable, eg

strMyFile = "<b>The quick brown fox jumps over the lazy dog</b>"

but the file is multiple lines and ideally i'd like to be able to copy-paste any changes into the module without having to manage line breaks etc.

Is there any way to do this in VBA, eg a command to read the subsequent lines as text input until some stop command is reached?

I'd like to do this in order to create a one-off self contained module that i can drop into an MS Access db and not worry about dependencies.

Thanks

I have installed an MS Access .accde in C:\Program Files (x86)\Contacts and when I run it I get the message 'A potential security concern has been identified.'

How do I overcome this?

Thanks in advance.

I have a directory that has hundreds of individual databases that contain name and address information.  Can someone please recommend a way to be able to search thru the directory to find which databases a name and address may appear in?  I'm hoping it's possible, but my Google-fu is telling me it's not.

TIA for any help

I would like to get some assistance with dynamically changing a form's **multi-select** property through VBA (without having to close/re-open the form).

Current process:
- I have one listcontrol ("ListBoxActions") with 4 tabs on a form
- In the listbox's property sheet, the value for **multi-select** = "None"
- Upon clicking tab 1, 3, and 4, I would like to have the multi-list property set to "1" (single).
- Alternatively, upon clicking tab 2, I would like to dynamically change the multi-list property to "2" (extended).

I have tried two approaches (see below):

           Me.ListBoxActions.MultiSelect = 2   ' Extended

Select all Open in new window

and/or

           Forms("frmLogin").Controls("ListBoxActions").MultiSelect = 2   ' Extended

Select all Open in new window

Unfortunately, neither of the two methods work.   That is, once I click on tab 2, I only can select a single value (vs. multiple values) from the listbox.  

Below is the full code for the listbox.   What am I missing?   How should the VBA be modified to allow dynamic switching of the multi-select property?

Thank you,
EEH

Private Sub TabControlObject_Change()

    Select Case Me.TabControlObject.Value
               
        Case 0
           MsgBox "1st tab"       
           'Me.ListBoxActions.MultiSelect = 1
           Forms("frmLogin").Controls("ListBoxActions").MultiSelect = 1 'Simple
           Me.ListBoxActions.RowSource = "SELECT tblTabControlRowSources.RowSource_Page_1 FROM tblTabControlRowSources WHERE

Select all Open in new window

…

Hi everyone. I'm designing a database app by using Microsoft Access as a front end (FE) to a MS SQL Server backend (BE). I want to optimize performance as much as possible. Currently, I'm using linked tables. However, for some of my queries, I use pass-through queries and it returns its results instantly. As I have observed, I can still use pass-though queries without linking the tables in the BE. The problem is that the results of pass-through queries are read-only.

Presently, for adding/editing records, I build those queries by basing them on the relevant linked tables. Sometime, I add records by building the query as an Append Query (INSERT INTO).  Is there any equivalent of a pass-through query that allows me to add/edit records? Please note that I will like to accomplish this using either the Query Design Grid (QDG) or by writing pure SQL in the QDG.

Thanks.

I would like to use VBA to change the color theme of the Access application I have created. I actually use the database when I am at work, along with other employees within the company. I have code that switches between the live data and my development data. As part of that switch, I would like to change the color theme when I am in development mode so that I always know when I am using the development data and when am using live data. I have looked around on the online groups and don't find anything that lets me change the color theme and not just change the colors on a single form or report. If this is not doable, does anyone have another suggestion on how I can make it obvious when I am using the live data and when I am in development mode?
Thanks,
Kim

Hi Experts,
I am looking for a script that will read all files of a specific folder (.txt,.csv) and count how many records they're in total.
all files have fields header, however some files only contains the header and should not be count.
Thanks in advance.

I am using the command DoCmd.Outputto  and I need to know how to complete the command to identify the individual's name (I have it in a text box on the form + "_DailyReport_" & Todays Date

Docmd.OutputTo acOutputQuery, "qPrintDaily", acFormatXLSX,  Me.User & "_DailyTaskReport_" & Date()

Tried doing it this way but keep getting errors.  How can I make this work?

I have a table in an Access 2007 database that has a bunch of different statuses for one row of information. I am trying to match this table's data to another table which separates each status into a different row. Now, my original plan was to separate the first table's records into different rows based on their statuses and append them to a new table that can be used to match data with the original table. That is, I would create a query that focused on one status and assign it a letter that was associated with the status, such as "P" for pending. Then, I would append that data, with the letter replacing the original status column, into a new table that could be used to match data with the second table.

The only problem with this plan is that it would require multiple appending tables. I'm wondering if anyone out there has made a query that could break a row of data into separate rows and assign them data so that I would only have to build and append one query instead of several separate ones. If not, does anyone have any suggestions as to how I could make a single query that could do all this work? Or am I better off building multiple appending queries like my original plan?

Please let me know if my explanation was unclear and you need more information!

Hi

I have a database which is used to keep track of industrial objects for a project. For each record (object) there are a connecting revision table (one to many) which is utilized to keep track of data changes for the object (revision handeling).

Data structure:
-Main Table
*Revision Table

The interface is a split form with a subdatasheet form for the revision handeling. I want the user to have the possibility to work in both views (form view and datasheet view).

Now to the issue, when deleting or copying records in the subdatasheet form I get the notification "This Operation is not supported within transactions" and the operation is not carried out (even if it looks like the records are deleted).
When directly in datasheet view for the main form this problem does not occur.

I have made a video of the issue

Hi,
There are lot written about by hiding Ribbon. Still, it seems not be too easy to hide the ribbon. Previously I used the "menu bar" and a application menu bar for the .accde (.mde) application. It worked fine. For to summaries the findings:

* use DoCmd.ShowToolbar "Ribbon", acToolbarNo
* no add-ins
* use dynamic ribbons to replace right-click
* DoCmd.ShowToolbar is not enough use DoCmd.NavigateTo "acNavigationCategoryObjectType" and  DoCmd.RunCommand acCmdWindowHide
* Search for anything which might do something with the ribbon - but what?
* move everything to a new db - sometimes access mix things up. I know, It is not so long ago I did that.
* ...

I use in Form_open event
         If Right(SetDB.Name, 6) = ".accdb" Then DoCmd.ShowToolbar "Ribbon", acToolbarYes Else DoCmd.ShowToolbar "Ribbon", acToolbarNo ' I want the ribbon while developing

Since, the menu bar is still around I disable that one as well - commndbars("Menu bar").enabled=false

I still use commandbars for right-click.

Anyway, Still the File and Home tabs are around, The File contains Privacy Options which means that they change important properties.

There is a lot of XML - code around for this. I have so far not done very much with XML, there is that code and how can I edit it?

What to do?


Thanks advanced


BAnders

I have a form that users input data into.  At the end of the day they click on a button to load this data into a linked table.  At the bottom right hand corner of the for while the background is running queries, the bottom right hand corner of the form shows "running query".  Is there a way I can make it show "processing data" instead while it is running these queries in the background?