Calender Form

Dec 31, 2006

the calender form Input_2000.zip is quite useful. how can i modify its frmInputBox to have two text fields to enter numbers only?

After entering numbers in the text fields, the two numbers will be shown inside frmCalender box. perhaps can enter the numbers directly into the calender instead of using the frm InputBox.

anyone can help me to modify the Input_2000.zip into something like this: qp.jpg (see attachment)

View Replies


ADVERTISEMENT

Calender In Form,

May 18, 2006

Hi, i am fairly new here, but i am building a database to hold bookings,
therefore i need a calender which wen dates are selected will display that days bookings,

If anyone has any ideas! can you please let me know ASAP!

Thanks

Tom

View 8 Replies View Related

Problem With Implementation Pop-up Calender In Form

Mar 17, 2006

Hello guys

Here i am again with another problem. I have date field in my table (MyDate) and used that in form. I downloaded PopupCalendar file, which, i saw here in this discussion forum.

i had implemented all properties of 'Text3' of "Frm Trial" form in popupCalendar.mdb. Now when i run 'zsformCalender' form, i am getting message

Compile Error:
Can't fine project or library

and the error is highlighting - intDayToday = DatePart("d", Date)

please help me howto resolve this problem

Thanks :)

View 7 Replies View Related

Using A Calender

Feb 28, 2005

I was looking through some of the stuff access has to offer when I came across the calender control. I really like its set up and what I would like to do is create a switchboard to link to the calender then have the user click on the correct date. I need the date clicked to create a table based on the date. I click 2/5/5 the table is labeled 2/5/5. If possable, after the date is clicked I need a form to open for inputing numbers and i want those numbers going into the table based on the clicked date. This possable?


Thanks
Chris :rolleyes:

View 7 Replies View Related

How Can I Make This Calender

Oct 15, 2005

Hi all

in the attachment there is two pictures for a form with interesting calendar to chose DOB

any one know how to do something like it


Thx

View 5 Replies View Related

I Need Help With A Calender Problem...

May 23, 2007

Hi,
Im new to the Forum.
Ive been learning Access on my own and I have this calender that I am not sure how to get up and running.

Basically I have my switchboard with an area for buttons on one side and a calender on the right. The calender is built into a Tab section where I am wanting to be able to tab back and forth between a calender that shows daily work orders or jobs etc, and a form that lets me look at jobs individually.
Its prolly alot easier to understand if you see it so I will just attach the file.

My problem is I dont know how to code out the calender so that I am able to click on a day and enter either text or code depending on what I want to be displayed.

**EDIT**
Sorry,
Im using Office 02.
THats prolly need to know info :)

Thx in advance for any help you can give,
Meat

View 3 Replies View Related

Calender Control 11.o

May 20, 2007

hi can anyone help, im trying to insert a calender to an access database but i cant assingh it to a command button, when i go to form view it is larger than life insted of an icon can anyone please help.

View 2 Replies View Related

I Need Help With A Calender Problem...

May 23, 2007

Hi,
Im new to the Forum.
Ive been learning Access on my own and I have this calender that I am not sure how to get up and running.

Basically I have my switchboard with an area for buttons on one side and a calender on the right. The calender is built into a Tab section where I am wanting to be able to tab back and forth between a calender that shows daily work orders or jobs etc, and a form that lets me look at jobs individually.

My problem is I dont know how to code out the calender so that I am able to click on a day and enter either text or code depending on what I want to be displayed.

Im using Office 02.
THats prolly need to know info

Thx in advance for any help you can give,
Meat

View 4 Replies View Related

Calender Dates In Query

May 18, 2006

I`m using a calender to pick a start date and end date shown in two combo boxes. I can store this value in a table with fields StartDate and EndDate I want the user to be able to pick the dates and show query records between these dates I thought i could use something like - Between"StartDate","tblDate" And" EndDate","tblDate" but it brings a syntax error anyone help ?

View 1 Replies View Related

Calender Forms And Modules

Jul 12, 2006

Hi

I have a form pop up calendar that returns the date in a date field on a form. This was a free popup and is activated by a double click which issues the command popupcalendar(screen.ActiveControl). I select the date from the calendar form and this date does update the correct filed with the date value I selected. What I have been trying to do is also display the day of the week which I can get using the vb weekday function. This all works well if I put the code in the on exit event of my date field and then use tab or any other way to exit the field. However I would like to be able to automate the process so that when I returne from the popup calendar the day field is updated at the same time. I have tried all the event options of my date field but do not get any changes to my day field. If a field is updated using VB does this disabe these events. Any help wpould be great.

View 2 Replies View Related

Calender To Select Records

Oct 24, 2006

I was wondering if anyone has seen a easy way to use a calender to select records rather than having to type in a "between such and such a date".

Because what i have now is a qry that pulls data from a table between two dates. And i would like to make it more GUI rather than typing to prevent user imput error if you understand what i mean.

I tried searching but didnt know what to search for.

Thanks for anyone that has any input!

Regards,
Jon

View 2 Replies View Related

Adding Calender Option To Access

Jun 29, 2006

my departments seems to want to add some sort of notification feature to our database. It's supposed to notify the department when a certain date is approaching.

How do you even begin to think about adding this feature into Access? I don't know where to start. I'm no Access guru. :confused:

View 1 Replies View Related

Calender Control And Date Field

Jun 28, 2006

Using Access 03....

I created a form with a calender on it [frmCalender].

I placed a command button on my parent form, next to the date field [request_date]

How do I link whatever date I click on (in the calender) to appear in the [request_date] field?

View 4 Replies View Related

Calender Control And Date Field

Jun 28, 2006

Using Access 03....

I know this seems noobish. But I've never used the calender before now. So while I know how to make one...

I created a form with a calender on it [frmCalender].

I placed a command button on my parent form, next to the date field [request_date] to open the [frmCalender]

How do I link whatever date I click on (in the calender) to appear in the [request_date] field?

View 1 Replies View Related

Access Calender Size Problem

Dec 12, 2006

Im Making a Room Booking System for Our Meeting room,

there is only one room, so its easy to use the Calender(MSCAL.Calendar.7)value to pull a query for whats happening on anyone day, this also allows to add new entries,

my problem is Ive writting it in MSA2003,

and my main user is in 2000, when she opens the form with the calender on it the fonts are all reset to 1.5 in size,

and this is not useable,

has anyone seen this before or had something similar,
I thought Id just use VBA to reset the font sizes in the Form_open routine, but I cannot get VB to Access those properties of the calender,

so Im a little Stumped.

View 2 Replies View Related

Access Calender, Ignore Weekends And Bank Holidays

Apr 2, 2008

I'm using access 2007 and have some date fields in my forms, i'd like to be able to blank out weekends and public holidays from the calender/date selector in these fields so theres no way those dates can be selected. Is this possible? Thanks.

View 1 Replies View Related

Calender ActiveX Control Display Also Hours, Minutes And Seconds

Jul 22, 2007

I am using the calender control 11.0. By this calender I can only set the date year, month and day. I can not set the clock time:Hours, minutes and seconds. Is there a calender that enables me to set the date in the format:dd-mm-yyyy HH:MM:SS, means day,month,year Hour:Minutes:Seconds.


Grateful

View 1 Replies View Related

Input Date By Picking Date From Calender

Jun 14, 2005

I am not a professional programer but would like to do a simple database for my group to track research progress. Is that possible to "pick up a date from drop down calendar" then the date will input to the cell (save in table) in a form, instead of typing it in? I saw that in lots of web sites, but can not figure it out how to do it in Access. Tried "Canendar Contol" and "LANDesk Data control" in the toolbox.

Thank in advance

PK

View 4 Replies View Related

Forms :: Button In Form To Open Different Form And Chose A Customer Based On Last Form

Mar 26, 2013

Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.

I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.

View 5 Replies View Related

Forms :: Opening A Form From Another Form Via Combo And Auto Loading Form Data?

Apr 14, 2015

I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.

The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.

The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.

View 9 Replies View Related

Forms :: Send Data From Pop-up Form To Main Form (sub-sub Form)

Aug 27, 2014

On the form: User enters first name, then last name. Upon updating the last name field, I would like another form to pop-up and display all the people with that same first name and last name that the user just entered.

On the pop-up form: All of the matching first names/last names are listed with a button control beside each record that says 'Select'. The user clicks the select button beside the record he/she wants. This pop-up form closes and all of the data from this selected record is now showing on the original form.

So far, I have a query/form that pops up only showing the matching first/last names. I'm having a hard time getting my original form to auto-populate with that record that the user selects on the pop-up.

(Also my main form is actually a sub-sub form - so in my trials I could've been massacring my syntax trying to point to it.)

View 5 Replies View Related

General :: Create A User Form With Sub Form Using Form Wizard?

Aug 10, 2013

I am trying to create a user form with sub form using the form wizard. I have only 2 tables, Employee (main table) and Vacation (subform table). I pick the fields from Employee Table then fields fro Vacation, but the wizard treat the Vacation as main form and Employee as sub form.

View 4 Replies View Related

Open Previous Form From Current Form Sub Form

May 7, 2005

I have a fault form which the user enters details of a fault. When the fault form is submitted the data is saved in the relevant table and the form is cleared so that the user can enter the next fault. On the fault form i have a subform which displays the faults previously entered by the user. I want the user to be able to click on an entry in the subform and open the orignal fault form and see the data that had been entered. How can i create this functionality??

View 9 Replies View Related

General :: How To Make Form Controls Change Size / Position As Form Is Resized

Jul 24, 2013

how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.

View 4 Replies View Related

General :: Bound Form With Search Box - Select Record In Dataset And Display In Form

Aug 19, 2014

I have a bound form which is from tblEmployee, I'd like to have a dataset below (like a splitform but not a split as they have limits) so when i search in the box it gives me say all the smiths - i select for example david smith and it displays his information in the form objects above so they can be edited?

View 1 Replies View Related

Forms :: Open Blank Form Based On Value In Text Field In Main Form

Jun 6, 2013

I have one table containing name of restaurant with its address etc. Then i created another table to list out the restaurant workers names and details. Just as an example,

Table:Restaurant
Restaurant name
Address line 1
Address line 2
Restaurant #
Website

Table:StaffContact
Staff Role
Name
speciality
email
phone

I have the main form that has all the restaurant details only. And i have another form containing the Staff information. Please note the two table have a relation and it works well.

Now to make it user friendly(basically easier for the lazy ones), I dragged the staff contact form on to my main form and displayed it as a datasheet(basically a sub form).

Now, my boss does not want users to add/delete on this sub form(datasheet). So,he wants me to create buttons to open new record of staff for each restaurant(new form)

My issue is with opening a new record to enter a new person to the staff list and give them a role as well in form view.The new form has

So i ran a Macro, with open form with Where condition

Code:
[Staffcontact]![Rest Name]=[Forms]![MainForm]![RestaurantName]

But, it does not work .

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved