C
cporter
I have a form I'm using to pass data to a query. The data seems to be
formatted ok but I keep getting wierd characters from my form or no
data, what is going on? Could the validation text mess with the data
transfer?
MachID Wono DayDown Timedown Dayup TimeUp Employee Action Subsys
ACS-215 Ȳ å••å••å••ã¿¡ ë›å¬…ã¿¡ CAP PF ALG
SELECT Forms!frmEnterWO!Combo24 AS MachID, [Forms]![frmEnterWO]![Text2]
AS Wono, Forms!frmEnterWO!Text6 AS DayDown, Forms!frmEnterWO!Text10 AS
Timedown, Forms!frmEnterWO!Text8 AS Dayup, Forms!frmEnterWO!Text12 AS
TimeUp, Forms!frmEnterWO!Text14 AS Employee, Forms!frmEnterWO!Combo16
AS [Action], Forms!frmEnterWO!combo18 AS Subsys;
MachID - text
Wono - general number
Daydown & DayUp - short date
TimeDown & TimeUp - short time
Employee - text
Action - text
Subsys - text
formatted ok but I keep getting wierd characters from my form or no
data, what is going on? Could the validation text mess with the data
transfer?
MachID Wono DayDown Timedown Dayup TimeUp Employee Action Subsys
ACS-215 Ȳ å••å••å••ã¿¡ ë›å¬…ã¿¡ CAP PF ALG
SELECT Forms!frmEnterWO!Combo24 AS MachID, [Forms]![frmEnterWO]![Text2]
AS Wono, Forms!frmEnterWO!Text6 AS DayDown, Forms!frmEnterWO!Text10 AS
Timedown, Forms!frmEnterWO!Text8 AS Dayup, Forms!frmEnterWO!Text12 AS
TimeUp, Forms!frmEnterWO!Text14 AS Employee, Forms!frmEnterWO!Combo16
AS [Action], Forms!frmEnterWO!combo18 AS Subsys;
MachID - text
Wono - general number
Daydown & DayUp - short date
TimeDown & TimeUp - short time
Employee - text
Action - text
Subsys - text