Recent content by rohnds

I have date column and not all the data have day, month and year. Some of the data only have month and year. How can I create a format such that when I enter, say 7/2001 It should display : July 2001 But if I enter: say 3/7/2001 It should display : July 3, 2001 Thanks Rohn

It is my understanding that size of the db is MS Access is ~ 2gig. I doubt if I would have 3 millions records in my application but I would like to know the what size either of those two would use. Thanks, Rohn

I have a field named as "StockNumber" and is defined as Integer (Long). The values of this field range from 000001 to 999999. My question is this, what defined is more optimal in storage amount? Would it be better to leave it defined as Integer (long) or should as redefined as Text with length...

I have form with a unbound object frame linked to MS Word document. But when I make changed to MS word, changes are not reflected in the form. How can I link the MS word document to the unbound object? Rohn

If the sub form doesn't contain record matching the criteria (link) from the main form, nothing is displayed. This is how sub and main forms works. And this is how you want it to work.

Here is who I did it: Dim sortFlag as Boolean Private Sub Form_Load() sortFlag=True Me.OrderBy = "name of field" Me.Refresh End Sub Private Sub name of field_Label_Click() Me.OrderByOn = True If f1 Then Me.OrderBy = "name of field DESC" f1 = False MsgBox "Sorted Decending Order"...

Then my next question is this. I you are using earlier version, how can I assign value to ubound field in a Report at start up. The value for these field would come from a form.

Thanks. That is exactly what I wanted. It

I tried it. But I keep getting "Can't assign to read-only property" error msg. What am I doing wrong?

I have small form that consist of nothing but a calendar. In the main form is a command button that opens this calendar form. What I would like to do is position the calendar form at certain position respect to the main when it open. Can this anyway be done in MS Access (I am using 2007).

I have noticed that Report_Load() option is not available for reports on earlier version of MS Access. Is this unique to 2007?

Here is what I want. I have option button. The default value is set during form load to "False". When the use clicks on the option, I want the option button to be set to False rather than True. When the user unelects, the option button should be set to "True" rather than False. The reason for...

How would you change the value of the option using vba such that the opposite value is stored. I tried creating a flag and then changing the value of the option button using vba but it just doesn't work depending on the value of the flag.

I have an option button on my main form. You click on the option button to display all the cars available. But in my table the available cars are stored "False". Is there anyway, I can change the values of the option button such that they work the opposite. For example, if I click on the...

You can change the .Picture properties of the image to the file using vba. Create an event BeforeUpdate for the combo and then in that procedure assigned the file name the .Picture property of the image. Private Sub Combo5_BeforeUpdate(Cancel As Integer) me!combo5.Picture="File name" End Sub