Search results

Hello again everyone, Thanks to everyone for their help so far with getting my DB working and on SP2010. Unfortunately I've got another issue I need your help with! My main form "ExchangeView" contains a subform "PCPList", the source object for "PCPList" needs to change depending on the...

Dont worry about the wrong info! I dont think I can get more confused anyway lol! Putting "UID" as the Master/Child link was the very first thing I tried, but the "PCPs" table has over 5,000 records (24,000 to be exact). From what I've read on the web, SharePoint has a 5,000 record query...

Sorry I'm not quite sure what you mean? My subform is built into the main form, I dont use a macro to make it appear. Is that what I should be doing? If so I have no idea how to! Could I use the Filter option in the property sheet to make this work? I've tried several formulas but cant get...

Update: I tried changing the way my subform is filtered by setting a macro on the "on current" event of the main form "ExchangeView". Again, everything worked fine in Access but when I try to view the form on the SharePoint site, I get the "failed to retrieve list data" error whenever I invoke...

Hi there, I really hope someone can help before I tear my remaining hair out! :( I have a web form "ExchangeView" which is populated with data from the "Exchanges" table. Attached to "ExchangeView" is a subform "PCPList" which pulls data from the "PCPs" table and displays it in datasheet...

Thanks a lot! That got it working. The reason I thought Date() wasnt working was because it wasnt showing up in IntelliSense and kept giving an error whenever I typed it in. Turns out Id stupidly put a calculated field in my table rather than the query and when I tried to set the Date...

Hello again! I need to use the Date() function in a few queries and forms with criteria such as: Between (Date()-1) And (Date()+14) <=Date() <Date() The database will eventually live on a SharePoint site which means that the Date() function cant be used as Access keeps telling me its not a...

Hi John Big Booty, thanks for getting back to me and for welcoming me to the forum! I tried to get my head around how I could customise your code so that it worked with my pre-existing form but I just couldnt work it out. From what I read in the comments, it seems like this creates an...

Hi guys, Im pretty new to Access and am learning as I go! I've got all my tables, queries and forms set up but Im really struggling to get a working search function which suits my needs. I've searched for weeks and tried so many examples but nothing does what I'm looking for so I think it's time...