I am looking for a developer to budget routine / BUSCO DESARROLLADOR PARA PRESUPUESTAR RUTINA - Forum
I am looking for a developer to budget routine / BUSCO DESARROLLADOR PARA PRESUPUESTAR RUTINA
Quote from joferar333 on October 20, 2021, 1:03 pmI need to be able to complete a small project and for days I have been blocked without achieving a routine, the help and documentation do not solve it, this is why I ask if a developer can solve it for me, please budget.
The routine is very simple I have a database, and a table where there is a date record ... I need to be able to enter a from and to setting two dates and that all the records that are within the range are shown in a grid and that in turn this grid that shows can be printed.
Argentina's date format is 10/20/2021 and I used the date picker popup itself to set the initial and final but there is no way, I did all the tests but it was a failure.
I clarify that the database is managed by the NEodbdpro plug.
Base name = ricardo
Table name = caja
name of the field = Fecha (Date) (I have not established any format since when I do it when declaring the field I get that they do not match so I leave it blank ...
It may be that the system has a format and then it is misinterpreted so I investigate the format it should be
month - day - year but I don't know how to establish that format so that the base takes it like this, since the same selector plug takes me day-month-year ...I'm waiting, greetings
ESPAÑOL
Necesito poder completar un pequeño proyecto y hace dias estoy bloqueado sin lograr una rutina, las ayudas y documentacion no lo resuelven por esto es que solicito si algun desarrollador me la puede resolver por favor presupuestar.
La rutina es muy simple tengo una base de datos, y una tabla donde hay un registro fecha... necesito que se pueda ingresar un desde y hasta estableciendo dos fechas y que todos los registros que esten dentro del rango se muestren en una grilla y que a su vez esta grilla que muestre se pueda imprimir.
El formato de fecha de argentina es 20/10/2021 y yo use el propio popup selector de fecha para establecer la inicial y final pero no hay forma, hice todas las pruebas pero ha sido un fracaso.
Aclaro que la base de datos esta manejada por el plug NEodbdpro.
Nmbre de la base = ricardo
Nombre de la tabla = caja
nombre del campo = Fecha (no le he establecido ningun formato ya que cuando lo hago al declarar el campo me sale que no coinciden asi que lo deje en blanco...Puede ser que el el sistema tenga un formato y que luego se interprete mal por lo que yo investigue el formato deberia ser
mes - dia - año pero no se como establecer ese formato para que la base lo tome asi, ya el mismo plug selector me toma dia-mes-año....Quedo a la esperea saludos
I need to be able to complete a small project and for days I have been blocked without achieving a routine, the help and documentation do not solve it, this is why I ask if a developer can solve it for me, please budget.
The routine is very simple I have a database, and a table where there is a date record ... I need to be able to enter a from and to setting two dates and that all the records that are within the range are shown in a grid and that in turn this grid that shows can be printed.
Argentina's date format is 10/20/2021 and I used the date picker popup itself to set the initial and final but there is no way, I did all the tests but it was a failure.
I clarify that the database is managed by the NEodbdpro plug.
Base name = ricardo
Table name = caja
name of the field = Fecha (Date) (I have not established any format since when I do it when declaring the field I get that they do not match so I leave it blank ...
It may be that the system has a format and then it is misinterpreted so I investigate the format it should be
month - day - year but I don't know how to establish that format so that the base takes it like this, since the same selector plug takes me day-month-year ...
I'm waiting, greetings
ESPAÑOL
Necesito poder completar un pequeño proyecto y hace dias estoy bloqueado sin lograr una rutina, las ayudas y documentacion no lo resuelven por esto es que solicito si algun desarrollador me la puede resolver por favor presupuestar.
La rutina es muy simple tengo una base de datos, y una tabla donde hay un registro fecha... necesito que se pueda ingresar un desde y hasta estableciendo dos fechas y que todos los registros que esten dentro del rango se muestren en una grilla y que a su vez esta grilla que muestre se pueda imprimir.
El formato de fecha de argentina es 20/10/2021 y yo use el propio popup selector de fecha para establecer la inicial y final pero no hay forma, hice todas las pruebas pero ha sido un fracaso.
Aclaro que la base de datos esta manejada por el plug NEodbdpro.
Nmbre de la base = ricardo
Nombre de la tabla = caja
nombre del campo = Fecha (no le he establecido ningun formato ya que cuando lo hago al declarar el campo me sale que no coinciden asi que lo deje en blanco...
Puede ser que el el sistema tenga un formato y que luego se interprete mal por lo que yo investigue el formato deberia ser
mes - dia - año pero no se como establecer ese formato para que la base lo tome asi, ya el mismo plug selector me toma dia-mes-año....
Quedo a la esperea saludos
Quote from Gaev on October 20, 2021, 4:06 pm@joferar333
According to this page in the Help file ... https://neodbprohelp.visualneo.com/CreatingaNewDatabase.html ...
Fields of the type Date (and also Time) are not supported by MS Access ... they suggest that you use DateTime instead.
If this does not solve your problem, and you need further assistance, please post the commands you are using to accomplish your goal.
According to this page in the Help file ... https://neodbprohelp.visualneo.com/CreatingaNewDatabase.html ...
Fields of the type Date (and also Time) are not supported by MS Access ... they suggest that you use DateTime instead.
If this does not solve your problem, and you need further assistance, please post the commands you are using to accomplish your goal.
Quote from joferar333 on October 20, 2021, 7:32 pmplease see the pub...
Please look at the pub I just put up. I'm really going crazy I can't get this to work I have no problems paying for your services, I just need to solve this ... thank you very much
please see the pub...
Please look at the pub I just put up. I'm really going crazy I can't get this to work I have no problems paying for your services, I just need to solve this ... thank you very much
Uploaded files:
- You need to login to have access to uploads.
Quote from Gaev on October 20, 2021, 10:13 pm@joferar333
Your Page Enter routine has these commands ...
dbpCreateAccessDatabase "[pubdir]demo.mdb" "Password=;Encrypted=No" dbpOpenAccessDatabase "demo" "[pubdir]demo.mdb" "" dbpCreateTable "demo" "caja" "Fecha DateTime;Detalle String(20)" dbpOpenTable "demo" "caja" "" dbpShowGrid "demo" "caja" "Rectangulo1"You do not need a dbpCreateAccesss command BEFORE a dbpOpenAccess command ... since the database already exists, attempting to create it could cause harm to the existing records.
Same with dbpCreatetable.
The code in the query button says ...
dbpQuery "demo" "caja" "Fecha BETWEEN [desde] AND [hasta]" If "[ricardo.caja.$RecCount]" "=" "0"The database ID ricardo should be demo.
After I changed it, I get a message No hay ninguin registro (in English: There is no record). This is most likely because of the way dates are being specified. I noticed that in the grid, dates are like 2021-10-01. I do not know if you recreated the database after changing the field type to DateTime.
As I mentioned in an earlier post, MS Access stores all dates in US format only (no matter what your Windows regional Settings are). Unfortunately, the Help file does not have an example query when handling DateTime fields, so I will have to search the old NeoBook forum posts for the correct syntax.
In the mean time, please provide the commands you used create and populate the database/Table.
P.S. There is no charge for providing assistance on this Forum.
Your Page Enter routine has these commands ...
dbpCreateAccessDatabase "[pubdir]demo.mdb" "Password=;Encrypted=No" dbpOpenAccessDatabase "demo" "[pubdir]demo.mdb" "" dbpCreateTable "demo" "caja" "Fecha DateTime;Detalle String(20)" dbpOpenTable "demo" "caja" "" dbpShowGrid "demo" "caja" "Rectangulo1"
You do not need a dbpCreateAccesss command BEFORE a dbpOpenAccess command ... since the database already exists, attempting to create it could cause harm to the existing records.
Same with dbpCreatetable.
The code in the query button says ...
dbpQuery "demo" "caja" "Fecha BETWEEN [desde] AND [hasta]" If "[ricardo.caja.$RecCount]" "=" "0"
The database ID ricardo should be demo.
After I changed it, I get a message No hay ninguin registro (in English: There is no record). This is most likely because of the way dates are being specified. I noticed that in the grid, dates are like 2021-10-01. I do not know if you recreated the database after changing the field type to DateTime.
As I mentioned in an earlier post, MS Access stores all dates in US format only (no matter what your Windows regional Settings are). Unfortunately, the Help file does not have an example query when handling DateTime fields, so I will have to search the old NeoBook forum posts for the correct syntax.
In the mean time, please provide the commands you used create and populate the database/Table.
P.S. There is no charge for providing assistance on this Forum.
Quote from Gaev on October 20, 2021, 10:31 pm@joferar333
Following up on the syntax for date values, ignoring the values output from dbpPopupDateSelector, I tried a hard coded command like this ...
dbpQuery "demo" "caja" "Fecha BETWEEN #5/10/2021# AND #10/1/2021#"... and it works as expected.
Note that the date format is month/day/year ... surrounded by hash tags (#).
In order to transform the output from the dbpPopupDateSelector command into one that dbpQuery expects, you have to slice the year, month and day components ... and re-stitch them in the required sequence ... are you able to do this on your own, or do you need assistance ?
Following up on the syntax for date values, ignoring the values output from dbpPopupDateSelector, I tried a hard coded command like this ...
dbpQuery "demo" "caja" "Fecha BETWEEN #5/10/2021# AND #10/1/2021#"
... and it works as expected.
Note that the date format is month/day/year ... surrounded by hash tags (#).
In order to transform the output from the dbpPopupDateSelector command into one that dbpQuery expects, you have to slice the year, month and day components ... and re-stitch them in the required sequence ... are you able to do this on your own, or do you need assistance ?
Quote from joferar333 on October 20, 2021, 10:47 pm@Gaev
Friend, I cannot describe to you what you have caused me by finding the solution, I was literally on the verge of being admitted ... there was no way to achieve this goal. How should I use the selector, the truth is that I do not realize how to convert the date variable that the selector brings me to the new format ... any example? And finally I would need to be able to make an impression of the result, I am not realizing how to do it to carry the grid with the result and insert it in a form that I design with the designer of the bases, or in what other way to do it ... I would like to compensate you for your time, please, if you indicate a paypal account, I will gladly deposit your fees. I send you a giant greeting since you have saved my life.
Friend, I cannot describe to you what you have caused me by finding the solution, I was literally on the verge of being admitted ... there was no way to achieve this goal. How should I use the selector, the truth is that I do not realize how to convert the date variable that the selector brings me to the new format ... any example? And finally I would need to be able to make an impression of the result, I am not realizing how to do it to carry the grid with the result and insert it in a form that I design with the designer of the bases, or in what other way to do it ... I would like to compensate you for your time, please, if you indicate a paypal account, I will gladly deposit your fees. I send you a giant greeting since you have saved my life.
Quote from Gaev on October 21, 2021, 12:02 am@joferar333
1) I do not charge for assisting users on this Forum ... I do it to help @luishp ... so he can spend his time solving the big problems.
2) I will supply you with the functionality to take the output of dbpPopupDateSelector and transform it into a format that you can use with dbpQuery.
3) I do not understand the following ...
And finally I would need to be able to make an impression of the result, I am not realizing how to do it to carry the grid with the result and insert it in a form that I design with the designer of the bases, or in what other way to do it
... perhaps another person with knowledge of Spanish and English can explain it.
1) I do not charge for assisting users on this Forum ... I do it to help @luishp ... so he can spend his time solving the big problems.
2) I will supply you with the functionality to take the output of dbpPopupDateSelector and transform it into a format that you can use with dbpQuery.
3) I do not understand the following ...
And finally I would need to be able to make an impression of the result, I am not realizing how to do it to carry the grid with the result and insert it in a form that I design with the designer of the bases, or in what other way to do it
... perhaps another person with knowledge of Spanish and English can explain it.
Quote from Gaev on October 21, 2021, 1:09 am@joferar333
The solution was easier than I anticipated ... the dbpPopupDateSelector command allows you to store the selected date in any format you like ... so I just set it to the same format that dbpQuery expects (no transformation required).
For your clarification, I added two TextBox widgets that isplay the values of the two variables output by the dbpPopupDateSelector command.
You will need to add some error checking commands to allow for user not selecting Start and/or End dates.
The solution was easier than I anticipated ... the dbpPopupDateSelector command allows you to store the selected date in any format you like ... so I just set it to the same format that dbpQuery expects (no transformation required).
For your clarification, I added two TextBox widgets that isplay the values of the two variables output by the dbpPopupDateSelector command.
You will need to add some error checking commands to allow for user not selecting Start and/or End dates.
Uploaded files:
- You need to login to have access to uploads.