Recent content by nax009

I'm doing a material take-off database. The values in the list box are come from calculated queries from various jobs. So when it comes to calculate the cost i decided to let user put the taken-off value to a table for further summation because some of my users would like to input manual cost...

Actually, I have a difference name though. and yes, i used a multiselect listbox

yes

the error said:

Hi, I need help with populating a subform from data in a listbox which contain data from a querry: q_sum_A Hereis data example from q_sum_A: CODE (Short text) VALUE (Number) NOTE (Long text) A 00 01 000 27.18 RC Footing A 02 00 000 0.88 RC Slab A 04 01 001 770 RC Collumn Here is my...

Thank you josef, you've been helpful.

Hello. Yes, a list box name LstSection

Greeting folks. I need some help with VBA coding for my filtering form contain a listbox: LstSection which have data from a query name q_mat_A06_00 . Here is the fields and some example data in q_mat_A06_00: ID (Primary key) CODE SHORTNAME DESCRIPTION LENGTH SECTIONTYPE 1 A 06 00 00 A-6 m...

How can I check by the way. Or just recreate it?

Hello. First of all i've created a sub form to record my data but the form did not display a new record correctly. Its look like a bug and it bothering me for a while now. Anyone with the solution? (See the picture)

OH!! That's work! But can I ask something? Why can't I use the button's position why a textbox?

I see, a good example. Are there any ways to get coordinates dynamically without forcing the cursor?

sorry for those messy code, here's the new one Option Compare Database Option Explicit Private Sub cmd_file_Click() Set objPopup = CommandBars("t_m_A_1") objPopup.ShowPopup Me.cmd_file.Left, Me.cmd_file.Top + Me.cmd_file.Height Set objPopup = Nothing End Sub

Hi I have created a command bar which popup when the user click "cmd_file" button. What I need is to replicating a classic windows menu bar (i.e. MS Office 2003 style) by create a button that show command bar popup below the button. But my problem is I can't find a way to put the command bar...

Hello. Lately, I've been busy to make some event to run on "on load" event in my continuous form but it seems the codes work with only the first record in the form as shown in PIC_01. So my question is; How could I make my codes work for all the records. Thank you in advance :) Here is my...