Having the same problem and after searching this forum I found how to fix it.
You can go to the table design and leave blank the formatting property of the affected fields.
Hope this will fix your problem also and thanks a lot to that people who posted how to resolve it (so sorry, I don't...
I have Explorer 6.0 under Windows 2000.
For some reason I don't know, if I click a link to a page that comes in a new window it takes too long to open.
This started to happen a week ago and apparentely nothing has been changed before.
Any idea of why?
Thanks.
I have placed it at the Form B close event. It works fine.
And.....I don't want to abuse of you both (if so let me know), but why is not a good place On Activate?
Many thanks.
I have a form (let's say Main) which has a button that opens another form to add data.
When I close this second form I want the Main one to display the new data. But it doesn't unless I close and open it again.
I have tryed the docmd.requery and to unload and load the form again by itself, but I...
Well, I have to do it in that way and later apply some more calculation I don't have problem with, and of course I have startdate and enddate fields.
But don't worry, I know how to do it with Access, the thing was if there is anyway to do it with Excel.
Thanks a lot Mailman.
Well, I have to do it in that way and later apply some more calculation I don't have problem with, and of course I have startdate and enddate fields.
But don't worry, I know how to do it with Access, the thing was if there is anyway to do it with Excel.
Thanks a lot Mailman.
Hi Mailman,
Thanks a lot for your help but I don't get it.
I know how to do it if I separate the month, day and year for each date in new cells and later on I sum all of the rows. But I was wondering if I could do that with just only one step.
The thing to do this is because sometimes we have...
Hi,
I have a column with several rows that show dates.
I would like to show in a cell the sum of all the months months, in other the sum of the days and the sum of the years in other one.
Ex.
9/12/2008
10/11/2008
10/21/2008
Sum of the months: 29.
Sum of the days: 44.
Sum of the years: 6024...
This is how I did.
At the combox box property "Row Source", place how do you want the report names to be displayed:
"Report1";"Report2";.......
At the AfterUpdate property place:
if me!ComboBoxName!ListIndex=0 then
docmd.openreport "Report1Name", acViewPreview
endif
if...
Hi all,
I have a form with a ListBox.
I don't know why, but suddenly it doesn't show the fields, it only shows that fields that have a Date format.
Any idea of why this is happening?
Thanks a lot.