Search results

Thanks for your reply. I tried this but when publishing on sharepoint it kept stripping this change out and reverting the file to default. I managed to store it as a text field and got it working. Cheers

Hi, I've set up a multi user split access database. Users will be opening the database on sharepoint and submitting records via the front end form. Within the database file the main data table is stored which is being updated. Is it possible to hide this table without affecting the users...

That has worked. Thanks all

Thanks for clearing that up, still new to access so taking a while to click. Using the below formula since it is a text but still getting #error! Unable to see any issues with it, all tables and combos match.... =DLookUp("Department","qadata","CaseID = '" & [Forms]![EvaluationForm]![caseid])...

The field data type is text, i changed this in design view. However the values within the field are all numeric. Is it possible to run a dlookup with this setup? The table is 'qadata', i removed the space when entering the formula

Apologies been messing around with this issue all morning !! The dlookup works fine when the CaseID field in the table is formatted as a number. However, when changing the format of the CaseID field to text it breaks the formula and unsure how to tweak it to get it to work. All of the...

Hi both, I've tried the suggested methods but still receiving a #error! Unsure if i have explained properly.... The CaseIDs stored are fully numeric values eg 123456789. I've stored them as text as when publishing the database to sharepoint when formatted as number values (general format)...

Hi, I am using a dlookup to fill a form in based on the CaseID field selected. The CaseID is currently stored as a number and works fine. However, I now require the dlookup to work when the CaseID is a number stored as a text, when i change the tabe field to text it breaks. Is it possible for...

Hi, I am in the process of publishing a split access database to sharepoint (access2010/sharepoint 2013) The database includes a form and table which are linked for data entry purposes. One of the fields are CaseID formatted as a general number without decimal places to remove any commas...

Hi, When I am publishing a copy of my Access database I have stored locally onto Sharepoint the tables are being assigned extra columns (labelled Title) This is causing my combo boxes to show blank drop down lists. Any ideas why this is happening and how I can stop it? Thanks James

Hi, I'm currently running 2 seperate sharepoint databases, one which stores a form and table which stores "scores". Another database which compares scores from the table within this to the data entered in the variance database. I currently have the scores table within the variance database and...

Sorted. Managed to crack it.

Based on how I would like the form to work I think the Dlookup is going to be best, could anyone direct me how to get around the #type! error? Thanks

Thanks for the response. I'm very new to queries. Am i correct in thinking i create a combo box looking at the user list table, then another combo box which is linked to a query with the columns Case ID and User, and in the query it would have as critieria for user...

Hi, that would do the trick. The only issue with that way is the large volume of case IDs which would be showing. How easy would it be to limit the no of case ID showing based on other columns eg user / date so I could select a user or date in another combo box etc to limit the no of case ID...

Just to add - on the formula there is an error box showing saying 'invalid control property : control source'

Hi, Thanks for the response. The Case ID field is numeric. I removed the quotes as suggested below on the Case ID part of the formula but still receiving the same error ?

Hi, In a form I have set up (Form1) I type a Case ID into a text box and from this 4 other text boxes need to be populated, this info is pulled from a table I have setup. Within the table there are Case ID, Investigation, Customer, Business and Account columns (all text columns apart from Case...