Search results

When I reply a post, it always show this message Oops! We ran into some problems. Your content can not be submitted. This is likely because your content is spam-like or contains inappropriate elements. Please change your content or try again later. If you still have problems, please...

How can I modify the following code to add a row number in the query, now that the data source 'packing_ship_mark_1a' has been changed from a table to a query, so it can run correctly? Public Function fnRank1(ByVal id As Long) As Long ' ' put the Linked table name here and replace...

I used the following SQL to automatically generate the RowNumber column SELECT A.id, (SELECT COUNT(*) FROM packing_ship_mark_1a WHERE A.ID>=ID) AS RowNum FROM packing_ship_mark_1a AS A; id RowNumber 596 24 568 1 571 2 572 3 573 4 574 5 575 6 576 7 577 8 578 9...

In an Access report, the detail section has 5 fields "Bilname, Text315, Text323, Text324, Text325" set to auto grow. If any of the field data is too long, it will cause the height of the detail section to change. In the detail section, there is a vertical line "Line1". How can I automatically...

m_box_id SHID 20240719144942 X807-TW-X-XXX-AB563(CS39#HC) 20240719144942 X807-X-X-XXX-EC499-TW 20240719144942 X807-X-X-XXX-AC383-TW 20240719144942 X675-X-X-XXX-HB065-TW 20240719144950 2N6U-XXXT-0900-123 20240719144950 2N6U-XXXT-0810-123 20240719144823...

I use the above code to import content from some text files into a table, but it does not support certain characters such as full-width symbols or Chinese. How can I modify it?

Hi, I use "=1" on the report C/O NO field for a carton serial no, but I also want to add a group records count on the right hand side anyone can help?

Hi, I want to auto add a serial no on a label report, but need to base on a "ID" column if value is "0", don't show the serial no, please see the attached file "sample 1" & "sample 2" Thank you very much!

How to play a wav file on a form event? 64 bit office Thanks!

I want to convert some data like this in a query 0K9F-5-L-997-01 >>> 0K9F5L99701 4W7Y-0-99-99-99 >>> 4W7Y0999999 I use replace fuction, but it not works and show error! man_code: Replace([item_code],"-","") It is the replace fuction not works in access? How can I fix this problem?

Hi, I want to use the following code, to sort the records from a field value, but it not work! Please help to fix it! Private Sub Report_Open(Cancel As Integer) If Me.E = "1" Then DoCmd.SetOrderBy "C ASC, A DESC" Else DoCmd.SetOrderBy "C DESC," End If End Sub

For explame ... field value is "BOOK", open the report name is "BOOK" field value is "CAR", open the report name is "CAR"

Hi, How to auto add a Serial No with date in a form field, like the following sample format... N201911190001 N201911190002 N201911190003 N201911190004 N201911200001 N201911200002 N201911200003 N201911210001 N201911210002 the last four digital can reset everyday Thank !!

How can I open another form can copy two field data ? Please check the picture, Thank you so much!!

Hi, How to filter the query value when I click different button on the form, Please check the picture

Hi, How to requery "B"after entry a new record in "A"

Hi, I can't run a query record, when I lookup from a form unbound field Picture1 & 1a is OK by the criteria like "1903*" But in Picture2 , 2a & 2b,it does not seccess

Hi, I use the following code in a query... SELECT [tblData].[ID], Conc("Field1","ID",[ID],"tblData") AS Field1, Conc("Field2","ID",[ID],"tblData") AS Field2 FROM tblData GROUP BY [tblData].[ID]; but I want to change the [ID] field from number to text.. so how to change the code?

How to use modules to convert query from A format to B format? A Format 101001 A2 101001 A8 101001 C1 101001 D12 101002 B12 101002 C1 101002 J10 change to...B format 101001 A2, A8, C1, D12 101002 B12, C1, J10 Thanks!

litem Loc 101001 A2 101001 A8 101001 C1 101001 D12 101002 B12 101002 C1 101002 J10 change to... 101001 A2, A8, C1, D12 101002 B12, C1, J10 Thanks!