Search results

  1. M

    Solved Access error message I can't find the problem, Any help wound be be very welcome

    I made a database called LandG. It was working fine till Friday. But first some back ground notes. I have a front end and a back end files. That have been linked for some time with out any issues. I was feeling so good with myself. Backups saved all running well. forms and procedures and...
  2. M

    problem with images reloading on a form

    HI can any of you give me a hint were am going wrong. I have a form that user use to change or add new image relating to a stock id in tablesStock Images ate stored outside the database. only the images address (on the hard drive is is stored in the database) example A field called ImageAdd1...
  3. M

    Access 16.0 Object Library do i need it

    Hello all, I need a little help. I have a project in office 365, accesss vba. I want to use/add a Office. FileDialog box. but I need to add in a copy of Office 16.0 object libary object. but i can not find a copy of it on line. any one got any ideas...
  4. M

    Solved I have a design choice to make and am not sure which is the best way to go.

    Hello every one, hope you are all nice and warm on this cold morning. I have built a database that is used of a retailer of clothing shop. They are a small one man business with one retail shop. with no buget at all.. My fee for doing this a pint when the lock down is over, I need to add...
  5. M

    adding images to a form

    Hi all. I have a continues form that list around 2000 products. I want to show the image of each product . SO the user can look at the image to make sure it has the right product. I have the images sorted in a folder on the pc. I use a field in the products table to store the location address...
  6. M

    link a combo box to a list box

    HI I am hoping you can help me. I seem to have a metal block and can’t remember how to do this. I have a form, with a combobox (on the form header) that is linked to a table called suppliers. The table has the suppliers Name and IDcode and other information. When the user selects a supplier...
  7. M

    fonts size

    First of all A merry Christmas to all, I hope you have better thing's to do today the 25th than read this lol my eye sight is not as god as it used to be. I was wondering if any one know how so increase font size on the vba screen thanks mike
  8. M

    need help with an image problem

    I have bit of code below, that should open a image file. Namely a jpg file, that i or the user selected for the dialog box. But i keep getting an error "error message 20=Microsoft can't open the file'C:\Users\miked\2\LandM\images\6jpg' i have put in the references libraries as you can see in...
  9. M

    how do I link a list box to another list box

    Hi all, I hope you can help me. I want to use the selected row in a list box , which has 3 fields in it. CustID, CustADD and CustName. that will then populate a second list box with invoice details where the custid from a invoice table is = to the custID in the first list box. So that I have a...
  10. M

    Printer not found

    Hi I had a problem with my hp printer the other week, it ran our of ink. I refilled the cartridge and every thin was fine, until I came to use my database in access 2010 . The data base no longer see's my printer at all. I have un-installed and reinstalled the printer a few times already...
  11. M

    loading images for a array

    Hi all I have a form , on which i wish to add a number of images during run time I am using a image type to show the images. As they will be a lot of images to pick from, I am storing the images on the a drive, and have a table with the address of each image. ( this is to save loading all...
  12. M

    wERE CAN I FIND HELP TO CREATE HELP HINT ON BUTTON ect

    Hi all am trying to find out how to add help hint or note to a project. Does ant know were i could find some help on how to do it
  13. M

    I KEEP GET A ERROR MESSAGE run time error 94 invalid use of null

    When i Add this Dlookup below to my code "DOB = DLookup("[DOB] ", "staff1", " [DOB] = #" & forms!NewStaff!txtdob& "#") " I get the errror message the field DOB in the table and the venerable are both date type values The full bit of code looks like this sn = DLookup("[Sirname]"...
  14. M

    Dsum not giving expected results.

    tamount = DSum("[Invtotal]", "tblsalesinvoice", "[InvDate] >= #" & [Text150] & "# And " & "[invDate] <= #" & [Text152] & "#") Hia all, I was wondering if any of you have come across an issue I am having with the code above. It is simply calculating the total value of the field “Invtotal”...
  15. M

    Question using dsum with a text box

    HI am a bit stuck on a small problem I am using the dsum to get a total value from a field in a query. When I use the code 1 below it works fine 1) DSum("amount","QryPandLcaptialInvest","dateofinvestment >= #1-1-19# ") But I want the user in in put the date in a text box on the form. But I have...
  16. M

    i keep getting aa prompt box asking me to enter a parameter value

    The problem I have is this when i test a query in the datasheet preview they work no problem. But as soon as i put the query in to a form or a report. I get a prompt box asking me to enter a parameter value. If I click ok without entering any thing. It go to the report or from and work fine...
  17. M

    am brain dead

    Good morning every one. I have been up since 4.30. watched some tv and had a coffe then set to working at 5. 10. it's now 7.30 and am ready to go back to bed for a hour to recharge my body and my peanut size brain. But I have brain block, or am just stupid. My simple problem is I have a form...
  18. M

    Question astrange formatting porblem in vba

    Hi can anyone help me. I seem to have altered my vba, to not allow me to put a space between words. example when I press the space bar, the curser moves to create the blank space, but delete the space once I start writing again. So if I type "dim bank As integer" it appears as...
  19. M

    Am new here and to access 2013

    my Name is Mike Live in Oldham, nr Manchester. AM using MS access 2013 to write a small stock control and invoice system for myself Age too Old:):):) I tent to be a morning person and not look at the screen much after 5pm. Depending what am doing.
Top Bottom