Allen Browne Popup Calendar Question
Sep 12, 2005
I'm *finally* getting around to getting rid of the ActiveX calendar control in my application. After doing battle with references on other users' systems, the ocx references have finally lost the plot and don't work.
I've downloaded Allen's popup calendar but have a problem since the app uses text boxes, and I need to add the selected date into a table with date fields. Also, instead of clicking an icon (where his instructions say to put "=CalendarFor(SaleDate],...", in my previous code I just call the calendar form from the on click event when the user clicks the date field.
I've tried modifying Allen's code to no avail, and I'm afraid of really cocking things up in all my forms, tables, reports, etc. if I change all may table's date fields to text.
Could someone help me modify the code from text fields to dates? Alternatively, is there any other calendar popup out there that would suit? (I've looked at all of them in the links but haven't found anything.)
Thank you,
Christine
View Replies
ADVERTISEMENT
Feb 1, 2005
Hi. I have managed to create a command button on my form to send a date field on the form to Outlook as a task. I know this isn't exactly what you wanted to do, but you may be able to tailor the code to suit.
Private Sub cmdOutlookRem_Click()
Dim OutlookApp As Outlook.Application
Dim OutlookTask As Outlook.TaskItem
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookTask = OutlookApp.CreateItem(olTaskItem)
With OutlookTask
.Subject = "Contact " & Me!Forename & " " & Me!Surname & ", " & Me!CompanyName
.Body = "Company Tel No: " & Me!CoTelNo & ", " & "Direct Line: " & Me!DirectLineinCo & ", " & "Mobile: " & Me!MobileNo
.ReminderSet = True
.ReminderTime = DateAdd("n", 2, Me!DateNextContact)
'Remind 2 minutes from now.
.DueDate = DateAdd("n", 5, Me!DateNextContact)
'Due 5 minutes from now.
.StartDate = DateAdd("n", 2, Me!DateNextContact)
.ReminderPlaySound = True
.ReminderSoundFile = "C:WindowsMediaDing.wav" 'Modify path.
.Save
End With
End Sub
View 1 Replies
View Related
Nov 29, 2006
I am looking at a DB I created a year or so ago... Trying to redo and correct a few problems. BUT.... I've used a popup calendar on this one... pops up from the dropdown on a text box. First, when I try to pick a date... an error happens and it closes the DB... prompts to make a backup and reopens the DB.... My problem is I CAN NOT get rid of this calendar!!! I put it in design view... delete the code... Still when I try to click on the little calendar... The same error happens. Has anyone ran into this before???I used the popup calendar from here... http://www.fontstuff.com/access/acctut09.htm
View 4 Replies
View Related
Nov 30, 2006
hi.. i have attached a simple db.. 1 table.. 2 fields..
jobdate and jobday
open the form and double click on the jobdate.. it opens a calendar.. when you choose a date it puts it into the jobdate field..
i have created a simple drop down underneath the jobdate with the days of the week..
is there a way to tweak the calendar module so it also chooses the job day.. because the days are clearly displayed along with the number dates.. so it must be possible..
here is the db in 2000 and 97 format..
thanks in advance.. i think this will benefit many users using this calendar
View 6 Replies
View Related
May 5, 2015
Is there a way to have a pop-up calendar with only a certain day of the week showing - such as all the Fridays only in the month?
View 5 Replies
View Related
Mar 4, 2015
Is it possible to have a pop-up from a textbox that has a calendar picker.
i.e. if you have a textbox formatted as a date field that has a calendar picker, that pops up every time you click in the box.
I would like a pop up to appear next to the date picker to say please ensure you do not select dates that fall on a public holiday!
View 1 Replies
View Related
Apr 4, 2012
Is there a way to ONLY allow users to select a date starting today or in the future using the DatePicker? I want to disable any past dates on the calendar popup.
View 2 Replies
View Related
Jul 16, 2007
I have a subform I am using on a form. I would like to modify the code below that I have for a button on the form. I would like to use the master and child field link in the code below to only show candidates related to the main form. The link is candidate id. I have this working with a subform on the form but I would like to have this only display as a pop-up once the user clicks the button on the form. Is this possible? Thanks..
Private Sub Candidates_Click()
On Error GoTo Err_Candidates_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "CandidatesCPR_Frm"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Candidates_Click:
Exit Sub
Err_Candidates_Click:
MsgBox Err.Description
Resume Exit_Candidates_Click
End Sub
View 1 Replies
View Related
Apr 25, 2005
How do I set a form to popup and modal? What field in properties do I use the expression.popup?
View 2 Replies
View Related
Dec 21, 2005
I have a form that we use to enter our workorders (jobs) into the database. The bottom of the form runs a query and returns record information if a car has been in our facility before.
I would like to program it so that if the query does in fact find a previous record it pops up a window or message that says so.
Basically I need something like...
If the arrival date (and/or) item number is not null then popup a message that tells you the car has been here before.
Thanks!
View 7 Replies
View Related
May 17, 2006
I'm working on an invoice system for a company and they reqiure notification when an account is called up on a form that has an outstanding invoice.
So I created a query that locates all unpaid invoices, I made a form using that query, and I want to use it as a subform on my main invoice page.
But I'd like this subform to only popup when the criteria is met, that is the name on the subform matches the name on the current invoice called up.
Right now the subform is blank when the criteria is not met, and fields are filled out when they are...but I'd rather a nice big popup that can really get their attention...any idea if this is possible on Access 2000?
Thanks!
View 11 Replies
View Related
Sep 14, 2006
Alright, I did a search for this and came up blank, but I'm sure its been asked a million times, sorry for the inconvenience:D
Is it possible to make a subform a popup form? I have a client table --1--to-many--> service table and want the service form to popup out of the client form. But I also want to the foreign key to autopopulate just like a subform would. Is there any way to do this? Are there any pitfalls to doing it this way?
Thanks in advance,
Ox
View 3 Replies
View Related
Sep 14, 2006
Hello,
I have an application where all the forms are popup (i.e. the PopUp property is set to True). It was done because the customer wanted to see only one entry of the application on the taskbar. Now I have a real problem! When the customer opens reports in preview mode, he gets it opened BEHIND the application forms =( So he can't see it. And there is no "PopUp" property for report... What should I do? How can I put the report ON TOP?
View 2 Replies
View Related
Dec 21, 2006
How do i go about making a confirm yes and no dialog.
I know i can do it with a form, but would rather have a proper one :D
View 2 Replies
View Related
Dec 22, 2006
I would like to make a form that would pop up in a standard keypad format. This would allow me to enter the number and on close, it would place it in a chosen field. I saw the one that was is a previous thread and it does make sense to me.
Thanks for the help
View 1 Replies
View Related
Aug 30, 2004
I am using an Access generated number for a "ref. number" I would like to know how when im in a form shown the box that would house that number, and someone clicks on the "ref, number" box a popup "search" would appear.
View 1 Replies
View Related
Sep 22, 2004
i have a Simple form called people. it has three feilds on it called
name
address
city
i have a button next to address that onclick popups up the form called address.
once the user finds the data i have a ok button. Now what i want done is when they click ok
it populates the address field on the people form. no one seems to be able to help me?
NAy examples would be great
thanks
View 1 Replies
View Related
May 9, 2007
I have made a message service in access db using a pop up on timer even.
It works fine but sometimes it does not load. My db is split db and so what ever I am doing, doing on my machines only. So is there any way to check if a form is loaded and if its loaded then do requery.
View 1 Replies
View Related
Dec 20, 2007
On opening the form, i want to give a command with Move To command to move to the right upper corner. Is there any such command ?
View 1 Replies
View Related
Feb 6, 2008
Hi everyone,
I have a main form showing a number if information for one project. Within this form I have yes/no buttons that when clicked, open a popup form where you can add additional data. The problem I'm having is that when opened, the record # for the pop form does not match the record # for the main form.
Example: Let's say I'm in the main form and showing record #5. When I click the yes/no button to add extra info, the popup form opens but it shows record #1, not #5.
Any ideas how to tell the popup form to link with the corresponding record would be very much appreaciated.
Thanks
View 6 Replies
View Related
Mar 31, 2015
I am getting 2 problems what I am trying to do is depending on the user logging in I want to open form (Aform) on specific record for that person ID. However where Y=1 I am getting a popup asking for AForm ID and where Y=2 I am getting run time error 3075 Syntax error (missing operator) in query expression.
Code:
Private Sub Command6_Click()
If IsNull(txtUsername) Then
MsgBox "Invalid username"
Exit Sub
End If
If IsNull(txtPassword) Then
MsgBox "Invalid password"
[Code] ......
View 1 Replies
View Related
Apr 21, 2006
Hi all,
Is it possible to have a Continuous form that is a pop up.
Any ideas.
Many thanks
View 1 Replies
View Related
Jul 3, 2005
Hi All,
I have a form that has a combo box and a subform. After a choose the value of the combo box I want to start adding values into the subform, and I want to be able to select the values that are to go into the subform fields. Now I am thinking of using a pop-up subform which shows the values that I can choose from and then as I close the form it will populate the fields of the main subform.
Is it possible and has anyone got a little example of form that can do that. If so can you put it as an attachment to this post.
Thanks
Greg
View 1 Replies
View Related
Jun 8, 2006
Is it possible to make a query Pop-up? All of my forms are set so the Database background is hidden and they popup. I haven't been able to figure a way to do this with a query. Any help or suggestions would be great :)
View 6 Replies
View Related
Jun 6, 2007
I have no idea wheather this is supposed to go in Queries or Forms, so feel free to move this to either.
Here's my problem:
I made a query that looks at three text boxes on a form. I'm not sure how to set up the buttons correctly so I just bluffed it (like always :) ). Every time I run the query it keeps wanting me to re-enter the data that it was supposed to look at anyway! If you need more info, just ask. Thanks.
Anonymous_354
P.S.: I'm really new at this. I just learned about Access a week ago.
P.P.S.: I use Access 2000
View 14 Replies
View Related
Feb 23, 2005
Hi
All my popup forms come up at the wrong size. I have popup = yes, modal = yes, border = dialogue box settings. I have tried this with both autoresize on and off. One form comes up to small and one comes up to big. I've tried changing the size of the form in design mode, but this has no effect.
Could someone please help me pls?
Thanks.
View 3 Replies
View Related