Recent content by Evon

When I run the expression (Summary) in the query, I get results and no error message. The only problem is I am getting the output from the wrong combobox column.

I feel you are complicating the problem. All I am saying is: if you have these fields in a query, what expression would you use to group them all together in one column of the query design view. The fields are enclosed in brackets [ ], and they are: Summary: [Comodity] & "," & [Comodity1] &...

Summary: [Comodity] & "," & [Comodity1] & "," & [Comodity2] & "," & [Comodity3] & "," & [Comodity4] & "," & [Comodity5] & "," & [Comodity6] & "," & [Comodity7] & "," & [Comodity8] & "," & [Comodity9] All of the data in the above fields in a query are generated from comboboxes in the...

Some of the fields in the query are populated from comboboxes in the underlying tables. So when I run the queries these fields populate with the required data (column 2). When I try to group those combo generated fields I get a summary of column 1's instead of the desired column 2's.

Seems as if my thread has been hacked. I am seeing some java script type coding below it. Anyway, back to the post. That is exactly what I did but because the fields are generated from a combo, I get a summary of the bound columns (column1 of each field). I want to find a SQL expression that...

I have a situation where I use the output of a combobox in a query. When I run it everything is fine. Now I want to make a summary of 9 of these text fields in the query. However, when I do this only the bound columns show up in the summary field. I can't get a summary of the second columns of...

Yes Doc, you are unbelievable! I actually played around with that control's properties but somehow, I never got through. Everything is working like a charm. Yes, the database as I said was kind of clumsily built so I may just continue the new one in parallel. But once again, hats of...

Highten Main Form from the switchboard or Highten Trading from the Nav. Pane. On opening you will see the Purchases and Sales pages. The incremental number control is "text721 at the top of the form on the Sales Page.

Okay Sir p, this is the database. I will remove it shortly.

Thanks, no it is too big. The design is kind of cumbersome. I had not really planned it out before and kept on changing as I went along. I have decided to build it over from scratch. So I created a new database and started importing and editing some of the tables. The table with the index...

Yes, I tried it without the tab reference in another form I created specifically to test the code within the same database and also some other forms in another database. The code worked perfectly. However, when I run it on this particular form, it works for the first increment then I get a pop...

This works on a regular form without page tabs: If Me.NewRecord = True Then Me.YourCounterField = Nz(DMax("YourCounterField", "YourTableName"), X) + 1 End If Just cant modify it to work in a page tab of a form.

Can some one help me with this code. I have 2 page tabs on a form, and I want an incremental number assigned to each new record on that page. Been doing some research and this is what I came up with: Private Sub Form_Current() If Me!tabSupplier.NewRecord = True Then...

Point taken my friend. Anyway, I have another one for the forum. Been doing my research as usual, but still have not found a solution that is understandable at my level: I am working in a form that will generate an invoice report. The form is set up to facilitate 10 lines per page on the...

Found the problem. Examined the code for the form that opens with the database and found a code that Access was trying to run on "got focus" . However, I had renamed the control. So I deleted the Private Sub code. Still, big-up to my new friend pbaldy anyway and nuff respect, and sir we are...