Search results

well can u just create a table and use the attached txt file as data. u have the word screen shot to work from.

Rich, Could you download travismp example db and show me how to do this in a query? Thanks Mark

what you need to do is run the query in code and then open the excel object. then if u want to use the sameworksheet then set the new range to paste in the query. On Error GoTo ErrorHandler Set db = CurrentDb() Set rs = db.OpenRecordset("YOURQUERYNAME", dbOpenDynaset) 'If recordset has...

i know that this can be done with vba and i could write this code but it would mean creating the report direct from code. basically you would record two variables one being the last date for the ss and then check if there is another entry for the user and if only two entries then select both...

you can use max to get one date for each ss but i would like to know how to return the top 2 for each ss

well when you open another database you will be opening another object in code so why don't you just pick up the Global Variable in that code?

zip up the db and it will be looked at!!

Stop it!! my sides are splitting!!!!:D :D :D :D

you dont even have to convert the back end as the front end only links to the tables. but if you are converting both then i would back them all up and then convert the back end 1st.

have a look at attached example

looks like he got the sack???

pop on the db and it will be looked at, if you wish?

you can do 2 things: 1) You can in your development db(not live), Delete all the tables except the system tables and then right click and import all the tables from the live db or 2) You can in your development db(not live), Delete all the tables except the system tables and then right...

jlocke, It is worth taking note of what the "Female of the Forum" Pat Hartman has to say as the lady knows what she is talking about!!!!

here u go!

Dear all, Is there anyway that I can protect the queries in an MDE from being tampered with? Thanks Mark

If I was you I would create a combo box woth the PatientID as the bound column and then on the ClickEvent: On Error GoTo ErrorHandler Dim stDocName As String Dim stLinkCriteria As String stDocName = "YourForm" stLinkCriteria = "[PatientID]=" & Me.combo.Column(0)...

in the query change the date()+60

u can just format the report to produce the letter for each birthday. just force new page for each id. u can run a macro or code behind a button to produce these letters. if you put some data in the db and provide me with the letter format and content I will do it 4 u!

i've knocked up an example to get u started, attached.