Search results

  1. alastair69

    Adding pictures to word

    Hello All, I would like some help on how to get a stored file name out of access and into word, there could be mulitible pictures to a site i have a table called tmakSamplePhotos that holds the filename which is called "file". The output of the pictures should go into a table with in word (see...
  2. alastair69

    Removing Letters

    Hello All, I a very simple question and i know this has been covered before but any help as ways. I have a room number that is entered like this E\001 the table name [tmakProperty] and field name is [Area_Number], it could be upto two letters at the front of the \, i am saving the room number...
  3. alastair69

    Access to Word via comand button

    the following is a line of code that places one line of code into the word document, but i now need carryout a loop on this to get other data line into the word document. I am not sure to go about this has anybody got any ideas. 'tbl_Photo_No...
  4. alastair69

    Access to Output into Word

    I have a database the i fillin for a property, want i need to do is output this into word but i am not how to do this i have looked at using document properties, but i feel there must be an easier way of out putting the information to word, does anybody have any ideas. The version of office i...
  5. alastair69

    Query Counting

    Hello All, This is a problem that i have had for a bit now and after using the search function on here, i am still no the waiser. I have a query that i need to make a caluation on every 10th record, i would really like some help on this please. Kind Regards Alastair
  6. alastair69

    Automating Numbers

    Dear All, I have spent two days looking for an answer to a problem i am having, i have a database that i need to populate room numbers, i have a front form which allows a user to enter how many rooms there are on a floor. I would like a button funtion that will count up to the maxiumum number...
  7. alastair69

    MSN Messenger (Live)

    Is anybody else having difficutty in logging into MSN Messenger today?
  8. alastair69

    Any Solicitors on the forum in the uk

    Dear All, If you are a solicitor within the uk and deal in landlord and tenant agreements, could you please help me. As i was a tenant of a property and the landlord has changed the locks and has lock all my belongings in the flat, i would like to know how i can get my stuff back. Any ideas...
  9. alastair69

    Page break paramitors

    Hello all, I have figured out how to export from access to word using a template after hours come days of searching. I now need the document to break at the end of a page as currently the data flows over a page, does any body know how to complete this. If you need the code i am using let me...
  10. alastair69

    Selecting enteries to export into word

    Hello One and All, I have a problem, with bookmarks into a word document. I have spent three days looking at the search function and i have not found any help. I have a database the uses a report number to filter on samples taken, this works fine and all the right samples are displayed when...
  11. alastair69

    updating a table using a command button

    Hello All, I have successfully coded a button to copy one line of data, i need to be able to copy any selected records, but i am not sure how to go about this, i have included the coding that i am currently using. The form is a continuse form. The Code Is: Private Sub...
  12. alastair69

    Removing selected text from a string

    Dear All, Thank you for taking the time to look at this Question. I am using a form in which i only need the last sections. example:- G/001 - Ceiling - Tiles - Perforated. this is what i get at the second, but i would like to drop the "G/001 - " and just have "Ceiling - Tiles - Perforated."...
  13. alastair69

    Placing Data in another Table

    Hello, It has been some time since i have been on the forum. My issue is this, i have a form called "JT History (New)" is need to copy some of the information into another table on close. I have tried to use the following:- me.Clientlookup = [tables].[tbl Scheduler]![CompanyName] This...
  14. alastair69

    Refreshing Pictures

    Hello all, I have search the forum for two days and can not find anything about this promble so any help would be good. I am using a linked picture i have then browser setup and works ok but my issue is that i can not get the picture to refresh its self, with out going into design view and...
  15. alastair69

    A quick Question on Pictures

    Hello All, It has been a while since i posted and answered any posts. I am have a problem with a subform that has a picture on it, the problems is how to get the frame to refresh upon change of the picture. I have tried the normal me.refresh with no joy, just thought one of you master minds...
  16. alastair69

    SQL Information

    I am currently updating a database and would like to know how easy it is to incorporate Sql into my database i understand that this is the fastest way of reteiving information and is best practice when working with servers and desktops. Any information will be gratefully recieved and tutorials...
  17. alastair69

    Excel Template to Import into Access

    Hello All, I thought i would ask this question an how to import data from excel into access. I am using sage to invoice clients and i can output this in to excel format then i would like the best and simplest way to pull the data though into access. The data file has column headings at the...
  18. alastair69

    Import Excel to Access 2000

    Hello One and all, I hope you are all well and can spend a little bit of your Precious time to help me out. I am tring to import a perdifined excel document, the Excel document is used as a template so all the heading stay static though out the document. This is a double question: 1...
  19. alastair69

    Error Message with no error number

    Hello All, I have been developing my database all one seems to be well exept for an error message which is attched. If anybody can help me trap this error or offer some advice i would be greatfull. Alastair
  20. alastair69

    Office Developer XP

    Hello All, I am going to try and use my copy of Developer and was woundering if there is anything i need to know before i start. One questions is do i need to make my front end an "mde" file, for distruption needs or not, any other commends greatfully recived. Alastair
Top Bottom