Noob Question Sorry. Forum Sizes!

May 30, 2006

How can i make all my forums fill my screen? so dont have to recreate them? so they are not just tiny boxes. as originaly designed? I looked in hope that there maybe have been something in the startup drop drop down, but i was't so luck. also tried to select whole forum and group and name the whole thing bigger by dragging the resize command. but this just messed the whole forums up so i did't save changes.

Thanks im sure this is a really stupid question.

Shrew

View Replies


ADVERTISEMENT

Field Sizes

Jan 13, 2006

Hello,

I have database that is linked to an asp style website. In my Products table, I have a field for Product_Description. Unfortunately the descriptions for the products that I have are very lengthy, some 10 sentences and above. And as access only allows for field sizes of 255 characters max, I can barely fit 1-2 sentences here.

I was wondering whether there is a way of getting a much bigger field size at all?

Any help would be greatly appreciated.

View 1 Replies View Related

Controling Form Sizes

Oct 20, 2005

How can I control the size of my form. I would like some of my form with my program to open small, since they are small forms, and some large because they are the whole size of the forms. I hope I have explained this enough for someone to help.Thanks in advance.

View 14 Replies View Related

Setting Form Sizes

Nov 17, 2004

Hi,
I am a new member, who has been reading these postings for several weeks, hoping for a few quick answers, but no luck.

I have several issues on form size.

The first is that some of my forms open OK, but they change the form size of the form that opened them. My main form is maximized. When I open a child form, not maximized, the main form, and the open Access windows, such as the DataBase form and any open Tables, Queries, Reports, etc all become non-maximized.

The main form has the dimensions of the last-opened form .mde files, which leads me to believe that there is some Access option that crosses project or database lines. I cannot find it.

If I maximize the main form with the child form open, Access maximizes the child form also. If any form is open in Design View, the Properties window may be on top of everything. As the controls I need are seldom visible in these small windows, I spend much effort resizing windows.

What do I need to do to have a maximized "Switchboard" and smaller child windows/Forms???

View 2 Replies View Related

How To Determine Table Sizes (in Mb)

Dec 4, 2012

I have a multiuser database back end with approximately 25 tables. The file size for the back end has recently jumped from approx. 50mb to 270mb, but I do not know where the data causing this increase is placed. Is it possible to measure the file space usage (in mb) that each table contributes so that I can determine the source of the increase.

View 1 Replies View Related

Slightly Worried About File Sizes

Jun 29, 2006

Well, today I had a problem with my main access db. It stopped letting me create MDE files, and my usual trick of decompiling it didn't work. I eventually got it working by importing everything into a blank database and setting the startup form and references again. However when I did this, I noticed a very big difference in file sizes. My old MDB file was 14mb, while the new one was about 5mb.

Just wondering if anybody else has come across anything like this before? Everything seems to be working fine and transferred over corrrectly, but such a huge difference worries me slightly.

View 2 Replies View Related

Product Sizes And Differing Prices

Jun 20, 2007

Hi,

i am developing a clothing order management database.

I have so far got [order details], [products], [product details] entities.
This is so that products with the same model code can have a selection of colours and sizes which are held in the product details table.

I followed this website which was very helpful: http://www.princeton.edu/~rcurtis/ul...database2.html

The question is now: each size and colour will have a different stock quantity. How do i model this, for example, so when a Small Red t-shirt is added, the small red t-shirts quantity decreases rather than the overall quantity for the model.

any ideas?

View 1 Replies View Related

Problem With The Window Sizes On Forms?

Mar 31, 2005

After much work and help from a lot of competent ppl on this forum i have finally been able to get my dB together. Now i have a problem though which i can't solve.
Problem is this:
I open a form, lets call it MENU. From this you open a second form called NewEmployee.
In this new form you insert new data about the employee(s) and then insert them in the dB.
So far so good, but when you do a print about the employee, the procedure is this:
A special form is opened (PrintOutForm), its fields are filled with data from the NewEmployee, it is printed and then closed.
Problem with this is that the MENU form is now not-maximized :) Which it was when you opened the dB.

Is this something any of you guys have encountered before?

View 3 Replies View Related

Form Sizes And Fonts Change On Different PCs

Nov 19, 2006

I browsed a lot of posts related to fonts, and pored over my "Mastering Access 2000" and "Access 2000 Power Programming" books, but I couldn't find answers to my specific questions.

I have many years of experience with Access, but I've only recently become interested in making my forms look nice on a variety of user PC configurations. Now, like many others, I sometimes spend too much time formatting a form so it looks really nice on my PC, only to find formatting problems on the user's PC. For example, a label using Arial Rounded MT Bold looks great on my PC but is cut off on the user's PC. Similarly, Tahoma on buttons looks nice on my PC but looks bigger and bolder on the user's PC.

At first I thought this was probably a font problem. But then I realized that even with the same screen resolution, the forms themselves (not just the fonts) appeared bigger on the user's PC. Some forms didn't even fit inside a maximized Access window, whereas they certainly did on my PC - again, this is with the same screen resolution. So now I don't know if it's a font problem, some other problem, or perhaps multiple problems.

Which leads to my questions:

(1) If I set the size of a form on my PC, and the screen resolution is the same on my PC and the user's PC, then why does my form show up relatively bigger on some users' PCs? How can one control the look of a form if the form properties are not applied identically on different PCs?

(2) Why do all the fonts look bigger and fatter / bolder on some users' PCs?

(3) Is there a user-configurable Windows setting that overrides the font size settings I assign to controls?

(4) How can I determine in code if specific fonts are supported (if this is a necessary step)?

(5) What is the industry best practice for managing font selection, allowing for the possibility that the desired fonts may not be supported?

Thanks for your help...

View 1 Replies View Related

Designing Forms For Different Display Sizes

Aug 25, 2005

I have written a database application in Access 2003 for my company. I am going to deploy it with Terminal services on a Windows 2000 Server. I went to my server room to logon and test and found that 90% of the screens I designed had print and close command buttons that were off the screen. I developed the application on a 19" plat panel display with 1280 X 1024 res. The server room has a 17" Non-flat panel with 1024 X 768 res. I am assuming this is the culprit. Is there a way to make the application a "ONE SIZE FITS ALL" solution. Im sure writing a different version for every possible resolution is not how it is done. Any ideas would be deeply appreciated

Thanks

View 1 Replies View Related

General :: Increasing File Sizes In Access Database?

May 1, 2013

I have an Access Database of around 8MB. However, after a day's use, this file size increases to around 110MB. If I run a Compact and Repair, the file returns to it's usual size. The first time I noticed this, the file had reached a size of 2GB which is a bit alarming. The file does get used but only appending around 50 records a day and making some amendments. What could be causing this increase?

View 3 Replies View Related

General :: Distributed Application - Variable Screen Sizes?

Mar 26, 2013

Is there a means of making an application grow/shrink to accommodate different screen sizes? eg. not all users of a distributed application will necessarily have the same screen size.

View 2 Replies View Related

Forms :: Formatting Datasheet Font Sizes (Access 2010)

Sep 18, 2013

Using Access 2010, I have a subform in datasheet view and I want to set the font size to 10pt. Setting font sizes for datasheet fields in the Format tab does not change the font size displayed.

I understand that the font size can be set using VBA (for example: Me.DatasheetFontHeight=10). Where do I put this code for it to work in a) a single datasheet b) all datasheets in the db?

View 6 Replies View Related

New To This Forum

Mar 9, 2007

Hi,

Before I ask my question I was wondering if it was possible to attach a zip file of the database I'm working on? It would save some typing.

Thanks

Eddie.

View 2 Replies View Related

Hello I'm New To This Forum And I Have A Question :)

May 16, 2005

Several of my databases is a little slow and that puzzles me since there isn't over 200mb of data yet :confused:

Is there any advantage in storing data on an oracle server and will it speed up things or is there other things I can do?

Perhaps someone in here would be so kind to look at my database and give some advice on the structure and possible changes to improve performance?

Perhaps I should add that I don't know much about other database tools so I'm shooting in blind here.

So if anybody will look at my database and see if he/she can optimize it I will be happy. I can leave little data inside to allow You to see the output - if needed.

I'm not very technical with access (not yet) so things might be done differently than I do to speed up things

Any help is greatly appreciated :)

View 4 Replies View Related

Forum Restructure

Mar 19, 2007

Due to the ongoing bulk of regular spam posts that this forum receives, and based on similar activity on other forums, I think it would seem to be that the reason for this is the use of the word 'General' in the forum's title. In my experience it is the areas marked this way that generate the most spam, be it 'General Discussion' or otherwise.

So, in order to try and combat this, I was thinking that it may be in the forum's interests to change the name of this section. If it's what spambots are geared up to search for then it makes sense to shield the target from them.

My thinking is that, were I to change the name, the forum would be best placed at the base of the 'Microsoft Access Discussion' area and renamed to 'Other Issues'.

Thus, my plan would be to have the 'Microsoft Access Forum' ordered in this way:


Database Design
Tables
Queries
Forms
Reports
Macros
Modules
Other Issues


I'd appreciate others thoughts on this so reply away. There's a poll at the top of this thread if you just want to post a yes/know/don't know sort of response. The poll will only be active for one week, starting now.

View 14 Replies View Related

This Forum Got Me In Trouble...

May 1, 2007

Hello all active members of this forum,

Like I stated on the title, this forum got me into trouble. By following the reading in this forum and some recommendations from the regular users I have created thre database for the place I work at. now they want me to be the official DB admin! :eek:

So now I'm coming back to you guys for more advice... :rolleyes: what reading should I do to better my Access knowledge over all.

Any recommendation is welcome.

I have already contacted th local college and they do have a distant learning class for Access and I will be taking it the next semester, but I would like to do some reading into becoming a REAL Access programmer with a solid foundation.

There must be some good books out there to purchase to get me started. So all are welcome to give me some feedback.

Thanks!

René

View 14 Replies View Related

Forum Database

Jan 2, 2006

I have been tasked to design a Forum Database using ASP, could someone please point me in the right direction as to the design for table structure for this.

I know that the user will be looking at a web front end which in turn will be accessing the Access Database.

Any assistance would be much appreciated.

Dispersion36

View 1 Replies View Related

Question On This Forum

Oct 10, 2004

How long normallly does it take to get an answer?
Also, what does the "View" on the right margin mean?

View 4 Replies View Related

Does Anyone Know How To Post A Db On This Forum

Mar 17, 2005

could anyone please tell me how to post a database on this forum ive tried attachingit but it says file not suitable

View 4 Replies View Related

Complex Sub-forum

Jan 5, 2007

I'm trying to design a system for an electronics shop. I have two tables, one called Products and another called Suppliers.
The Products table has the following fields-
- 1) Product ID
2) Supplier ID
3) ProductName
4) Information
5) Price

The Suppliers table has the following fields-
- 1) Supplier ID
2) Company
3) Address 1
4) Address 2
5) Address 3
6) Town
7) County
8) Post Code
9) Country
10) PhoneNumber
11) FaxNumber

Basically I want to create a form to show the supplier name and ID and then implement a sub- forum which shows all the product details for that supplier. How do I do this? Do I have to use a query?
Thanks

View 2 Replies View Related

Recommendations On SQL Server Forum ?

Oct 6, 2005

Recently I moved the back end of some databases I develop and maintain to a SQL Server for speed and stability purposes.
Whilst this forum has been great for digging out answers to various Access problems I encounter, I persume there are some similar forums dealing with SQL.
Has anyone got some recommendations ?????

Thanks

Richard

View 2 Replies View Related

Report Spaming On This Forum

Jun 5, 2006

How does one report spaming on this Forum?

View 3 Replies View Related

Publishing URLs In This Forum

Nov 1, 2006

Brain-death is a horrible thing to witness.

I have searched FAQs, advanced search, etc., and know I'm not looking in the right places.

Question: How do you, in this forum, publish a URL using a descriptive title versus the actual URL itself?

Obviously it's not rocket-science since so many contributors do it apparently effortlessly, but folks I'm struggling.

Please point me in the right direction.

Thanks - Bob

View 3 Replies View Related

Using Google To Search The Forum

Feb 9, 2007

Did you know that you can use Google to search the Access Forum and get a more refined result?

I find that the search facility provided is excellent at searching for single words. However it does not provide the sophistication of tools like Google for searching for exact phrases.

To get this sophistication do this:

Open Googles advanced page: (http://www.google.co.uk/advanced_search?hl=en)

The first section of this page is shaded blue, and contains the following items:

with all of the words
with the exact phrase
with at least one of the words
without the words

You can add words to varying degrees of sophistication for your search.

This is the important bit!
Just below this blue shaded area there is another section, go to the fifth item down in this section which is:"Domain" also make sure "Only" is selected. In the next text box (to the right of Only) place the domain you want to search in, this case you want to search the Access Forum so place in this box the following:

http://www.access-programmers.co.uk/forums

Now give it a try! Try searching for: "Date Selection" (without the Quotes)

If you search for this with the above Google method, you will get 90 results, If you search this result with the Forum search then you will get over 300 results.

Caveats:
Your search will only return items within the access-programmers site, and only items that are allowed to be indexed by Google.

Cheers Tony...

View 14 Replies View Related

How Do You Put Usernames In Forum In Access? Please Help Me?

May 25, 2006

Hi,
I have been using access for quiet awhile (I learned it 2 months ago). I want to have a online business (using Dreamweaver and Access) but, I want to organize my data and I want to figure out how (when you go onto a website say target.com) to make the username and password in Access (Like when you register for an account, you put in your username, password, email address...ect. and the you make your account and then when you put in you username and password again to log into your account (I want to know how to do that)). Another thing, when the person logs into a account and wants to buy a product how do you do that in access.
Any answers can help me.
You could send me a link to a webpage that tells me how to do this stuff.
Any Tips?:)

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved