• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Access DB Question/Help

M

Magic Hat

n00b
Joined
Mar 17, 2002
Messages
42
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
 
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.
 
Are you using VB for Applications or a stand alone VB app interfacing with the database file?
 
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.
 
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.
 
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
 
You must log in or register to reply here.
Back
Top