Search results

It seems a lot of people are using calendars other than the built-in calendar (Access 2007). QUESTION: Is it possible to get the Access calendar to pop up automatically when entering an unbound text box? I can get the little calendar icon to show up, but I need to click on it to get it to...

Mmm ... There must be another issue. I've attached a zip copy. If you can see what I've done wrong, then I'd appreciate getting your feedback. Thanks, Bob.

Do I need to bring the autonumber fields into the Detail section of the form? I don't really want them to be visible.

It's been a few months since I've used ACCESS and I've forgotten how to do something. I have 2 tables: tblClientInfo ClientID (autonumber) (PK) StreetAddress City StateProv PostalCode tblClientName ClientNameID (autonumber) (PK) ClientID ClientName EffectiveDate There is a 1 to many...

The underlying data for a graph contains a date column with a bunch of dates in 2010. I've created a scatter type graph and the strange thing is that the dates are showing up as 01/10/1900 (as an example). In fact all the dates are ending as 1900. I've tried re-formatting, but my attempts...

Looks good, Endre. Thank you. I noticed there is a VBA module in the access file. I'm no expert on VBA coding, but it looks to me as if that module isn't necessary. Is that correct?

Thanks, Endre. That works, sort of. The only problem is that the number of days between entries varies, but I am setting the width of the error bars to a constant amount. Perhaps what I need to do is to repeat the $ balance for each day of the year, until it changes to a different amount.

Yes, that shows how the data points occur at irregular intervals over time. One other question: If I wanted to show the data as columns, is there a way to vary the width of the columns?

I would like to create a chart / graph with dates along the horizontal axis and dollars on the vertical axis. The underlying data consists of 2 columns: $ amounts in 1 column and dates in the 2nd column. IMPORTANT POINT: The time period between dates varies. QUESTION: Is there a way to...

I have a spreadsheet with 10 columns of data and approx. 5000 records. I want to filter the records based on 2 of the columns - which I have done. Then I plan to sort the remaining records (based on the contents of a 3rd column). Finally, I want to sub-total the "Amount" column (Column...

Thanks for the recommendations, Bob.

It may be too soon to ask, but does anyone know if there are any good reference books out on ACCESS 2010 ? If you have a recommendation, I'd be interested in hearing your review(s). Thx.

What is the latest estimate of when ACCESS 2010 will be introduced? Will it be part of a new Office Suite? OR will it be introduced on its own?

I tried using TransferSpreadsheet and when I opened the Excel file later, it was illegible - just a bunch of gibberish. Any suggestions ?

Thanks, SOS. I was focussed on the controls above the paint brush and didn't even notice.

In ACCESS 2007, how do I draw a horizontal line on a Report? In Access 2003, I recall that this could be done in Design view. But I can't seem to do the same thing now that I'm using ACCESS 2007.

Thanks for confirming, Bob. You have saved me from "spinning my wheels".

When I create forms, I often use the naming convention frmNameOfForm. Then I will change the caption property of the form so that the tab of the form does NOT show frmNameOfForm. I replace it with something more user friendly. I'd like to do the same for my queries. Is it possible to...

I tried the requery suggestion, but it didn't work. The 2nd try at the combo box still showed the record which I had just tried to change. The updating of the record isn't occurring until the form closes. Maybe I do have to get into ADO and recordsets, after all, to solve this problem.

I'd like to place an unbound control on a form and use that control to input dates. I have tried using Microsoft Date and Time Picker Control 6.0 (SP6) and it is working alright. But I don't care for the fact that it displays a default date when the form opens. I posted a question about...