Search results for query: *

Thank you so much for all your help - database now complete!

Hi Thats great - all sorted, but my next problem I've come across is from one of the subforms on the second tab contol I open a new form, but I can't seem to pass the EventID and PatientID through to this form? Any pointers would be great Tigger

Hi Thanks for the fast reply - tthe solution works great, but my only problem now is if I add a new Patient Event the EventID isn't written to the text box so I have added a refresh but this seems show the egg timer and waits a second or two is there a quciker way? Thanks again Tigger

Hi I'm slowly going mad and have fogged over... something so simple seems so complex I have a main form which contains two tab Controls (tabMain and tabEventDetails). The MainForm links to the first subform by PatientID On TabMain I have a subform which contains PatientID and EventID, on...

Hello I have a main form which is linked to a table, this data is displayed on a tab control. I then have 6 more pages each with a subform on which are linked to the id on the first page.(patientid) These subforms are based on queries but I have tried this with basing them on the tables With...

Hi I haven't but will try that now thanks

Hi I have a combo box that contains the name of word documents, what I could like to do from an OK button is when the user selects a document from the combo to then open this document? I have setup a table with the names of the documents including full file path. The documents are mail...

Hi Its version XI and it just a concatenation field for First and Last Name - a command would be best but i'm not sure how to do these? Any help greatly received Ralph

Hi I want to populate the pick list with the formula Hope that makes sense? When I go into Paramaters and select field it only shows Tables/Fields not the formula fields on the report Thanks Ralph

Hi It is possible to have a parameter based on a formula created on a report? What I would like to do is pull the values from the formula so that users can select one from the parameter? Thanks Ralph

Hi I have a simple User Information Table that based on the login I want to open one of three forms. The AccessLevel can be either Full, Part or Activity. I have the first part working fine to check the userid against the userinformation tabel to can't get it to open the form based on the...

Hi I've been asked to look at a solution for the following: Currently we create 5 reports manually in access and save as pdfs and then email to users all manually - takes days! We have a website with secure login and i want the login to be passed as the parameter to crystal reports to ensure...

Hi Not talking Server but the client has informed me that they dont have Project installed on there local machines so guessing that it's over something like citrix (gulp!) Any ideas of what i should check? Thanks

Hi I have created an MS Project which has a Main Project File and a resource project file - i have created custom toolbars, menus and have macros running from it saved into the global.mpt. When i move these to another machine and copy the global file i still can't see the macros and toolbars...

Hi I have created a custom field with a formula set as follows: IIF([Finish]<now(), "Overdue", "")) This is then displayed - at the moment I have it set as a icon (red one). Just can't seem to find a way to set the whole line of text for the task to red. can change the colour of the...

Hi I have a custom field set so if the finish date is less than now() then say Overdue. Works fine. But i'd like it to do the following: If = Overdue set whole task to red? Is this possible in Project and if so how? Thanks N

Thank you for the response - just having a moment of madness i think!

Hi I have custom field called Status, which user can select one of three options from a dropdown list - depending on the option selected i want another custom field to be populated - is it possible by doing a nested IIF statement or do i need to VBA it? For example Status = A then Arrival =...

Hi Skip Thank you for the response the master data comes from an exported crystal report - and it is yuk!, that's why I have to mess with it so much. Your right regarding the master data report the only problem is to the data is too big for excel over 100K rows so unless I do it in access I...

Hi Skip Your right - being newbie to VBA what would be the easiest way to get it to autofill the account code down for each subset? Thanks for the help and advice