Search results

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

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

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?

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

I have two table, I containing make and model of cars and a few others. I have another table containing all the feature of the car linked via "Stock Number" I have a form and subform linked using the field "model". But I have designed the main such that I can filter the sub form using "Model"...

In MS Access 2003 I used this code to compact and repair my database, Public Sub CompactDB() CommandBars("Menu Bar"). _ Controls("Tools"). _ Controls("Database utilities"). _ Controls("Compact and repair database..."). _ accDoDefaultAction End Sub But for some reason this...

I have a form with a field that require the user the enter the date. This can be done either by enerting the date or clicking on a command button that opens another form with an Active X MSCAL.Calendar.7 When the user select the date, the date field will be filled by the date selected and the...