How To Use Stephen Lebans Calendar In 'reverse'?
Feb 8, 2006
Hi.
I've downloaded Stephen Leban's nifty calendar and have it working beautifully to enter in dates and ranges of dates to a fishing schedule table (this is a fishing regulations database). (thanks to RuralGuy for posting the link to this, and other calendars, on another thread)
I have a form for entering some parameters to narrow the results of a select query that shows the start and end dates for individual blocks of consecutive time for each scheduled fishery. (Some fisheries might be scheduled to occur every thursday and friday for a couple of months, or other hard-to-predict ranges of time.)
What I would like to do next is to click a button on the form to make the calendar appear with all the dates where fishing is scheduled to occur (from the query results) be highlighted, or circled (or something equivalent).
My vba 'skills' are not up to tinkering with his class module without some serious assistance. Has anyone tried something similar to this with his calendar? Is it even possible?
I have seen other calendars that do something similar (though I'm still in over my head trying to figure out the modules) but I'd really like to keep with Stephen Leban's calendar since it allows much more felxibility in displaying over various time intervals.
I would greatly appreciate any assistance. Thanks.
View Replies
ADVERTISEMENT
Feb 13, 2008
Hi,
I've just installed Stephen Lebans Rich Text Control as I have a a couple of memo fields on a form on a 2003 database where the user needs to be able to bold parts of the memo. I've installed it fine, and put the text control onto a form and it doesn't seem to do what i need (i.e. the Bold button isn't even enabled on the toolbar). I've downloaded the sample database that he has on the site and this works fine suggesting ive installed it correctly and i am going through the properties of the control with a fine tooth comb but havent found anything different yet to what i am doing on my trial form.
Any ideas what I've missed?
View 1 Replies
View Related
Mar 17, 2008
Hi, all--
I recently downloaded the Lebans RTF control (recommended by a user on this forum). I want to use it to allow formatting within a memo field.
Although I havRTF2 Control Design View Windowe it basically set up, it seems that I keep losing the use of the "RTF2 Control Design View Window". Instead of seeing the content of the record I actually see the words "RTF2 Control Design View Window" in the field either in in a form or report. If I close the database and reopen, the content of the record may appear but it will not stay.
Anyone else have this problem? Any ideas? I am totally new at this sort of control.
Thanks.
Paul
View 3 Replies
View Related
Oct 14, 2005
I have a one-to-many-relationship set up. Now I need to jam each related many into one field in a new table to make it like a list. Is there an easy way to do this?
View 4 Replies
View Related
Sep 21, 2005
Hi
Im working on an Access Database at work. It records the training undertaken by NHS clinical, managerial and admin staff in Brighton. It is used also to generate invoices etc.
I have a better knowledge of access than anyone else here (outside of IT department obviously) so I have been asked to get rid of some glitches and add some functions.
A big hurdle I have found is this:
I can very easily for example, add a command button to open a form, run a query etc, using the wizard.
However I am trying to ascertain what some particular command buttons actually DO. Am I right in thinking there is no way of "reverse engineering" using the Wizard or similar? Because the only thing I can find is Properties > Event > Onclick [eventprocedure] and if you click on build you just get visual basic which I sadly dont understand.
Im not sure if ive made any sense at all. In essence, im saying that making stuff seems easy, but working backwards and dissecting it seems to only result in VB code.
Is there a way around this?
Gazz
View 1 Replies
View Related
Jul 15, 2006
Is there a way to reformat so that the line that is the next line to be entered is at the top instead of the bottom >> I hope that is clear
Also when i use the scroll bar at the bottom at the very end to the right it show grey in the background is there a way to limit it so only what is used is showing
Thx STeve
View 5 Replies
View Related
Sep 14, 2005
I split a database and created a backend but now I dont need it and I accidentally deleted the backend while I was updating the file folder and it was on the network so it's gone for good.
Is there a way to reverse splitting a database so it no longer requires the back end?
View 1 Replies
View Related
Nov 8, 2005
i have a lists of emails+domain names eg camae@yahoo.com. im trying to sort them in reverse order but "reverse" seems not working in access. anyone knows how to do them or i was thinking of sorting the list begin with the domain names (which is after the '@') but i dont know how. ive tried using "like "*@[a-d]" but the result displayed is not sorted in alphabetic order. sorry im a beginner. thanks in advance
View 8 Replies
View Related
Jun 9, 2006
I have two tables A and B. There is a 1 to many relationship between A and B. Table A's data is controlled by FormA, Table B's data is controlled by FormB which is a subform on FormA. I already have a combo box for navigation on FormA, however I would also like to be able to have a combo box on FormB (FormA's subform) for navigation, so that when I choose an record from the subforms (FormB) combo box, FormA then jumps to the 1 record from FormA that contains the related record choosen in the SubFormB's combo box (along with the subforms choosen record on the subform) .
Kindalike the combo box on FormA, except it's a 'reverse lookup' if that makes sense. Is this at all possible, does this even make sense? :confused:
_______________
HOLY CRAP BATMAN!!!
View 2 Replies
View Related
Aug 21, 2014
I have a table with data that is imported from another application. The employee name is showing up as LName, FName. What function can I use to make these FName LName with no comma? I know I may have to do a two step to separate the two then concatanate but not sure how to do it.
UTA: I figured out LName: Trim(Left([ApprovedByFullName],InStr([ApprovedByFullName],",")-1)) to pull the last name minus the comma. How do I pull the first name?
View 7 Replies
View Related
Mar 22, 2006
Hi everyone,
I have learnt so much here and I could do with some advise from all of you.
Recently I have developed a software using MS Access and I am in the process of getting Copyrights, Trademark rights for my software.
The software is to be distributed via the internet for personal use. However, I have been having serious concerns about people trying to reverse engineer the code and selling it under another name.
The last thing I would want is someone else making money off pawning this. Not only does it bring bad credibility but can really dent the business end for me.
Can anyone please suggest any way that I can block anybody from reverse engineering the code.
Also how can I make my program user specific and tamper proof??
Thanks and appreciate your help.
View 6 Replies
View Related
Aug 3, 2015
I'm using I have a secondary control being populated by an entry from another control. I was able to find the code I needed to do this using a combo box here in this forum.
me.txtDependent=me.cboPrimary.column(#)
(specifics changed to protect my company's paranoid view of privacy)
the code itself was showing up in the secondary control instead of any value. I found though that moving the code from the On Change event for the primary control to the On Current event for the form itself everything is working beautifully.
However, I have a different task now that I need to be able to accomplish with the same two tables but in the opposite direction. I suspect that I'm going to need to create a second set of controls and maybe even a second relationship or table to do this. To use a set of specifics that I think will get this point across, if I had a master table which includes a field for "City" and a secondary table, CityState, which contains both "City" and "State", and two controls, a combo box cboCityState to look up the specific City and a text box, txtState to display the State, putting the following code in the City combo box's On Change event populates a text box with the State when the specific City is selected, or putting it in the form's On Current event will be sure that State shows up in all the copies of a form when the form is used in a search and the City is not changed :
me.txtState=me.cboCityState.column(2)
What I need to do now is to set up a control which allows me to type in the State and have the results show all records that include that State.
I'm using this in a Filter by Form environment. I know the objections to this method and the benefits to creating a dedicated search form, but this method appears to be working well in all other ways for us for now. I have several situations within this form where I have one control showing up at the initial load of the form and at the beginning of the filtering process, allowing selection of multiple values from a long list of values in a list box, for instance, (using the On Filter event) and other controls showing up as a result of the filtering process, to display the selected criteria only, for instance (using the On Apply Filter event), so I'm aware of how to make this work if that's required. I'm thinking I may need to create a second control, something like txtStateInput, to accept the State search criteria and another, something like txtCityResults, to show the cities that are part of the resultant records.
View 5 Replies
View Related
Jun 13, 2013
One of my clients has asked me to look at building a way to check if the email addresses they are capturing in my CRM are valid. He want's to go beyond checking for no "@" etc.
From what I've seen, it looks like a reverse DNS check (might be totally wrong) is the way to go. IE: check if the email is valid. I've see a few tools online that can do it one by one (which I could parse to if I had to) - but ideally I'd like to be able to run this from a VBA script.
View 9 Replies
View Related
Jul 22, 2006
Hy!
I've putted on calendar on an database but by example when I press first of June how can I make it recognise which week day is it?
Thanks
View 1 Replies
View Related
Jan 2, 2007
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()....
Please advice,
B
View 2 Replies
View Related
Mar 18, 2008
Using an activeX calendar. I have 2 questions.
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.
View 10 Replies
View Related
Jan 2, 2007
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()....
Please advice,
B
View 2 Replies
View Related
Mar 10, 2005
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
Any thoughts on how I can fix the problem?
View 1 Replies
View Related
Sep 28, 2005
Hello,
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?
Thanks
View 2 Replies
View Related
Feb 8, 2006
i cant hide the calendar when u open the form and i cant click a date without an error appearing help please
View 6 Replies
View Related
Mar 17, 2006
Hi all.
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).
sugar05
View 2 Replies
View Related
Jun 7, 2006
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?
View 1 Replies
View Related
Aug 27, 2006
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
View 1 Replies
View Related
Oct 31, 2005
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 ...
View 5 Replies
View Related
Jun 6, 2005
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.
Thanks.
View 3 Replies
View Related
Aug 3, 2005
Hi,
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.
thanks
Chris.
View 2 Replies
View Related
