Search results

After getting that error a few times, decided to try and find a way to fix it. Found this code that will check the table for the fields. So now I'm running this code on open and then either letting it run if the field is there, or back to arne's code to fix the table. No more error messages...

Yes that would be a much better way of doing it. Right now, I'm launching Access and assume that I can get into the normal stuff. But if not, then I get a "Enter Parameter Value" dialog with a following Run-time error '2467". So I just click "End" and then click a button I called "Prepare...

Hello arne After Pat's comments about being able to modify the table if the table was closed, I decided to give your code another shot. This time, I created a new form with just one button and this VBA. To my surprise, it worked. The reason being that I had put this code in an existing form...

I can't modify the Excel Table within Access. It's a linked table, so Access will want it closed before it can modify the structure. But since it's linked, I can't close it either.

Yes that's what I'm doing now. Works fine but wanted to try and automate it all with Access. Yes, I am attempting to add a column that has no header name, give it a name and then populate that new column from within Access. I can do all of this except add the new column from Access. I'm...

The Excel spreadsheet is a system generated file which I have no control over. The idea is to link to the raw file that gets replaced by the system, modify as needed with Access and then export it another excel file for distribution. For reasons too many to mention here, it's a lot easier to...

Thanks arnelgp!! It's working but not quite. Something isn't quite right. If I run the code as is, I can't get passed the "The workbook is already open..." message box. Suppose that's expected since I need to have the workbook as a linked table in Access. If I remove that step, the code...

Thanks for the suggestion CJ. I may try this method if I can't get it working directly from within Access. Otherwise, I'll just keep updating the Excel file with Excel before launching Access.

Thanks isladogs - I'm using Access 365 and have been using method 2 to change the connection string from IMEX = 0 instead of the default value 2. So I can change the contents of the table, but can't find a way to add an additional column from Access. Sorry for simplifying the original post...

I've used the Linked Table manager to Link an Excel Table as the data source in Access. But the table needs a small change to one of the field titles. Very simple to just open the file in Excel and edit the field and then launch Access. But I'm trying to add a button in an Access form that...

Found a workaround. Had to add another button just for null values. So now I've got the combo for the Ys and Ns and using another button for the nulls. Me.Filter = "IsNull([Tested])" Me.FilterOn = True It's not pretty, but it works...

That's not working. Access run-time error 2465. Can't find the field referred to in expression. Seems like a combobox can't be used to filter blank records. Will need to find another way to do that...

No sure how to do that. Besides, that would filter out only the "N". So I'd still see the "Y" and anything else someone may have put there. Like N/A... I'm trying to see what else hasn't been tested yet. So basically, just blank records...

I'm using a text field in a continuous form to show Y or N or just leave blank if nothing is filed in yet. To filter out the records, I'm using a combobox with a filter like this If Not IsNull(Me.cboYN) Then strWhere = strWhere & "([Tested] = """ & Me.cboYN & """) AND " End If This...

Thanks for all the help. I had originally created the table with an autonumber ID primary key. Deleting that field and making the TeamFunction the primary key fixed the non-edible issue. Now the form sorts perfectly and is editable.

Well that works very well for the sorting - does exactly what I'm looking to do. But now I can't add a record or make any changes in the continuous form anymore. When ever I try to make a change, I get a tone. So looks like I'm going to have to go back so I can gain use of the form again...

I've got a table called CompanyTeams and one of the fields is called TeamFunction. I'd like to sort by TeamFunction, but not by actual name in that field. So I created another table called TeamSortOrder that has the TeamFunction as well as a numerical field called TeamSortOrder. So basically...

No. Just the first column does. I tried to create a query and add both to the datasource, but then I couldn't edit the form anymore.

Trying to find a way to sort a continuous form from a column in one of the combo boxes. I can add an unbound field in the continuous form and call it TeamSortOrder and make the control source the second column of one of the combo boxes. For example, =[TeamFunction].[Column](2) This unbound...

Thanks - that worked perfectly. And double thanks for responding so quickly!!