Search results

  1. R

    Print Main Report with selected subreports.

    I have one report, which has approxiamtely 10 subreports. Sometimes it is not neccessary to print all the subreports off, just specific ones. I would like to have in my report list (I use the list box method) that when a user selects custom report, it brings up a form, where tick boxes can be...
  2. R

    Printing a PDF file out using VBA

    I have tried scouring the internet and find find answer to this and Adobe's SDK etc is confusing hell out of me. What I have to produce is a pack for new clients and this consists of many documents which are in MS Word. This works fine and got that working fine, but one document gets supplied...
  3. R

    New SmartPhone - HTC S710 or I-Mate SPL

    I am looking at replacing my phone with a smart phone. I have had an O2 XDA IIi and s and do like them, however they are a bit large, and I find the fact that if the device wakes up on its own, it releases the key lock so you can end up with the backlight on whilst its in your pocket draining...
  4. R

    Exchange Server 2003

    I currently have a Windows 2003 SBS Server running Exchange Standard. I have learnt so much fiddling about with it, it now needs clearing out and starting again. I have spent ages getting exchange running just right, is there anyway I can just backup a registry entry/file that contains all the...
  5. R

    Using a list box to call VBA function or Macro

    http://www.access-programmers.co.uk/forums/showthread.php?t=123538 Following on from that thread, I would really like to tidy up other areas of my front end. I am using the idea that Roy suggested and it works very well. At the moment, I have a form, that has buttons on it that people click...
  6. R

    List Box of Reports - Filtering Result

    http://allenbrowne.com/ser-19.html I use the call back function to generate my list of reports in a list box. I chose to use this method as it seems like an easy way to do what I want, and to a certain extent understand how it works. What I would really like to be able to do, is have it...
  7. R

    Split one field in to two - How?

    I have a table that holds 250 records, and dont really want to split manually as the saving grace is that each record, has a hyphen that marks the point where the split needs to take place. For example, the field currently holds 'Movicol sachets - 1 or 2 sachets dissolved in water at 21.30'...
  8. R

    I dont know what I want is called

    What I want to do, is have an unbound form, user enters data in to it, then clicks on a 'save' button which then writes the data to a new record within a table I have got no idea what it is called so find it hard to do the search.
  9. R

    Problem with Form to Subform Code

    I have a main form, which has a subform on it. THe Main form is the main page for the clients, and the subform holds hyperlinks to PDF files (letters we have recieved on a client). This works fine. I am trying to get it so when a document gets inserted in to the subform, a date is...
  10. R

    My main tables AutoNumber playing up.

    OK, My main table has an autonumber field in it to make records unique. At the moment, the number 5-34 are all in use on active records. But when I create a new record either in the front end form, or the back end directly in the table, it attempts to start the record off with an already...
  11. R

    PLease help with automating excel from access vba

    OK, I have spent all morning trying to work this out to no avail. This is some code I use, Dim obj As Object Set obj = GetObject("f:\clientdatabase\templates\ChartTemplates.xls") obj.Application.Visible = True obj.Windows(1).Visible = True obj.Application.ScreenUpdating = True...
  12. R

    Using bookmarks in word, what other options can be used.

    OK, Tried doing a search, but all I found was what I can already do. I use the following code to make access open word up, fill in a blank. What I would like to do is for access to open word, fill in the blank, print the word document out, and close word without confirming the need to save...
  13. R

    Ladies - Need your help please? Guys dont laugh at me! lol

    Ladies, I need some advice, and I hope that this does not breach any rules here. I got married earlier in the year, and as its traditional, within my family, for the husband to buy his wife some nice lingerie for Christmas, I would like to follow that tradition on. Now my question is, do I go...
  14. R

    Changing case of data already in access tables

    My database is now live within our office and is working fine. The databases which I have imported the data from, where done by my dad, who being old fashioned, used CAPS for everything he typed. So for quite alot of the data, its all caps, and it would be great, but not essential if we could...
  15. R

    Image Quality when using linked images

    http://www.access-programmers.co.uk/forums/showthread.php?t=108698 I am using the example database to avoid storing pictures in my database, as the size could grow and make the backend slow down. The only thing with it is, the image quality isnt that great. Is there a way to sharpen it up?
  16. R

    Blank data causes crash with word bookmarks.

    OK, I am learning loads. I have made it so when a user clicks a certain button, it starts word up, fills in name and address of the recipient, and fills in who the letter is in reference to. Works a treat UNTIL a field tries to be inserted in to the bookmark, the code crashes out to debug, and...
  17. R

    Inserting text from module as a hyperlink

    I am using the current code to browse for a filename, which gets inserted in to the relevant text box on a form. Private Sub Command8_Click() Dim strFilter As String Dim strInputFileName As String strFilter = ahtAddFilterItem(strFilter, "Acrobat Files (*.pdf)", "*.pdf")...
  18. R

    Trying to get a first module to work.

    I am complete novice to coding, so please be gentle. I have come accross the following code so I can browse for a file, which I then want to store in a field in a table, so people just click on it as a hyperlink. Like many people, I dont want people typing in the link, I would prefer them to...
  19. R

    Hi and a hope of help over listing file names in Access

    Hi, newbie here to this forum, been looking about for ages to try and find an access based forum. I am not a great coder, have not really done it, nor remotely understand it, but I have still managed to write a database in access for the office. We run a residential care home, where we had 5...
Back
Top Bottom