Recent content by bigmac

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?

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...

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...

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

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...

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

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...

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

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...

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

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

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:

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

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:

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