Search results

Hi all, i would like to ask how to have duplication of text on the form. For example i have selected two data on my list box on the form and my form is only able to show one record at a time, hence if i want to do the second record i will have to click next on my form which will then display...

Hi all, i would like to ask how can i disable design mode in report, running on access 2007-2016.

Dear all, Would like to seek help in how to display multiple items on the form. Based on my screenshot I attached, I selected two colors (item in black) and retrieve on my form, but it populates two same colors onto my textbox. How to display two different colors on the textbox?

Hi all, I would like to seek help on how to have this remarks on every page of my form? Currently, i am able to show this header on page 1, page 2 and page 3 if i selected 3 records. I am unable to show the details that i have fill up in page 1 in page 2 and page 3. If...

Hi all, just a brief understanding of my database, I have multiple lines of colours, pounds qty and yards qty for the same fabrication. I have a button which will calculate the gross weight, so in order to calculate the gross weight, I will need to calculate it line by line. I have zero issue...

Hi all, I would like to ask how to have difference calculated value appear on report through button? I am able to click on the button on my report to perform calculation, however, all the calculated value are the same. How can i have difference calculated value for each line? Only the first...

Dear all, I would appreciate if you can offer me some helps here. I am facing this run time error '91' for quite some time, it will unexpectedly apppear. This error occurs when i attempt to click the next,previous or save button, it only appears when i did not key in the form or stop at one...

Hi all, I have an error on this module where it ties to the browse button on my form. It prompt me user defined not defined when i click on the browse button. Below is my screenshot

Hi there, how can i update data that is saved on the table through form? Currently, i have a form modify, and a listbox that is created by using data from the table. So let say i want to modify on one of the PO number that already exist in the table, by retrieving the data to the form and...

Hi all, Can i ask how to do validation on form? As i put the validation rule on one of my textbox = <>0 and validation text = "filed cannot be blank" By right, if the textbox = 0 then when i click onto the save button on my form, it will prompt me the validation text right? But in my...

Hi all, I have a form which allows me to select as many records as I want. However, i got an issue here. For example; I selected 4 records, but i will only want to key in the value on the textbox in the 1st record out of the four record, that i have made marking on the image i have attached...

Hi all, I have 5 textbox that link to a search button on my form, and the code works fine when i fill up all 5 textbox with PO number and click search it will show data that belong to the 5 PO number that i keyed in. However, i do face issue when i did not fill up all the 5 textbox. For...

Hi all, I would like to sum up multiple fields in a textbox in my report. I tried summing up by using expression builder, however the result display on my report seems to concatenate the number together instead of summing it.

Hello everyone, How can i show this on the textbox on my form? so that user will not need to keep typing or copy to the textbox and make the adjustment? 1) Please State: 2) Shrinkage: Maximum W: L : Twist: 3) PP sample -

Hello everyone, I would like to ask how can i combine two report as on report?

Hi all, I have a search button on my form and when I click on search it is unable to show only the data that I search. Below is my coding: Private Sub txtSearch_Click() 'declare variable Dim sql As String 'Determine and return the number of records in UnmatchFabricPOqry If...

Hi all, I am facing issue with this error "91" object variable or with block variable not set at this line of code. Can you help me? I have declare and set the variable at the start of my coding. ' loop on each item in maximrecords collection For i = 1 To modifyRecords.Count This line of...

Hi all, I encounter this error "TYPE MISMATCH" when i click on my "save" button on my form. Private Sub Write2DB(ByRef Arr As Variant) 'arr(0) PO# 'arr(1) GL# 'arr(2) Fabric Del Date 'arr(3) Fabrication 'arr(4) Fabric Width 'arr(5) Fabric Color 'arr(6) Net Weight 'arr(7) Gross Weight 'arr(8)...

Hi all, may i know how to perform join on two table? I tried using join but it is not the result that i want. Below is my SQL Code: SELECT * FROM Table1 INNER JOIN Table2 ON Table1.PO = Table2.PO; I want the table to show all the fields in both table 1 and table 2

Hi all, I would like to combine my crosstab union query with a simple query as one query. Below is my union crosstab query SELECT [Size breakdown], XS, S, M, L, XL FROM [CollarLengthAndWidthQuery]; UNION SELECT [Size breakdown], XS, S, M, L, XL FROM [CuffLengthAndWidthQuery]; Below is my...