Search results

Hi all, i would like to ask if it is possible to have report display in a table view? if can, how can i do that? As i want to have a table so that it will be able too show the size breakdown for the clothe. ( I have attached an image of the end result of the report) Currently, i am only able to...

Oh!! Thank you!!

It prompt me to key in the fabric cuttable width

Oops, I did not. I tried keying the code you wrote here into my query and encountered error.

I think i need to replace the pInput as Fabric Cuttable Width so that it will not prompt me to enter fabric cuttable width each time i run the query. How can i do that? Public Function CustomSplit(ByVal pInput As String) As String CustomSplit = Split(pInput, "x")(1) End Function

Thanks for great help! I managed to achieve what i need! Quick question, how can i use the customsplit that i have created in the module in the MS Access query to retrun the same result in the customsplit module? Below is my code: Public Function CustomSplit(ByVal pInput As String) As String...

okay, I will try first. After trying i get this error "A string can be up to 2048 characters long, including opening and closing quotation marks." I use this under the fabric Cuttable width criteria split("[Fabric Cuttable Width]", "X","4')

After separating14 1/4Lx3Wx18 1/2Ix1V Into this: 14 1/4L 3W 18 1/2I 1V I want to store 14 1/4L under one field name then 3W another field name, 18 1/2I another field name, 1V another field name

Thank you for your reply. May I ask how does replace function help me in this case? as I do not need to do any replacement.

Hi all, I would like to separate the following into 141/4L 3W 18 1/2I 1V 14 1/4Lx3Wx18 1/2Ix1V I tried using left trim but it will not work as the number of character is inconsistent for each line of the data.

Okay, Thank you!

Oh, so the only way to group data is through query? Because I thought that after I selected the data on the list box and retrieve it on the form the same data will be group and shown as one. I attached an image of the sample data for your reference. For instance PO 100000958 has 6 lines of...

Does this apply if i am using an unbound form?

Hi all, i would like to ask if it is possible to group all the similar data as one on the form? For example: Current data on listbox Line 1 Blue 300gm Line 2 Blue 200gm End result on the form after retrieving these two data: Blue 500 gm

Thank you all for the useful input! I have solved it.

Hi all, I am facing this error when i want to calculate the weight on my form. the weight i want to convert is 32800lbs to KG with this formula (lbs/2.2046) but when i click on my button, it show error message "Overflow" I change the data type to long integer in my table and it still did not...

I did include, but it still does not work.

Hi all, i am facing error when i try to save and run the my macro in returning me the date and time stamp when i save a recor. Below is my screenshot

Hi all, I have this issue where my remarks does not display on my report. I think there is something wrong with my query. I create the query and use SQL aggregate first on my remark so that i will only need to key in remarks on the first record and key in one time. But it appear as i key in...

omg!! Thank you it works now!!