Re: Calendar Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

No, I need to see the RecordSource for your form.

If it's the name of a query, I need to see the SQL of that query. To see the
SQL of a query, open the query in Design view, then select SQL View from the
View menu.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Melissa" <melissafleetwood@xxxxxxxxx> wrote in message
news:%23fMGZHmfJHA.5844@xxxxxxxxxxxxxxxxxxxxxxx
Thank you

When I first open the form everything is displayed. All the text boxes
for each date, the month, year, etc. also there is info in some of the
"days" text boxes.

I apologise, im not very experienced in access, im not sure what its SQL
is?
In the "Row Source" of the CompanyName combo box, is the following:

SELECT tblCompany.CompanyId, tblCompany.CompanyName FROM tblCompany;

Im not sure if thats at all helpful?

Thank you kindly for your assistance

Melissa

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxx> wrote in message
news:uRefQKifJHA.4052@xxxxxxxxxxxxxxxxxxxxxxx
What you've done sounds sufficient.

When you first open the form, what appears on it? If there's nothing in
CompanyName, then the form should be empty. If not, something's wrong
with your query. Post its SQL.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Melissa" <melissafleetwood@xxxxxxxxx> wrote in message
news:OY6NoxWfJHA.2180@xxxxxxxxxxxxxxxxxxxxxxx
Thank you for the reply

I put the record source of the form to "qryCalendar", which I have the
field "CompanyName", and then in the criteria, i added
Forms![frmCalendar]![CompanyName]

Also - after update for combo - Me.Requery

It still shows all the records for all the companies? did I perhaps do
it incorrectly? should more fields be added to the calendar query?

Thank you

Melissa
"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxx> wrote in message
news:%23gYZywMfJHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
Base the form on a query. As a criteria in the query (under the
CompanyName field), put a reference to the combo box:
Forms![NameOfForm]![NameOfCompany].

In the AfterUpdate event of the combo box, put code to requery the
form: Me.Requery

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Melissa" <melissafleetwood@xxxxxxxxx> wrote in message
news:%23EPY%232LfJHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
I'm using Access 2002...

That did the trick, thank you.

My Calendar form opens, and I can add information into it, as well as
print the various reports.

Is there perhaps a way that I can insert a combo box on my calendar
form for "CompanyName", in which I can select a company from the list,
and then add/view information on the calendar for that specific
company?

Eg. I select "ABC Trading", and then add some text in the block for
January 15th, then I select a differenct company "SEL Importers" from
the list, and the text i inserted on January 15th for ABC traders will
no longer appear....and I can add records for SEL Importers?

Thank you kindly for your assistance

Melissa


"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxx> wrote in
message news:%23FubnyIfJHA.1168@xxxxxxxxxxxxxxxxxxxxxxx
Go into the Refererences dialog (If you're using Access 2003 or
earlier, it'll be under the Tools menu when you're in the VB Editor,
afraid I can't remember where on the ribbon it is if you're using
Access 2007, but you need to be in the VB Editor there too)

Assuming you're using an MDB, you need to find the reference for
Microsoft DAO 3.6 Object Library and select it. If you're using an
ACCDB, you need to find the reference for Microsoft Office 12.0
Access database engine and select it.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Melissa" <aog.jhb@xxxxxxxxxx> wrote in message
news:ufXXA5FfJHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
Hi

Error: Compile Error....User defined type not defined.
(Dim db As DAO.Database) is also highlighted, each time I close and
go back in it highlites a different line.

What is the DAO library?

Thank you

Melissa

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxx> wrote in
message news:e3zInF8eJHA.5316@xxxxxxxxxxxxxxxxxxxxxxx
What error do you get?

The fact that the previous line (Dim db As DAO.Database) doesn't
cause problems implies that the DAO library is properly referenced.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Melissa" <aog.jhb@xxxxxxxxxx> wrote in message
news:eykWnc5eJHA.5572@xxxxxxxxxxxxxxxxxxxxxxx
Boyd

Thank you very much for your reply

I have imported the module as well, and when i open the calendar
form, it gives me the "debug" option:

Public Sub PutInData()
Dim sql As String
Dim f As Form
Dim db As DAO.Database
**Dim rs As DAO.Recordset
Dim i As Integer
Dim myDate As Date

(When - debug, line with stars next to it is highlited in yellow?)

Thank you

Melissa


"Boyd Trimmell aka HiTechCoach via AccessMonster.com" <u14500@uwe>
wrote in message news:9080279a995de@xxxxxx
Melissa wrote:
Hi

I am creating a database for a security company.

I have a form for "Company" 's , "Employees" , and "Contracts
On my Company Form, I have a subform for the contract, which
works fine
My Employees form is just where you add employee info, this is
also ok.

Now what I would like to do, is create a form with a large
calendar on it,
and there must be a combo box perhaps on the top of the form to
select which
Company the calendar belongs to. Then, after selecting a
company from the
combo box, the user can double click on a day in a specific month
which then
brings up an input box to type in the names of the security
gaurds
(employees) who are working, or who have worked at that company's
premises
on that specific day.

I would also like to be able to print this calendar form to see
exaclty who
worked on which days. Would this report perhaps also be able to
give a
total number of shifts worked per gaurd (employee)?

I found a database example on the internet of a similar "Calendar
form"
which works great, However I cannot import the form and table
into my
database - it wont work. The code for this form is also much
more advanced
than my knowledge, so Im not sure exactly how to get it to work
in my
database?

Please could someone assist me?

Thank you kindly

Melissa


Did you check to see if there were any code "modules" that you
also need to
import? If there are any in the sample database, try importing
those also.
This may get the example to work in your database.

Hope this helps ....

--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200901/1


















.

Relevant Pages

  • Re: Query to Filter by Dates, Using Form
    ... This is the SQL that works: ... Dim strDateCondition As String ... drop the stored query and create a new one with the SQL you have built? ...
    (microsoft.public.access.queries)
  • Re: Calendar Form
    ... If it's the name of a query, I need to see the SQL of that query. ... To see the SQL of a query, open the query in Design view, then select SQL View from the View menu. ... Is there perhaps a way that I can insert a combo box on my calendar form for "CompanyName", in which I can select a company from the list, and then add/view information on the calendar for that specific company? ... The fact that the previous line (Dim db As DAO.Database) doesn't cause problems implies that the DAO library is properly referenced. ...
    (microsoft.public.access.forms)
  • Re: Ordering a filtered proximity search
    ... >>> search variable, filtering it, and ordering it at the same time. ... >>> appended query approach. ... if p1 is empty then your SQL syntax is messed up. ... Dim SearchTerm1 ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Building SQL statement in VBA. Getting 3131 Runtime Error in FROM clause :@
    ... Number of characters in a cell in the query design grid 1,024 ... Since the SQL parser mentions an error in the FROM clause, ... The only problem I can see is the SQL string is very long. ... Dim qdf As QueryDef ...
    (microsoft.public.access.queries)
  • Re: SQL help
    ... query and output the record count to another text box on the same form ... Dim strTotalships as string ... Can you help with this portion of the SQL statement? ...
    (comp.databases.ms-access)