Search results

You are totally right I didn't explained well myself. In the table age will be saved as number in our case 30 because for us is important the age and not the birthday.But as long as in the papers sometimes is written the age and sometimes the birthday I want the age to be calculated...

I have a birthday textbox datatype number.Is it possible in this box for the user to enter both formats number like 30 or 13/01/1981 and the age to be converted in number? Please help Regards

Hi. I don't know what's wrong with this query GrupMosha: (IIf(([Mosha]<=19),"14-19 vjec", IIf(([Mosha]<=24),"20-24 vjec",IIf(([Mosha]<=29),"25-29 vjec",IIf(([Mosha]<=34),"30-34 vjec",IIf(([Mosha]>34),"Me shume se 34 vjec"))))))) but I cannot get data range 30-34 for birthday 1979.The other...

Please regarding your function SendTQ2Excel how to make possible that my reports in form field1 field2 field3 total do not convert in excel in the form total field1 field2 field 3

Hi. I make the export of my Access reports using SendTQ2Excel posted before in this site http://www.access-programmers.co.uk/forums/showthread.php?p=1041091#post1041091 Everything goes fine beside that my reports of form field1 field2 field3...total are exported in Excel in the form total...

Thx the function SendTQ2Excel works perfectly. Anyway I got a new issue. My reports are of form field1,field2,field3...total. After export in Excel field total is the first and after that field1.... How to repair this problem and make the reports in Excel like the ones in Access? Regards

docmd.RunCommand acCmdSaveRecord Me.TabControl.Pages(0).SetFocus Changed the code in the button and now my form doesn't open at all:(

Hi. I have a tabbed form where all fields inside tabs belong to a single record registration.The registration of record is accomplished after passing through all tabs.Is it possible to create a button in the last tab which makes possible record saving and automatically send the user to the first...

Exactly that is the problem when I press new record there are still some old datas shown there...

Hi. In my tabbed form controls show some values from the control sources. How to keep them empty before user enters data himself? Regards

My DB is a single table where every field of tabbed form corresponds to a single table field..:(

Hi. I got a tabbed form.To a single record corresponds data entered in all the tabs.I don't know why when I enter a new record in some tabs there are some old data. I need all fields in the tabs to be empty when i press button new record

Hi. I'm merging some Access db with the same structure of tables. As long as I don't want ID numbers to be overwritten I deleted Id columns I merged the data in a new table and now I inserted a new column named ID. How can I auto fill this ID columns because it is too long to insert data manually..

Hi Basically I have a tabbed form.Filling all the fields in these tabs is needed for a full record.How to make possible that when I complete a record I go automatically in a new record? Regards

I have a tabbed form. A full record is created after filling all the fields in the tabs.I noticed that when I move from tab to tab in some fields there are still some old data shown.How to make possible than when I press new record button all the fields in the tabs become empty by default so to...

Thank you for the advice. But still not very clear.I have a tabbed form and moving through tabs user enters the record data.Now if we use navigation buttons and see a record is it possible to delete this record?

How to make possible that every field in a tabbed form to be empty when we press button New Record? Regards Endri

Hi I need a button to delete selected records and not all of them.Is this possible? Regards

Hi I builded a report based on the query as in picture attached. GjendjaFamiljare is 0 = Single,1=Married,2=Divorced,3=Widowed. My report works fine for this value but I need to add another 4=N/A where is described data missing(the user does't fill this value) How to make this happen? Thx

I need to merge table1 from each db using merge tool.But this is not done correctly because of ID column.Please help with the script