Search results

I think I already told you that selectobject will not work in these circumstances.

Forms are not designed to work like reports and they are not designed to print. If you want to print (open) a report just do it printing is not a screen thing anyway. If you want to view (preview) use snapshot viewer. I have provided a way plus you can also put a snapshot viewer object on a...

Sorry I assumed you were using a report. Then again I'm a bit slow I should have looked more carefully.

The Access environment does not understand animated gifs, it interprets them as still images. Your best bet is to run a sequence of images. You could use a compatible image control device but I don't know of such other than a browser object, but I think that would be over the top.

Function SetTextSize(FormName As Object) Dim UsersSettingSize As Long Dim ctl As Control Dim subctl As Control Dim subfrm As SubForm UsersSettingSize = 20 For Each ctl In Forms(FormName.Name) Select Case ctl.ControlType Case acTextBox ctl.FontSize = UsersSettingSize...

This will not work for reports because they cannot be popup/modal. This has been disscussed in detail here. I have also a solution for the report problem here

:confused: Hmm. Try toggleing with AutoSize on the Chart control. If you are in absolute dispair with ActiveX (MS Chart) there are other solutions that would work just as well.

Ok I'm pretty sure it is not a printing problem. Can you tell me what you use to populate the charts? Are you using any events at all?

Have you got layout for print selected? Have you put any code in the on print and/or on current events? What are you using for the charts Active-X?

I have Acc97 on this computer so I can't see your sample. But I presume they have to have the form open all the time and you store times for adding up. I don't think this is realistic. Having a timer on all day is a waste of processing time, and if the user is having technical problems they are...

Try this: Private Sub Report_Open(Cancel As Integer) Me.Filter = "[Sample Date] > #" & Format(DateAdd("d", -60, Date), "mm-dd-yy") & "#" Me.FilterOn = True End Sub

Try this link

No problem, I will look into your other problems after I go to the barbers. Incidentally =>10 to cancel will give you nine invoices.

I won't undercut you..not. :D

What do you use to create the bar codes?

In the before update of the sub form: Private Sub Form_BeforeUpdate(Cancel As Integer) If DCount("[InvoiceID]", "Transactions", "[InvoiceID] = " & Forms!MainForm![InvoiceID]) > 10 Then MsgBox "You can't have more than 10 transactions per Invoice" Cancel = True End If End Sub

In the OrderBy property of the report put [key field] DESC, and set the order by on to yes.

I not saying it can't be done but it is normally best to reserve forms for: Switch Boards Data Entry Data View forms are more for collating data for visual aids, unless the visual aid is specific to a record or a special case such as accumulation, calculated values or a summary in the footer.

I would not recommend exporting to snapshot. If you are using a dot-matrix printer there is really no need for a fancy report. I would recommend outputting it to a txt file. This way you can control the output size by character string length. Dot-matrix printers are great for this and it will...

Not nessarily. Can you explain in more detail what the timer is for.