calendar scheduler for a lan

[stefanocps]

Hello i am looking for a simple calendaragenda scheduler to use in a small lan
Now we are using an excel file, but as you know, when it is open on one pc, all the other user can access only in a read mode
So we need somehting that can be accessed at the same time in read/write mode from multiple users
The need is quite easy. Each day we need to schedule appointments for 3-6(the numebr is to be decided yet) differents areas
I have seacrhed for some software, but now it seems that everything is online. But we work in an hospital departments and all datas must be reserved, so it is not possible to use anything web based!
So i am thinking to use access. Problme with access is that it is quite a time i am not using, so i feel a bit lost when it is time to start to program. I was never a real programmers, but with forms and tables i did several little applications in th epast
Now, i am asking you if there is any template available to start form, or you can give me some hint to start, or also if you know a free software that cansuit this need
Thanks a lot

 

[stefanocps]

to make it clear
This is what is used, it is a daily scheduling. As you see should be important to have all time slot already available, just blank. And time by time they are filled with new appointmens
This kind of view i important because when someone goes to set upo a new appointment for example the 1st of december 2024, he can see at glance what slot of time (8-9,9-10 ecc ) are still available. So it is important to have the view just like a paper agenda. All the time slot visible at once. This is the things that i find most difficult to imagine when programming with access

 

[CJ_London]

If you Google ‘Microsoft access calendar template ‘ you will get a number of hits - this one for example

Calendar Scheduling Database Template | Calendar Software

An easy to use calendar view can greatly increase the effeciency of your database application. The Calendar Scheduling Database Software Template allows for Scheduling and viewing Tasks and Appointments in a Microsoft Outlook Style. Full source code included in purchased version. Free demo to...

www.microsoftaccessexpert.com

 

[stefanocps]

If you Google ‘Microsoft access calendar template ‘ you will get a number of hits - this one for example

Calendar Scheduling Database Template | Calendar Software

An easy to use calendar view can greatly increase the effeciency of your database application. The Calendar Scheduling Database Software Template allows for Scheduling and viewing Tasks and Appointments in a Microsoft Outlook Style. Full source code included in purchased version. Free demo to...

www.microsoftaccessexpert.com

yes , i am looking for a free version though

 

[arnelgp]

see Peter Hibb's Calendar

 

[stefanocps]

see Peter Hibb's Calendar

just found it now and it seems really promising for my need
I have some questions about it
first thing is that when i open it on a 64 bit version i get error as it says the db is for 32 bit and i don't know how to convert(also i don'tknow yet the office versions of all pc in the lan)
Second thing, trying to modify som ething and i cannot, for example the scheduler start from hours 00 and it finish to hours 23..and i don t want all this..Just deleting form the source table is not enough, som epart of codes must rewrite these..and cannot find where, yet(as i said i am not good with code)
Third thing: ok let's say th efile will be fine for me. I would need to use 3 of these because i will use one for each different areas. I don't want to have 3 separate files so i am thinking to gather those 3 files in one access files. I import all the files in one single files, but of course it don't work as the tables and formnames will change being duplicates and all the codes getr broken. Is there a different way to do this?do i need to fix all the codes and rewrite the correct table/form names? thanks

 

[arnelgp]

i am not the author and have not exhaustively seen all objects of the db, therefore, i cannot answer you.
you can ask questions on that forum.

 

[stefanocps]

i am not the author and have not exhaustively seen all objects of the db, therefore, i cannot answer you.
you can ask questions on that forum.

can imagine but the first and the third questions are not realted to that db, but general question i suppose
The frst is about a db being written for 32bit version and used on a 64bit version of access
the thirs is certianly common, and is about how to duplicate a db and use it wihtin a single file, keeping in mind that when i import the files it change the name of table. For example: i import the file and i have table_main and form_main. If i import again the file i will have table_main1 and form_main1 : all codes related to those name will be broken. This is a general question for sure

 

[arnelgp]

first question, i have done the changes and will work both for x32 and x64.
third:
a. you need to create a Shared folder on the Lan.
you must grant all Rights to user Everyone on this
folder.

b. split the db (FE/BE).
the BE will be put to the shared folder.
open the FE and Relink the tables.

give each users a copy of the FE (front end) database.

 

[stefanocps]

first question, i have done the changes and will work both for x32 and x64.
third:
a. you need to create a Shared folder on the Lan.
you must grant all Rights to user Everyone on this
folder.

b. split the db (FE/BE).
the BE will be put to the shared folder.
open the FE and Relink the tables.

give each users a copy of the FE (front end) database.

ahh good so this one is the corrected version, i can now open it on my 64bit. Thanks a lot
Yes i know i need to do this procedure to share the file on lan..but is this related to the 32/64 bit issue?

what about how to manage the need for use multiple instances of the db within one unique file?what solution may i use?

 

[arnelgp]

Yes i know i need to do this procedure to share the file on lan..but is this related to the 32/64 bit issue?

no issue, just don't make and .accde out of it. accde is based on the bitness it was created.

 

[stefanocps]

no issue, just don't make and .accde out of it. accde is based on the bitness it was created.

ok. sorry to ask again , any idea for the multiple instances?

 

[Gasman]

Crossposted at https://www.accessforums.net/showthread.php?t=90297 with same advice.

 

[arnelgp]

any idea for the multiple instances?

what do you mean? you already split the db, so give each Users their own FE. that i think is multiple instance?

 

[stefanocps]

what do you mean? you already split the db, so give each Users their own FE. that i think is multiple instance?

ok so i have not explained well then
We have 3 to 5 different areas with different scheduler for example appointment in blue room, appointments in red room etc...
So we need different scheduler for blue room, red room etc
I could use one instance of the file ofr the red room, another one for the blue room and so on, but i 'd rather have all within the same file
SO that i should add to that file one more form, at top level that say RED ROOM SCHEDULER that will open the red room scheduler, BLUE ROOM SCHDULER and it will open the blue room schduler. The way iu have thought i can do is to import several instances of the file in a blank db , and use it within a single file instead of multiple files
But when i import the same file more than once all the names of the tables and form will change as they are duplicated. This will cause an error in the code as the names of table and forms are changed
is it clear now?

 

[Gasman]

I would just have a combo, which selected whatever rooms you have from tblRooms.
Then Conditional Format them by colour, so you can see Blue and Red rooms both booked at the same time.

You amend that calendar to include what room for each record. You do not have seperate tables for each room. You could, but not wise.

I am not going to respond further on the other site where you crossposted either.

 

[arnelgp]

there is no need for additional table or form.

modify the startup of the db and remove frmCalendarMain from opening.
you need to modify tblAppointments and add 1 field for the Room (color).
modify frmCalendarMain and add an Unbound textbox (txtRoom).
create a Form, for your menu to select which room (add 5 buttons for your room color).
on the click of each button passed the associated color (string) to frmCalendarMain on opening it.
when you save, add the color to tblAppointment.

this is but an outline, but the list can go on.
and you need to implement it.

 

[stefanocps]

there is no need for additional table or form.

modify the startup of the db and remove frmCalendarMain from opening.
you need to modify tblAppointments and add 1 field for the Room (color).
modify frmCalendarMain and add an Unbound textbox (txtRoom).
create a Form, for your menu to select which room (add 5 buttons for your room color).
on the click of each button passed the associated color (string) to frmCalendarMain on opening it.
when you save, add the color to tblAppointment.

this is but an outline, but the list can go on.
and you need to implement it.

thtis is what i thought at the beginning but it seemed too complicated...anyway i'll try now that i have some hint on where to start. if i need i might come back later for further requests
thanks for now

 

[arnelgp]

have not fully tested and i let you do the testing.

 

[stefanocps]

there is no need for additional table or form.

modify the startup of the db and remove frmCalendarMain from opening.
you need to modify tblAppointments and add 1 field for the Room (color).
modify frmCalendarMain and add an Unbound textbox (txtRoom).
create a Form, for your menu to select which room (add 5 buttons for your room color).
on the click of each button passed the associated color (string) to frmCalendarMain on opening it.
when you save, add the color to tblAppointment.

this is but an outline, but the list can go on.
and you need to implement it.

here already
i am trying to do the way i think to it at the beginning
Thewre is a field APPTLOCATion in tblappointments whivh i thought i could use it. Can i use it right?don't need to create a new field

Now i have added the unbound text in the main form, an dat this point i get lost. How shall i use this unbound text?
Also i don't know ho to open the frmcalemdarmain passing the color specified in the button. I am doing with macro but i don't like at all( also it still not working as i don't know what to do with the unbound text in main). I suppose this unbound text should contain the color i pass to the form when opening right?how do i do?