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 Replies
ADVERTISEMENT
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
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
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
Aug 29, 2005
Will keeping your field size shorter result in a smaller MDB file?
Or does Access only use as much space as there is real data in its fields.
Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.
Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...?
Thanks............
..dc
View 3 Replies
View Related
May 20, 2005
I'm still in design phase but I'm going to have more than 30 tables. I know I'm going to have a pretty good number of forms, queries and reports. Should I start preparing for the worst in case this db gets too big? What kind of techiques can I use to make sure that it still runs quickly enough?
Thanks
scratch
View 4 Replies
View Related
Mar 26, 2007
Hi there..
we have one access database with size about 600mb and 1 million rows in one table.My concern is is it bad to have so much data in access database. If so what is the possible solution for that.
Thanks
Danny
View 3 Replies
View Related
Dec 20, 2007
I will like to know if access can store a lot of data. I am using a database that was written in access and the database has been in use since like 2004. How long can we still use this database. It is becoming slow and having one or two error messages.
View 2 Replies
View Related
Aug 20, 2004
How big can an Access database be without having problems with it? How many records will it actually accept?
Thanks!
View 6 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
Oct 4, 2005
Hi:
I have one problem.
If I create many many tables, then delete them, then create new tables, so on. The size of the MS Access file will become large.
So, how can I reduce the size of the file? Even though I delete the tables, the size will NOT become less, so how to reduce the size of the file?
Please let me know, thanks a lot. Thanks.
View 2 Replies
View Related
Apr 6, 2006
Hello all.
I have a large db. I need something to monitor the size of it. For example the db is saved on a server and used throughout the day. What I need is something to email me an alert when the db reaches 900mbs. Then I can compact and repair the database back down.
I do purge it annually though. Currently it is about 750 mbs.
Any thoughts, please let me know. Thanks much.
Using Access 97, 2000, and 2002.
View 2 Replies
View Related
Oct 3, 2006
We have a database in Access 97 which is 0.8GB.
Can anyone tell me:
a) The maximum storage capacity.
b) What will happen when it reaches that size!
View 3 Replies
View Related
Apr 3, 2007
Hello,
I am working on something and have to link I think a few thousand tables from a "store bought" database here at work. Is there a limit in regards to access? I know they are just linking but I didnt know if Access gets nutty after a while...
Anyone encounter functionality breakdown due to size or complexity?
Thanks.
View 3 Replies
View Related
Dec 7, 2005
Hi, i am wondering how to reduce the size of access.
i have included pictures within forms which obviously made the database bigger (it is currently around 12mb).
However i have tried to delete the pictures to reduce the size, this method did not work at all. The database remains the same size.
does anyone have any suggestions on how to solve this problem i am having?
thanks
Pete
View 8 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
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
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
Sep 30, 2005
Hey guys,
Was wondering, what is the recommended maximum size for Access databases? I've heard that for very large databases that oracle is preferred. Would Access be appropriate for something on the scope of 5000 records of roughly 6 text and 2 number fields? Do people ever notice performance effects on databases of that size?
Also are there any ways to help reduce the size of the database? Do you recommend change the default field sizes where appropriate and would this have a noticeable effect on a database of this size? Any other suggestions to help keep the database manageable, and functioning?
I'm basically trying to figure out if there's much to worry about here, before I start importing my data. Thanks.
View 3 Replies
View Related
Jan 1, 2008
Hello everyone,
I've just finished my access application, but its size is 4 Mb. I expect that it will be much bigger once users begin to add records.
What is the best way in Access to keep the size of the file as small as possible?
Many thanks in advance,
Regards,
View 8 Replies
View Related
Jan 3, 2008
Hi,
I have been given an Access database to maintain and it has some performance issues.
I have been looking through this forums for recommendatons regardng size etc but didn't really find anything.
It is all in one file (might consider splitting it..) and it has about 350 forms, 300 database queries, 130 database tables and 200 Macros!! Filesize something around 200 MB.
In one of the forms there is a drop down that when changed refreshes two other dropdowns. I have chyecked the queris used and they are really fast but it still takes at least 6-7 seconds for the 2 dropdowns to reload!
I don't know if it is due to the way it is done, the VB code calls a macro that calls a query.
Personally I wouldn't have done it like that but there has been about 2 years since I did anything complicated with access..
Or is it the size/complexity of it that makes it slow? Does anyone have experince of a similar system?
Thanks /H
View 3 Replies
View Related
