Search results

  1. C

    Solved Only 1 column of combo box query is getting information, the rest are null

    i had not, i did not realize this was a thing, problem solved, thank you!
  2. C

    Solved Only 1 column of combo box query is getting information, the rest are null

    Hi all, To give context, i am using microsoft's goods database, but modifying it slightly to my needs. On the Purchase Order form, there is a combo box to select a supplier I am going to be passing the details from this form over to a report to send off as an order form In order to do this, i...
  3. C

    Getting Multiple Order Items to report

    Hi there, I have an order tracking database (its the pre-made Goods Database by microsoft but modified slightly to my needs) I have the purchase order form with the subform that allows for multiple products to be selected from the selected supplier I am making a report that will be an order form...
  4. C

    Solved How can I modify the Microsoft Goods Template Database

    Yep you get all the code, macros etc. it all works perfectly. I converted all the macros to VBA and am in the process of tweaking it to my company's needs Good news, there were several templates for the AWA that I thought might be useful.
  5. C

    Solved How can I modify the Microsoft Goods Template Database

    Hi there, i managed to get it to work! you can't import web based objects but what you can do is open each web based form, table etc and then do File\ Save As\ Save Object As\ Save As Client Object What this does mean is you have to do it for every single object in the database that is web...
  6. C

    Solved How can I modify the Microsoft Goods Template Database

    Hi there, Apologies if this has been asked before, I couldn't find anything on it. I have downloaded the Microsoft Goods Database, it is extremely close to being exactly what my company needs bar a few tiny modifications (another combo box on the purchase order form so i can select who the...
  7. C

    Subform isnt adding first field to table

    Thank you very much for the tips. It's nowhere near done, i have a lot to learn but i appreciate your time and efforts. Sorry again to be a pain
  8. C

    Subform isnt adding first field to table

    Thank you, i'll have a look, its just difficult being one of the only IT orientated people in the business, these kinds of jobs get put on me :/ no doubt i'll be back with more silly questions in the future
  9. C

    Subform isnt adding first field to table

    i have absolutely no idea because im so new to this :/ ive just been trying different things. That timer was to get the net price to update automatically based on the quantity and unit price because i couldnt figure out another way Like i say, im very new to this, are you able to explain an...
  10. C

    Subform isnt adding first field to table

    Perhaps, i am very new to access though so all of these things are all foreign to me, i know what autonumbers are and primary keys etc but i basically need things explained in steps. i know im hard work, sorry😕
  11. C

    Subform isnt adding first field to table

    yeah i can, its nowhere near finished or operational yet, im just trying to get the fundamentals working and will probably make the seasoned professionals cringe big time because its a bit of a mess at the moment but here it is I wouldn't be opposed to using a pre-made database and slightly...
  12. C

    Subform isnt adding first field to table

    Here is another example, the two parts are under the order number "ORDER" the orders table recognizes the order number as "ORDER" the order details table also does, but only for that second part (Part 5678)
  13. C

    Subform isnt adding first field to table

    i havent changed a thing in between. both of those records came from the same order submission
  14. C

    Subform isnt adding first field to table

    I dont think so, ive made sure it isnt but it still does the same thing, i have a whole plethora of issues to be honest with you, im just trying to attack them one at a time Unless by edit mode you mean it still looks like a datasheet? in which case i will be sad because then i wont know how to...
  15. C

    Subform isnt adding first field to table

    Hello, i am absolutely brand new to access and no basically nothing at all I was supposed to do a unit on databases for my extended diploma in IT but i never got to learn anything because the virus shut my college down Anyway, i am making a database system for the company i work for...
Top Bottom