Search results

Hello 'speakers_86' Many thanks for your reply. I have downloaded and had a look at your Ribbon Builder.mdb, and I think this could give me the ability to do what I need to do ... but I'm a bit out of my depth! I am very comfortable with coding in vba in general, but would find it extremely...

Hi All I need to export data from our access 2010 accdb to various xml files that adhere to very specific schemas (for submission to the Inland Revenue). I'm pretty sure this can't be handled by access's built-in 'export to xml' facility, and needs to be done with vba instead - but although I'm...

Hello 'AccessMSSQL' Many thanks for your reply. On trying your suggestion I found that only where two carriage returns had been entered (so two little squares) was I getting a new line generated. I therefore added two further Chr(10) & Chr(13)s to the replace function...

Hi All I have a routine that imports data from an excel file into an access table and then generates a report based on the table. One of the cells in the excel file contains free text, typically a few sentences. In some cases the sentences are separated onto new lines - the user has done...

Hi Bob and Trevor That's really great - many thanks. I recorded the macro as Bob suggested - which resulted in something very similar to what Trevor suggested!! So now I know the 'record and copy macro' technique and also something about setting fonts: a good day's work:D Thanks again Les

Hi All I have an access module that creates an excel file from a template and assigns various values to various cells, and it all works fine ... except that I would like to vary the font size and colour of the text in a particular cell. So where I currently have: range("V7").value = "NHS...

Hi 'shazywie71' Many thanks for your reply: I was beginning to give up hope!! In fact the government has provided a 'test service' to validate xml files against their schema: the problem I have is how to 'tell' access about the schema - i.e. how to specify the precise structure of the...

Hello All How do I output data from an access2010 accdb as an xml file that complies with a pre-defined schema? Our access2010 application is used to process payrolls - calculating pay, tax, national insurance and pension deductions. The government is introducing a new requirement for payroll...

Hello plog and vbaInet Many thanks for your help: almost there but not quite! The code you - plog - suggested does succeed in returning one record for each [staff_name] that has both 'fulltime' values, but what I really need is to return ALL the records for these employees. So perhaps it's a...

Hello All I have a table [x confirmed], and two of its fields are 'staff_name' (text)and 'fulltime' (Yes/No). There are many records in the table for each 'staff_name' value: generally a given 'staff_name' value will always have the same 'fulltime' value, but I need a query that will return...

Hi All I have inherited a complex Access2010 app :rolleyes: that includes a facility to create an also-complex Excel file :eek: which has a lot of very specific attributes. The Excel file is based on an Excel 'template', which has a lot of VBA procedures to test data entered, and obviously the...

Hi sxschech Many thanks for your reply - and apologies for the delay in my response, I've been away for a few days. I knew about the "little circle with the down pointing triangle", but I didn't know about the right-click options on that!! I can see that here I can sort queries by type - and...

Hi All We have recently moved from access 2007 to access 2010. In access 2007, when viewing the objects (i.e. the tables, or queries, or forms, etc) it was possible to sort them by created/modified date, or, in the case of queries, sort them by query type (i.e. select queries, then make-table...

Hi Spikepl Thanks for your further replies. First, let me make clear that I really do appreciate the time that you (and others) put into helping us less experienced 'developers' in these forums. I have gained a lot of help from responses I have recieved, and have also added significantly to...

Hi spikepl Thanks for your further reply. tblCount is a single field table, with 1000 records with values 1,2,3,4 ... 1000: I use it in this query (and others) to generate a record for each day in the range [Sickness - Start Date] to [Sickness - End Date] (for if [Sickness - Start Date] = 7...

Hi Guus2005 Many thanks for your response. I have tried at length to make my query 'fit' the framework you gave - which I think I can follow, but have now got myself in a right tangle and now just cannot see the way forward:confused:. If you could have a look at the query I've got and let me...

Hi Spikepl Thanks for your response. The sql of the query that crashes is: SELECT DateDiff("d",[Sickness - Start Date],[Sickness - End Date]) AS Expr2 FROM tblCount, [qry Submissionsheets] INNER JOIN staffs ON [qry Submissionsheets].[Employee Name] = staffs.staff_name WHERE...

Hi All This works perferctly ... SELECT DateDiff("d",[Sickness - Start Date],[Sickness - End Date]) AS Expr2 FROM tblCount, [qry Submissionsheets] INNER JOIN staffs ON [qry Submissionsheets].[Employee Name] = staffs.staff_name WHERE (((IsDate([Sickness - Start Date]))=True) AND...

Hi All I am fairly new to using subqueries, but have been able to use some recently that have been very useful. I have now hit a problem though which I suspect is down to my inexperience with them:( I had a main query with 2 subqueries, and a report based on the main query, and all was well...

Hello apr pillai Many thanks for your reply. I didn't realise that you could only have one field in the sub query, so thanks for pointing that out. This causes another problem for me though, as I needed to set criteria on TWO fields from the sub query! Can I do that? Thanks again Les