-
Not sure if this is the right forum but here goes.
Im creating a db in access to keep track of appoinments. The problem Im running into is reoccuring entries. For example scheduling a particular event to happen every Mon/Wed/Fri for the next 3 months. Not even sure if Access is the right thing to use in this case. Biggest problem Im having is actually creating a new record in the table with VB
(özmen, Timor-Leste)
the most quick-n-dirty approach is that you should programmatically (ie: from the vb-side) determine which exact dates that the recurring appointment would occur, then insert a new "appointment" table record with the necessary details for each date needed.
there are more elegant approaches, but it is difficult to give a more exact answer to your setup due to what little that has been said about the database arangement/relationships/etc.
(Caner, British Indian Ocean Territory)
Are you using VB for Applications or a stand alone VB app interfacing with the database file?
(melis, India)
Using vb editor in Access (ie: running the code with a push button).
Relationships are very basic.
Table:
Date
TimeStart
TimeFinish
Room (combo box)
Notes
Ive already made the code to check to make sure there are no conflicts in scheduling. Just not sure how to go about making reoccuring events.
Events are added using a basic Access Form.
(HATİCE, Heard Island and Mcdonald Islands)
I think you would have alot more sucess if you used like VB.NET you can download the free ExpressEdition of Visual Basic.NET and pick up a book on VB.NET Databases. You need the DataSource, DataAdapter, and the DataSet and then you can bind your controls to the DataSet and it requires less than 50 lines of code depending on if you want to just add, update and delete records. Adding search capability is easy too.
(burcu, Mayotte)
Thanks for the advice. I never gave much thought to .NET. Looks like I'll be learning something new :) I was also thinking it might be easier just to incorperate something into outlooks calander with maybe a custom interface
(gamze, Belgium)