Search results

  1. B

    exporting to excel template

    hi all, is it possible to create an excel template and use it when exporting a table using the external data, export to excel option? if so how?
  2. B

    print a crystal report filtered to a data row that is on a form

    hi theDBguy, thank you for your quick response , the report is on a form and is quite easy to open it just " open form2.show" you can put code on the onload, but i do not know how to go about this, if this was access it would be quite easy to to a open where clause , but i don't know if this...
  3. B

    print a crystal report filtered to a data row that is on a form

    hello can you help please , i have a form (frm1) with a button to open a crystal report to show all the data in a database what i am trying to do is get the report only to show the row of data on the (frm1), i have the button working and it opens the report but it is showing all data rows...
  4. B

    excel to table

    thank you all for your advice, I will try it without the unique id first:)
  5. B

    excel to table

    hello The_Doc_Man, what i am trying to acheive is this, in an existing datbasethaty we are using in work, one of our team is using an excel spreadsheet, he likes the way we do searches in the database and has asked can we link his sheet to it (this i have done) but i need place a primary id to...
  6. B

    excel to table

    thank you arnelgp, can i get htis to auto update as well?, if so how
  7. B

    excel to table

    hello all, can you help please, i have a datbase with a link to an excel sheet,(linked so any updates on the excel sheet is shown on the link in the database). question can i make a table from this ? if so will the table auto update from the excel sheet, the reason i want to do this is that on...
  8. B

    text box with auto number

    hi I have just tried this and it does not increment by 1 every time, any ideas:banghead:
  9. B

    building a database from scratch

    hi all, i have built several small datbases to date with the help of members on this forum. one of the issues i have is it does not matter how i go about designin the DB i always seem to forget something (password setup ) for example, do you have a sequence of setting up a DB ? do you decide...
  10. B

    text box with auto number

    mike60smart hi, why do you recommend I do not use the method I found?:confused:
  11. B

    text box with auto number

    just found this, works a treat https://youtu.be/ClvW6QO6fCI?t=56
  12. B

    text box with auto number

    hi all can you help please , I want a text box on my form to show a number that will generate a new number every time I create a new record, I now I can use the primary key but I want it to show "00000" to start and next record to show"00001" etc any ideas :confused:
  13. B

    dates issue

    thanks all i went for JDRAW's solution and it works great
  14. B

    dates issue

    hi can you help please , i have a date textbox that uses a date picker, i want to be able to restore original date if certain conditions are not met, i know how to set the conditions but not how to replace any update with the original date, any ideas please :banghead:
  15. B

    error message

    think i have solved this, i have made a carbon copy of the hyperlink field and copied this onto my form, now i get no error messages, i dont know what was wrong with other one but this one looks ok
  16. B

    error message

    hello James Dickinson/Gasman, thank you for your response, but none seem to work . the field i am trying to put the hyperlink is an hyperlink field so it should work, (the link works after the error message goes and works ever time i click on it ) the database has a lot of files in it (around 8...
  17. B

    error message

    hi all can you help please, i have a hyperlink field on my form and when i drag a pdf link to it i keep getting this message "the field is too small to accept the amount of data you attempted to add, try inserting or pasting less data. but the strange thing is that if i click on another field...
  18. B

    dates issue

    thank you ranman356 , works a treat :)
  19. B

    dates issue

    hello all can you help please i have a text box [six month update] this uses a date picker to populate it , what i want is after update to add 6 months to the value in the [six month update]text box , i have tried Me.SIX_month_update = DateAdd("m", 6, Date) but it keeps coming up with 06/09/19...
  20. B

    mouse over issues

    found this and seems to work Private Sub lbl122_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) info.Visible = True Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) info.Visible = False End Sub
Top Bottom