Search results

  1. R

    Excel Grinding to a halt - Looking for an Access Option

    Hello all once again! Your much needed help and guidance is required once again if any of you would be so kind. I currently manage my "Workflow" on a rather detailed spreadsheet, with a number of filters and over 1,800 records. My excel spreadsheet is shared between 10 people constantly...
  2. R

    generate report from listbox

    Hi, i'd like to be able to display all contents of a listbox in a report on the click of the button. I'm very new to all of this, I did some research and downloaded some code to allow me to create the listboxes, but im not sure mysetup would allow me to be able to print each one. I'm thinking i...
  3. R

    Unsure of best option to use.

    Ive got a list of domains which id like to keep records of eg. Category, date purchased, how long for, active or inactive. I have lots of domains so i reckon the best way to view these would be in spreadsheet format but im open to suggestions. Id like to be able to select what category eg, car...
  4. R

    Organising files for beginner.

    Hello all. Would anyone be so kind as to help me out with this beginners problem. I have a lot a books which i'd like to sort into categories. I'd like to be able to select a category from a combobox on a form, and for relevant books in that category to appear in a listbox. Upon clicking on...
  5. R

    creating soccer league table

    does anyone know how i would go about creating a soccer league table form. i would have an option to type int he results for each week in a textbox, eg sunderland 0 - 9 Newcastle Manutd 2-3 man city if one result is higher than the other then add 3 points to that team, if they are the same...
  6. R

    soccer tactics in subform??

    hello there, could someone please help me i'm trying to design a database for my soccer team. please view *.jpg attatched. I have a form called matchday and on that form i have a combobox with formations. does anybody know how, when a formation is selected from the combobox, the relavant...
  7. R

    goto new record automatically in subform!!

    hello everyone I have a form, which contains a subform - in datasheet view. there are 100 rtecords in the subform datasheet. i have used a macro so that when the subform is opened, it goes to a new rrecord.. but when i clcik on the next record of the main form, to enter data on the subform...
  8. R

    255 characters not enough in text box!!! (any ideas)

    hello everyone, any help much appreciated.... i have an estimate form where the user enters a job estimate, they also type a job description in a text box describing what they are going to do... thing is its not big enough. Is their a way of making it even bigger, or importing a word document...
  9. R

    Running sum - Backwards!!????

    Hello everybody, I have searched the forums and noone seems to have asked this questyion and i would like to know if it is possible. I have a report which shows VAT charged, and it is ordered by the orderdate, which i have DESCENDING. so it shows the last order type in, at the top of the...
  10. R

    query loop for thosands of records!!!!

    hello everybody. does anybody please have absolutely any idea of how to change a large number of records??? i have a product price field, and every year the price of products vary, by say 5 or 10 percent. does anyone know if it is possible to create a function where the user can increase every...
  11. R

    requery problem in combobox!?

    hey, i have a datasheet where products are selected from each combobox based on a category selected from another combobox. If a product from building is selected, it can be added to the "cart" then if i selected category "bathrooms" i have to requery it to show the avalable records, but it wipes...
  12. R

    showing report based on selected record?????

    hi, does anyone know how to show a report based on 1 record selected. eg, a bill for 1 customer only, if im viewing a customers details and payment due data, is there anyway to show just that 1, instead of a list of all the customers and payments??
  13. R

    Hi, I'm stuck on these comboboxes and need help please

    hi, i'm trying to select products from a subform but would like them to be displayed in their categories in comboboxes and if possible, sub-categories. I'm only a beginner and really dont know if i have set it up correctly! please take a look at the *.jpg and see if you can help me please. when...
  14. R

    creating text box/memo independant to each customer

    hello there, i'm trying to do a program where a builder can save particular job orders to each customer, i need a blank box though, so he can enter the job description for that particular job. i tried just using a text box, but if i type something in the description field for customer 1, then...
  15. R

    linking combobox to subform.

    Hi does anyone know how to display a subform based on a value selected in a combobox. I can get values to display in a combobox based on a combobox value selection but not in a subform. my combobox is called categories, and my subform products. Any help much appreciated, thanks.
  16. R

    selecting products to add to an order and calculate

    Hello there, lets just say that i have a listbox with, wood, glass, bricks in it. and i click a button to add this to my cart as such.and i type in the number of units required in a textbox, or whatever you think is best, and when i do this it adds up the cost. I would really appreciate some...
  17. R

    Simple Combobox Proplem, for you maybe, for me? hell no!

    Hi, Could someone Please help me, My Knowledge in Ms Access is restricted, and i have next to no experience in SQL. good luck in helping me. Basically i have 2 combo boxes, one called ProductCat, which has two categories, garden and kitchen. when i click on garden, how can i make the garden...
Back
Top Bottom