Search results

Hello I guess from that comment you have been enjoying a stay at Mr Milburns fun factory. As for 15 month, no problems on that front we worring about 12 months at end of March! I have been testing this and for some reason when it tries to execute .Attachments =...

Hello Can anyone help please!. I'm populating an excel spreadsheet with 2 queries, saving it, and then calling this function to e-mail the spreadsheet as an attachment. Strangley when the line ".Attachments = XLSReportPath" has executed Access skips out of the function and back to the main sub...

Hello I've asked this ages ago and never got a satisfactory answer. Is there a way of running a macro in one database from another. i've written Dim ws As DAO.Workspace Dim db As DAO.Database ' Create Microsoft Jet Workspace object. Set ws = CreateWorkspace("", "admin", "", dbUseJet) '...

Hello managed to solve it using: Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) Dim CTLLABEL As Label Dim IntLenOfCtl As Integer Dim IntDate As Integer Dim IntLeftOfCtl As Variant Set CTLLABEL = Me.Lbl_This_Year IntDate =...

report

Hello I need to get this sorted before 5. i've got a report with two labels on and i need to repostion and size them when the form is printed how can i do this?? Cheers Chris

Hello Try using the search facility. You can look up key words in the body of the question and answer. Chris

Hello If i understand this correctly what you are doing is running a query using the datediff function with one static piece of information i.e YYYY for the year (the one in your table) and two variable dates. If you want the static data in your query could you not just write it in...

Hello I have written this in an attempt to run a macro in another database. I have been able to enumerate through the objects in this database with a for each container and document loop and i have "seen" the macro in question but i am unable to run it. I get an error message saying " MS ACCESS...

Hello I use this to sort on. It will order the dates correctly format([date],"yyyy/mm") Hope this helps Chris

Cheers Chris

Hello I realize there is a lot about this on the site (i've read most of it!) . What i can't find is where i can purchase the access developers version to allow me to distribute DB's to those without Access installed. I've searched the web but without success. Does anyone have an address...

Hello Could someone tell me if there is an onprint event for a form. Bascially when the form is printed i need to be able to carry out some other tasks. Cheers Chris

Hello some help was kindly given to me regarding the normalization of a questionnaire i chose to go with the structure tblQuestion -- QuesNumber (PK) -- strQuestion tblQuestionnaire -- QuesnairNum (PK) -- strDescription tbl QuesQsnair -- QuesNumber (FK) 'this question appears on...

Hello Thanks for your suggestions. Doc i take your point about the yes no... fields. The idea for a questionnaire subset is simply to allow us to analyse that particular area individually. i.e Sercurity and confidentiality. It will allow us to build a departmental map by topic to see which...

Hello I have a questionnaire that needs to be converted to a DB. My problem is i can see various solutions but if i get the normalization wrong at the start i'm going to be up the proverbial creek later. The questionnaire is comprised of 7 sub questionnaires, not all the recipients will be...

Hello I've created a form that allows the user to look for a training company and a sub form that shows the related trainers. What i wanted to do was allow the user to enter a new training company so i coded the following. The problem is that when the form is returned from me.dataentry = true...

Hello No the error is just occuring at that line of code. Any how i checked the select part of the query and that worked fine then i tried StrSql = "SELECT TBL_PATIENT.*, TBL_SPELL.* " _ & "FROM TBL_PATIENT LEFT JOIN TBL_SPELL ON TBL_PATIENT.PMI = TBL_SPELL.PMI_FK " _ & "WHERE...

Hello apologies the line is in top part of rant. ....i get an error (2001) "you cancelled the previous operation" at the line Me.RecordSource = OpenArgs .... It's obviously(??!) in the form load procedure of the form being opened. Your right about the lack of spacing but as i can't get the...

Hello I've written this in the on click event of a cmd button when i run it and it gets to get the form load event of the form i'm opening i get an error (2001) "you cancelled the previous operation" at the line Me.RecordSource = OpenArgs I don't see how this error can be generated as it...