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 Replies
ADVERTISEMENT
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
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
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
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 1 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
Sep 11, 2014
I have a form which opens as a pop up when the system starts. On here are several buttons, which open other forms.Some of these just open another form and the user starts using the system, other close that form and open another one, and take go further into the structure of the system, then the forms that open have the same etc.For each of the buttons the code is very similar..For forms that open another one and don't close the main form:
Code:
Private Sub cmdescalations_Click()
DoCmd.OpenForm "frmEscalations"
End Sub
for those that close the form:
Code:
Private Sub cmdStock_Click()
DoCmd.Close acForm, Me.Name, acSaveNo
DoCmd.OpenForm "frmMain_Stock"
End Sub
Just the main of the form it opens changes, and sometimes with ,,,dialog in the options if its required.The opening part works every time without fail, but the form doesn't always close and I end up with two forms open instead of one. If I close the newly opened one and press the button again it works fine. This is purely random and only started a few days ago, up until then it has been working fine.
There is a hidden form that is open as well when the system starts, which check for something on a timer event every 60 seconds. If that event is firing would the focus shift to the hidden form, between me pressing the button and the event firing and the hidden form is getting closed? then the new form opening?
View 2 Replies
View Related
Nov 5, 2014
I am after a script to lock a userform to the front but still be able to work on other forms.
I have an excel userform in access which does this and better still it is like a sticky note as it stays on the screen even when going to another program, but as I am working in vba all day long, every time I change something the form closes, it works great when not using vba though.
View 14 Replies
View Related
Jun 20, 2013
I have a form, frm_Master we'll call it, and on that form, within it's 'form footer' I have a tab control containing a few sub-forms, namely frm_Child.
Now, if I turn on my form footer's visibility, then the form's detail section is not shown; likewise, if the form's footer is not visible, then the detail section is.
View 2 Replies
View Related
Mar 4, 2014
How would I update all SQL stored within all forms to change its syntax?I am returning all the row-sources for all the comboboxes on all forms in an Access db. Most work fine but some have syntax errors, for example double quotes instead of single. Is there any way of finding these stored SQL statements and updating them on mass, as I am doing it manually at the moment!
View 1 Replies
View Related
Feb 7, 2014
I was just wondering if this could be done by code or he only way o do it was by the form properties?
View 1 Replies
View Related
Sep 28, 2014
Is this how to share a variable between two (2) forms ?
Form #1
Form1_Popup
Public Var1 As Integer
Form #2
Form2
Public Var1 As Integer
GotIt = Var1
View 4 Replies
View Related
Jun 27, 2014
My problem is simple, and i imagine it is easy to fix. I have more forms in my db than I would like to count, and I have a couple lines of code to add to the onload event of each form.
Is there an way, without actually having to edit each form myself, to add the code i need to add to all forms. Is there some code I can write that will let me modify the on load property of a form, and save it?
I know what i need to do, minus the part where i actually change the onload event.
View 5 Replies
View Related
Apr 9, 2015
I am creating a few forms one of which is the MAIN FORM that closes upon opening another form.
What I am looking for is when another form closes, if no other forms are open, then open the MAIN FORM again.
Can I use this : If CurrentProject.AllForms("BUT KEEP THIS EMPTY").IsLoaded Then ???
View 14 Replies
View Related
