Search results

Please bear with me while I try and explain this... My tables are linked sharepoint lists. I have a form with 2 subforms showing in datasheet view. They each show data from the same table (Exceptions) with slightly differing criteria. I have a column in each table that is a tickbox which is...

Hi, I have a small database working fine from a fileshare but have been asked to migrate this to SharePoint. I've uploaded my tables to SharePoint lists without many problems. If I append single records from my dataset they synchronise fine. I have a button to import multiple lines from an...

I have an access database that has a button to import data from an specific excel document into a table. The table had Name, and Date as primary keys. When importing the doc this obviously stops duplicate name/date entries from being added. This is probably a really bad way of doing it but was...

I have a form with 3 combo boxes (TeamNamecbo, CustomerNamecbo and AccountTypecbo). TeamNamecbo just lists all the teams from Teamtbl CustomerNamecbo is filtered (for want of a better word) to show only the customers that TeamNamecbo supports using the following. SELECT distinct Accounts.ID...

Still a beginner so please pardon my ignorance/ineptitude :) I would like to be able to join 2 text boxes and then copy them to clipboard. My initial fumbling has had me to joing the 2 text boxes as a string and then set that string as the value of another hidden text box and then copy that...

Afternoon, I have a form on which I use combo boxes to filter a listbox using the following code. ------------------------------------ Private Sub FilterpartsList() Dim strRS As String ' Filter the list box appropriately based on the combo box selection(s) strRS = "SELECT...