Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #13717

Re: Is it possible to import a .ics file into an Access database in code?

Show all headers | View raw

PW wrote on 6/25/2019 :
> On Tue, 25 Jun 2019 12:34:48 -0400, Ron Weiner <rw@domain.com> wrote:
>
>> It happens that PW formulated :
>>> On Mon, 03 Jun 2019 13:21:31 -0700, PW <PW@noemailaddress.com> wrote:
>>> 
>>>> Hi,
>>>> 
>>>> That is what the format Google Calendar exports to.
>>>> 
>>>> I don't want it to go into a calendar, but rather in a form so a
>>>> client can mark off what they want to import into their reservation
>>>> table, etc...
>>>> 
>>>> -paulw
>>> 
>>> 
>>> *--
>>> 
>>> Well, big bummer!  Google calendar only adds events with an import. It
>>> does not replace anything.
>>> 
>>> So each time I import from the CSV I have another entry for the same
>>> "room" in the calendar.  And if an event for a date or date range no
>>> longer exists in the CSV file, it still will exist on the Google
>>> calendar.
>>> 
>>> The client would have to log into GC and manually delete all the
>>> appointments/events first.
>>> 
>>> Too much to ask of them!
>>> 
>>> Looks like I am back to the drawing board on finding an on-line
>>> calendar that I can use with Access.  The problem is, after many hours
>>> of research, every one is an appointment calendar (even Microsoft's
>>> new Office 365 business calendar).  Great for hair salons, meeting
>>> rooms, whatever requires something like what the day view looks like
>>> in Outlook.
>>> 
>>> That is not what I want.
>>> 
>>> I do not know how this competitor came up with his calendar (I looked
>>> at the source code but couldn't tell).  I assume he used .NET.
>>> 
>>> -paulw
>>> 
>>> ---
>>> This email has been checked for viruses by AVG.
>>> https://www.avg.com
>> 
>> "Once Upon a time..." using Access 2000 I built a month view calendar 
>> form that would track unlimited events per day, that allowed for drill 
>> downs to get additional details for a specific event.  And while I am a 
>> bit fuzzy about how it was implemented all those years ago it used only 
>> Access controls.
>> 
>> If memory serves I filled the form with 6 rows 7 colums wide of Labels 
>> and List boxes.  When the user selected the month the form would 
>> reconfigure itself hiding/visiblizing and populating the visible 
>> elements for the month.  The whole thing was data driven, and yea, it 
>> was pretty complex taking many hours of dev work to get it going.
>> 
>> Perhaps the above general outline of what I did will give you some 
>> ideas how you might implement something similar for your app.  If you 
>> have interet in seeing what I did all those years ago, I believe that I 
>> have an image of that old hard drive around here somewhere.  I can 
>> probably dig it out and post it somewhere public if need be.
>> 
>> Rdub
>
>
> *---
>
> Thanks Ron.  If you find the image, let me know.
>
> paul
> at
> williamson
> enterprises
> dot
> com
>
> My wife made a real spiffy wall calendar that sounds like what you
> describe.  But we need it for clients to check reservations and
> availability on the web either via their website or something I would
> set up at a domain.
>
> Our app is running on AWS for some clients so they can access it
> anywhere.  But I am not sure how I would do a reservation system and
> have it hosted there or wherever.  I know we could come up with
> something in Access but how would people see the availability and book
> the room.  All the data is in our Access application and I am
> certainly not going to come up with our own booking.com, travelocity,
> etc...!
>
> Thanks,
>
> -paulw

Paul

I found my old app, contacted my old client, (He stoped using the app a 
few years ago, but since it was a work for hire, he owns the copywrite) 
got permission to share the Calendar form, and attached it here.

 Frankly I half expect the this post will fail and the attached file 
will be lost somewhere between my PC and Eternal-September (my News 
server host).  I have never sent an attachment to a Newsgroup, but 
there has got to be a first time for everything, So... Here goes.

Rdub

Yea Well "That Dog Woln't Hunt"!  Hmmm... I use to have a website 
hosted on...  Well somewhere.  Give me a day or two to figure out if it 
still exists, and if I still have access to it, and how in holy Hanah 
to point you to a link that will allow you to get the file.  It's been 
years.

Rdub

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-03 13:21 -0700
  Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-03 13:28 -0700
    Re: Is it possible to import a .ics file into an Access database in code? Ron Paii <ron81pai@gmail.com> - 2019-06-03 14:23 -0700
      Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-03 20:40 -0700
        Re: Is it possible to import a .ics file into an Access database in code? Ron Paii <ron81pai@gmail.com> - 2019-06-04 04:55 -0700
          Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-04 11:00 -0700
            Re: Is it possible to import a .ics file into an Access database in code? Ron Paii <ron81pai@gmail.com> - 2019-06-04 12:13 -0700
  Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-03 21:41 -0700
    Re: Is it possible to import a .ics file into an Access database in code? Neil <neil@myplaceofwork.com> - 2019-06-04 07:14 -0400
      Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-04 10:51 -0700
        Re: Is it possible to import a .ics file into an Access database in code? Neil <neil@myplaceofwork.com> - 2019-06-04 16:41 -0400
          Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-05 14:30 -0700
          Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-05 14:49 -0700
  Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-25 09:36 -0700
    Re: Is it possible to import a .ics file into an Access database in code? Ron Weiner <rw@domain.com> - 2019-06-25 12:34 -0400
      Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-25 13:40 -0700
        Re: Is it possible to import a .ics file into an Access database in code? Ron Weiner <rw@domain.com> - 2019-06-27 20:08 -0400
          Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-28 12:52 -0700
          Re: Is it possible to import a .ics file into an Access database in code? Ron Weiner <rw@domain.com> - 2019-06-28 17:00 -0400
            Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-30 20:06 -0700
      Re: Is it possible to import a .ics file into an Access database in code? PW <PW@noemailaddress.com> - 2019-06-25 14:27 -0700
    Re: Is it possible to import a .ics file into an Access database in code? Ron Paii <ron81pai@gmail.com> - 2019-06-25 11:23 -0700

csiph-web