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...
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)
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...
First, my customer wanted me to make a navigation menu. Then, they wanted to align to the center like figure no. 2. I tried to use anchoring but it didn't work for me and I also tried to put the form into a sub-form but I don't see the way to make them to the center either. Anyone have a...
Hi, I need some help when i anchored my objects as shown in PIC1 but when i opened form in form view there's an unknown spacing between the middle and right as shown in the PIC2. Any advise? Thanks in advance.
PS. I've checked that i have snaped all the objects to grid.
See the attachment of this reply. I want user to input a name of formula then lookup for it in the same query and store it in the same query as well. Is it possible to do that? Or any other idea if it possible.
Hi. I'm new for MS Access here. I really want to ask if it possible to lookup for value in the field in query that match the field name?
For example here ... I created a query containing ...
FormularID
DimensionA for input
DimensionB for input
Formula1 =...
Hello. I'm working on a bar bending schedule for construction and cost estimation and I'm new to MS Access and have no idea what the VBA look like. Though at some point, I'm working on how to lookup for an image to match the input bending code in the subform as display in my attached photo.
I...