Search results

hi I have a query showing a subset of records including a hyperlink field I need a form button to run a do while not EOF loop to save each file to a folder never done anything like this before so no idea what would be the best method. Found URLDownloadtoFile but struggling to see the correct...

hi got a field that is a long string of information with spaces to separate different bits of information that include a date in simple ddmmyy no slashes or dots I'm using various left and instr functions to separate out the information into individual fields in a query all working other...

hi trying to get an email in outlook with as many PDF attachments as there are records in the continuous subform -ie 1 attachment per subform record in code below ( which is button on the subform ) 4 possible values for Me![Master] hence the if then statements - it should determine which...

hi my vb skills are very limited and I need help with a task to rename 1500 jpg files in a folder ( left hand side of attached screen grab ) I've got the data on the right hand side in an access table i need code to loop thru the folder and rename such that in simple terms the new filename =...

I have been tasked with converting a series of excel sheets into an access database to allow multi user entry the main table will have a product name - desc in image below - and some fields that are required for all records but also a raft of other fields that only certain records will...

Hi hoping someone can point me in the right direction before I pull out all my hair ! Until recently I didn't realise that access 2007 and above could do multi-value combo box fields I have got it working in table view however when I select multiple values in form view and click OK...

I want every report to have an Export to Excel option in my 2010 runtime apps I have created USysRibbons table and copied sample XML code from the web in The ribbon will show but specifically <button idMso="ExportExcel" size="large"/> does not seem to show ?? Is that because it is...

I have been tasked with importing data from a clocking on system to analyse worked hours. There is no option to amend the format of the export which is not great surname forename Field2 Field3 xxx xxx 11/06/2013 19.18 xxx xxx 11/06/2013 5.37+ xxx xxx 12/06/2013 5.41+ xxx xxx 12/06/2013 19.21...

this is driving me nuts ! I have a form based on quite a complicated query I have a button to filter the results to show only records where next contact date = todays date ( next contact is a calculated field ) the button has code DoCmd.ApplyFilter , "[next contact]=" & Date i have...

Hi In an Access continuous form detail section how can you display progress of orders graphically Each order has to go through five stages the query will calculate for each stage whether the order has completed that stage ( based on dates in and out of each department ) I want the form...

help ! I have designed a database for a sales team to record orders taken etc they currently have a whiteboard where they mark up orders taken for each day - they want to replace this with a large monitor and display the info automatically from the database. I have created 2 crosstab...

can handle simple access programming but I am not a programmer as such access 2003 database - i have a hyperlink field on a form with a button next to it which saves the user doing right-click edit hyperlink problem is that it defaults to the folder that the database is stored is there a...