I currently have a textbox on a form where on mousedown it launches a calendar and on click it allows me to select a date. It has a validation rule that controls what date can be selected.
However, if I go to a record that has a date entered in the textbox and try to delete the value then the validation rule kicks in. How do I modify it so it will allow me to enter a blank value?
Private Sub Calendar1_Click()
If Calendar1.Value >= (MDate1 - 7) Then
MsgBox "Cancellation must be at least seven days in advance of the first meeting.", vbOKOnly, "Cancellation Date"
Else
CDate1.Value = Calendar1.Value
CDate1.SetFocus
Calendar1.Visible = False
End If
End Sub
Private Sub CDate1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Calendar1.Visible = True
Calendar1.SetFocus
If Not IsNull(CDate1) Then
Calendar1.Value = CDate1.Value
Else
Calendar1.Value = Date
End If
End Sub
I have a couple different reference files that get updated each week. Sometimes there are missing data elements, so I'd like to structure a select query to show me those records that have blank elements but I'd like the similar records to be pulled in as well, so I can make a determination as to how to populate the blank records..
See attached example: I have a client ID reference table that gets populated with forecast owner names (individuals responsible for the customer) from a couple of different sources. Sometimes there are names attached and sometimes the field is blank.
How can I structure a query to show me just those Client ID's that have multiple entries with blank AND non-blank forecast owners? I'd also like to exclude single/multiple records where there are only blank records...
OK, I have been searching around on the fourm for over an hour now...I give up. If this is some where else, I am sorry.
I have a database of maintenance data. There are several columns that are usually filled in, some records have some columns blank. They are formated text because they hold letters and numbers (see pic).
I am using a form to query the table...no problem. The form has text boxes the user filter down the data
The problem comes are with the results of the query. Any record that has a blank column is not retuned. I am using "Like" so that the user can enter in partial codes. I know "like" won't return "null" records.... Help!
Things I have tried: 1)IIF(form field is blank, return table field, else use like command to filter) - returns nothing! 2)Like "*" & [Forms]![Fleetwide_data_Request]![MAL_CD] & "*" returns all records without blanks (i.e. missing data)
I have been running the same database on numerous systems for 5 years and the user clicks on a button and using this code;
DoCmd.OpenForm "Employee", acNormal
Simple !, this always opened this form blank, without applying filters, ready to accept a new employees details.
But now this no longer works, for no apparent reason? What happens is that it opens with the form fields filled with the first person in the Databases details instead of being blank.
The only thing that could have changed is that i converted the database to 2003?
When entering information into a blank form, I would like to be able to continue entering information to another additional blank form after my last entry. Is there a way to continue to a blank form after entering information into the previous blank form? I would just like to continue without having to close the entire form and then reopening another form.
Hi All! I have Access Calendar on my form. I named it txttoday. Which code and where should I put the code in order when I open my form I want the date always be on todays date. I guess it should be on Open and something like txttoday = now()....
1) Is it possible to have certain dates always highlighted in the calendar so the user can clearly see these dates. What I'm looking for specifically is to have each second thursday always highlighted with another color.
2) Using a seperate form and calendar than the one above, how would I go about using a calendar to search for old records (apply a query to it maybe, but how would I do that?) so that when I click on a date, the records for that specific date are opened.
I really appreciate any help that anyone can offer with either question. If you leave an answer in code, can you please clearly define what you named each item that I may need to replace, i.e. Calendar, Date, etc., because I'm not incredibly familar with using code.
Thanks in advance for the help, I will be able to respond quickly if you have any questions or if I didn't explain anything clearly.
Hi All! I have Access Calendar on my form. I named it txttoday. Which code and where should I put the code in order when I open my form I want the date always be on todays date. I guess it should be on Open and something like txttoday = now()....
I am trying to use a calendar to fill the date box on a simple form, I have used the examples from various threads on here but I cannot get the calendar to pop up.
The error message I get is
Run Time Error 2110 Microsoft Access cant move the focus to the control activeXCt161
I have seen pop up calendars in use in other databases and wondered if it was possible to put one into my current DB. (The standard little Microsoft style one).
Rather than using a direct entry date field in my form how do I go about adding in a pop up calendar. Can this be done easily?
I'm trying tosetup a pop up calendar in my Access Database for users to select start and finish dates of activities. I have a calendar from here: http://www.utteraccess.com/forums/showflat.php?Cat=&Board=codearchive&Number=413286
Here is my problem, When I run the database "Calender2000" it works fine. The calendar is displayed, but when I import the database (using get external data), and try running the calander, I get the following error:
"The expression you entered has a function name that Microsoft Office Access can't find.@."
I am fairly new to Access, and currently using Access 2007. Any help appreciated (I can follow instructions in Access 2003 format).
I am getting myself into knots trying to solve this can anyone help:
I need a calender so that the user can book and check availability of courses for each date. ie course 1 has 5 places on this date, once one is booked then there should be 4 places left.
Does anyone know if there is a graphical form available which I can use for this function and serve the dual purpose of data entry?
Hi, I have find this calendar, wich is great for me as my ACCESS program is in italian and all calendars I have find gives me back date and month values in italian, this one I can set it either italian or english!!! What I need is to make it visible on double clicking on the date on a form and once opened selecting the dae on the calendar it returns the value onto my date field on the form. Thanks Marco
I would like to create a text box that when it has focus a calendar pops up, allows the user to select a date and then disappears after a date is selected, leaving the date (mm/dd/yyyy) in the textbox. Anyone know where code may be available -- I am willing to pay for it? Thanks ...
Please pardon my ignorance, but how do I set up a ActiveX calendar in Access? The help files are missing from the version of Access 2000 I am using, and I really don't know what I am doing. I would be grateful for any help with this.
I've created a database to keep track of schedules, and have created a report that displays like a calendar.
Similar to Pat's example here http://www.google.com/url?sa=D&q=http://www.access-programmers.co.uk/forums/showpost.php%3Fp%3D288791%26postcount%3D17
What I would like to do now, is create a DAP that will display in a similar format. But because the report uses subreports, it doesn't just tranfer over.
Does anyone have any ideas on how to create a simlar calendar format, within a DAP?
We want to use this on our intranet, so everyone can see each others schedules, and this is the only thing left I have to do. I just can't seem to get anything to work.
I just created a calendar pop-up for data entry in Access Version 2002 and it does not work with Access 2003. Any help from anybody would be appreciated!
Does anybody know if MSCAL.Calendar.7 can be set so that Sunday shows as the first day of the week instead of Monday.My company uses a timesheet with a week begginning on Sunday. Thanks
Is there a way to insert a calendar on a form from which a user can select a Month year and day similar to using the calendar on Outlook or Lotus Notes to set up or view appointments or meetings?
I use the Calendar ActiveX to select a date. The calendar have a dropdownlistto post the selectede date? I the calendar to dissapear after the date is selected. The selected date should remain in the drop down list. I think that the control have a dropdownlist to show the selection, but i didn't found it. Thanks, Richard
Trying to add to my DB. Looking to be able to keep track of time worked on stock parts on a weekly basis. Would like to be able to enter time at the end of the week, by week. IE; On the week of Sept 10th 29 hours were dedicated to restocking our shelves with stock parts. Is there an easy way to accomplish a calendar setup like this, as I seem top be over complicating the issue I think. If someone could point me in the basic direction on this that would be great.
I have been trying to find a calendar that I can put on a form to set up reminders, notes, and other things. I have had no luck finding such a thing. I tried using Calendar Control 9.0, but that will not work for my needs.
If anyone knows where I can get a calendar like this, or if there is some sort of code that will make this happen, please let me know.
I was wondering if there was a way to make a calendar in Access 2003? I work in a group of 60 employees and we track their vacation, and personal days in a web-based application. The web-based application is going away, as it it no longer supported. Could I use Access to create a calendar for the 60 employees and have it require a user name and password for them to log into the database to look at what vacation they have?
Would Visual Basic or C++ be a better program for this?
