I just tried it, and at first sight it does seem to work, day and month aren't switched around.. Unfortunatly this gives me several problems on other areas in the code and outside the code, so this i'll have to take some time to see what is effected by this
Thank you very much. I hope there will be other solutions that can fix the problem without too many changes to other systems. Otherwise i'll have to do a lot of work :)
Dopey Fletcher
Last Activity: Aug 31 '11, 01:02 PM
Joined: Jun 10 '11
Location:
-
I'll see if i can post the access application this weekend, it will take some time to clear it of anything that would be useless to youLeave a comment:
-
I'll try to explain it with a small example:
I currently have 15 tables in the Pro database, and the same amount of tables in the Tst database. Now i add a new table called LogReports to the Tst database. Offcourse when the forms around this new table are created and tested, it will be imported in the pro database as well
When i get the version from the Pro environment (which is linked to the Pro database) and place...Leave a comment:
-
Thank you very much for the suggestions you have just given me, I will take this into consideration and see if this would help.. Allthough i must say that we don't have any problem with the code currently used.
On another point, the suggestion you have provided does not include the fact that there are other tables in the MSSQL database which aren't included in the access file yet. I need some way to find these tables and add them into...Leave a comment:
-
Thank you RuralGuy for the link, but it seems that the back-end databases are Access files as well. What i need is some way to connect to the MSSQL server, get the correct database there (Tst or Pro), get all the tables from there and then connect from the access front end to all the tables.Leave a comment:
-
I am using the format property of the TextBox Control, the value of this format property = dd/mm/yyyy. this is the only thing i'm using to se the format. As NeoPa assumed, i am not using any code otherwise
I made some images of the textbox and will put them here..
When the form loads the value of the second textbox = current date. This shows correct.
[IMGNOTHUMB]http://img19.imageshac k.us/img19/9775/datetextbox1.jp g[/IMGNOTHUMB]...Leave a comment:
-
Handling/Linking tables in access
Hello all,
Current Situation
Access (front end)
MSSQL (back end)
We have 2 environments, one test and one production
We develop in the test environment, and users work in the production environment..
All the tables in the Access are linked from the MSSQL database, and every time we bring the Access application to the other environment (so from test to production or vice versa) the tables are... -
Input mask for date on textbox
hello All..
I am currently working on an issue that contains the following
I have an Access Form on which 2 textboxes are used to let the user select 2 dates. These two dates are used to make a selection. When it starts up, it gives the date in European standard.. (dd/mm/yyyy) but when the user wants to type in another date, the value in the textbox jumps to American date standard (mm/dd/yyyy) How can i make sure that the...
No activity results to display
Leave a comment: