Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 13th, 2003, 03:17 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sal and Bob

I got the form working in around about way.

Private Sub Form_Open(Cancel As Integer)
Dim count As Integer
Dim isDate As Double
isDate = Date
[Date].SetFocus
If [Date].Text = "" Then
lblNoEvents.Caption = "No Events For Today"
Else
count = DCount("Date", "tblSpecial_Event", "Date = " & isDate)
lblNoEvents.Caption = "You have" & " " & count & " " & "event(s) today!"
End If
End Sub

As a neophyte, I have a question or two to ask if you wouldn't mind answering them.

A Brief Synopsis:

I'm tutoring at a local college. My 2 tutee's have this assignment. Yes, I know they need to do it, but if I don't know how to do it, how can I tutor?

**&&

Is it me or isn't this too clear!

Assignment:
Create a menu driven database application which will contain the following parts:

1.) Table(s) to hold special event data
2.) Form(s) to enter special event data
3.) Macro(s) to run menu navigation.

The application will use Visual Basic to determine if an event is ready to be triggered to the user. Once the event is displayed the user will have the opportunity to print the event, release the event, or "SNOOZE" the event for another time. I'm working on the 3 command buttons next.

**&&

I don't like to assume, so what I would like to know is:

1.) You can't make an Access application into an executable and behind the scene check over the tables and pop up when it finds an event for the current date?

2.) This will only work when you turn Access on and you have the application title and form listed in the Startup box?

Thanks again for your help and when you get the chance, can you please answer my questions?!

Thanks in advance,

vbprogwb
(Bob)

PS
Is this the only bound field that you are using for your form?

I got rid of this one particular textbox, but I have several textboxes based on qryNow. The qryNow is "tied" to tblSpecial_Event, which picks out all events for the current date: >=Date() And <DateAdd("d",1,Date())

 
Old October 14th, 2003, 09:37 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes you can do that but not without running some schedule event from windows. I have done it before but only from NT Server or Windows 2000 Server.
I am not sure what you mean in question 2.

Sal
 
Old October 14th, 2003, 03:36 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sal,

Hi!

Are you saying that you actually created an executable from an Access database application?

#2 This will only work when you turn Access on and you have the application title and form listed in the Startup box?

I was assuming that one couldn't do an executable #1, so to have the instructor's instruction (The application will use Visual Basic to determine if an event is ready to be triggered to the user.)work. On the Tools menu, scroll down to Startup. You can have any form pop up when you click your application.

Is there a way to upload files to other members? If so, I can zip a copy of the homework assignment. You may get a better idea of what I'm trying to accomplish.

I went and bought the book my tutee's instructor said to buy. He told them to take back the textbook the school bought for the class.

Question: I'm getting way ahead of myself, but can you create a field in a table that will add/subtract fields in the same table? ie. a Balance (Balance-Withdraw / Balance + Deposit)

I'll be on and off the pc. Checking out the VBA book and trying to work on my online class homework.

Thanks in advance,

Bob

PS

The isDate didn't work this morning. I checked the table and there wasn't an event scheduled for the current date. Gave me an "invalid use of a null". I got it working though.

 
Old October 14th, 2003, 03:48 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

When you say an executable, are you referring to a program that automatically tells you when something is due? or are you referring to a compiled application that you can distribute?

What I created is a file that ran from a schedule on Windows 2000 Server. Far from being a file that automatically reminds you (like outlook would).

All this says is that you need a way to programaticaly change a date to a later date.

Sal
 
Old October 14th, 2003, 04:02 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sal,

As to your question "are you referring to a compiled application that you can distribute?" Yes!:D

Below is the exact assignment that my tutees gave me a copy of. Is it me or isn't this too clear!

Assignment:
Create a menu driven database application which will contain the following parts:

1.) Table(s) to hold special event data
2.) Form(s) to enter special event data
3.) Macro(s) to run menu navigation.

The application will use Visual Basic to determine if an event is ready to be triggered to the user. Once the event is displayed the user will have the opportunity to print the event, release the event, or "SNOOZE" the event for another time.

I've done the table (#1) and form(s) (#2). Haven't touched #3, yet because I don't have any ideas what all the instructor wants the menu to do. I don't even know what he wants for "SNOOZE". He hasn't gotten that far in the class. My tutee's, to say the least, are very unsure of everything.

Question: I'm getting way ahead of myself, but can you create a field in a table that will add/subtract fields in the same table? ie. a Balance (Balance-Withdraw / Balance + Deposit)

Thanks in advance,

Bob

 
Old October 14th, 2003, 04:19 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes you can create this fields. You are going to have to do the adding/substracting with some update queries and a button to run them, or with some VB / ADO.

You seem to have done as much as you can. The instructor need to be clear on the menu. i guess each button on the menu will do a task. He may be calling a piece of vb/vba code a macro.

Make sure your tutee's ask the instructor exactly what is it that he needs



Sal
 
Old October 14th, 2003, 05:56 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sal,

Fortunately, none of the assignments are due until 12/16.

The instructor needs to be clear on a lot of things.

You are definitely right when it comes to the tutee's needing to ask the right questions.

Later,

Bob

PS
Guess I'll go practice doing update queries!!

Would you believe I have a total of 5 tutees!






Similar Threads
Thread Thread Starter Forum Replies Last Post
textbox binding tryout greenbriar BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 4 February 14th, 2008 08:11 PM
Binding Results of an Xpath query to a datagrid cowa ADO.NET 2 November 17th, 2003 02:40 AM
binding of textbox sdibartolomeo ADO.NET 0 November 10th, 2003 02:26 PM
Binding TextBox from 3 Tables melvik C# 0 July 6th, 2003 02:51 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.