Search results

  1. Parker

    Tables only stores rounded number

    If you are doing this in a query then right click on the field you want to format and pick 'properties' Scroll down the format bax and pick from the list.
  2. Parker

    Tables only stores rounded number

    Glad to help. Hmmmm. I’ve already had a few brief discussions on books somewhere. I'm presently reading 'A Treasury of Mississippi River Folklore' edited by B. A. Botkin. But I haven't found any useful Access knowledge in there yet :D Seriously; Books are a bit like clothes you just get used...
  3. Parker

    Not sure how to do this...

    How many borrowers? You could end up with a lot of tabs. Take a look at This for an alternative solution, There are others in the same forum as well.
  4. Parker

    Undefined Function in Query

    Still don't understand why it would run others but not mine though :mad:
  5. Parker

    Tables only stores rounded number

    OK I've taken a look at this and it seems to be working off a form. There has to be away to make it print from a report but I can't see it in a hurry. I may have a play with it when I have more time. So, as a quick fix base your form on a query with a round expresion like this...
  6. Parker

    Undefined Function in Query

    Thanks Rich Well it's nice to know it works. I called it Pad ----- I can think of a few other names but not appropriate on here me thinks :D Pat suggested missing references which is also a thought I had but I cant think that it would be that 'cause I have downloaded a few examples from other...
  7. Parker

    Managing Employee Shifts

    OK here’s another tanners worth. Your spending far too much time mucking about with tables, relationships, and forms. The answer is in queries and reports. Take a look at this. I think this may be what you are trying to achieve. I'm not going to give it you all at once 'cause you wont learn...
  8. Parker

    Books About Access

    Sorry ghudson -------- Ah well; Great minds think alike :D
  9. Parker

    Books About Access

    You could try reading this first :D
  10. Parker

    Undefined Function in Query

    Thanks Pat Did you mean to give me a link on that or is it just to search this forum?
  11. Parker

    Distiller defaults to B&W in Access?

    I have Adobe Pagemaker that includes Distiller V4 and I don't have that problem either. So I think it must be your installation.
  12. Parker

    Tables only stores rounded number

    OK I'll take a look at it when I have 5
  13. Parker

    Tables only stores rounded number

    Why not just use the report and publish it to word?
  14. Parker

    Tables only stores rounded number

    :confused: :confused: :confused: How are you importing this info into word? Are you baseing your word doc on a report? If you have set your properties in the table and then base a report on that table -- Publish it to word then word just imports the report. So I don't understand why you...
  15. Parker

    Undefined Function in Query

    Bump I'm gonna bump this because I still havn't resolved it and now it's driving me nuts. I think I've followed all the right rules but I still can't call this or any other UDF from anywhere -- Query, form or macro. I get the same message all the time "Undefined Function 'function name' in...
  16. Parker

    Search web and record http address

    OK I've looked for this one and can't find any intelligent answers. 2 problems 1) Is it possible to create a web search facility from within an Access db? If so. How? 2) If this is possible, is it also possible to capture the web address of a found useful page and place a link to that site in...
  17. Parker

    Inserting new records into a subform

    Theres lods of help on this subject already on the forum. Use the search facility.
  18. Parker

    Splitting a database

    There is a limit to the number of users at any one time but that is over 200. I don't believe there is any limit to the number of access points. Excepting the limitations of your network. Yes set up user security. But my advice would be to develope this befor you move your db. Be carefull and...
  19. Parker

    How to import pdf file?

    Hi Rodney Why would you want to store a .pdf in your db? I would just create a table to hold links to the file and store the file elsewhere. Doing this you can give the file links meaningful names and use a pick list. HTH
  20. Parker

    One two Many - choosen by a form check box??

    Read up on 'Relations Collection' in VBA help. Using this you can write a piece of code that will do what you want.
Back
Top Bottom