Search results

Hi guys, I'm stuck in this one. I want to view some textboxes in my form, and add them into a listbox, but I need to take care of empty textboxes. This is the code I currently use, but it only works if all textboxes are filled. Thanks in advance... Private Sub Form_Load() Dim strMsg As...

Hi I'm struggling with this one. I want the data from some fields entered on my form appear in a listbox. The following code isn't working at the moment. What's wrong?!?!:confused: --------------------------- Private Sub Form_Load() Dim lst1 As ListBox Dim strMsg As String Dim entity1 As...

Hi, I am trying to send a value to my report from a form. In the report I have a unbound textbox called "contact". On my form I have a combobox called "cbocontact". When i am trying to open my report by pressing the button, the value doesn't appear into my report. What's wrong...

I want to sum some values in my report, but it gives me an error: You entered an expression that has no value. Option Compare Database Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim runsum As Integer runsum = Me.quantity1 + Me.quantity2 + Me.quantity3 + Me.quantity4 +...

Hi, I want to appear the last 2 digits of the year. for example "07". Now I am trying this with datepart, but it gives me an error, while opening my report. what's wrong?? Thanks year = DatePart("yy", date) this one works: Year = DatePart("yyyy", date) but it gives me the full year (2007)

Hi guys, I want a button on my form that prints data into a table. My code doesn't seem to work. Someone knows a solution?? Thanks!! Private Sub invoice_Click() Dim no As Integer Dim amount As String no = clientno.Value amount = amount.Value DoCmd.RunSQL ("INSERT INTO invoice ([no]...

Hi guys, just a short question, I want my autonum. to be in 3 decimals: 001 002 003 004 etc. Someone has a suggestion?? Thanks a lot. Stefan

Hi guys, just a short question, I want my autonum. to be in 3 decimals: 001 002 003 004 etc. Someone has a suggestion?? Thanks a lot. Stefan

Hi, i would be very happy, if someone could give me some advise, because I am stuck for a while... :confused: I want to filter my results into a report. I have some listboxes in a form, one of them is strContractcity. This one is to be copied to strContactcity2 and strContractcity3. (For...