Search results

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!

Hi, I use this code in form button, to open another form, but is not work... Form!CHECK_OUT_1.Form.RecordSource = "CHECK_OUT_data_1" DoCmd.OpenForm "CHECK_OUT_1", acFormDS, "", "", acReadOnly, acNormal

I want to auto add a value in A FORM "PIC1" field "min qty" after update "item" field, base on a TABLE information in "PIC2", please help how to do!

Hi, I want to open report by a from button, the report name is base on a subform field value, How can I do this? Thanks!

Is it possible to run batch file in access form?? access version "2013"

Hi, I want to use a form button to automatic create a new data record, need to use this format in the table field... date + three digit serial no... everyday from 20170110-001 to 20170110-999