Search results

thanks dbdamo - do you have a version of this db that isn't locked as I can't get in the backend of it when pressing f11

This woild require the user to copy/paste the file directory from the file properties to a field in a table yes? If the file directory is constant and ther filename is the only thing that changes - is there not a more efficient way of doing this. Just to clarify on what i am trying to do -...

This question has probably been asked before and In have done some searches but not found anything yet. I am trying to show hyperlinks to PDFs and word docs for database records - any signposting guys on how this has been done in the past?

I have a dynamic multi search function set up using a query criteria Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*" or Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*" under each column one of the columns is Meeting date but when you search for a date - no filtering...

Bearing in mind I have had only a few hours sleep last night - this question is annoyingly easy but fraught with difficulty through lack of shut eye:( I have a table called patients and another called patient attendance. Each one has forms for it. In the Patients form I want to be able to...

sorted now - thank you

Thank you I have created a month worth of cells but when I copy and paste it pastes the same dates

I have a table called 'meeting' and a column in it called date. I want to add records to the table in one go so there is a record of every workday for the next 2 years: i.e Record 1. 3/8/2010 Record 2. 4/8/2010 etc is there a quick way of doing?

PARAMETERS [Forms]![frmRptDialogSingle]![begdate] DateTime, [Forms]![frmRptDialogSingle]![enddate] DateTime; TRANSFORM Count(qry_cardiology1.EpisodeID) AS CountOfEpisodeID SELECT qry_cardiology1.Days FROM qry_cardiology1 WHERE (((qry_cardiology1.RequestDatetime) Between...

I have done a search a found a solution! WorkingDays: IIf(Weekday([RequestDateTime])>Weekday([Procedure1DateTime]),1+Int(([Procedure1DateTime]-[RequestDateTime])/7),Int(([Procedure1DateTime]-[RequestDateTime])/7))*5+Weekday([Procedure1DateTime])-Weekday([RequestDateTime]) I was wondering...

I have query where a column has a start date and end date. I wanted to be able to work out the days taken for each episode but take off days where weekends are encountered? Best wishes Tez SELECT tbl_Data.EpisodeID, tbl_Data.Outcome, tbl_Data.ReferringHospital, tbl_Data.ReceiveHospital...

brilliant stuff. thank you!!

ah - getting there now - have cleaned up code a bit more now coming up with error message though (see new attachment)

sorry - the consultant combo

I have done some searching now and found a sample. I have added this in the notinlist event but i still can't add new values see attached. the add patient form has the combo

I have limittoloist set to n but it own;t let me enter my own values though

Correct me if I am wrong but is it impossible to overide the value of a combo box? A colleague has asked me to have a combo box that can allow the user to type in thier own choice? if its not in the list

Hi guys What on earth is wrong with this: SELECT * INTO NewTable FROM qry_car_reqtoproc_crosstab ALTER TABLE NewTable ADD COLUMN ReportComments TEXT(25); I get ...... Syntax error in FROM clause. (Error 3131) You entered an SQL statement that has an invalid FROM clause. Possible...

thats is kind of what I want. I understand your reservation though as I suspected I am making life difficult. What I am trying to do is have the user be able to make comments on a report basically. To do this i wanted to create a form that pulls the results of the cross tab query and lets the...

Is there a way I can let the user decide what the table name is by essentially assigning a 'filename' to the table so they can store and recover results