Search results

Sorry now is working Thank you

I get error variable not defined Sub Search() Dim strCriteria As String, Task As String Me.Refresh If IsNull(Me.followupFrom) Or IsNull(Me.followupTo) Then MsgBox "Enter date", vbInformation, "Date Range Required" Me.followupFrom.SetFocus Else strcreteria = "([follow_up] >= #" &...

Hello Gasman, I get error variable not defined

Dear All, With this vba I try to do a search with the date I get an error What mistakes did I make I use below VBA Private Sub cmdSearch_Click() Call Search End Sub Sub Search() Dim strCriteria, task As String Me.Refresh If IsNull(Me.followupFrom) Or IsNull(Me.followupTo)...

Dear MajP, i get error see attach the file

Dear All, How to show the data from combobox on listbox Example Combobox 1 Afgehandeld 2 Ingediend on my database listbox showing 1 instead op Afgehandeld Please help how

Dear Gasman, Could you please look example, I can learn from it Thank you in advance for your help

Dear Gasman, When I klick on CMD all data wil be save as one Report. I Would like to save the report every claim ID as one pdf file Could you please help me how to do that see example pdf file

Dear All, How to create a filter on the Query to be able to save the report only showing data on form Without filters all data will be save in one pdf file.

I get error method or data member not found

Hello Gasman, How to do that with the VBA Could you please check the VBA

Dear All, I want to save Raport in pdf by name, depending on the information in the Claimnumber ( textbox) and City (combobox) With below macros I get the results. 235645262.PDF instead of 23564526 BDN. PDF Claimnumber = 23564526 City (combobox) : ID data type 1 DPS 2 BDN 3 JKT I hope...

Well done Mike

Dear All, Who can help me with a formula within Access? Sum all [Bedrag] from [btw Code] ==> BTW Code 1 Sum all [Bedrag] from [btw Code] ==> BTW Code2 Thank you in advanced. I use formula for the totaal =[Q_verkooporder_regel Subformulier].[Form]![Totaal bedrag] Thank you...

Hello, If you have time could you check my file and fix it? So I can change the price

Dear All, I would like to change prices for all items, the thing is I don't want to change the of any historical records, only new records. All help will be appreciated. Rania

When a costumer brings back 1 item, we make a credit invoice for the costumer. Question: Do you know how to add on Report : 1. If total invoice with (-) example -1000 must be credit note en if invoice total (+) example 1000 is invoice ( on Head of the report) 2. it's possible the invoice number...

(-) amount is for, if customer return the product ! if you have advice for this please lets me know? Thanks in advance for your help

Dear arnelgp, Yes thats what i want! could you please check on the Query =Qfactuur I dont see the amount from the invoice, what am i doing wrong here? see photos Greetings,

Dear All, I hope you can help me to make a form so that I can see all the orders I made. If I click the order number ( hyperlink) to the form Creat order en invoice will be opened and then I can fix the order en save again I made all these orders with the form Name Creat order en...