Search results

Is this possible to print the same report 3 times(produce 3 copies) with 1st copy has label "1st copy" 2nd copy has label "2nd copy" 3rd copy has label "3rd copy" When user click the button "Print" it should print 3 copies with 3 different label values. Thanks.

Or Export it to .snp (Snapshot) format. Then download free utility from microsoft.com in order to view and print report later. By the way saving to .rtf - not allow to see line control.

"Select YourFieldDate where Month(YourFieldDate)=Month(Forms!YourFormName.txtInputDate)" Something like this.

Did you apply the latest Service Pack? Did you upgrade SQL Server driver to version 2000?

Type L00000 expression in input mask property in textbox control. Also you can validate 1 letter for "W" or "C" value like Private Sub YourTextBoxName_BeforeUpdate(Cancel As Integer) If Left(YourTextBoxName,1)="W" Or Left(YourTextBoxName,1)="C" Then Else MsgBox "Invalid 1st character!"...

On Form_BeforeUpdate() event place code something like this: Dim ctl As Control If Me.Dirty then If ctl.OldValue<>ctl.Value then .....you logic here(send both values in table or in e-mail) End If Else End If End Sub

You probably need another field with Date/Time data type which stored Time. Use Time() built-in function as Control Source.

In report textboxes properties for dates find format and type mm/dd/yyyy.

What you can do is to adjust detail section height of report such way that it show you 10 records(mean distance between rows) You have to experiment(play) with this until you satisfy.

Also you should check WIDTH(no more than 6,5 inch with margin 1")

First try to create a new database, then import all objects from the original one, compile new db and repair/compact. This might help.

What if the database is public and sharable without any difference between users? Is this still good idea to secure db using group and permissions?

Hi everybody, What is the best way to prevent importing objects from another database using File-->Get External Data-->Import? Seems to me that if database does not have password , anybody can use the above feature and view data or source code!!! Thanks

To Mile-O-Phile. Your Location shows Glasgow, Scotland in Russian letters. Are you from there?

Thaks a lot Namliam. You are right. Without AM/PM it allows me to store with 24 hours format!!!

I am trying to insert Time to TEXT field by using Format(Now(),'hh:nn:ss AMPM') like: DoCmd.RunSql "Insert into TableTimes(MyTime) values(Format(Now(),'hh:nn:ss AMPM')". With Morning Time I am OK: 08:14:23 AM. Afternoon Time like 01:20:32 PM should look like 13:20:32 PM!!!!! How should I...

You Graph Chart based on RowSource. Your fields M1 etc. presents in Chart as in horizontal line. Sequence of months depend on M1,M2 etc. You have to manipulate with your fields values(sequence) in the query in RowSource. It works for me in Report Graph Chart.

I think you need go to the Graph property, find RecordSource and make field changes there.

You have to run VBA code from another database like: DBEngine.CompactDatabase DBName, NewDBName

Assume table name is "NumbersBetween" and filed name "MyNumber" Private Sub Command1_Click() Dim intMin As Long Dim intMax As Long Dim ii As Integer intMin = DMin("[MyNumber]", "NumbersBetween") + 1 intMax = DMax("[MyNumber]", "NumbersBetween") - 1 DoCmd.SetWarnings False For ii = intMin To...