Search results

This is my form(s) the code I used to put the buttons on is Private Sub invcopy2_Click() Dim sInvoiceNo As String If Me.Amount > 0 Then If IsNull(Me.InvoiceNo) Then Exit Sub [Forms]![Event Log].Form.[copyinvno] = Me.InvoiceNo DoCmd.OpenReport "copyinvoice", acViewNormal, ""...

Hi, I have a subform datasheet that lists all invoices and payments for the client displayed in the Parent form. On each row i have a'Print' button to print that invoice. This all works fine. However the print button is also displayed on the 'payment' row (each row is either a payment or...

I did delete the Macro on the Event property before I did wrote the VBA. This didn't work, so I deleted the button, created another button and called it something different. That did work. Thanks for your help, all working great now.

Thanks for your help. A strange this is happening, If i use a macro the button triggers it fine, but when I use VBA I get nothing, no trigger at all. I have lots of controls on the parent form, this is the first control on the subform (the VBA is empty). The continuous form is a sub form, I...

I'm currently using a macro, but i dont mind using VBA if its easier. the invoice number changes on each line, so the button must be able to pass on this number. but I'm not sure how i do that

Hi, Can anyone help please! I am trying to develop a 'Print copy invoice' form I have a continuous form with the following fields (already issued invoices) Date / Invoice / Description / amount / [Button] I am trying to print the invoice on the line then the button is pressed. (there could be...

I think I have sorted it. I have no idea why it was doing it but I re-wrote the SQL statement to :- SELECT *FROM [Invoice No] WHERE ((([Invoice No].[Client Ref])=[Forms]![Event Log]![Client Ref]) AND (([Invoice No].Date)<=Format([Forms]![Event Log]![stat_date],"dd/mm/yyyy"))) ORDER BY [Invoice...

I have tried to 'retro fit' a 'Client Statement' to our database. we have 400+ clients, our database has been invoicing for about 15 years, (Access has been converted to 2010), I was not part of the original programming but I have done quite a bit to it to bring it up to date. The invoice...

Can anyone help? I have a table of invoices, what i am trying to do is enter a date in a text box then get the total invoices up to and including that date. Sounds simple, and it all works fine until.... If I enter a date, say 27/8/16 and the last invoice raised is actually on 20/8/16 it totals...

Thanks for the reply, The code I found online as a copy paste. I've used your coding now. It still didn't work. I've re-booted my computer and it now works. Strangest thing I've seen in a while. Thanks for your help :)

I created a button that triggers a website yesterday, it worked fine yesterday, but today nothing happens, this is the code Private Sub SE_Click() Dim ctl2 As CommandButton Dim UTR2 UTR2 = Replace(Tax_Ref.Value, " ", "") ' Remove spaces Set ctl2 = Me!SE With ctl2 .HyperlinkAddress...

I'm using Access 2010, I totally forgot about conditional formatting :(( Sorted thanks .

HI, I have a multiple item form (Event_log) as a subform, listing all activity from the client on the main form. there are hundreds of entries on the Event_log. I am trying to turn the text of the 'event' field blue if the event filed contains the word Invoice. (to find them faster) I have the...

Hi, I am quite familiar with Access, but not the Navigation form. I have 2 questions, if anyone can help it be great? I am wanting the form with tabs across the top and down to the left, I have 3 tabs on the top (at the moment) and 9 down the left. When I client on the 2nd tab, the left column...