Search results

That is my issue the combobox is bound to a SharePoint table that does not have this information, and I am unable to edit the table to add it in. I am thinking my best plan of attack is to create a separate local table in the access database with this information, and as you suggest on the...

How would you advise using the AfterUpdate of combo? I am so glad the crew here recommended a local table. I think that is going to be the bets bet since I am at roughly 39 now and the list can grow at any time.

Unfortunately not, I do not have ability to add columns/fields to the SharePoint site.

Correct, the SharePoint does not have the folder information

The row source is one field from a linked SharePoint table I could create a new local access table that houses the full path and the employee name and maybe use Dlookup in the bbq to get the full folder path

Is my best plan of attack here using If .... then....else....end if I have a combobox with 40 possible options in it. Based off the selection in the combo box I need to open a file browser to a specific folder. What seems most logical to me is to do 'Declared Public in diff module Public...

Wait - I thought that is what you meant... Or are you referencing an approach like @jdraw said above?

So above this line --- sSQL = "DROP TABLE [" & rst!table_name & "]" There I would add my conditional For Each statement since we have explicitly stated to check local tables only at this point?

Ah - I can't drop all local. I only need to drop the 4 specific local tables.

I have a database with roughly 100 tables in it, now 75ish are linked SharePoint tables, and the other 25 are local access tables. Can I edit my VBA to ONLY scan the local tables and ignore any other tables? This is my current syntax but it is slow... Dim tblNamesArray As Variant...

Oh my gosh - I made such a simple mistake....Your code works exactly as you stated, had I used it as you shown. I accidentally omitted the line Dim varItem As Variant Once I included that at the top of the procedure the 0 is no longer displayed. Oh yeah, and I also included Option...

Bound Column: 1 Column Count: 1 Column Width: 4.0417

Table/Query It’s set from the VBA with a where clause of Me.cboName.Column(0) Is that what’s causing the error?

For some reason I’m getting a 0 as the first line in the text box on my report. If I do a debug.print it also shows the 0. What needs to be changed so this doesn’t happen?

I am getting a run time error of 'Compile error: Method or data member not found' on the List13.List(i) and it highlights List This is how I have my code set-up In a Module Public Msg As String In the button press event of my form Private Sub btnOne_Click() Dim i As Integer For i = 0 To...

I found this, which adds the new line, but I'm not certain on how to set this value to the text box on the report. How do forms and reports "talk" or "see" each other? For i = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(i) Then Msg = Msg & ListBox1.List(i) &...

Hi - if more than one value is selected I want a new line added between them, so it would look like this Selection 1 Selection 2 Selection 3 etc...

I have a List Box on a user form that is multi-select. With a little assistance I have code that will iterate the list box and show me what has been selected from the list box. The last step of my journey is to now have the selected items from the list box on a user form, display in a text box...

Hi - I have a form, with a multi-select list box, I am using this code to populate the list box Private Sub Combo2_AfterUpdate() Dim strSql As String strSql = "SELECT ID, txtName, [CVN] & ' - ' & [SNV] AS FullInfo FROM AllData WHERE txtName = """ & [Forms]![Form1]![Combo2] & """ ORDER BY...

I see what I did... under the Properties, Data tab, I cleared both the Row Source and the Row Source Type. Setting Row Source Type back to Table/Query -> has it working exactly as you state it should. Thanks again!!