Putting "indicators" On Tabbed Pages

Nov 1, 2005

I saw a database the other day that had tabbed pages and on each tab was a square that turned green when data had been entered on the page and red when there was no data.

is this easily done - can anyone give me a link where i can read up on it or suggest how to do it?

View Replies


ADVERTISEMENT

Properties Of Tabbed Pages

Jul 16, 2005

I have a number of tabbed pages and I was wondering if you could increase the size of the tab to make it (Vertically) larger so you could write the headings over two lines.

Also what does "Multi row" mean in the tabbed row pages?

View 1 Replies View Related

Tabbed Pages With Subforms

Jul 14, 2005

I have created a form which has a main section (Client demographics (bound to tblClient) and then five tabbed pages with subforms.(Data associated with the Client- all forms derived from tblAssociatedDetails). The subforms on the tabbed pages are all linked via a ClientID number.

In the form header I have put a a combo box and with the wizard said that I want it to select data from my form (in the case search via Surname). This works but only for the top part of the form (ie it will load the demographics) but will not load any of the data from the tabbed pages (subforms).

Any idea where the missing link could be?

View 1 Replies View Related

Tabbed Pages - Code Doesn't Seem To Work

Nov 13, 2006

I'm using a 5-tabbed form and have put it in my detail section.
Within the on click event of one tab knob i would like to activate some knobs in the form header where the tab resides on.

I've coded everything properly but in one or other way access doesn't seem to communicate between the tabbed form within the details and the form header. Anybody an idea?

View 4 Replies View Related

Putting It All Together

Mar 25, 2007

I dont know hot to say this but lets try :rolleyes:


I have about 8 forms each form with a table behind it or a query, so the user starts at the first form selecting this and that, after the selection a button is pressed another form opens the user fills out the information and presses a button and another form opens and so on until all the information have been filled.

My problom is that I want this to be only one window (form), and when the button is pressed this form changes to next window and so on.

Now it works like when the button is pressed a new windows opens and this window (form). The user can see this as a another form I want the first form to change into the second and the second to third and so on.

Hopefully someone understands what I am trying to say.

Best regards
Frodo

View 4 Replies View Related

Help Putting Password On Please Help

May 4, 2006

hi im doing my A level course work and im wanting to put a password on my database, so if i want to look at the tables ect i need to put a password in, i think its something i have to do in quries but im not sure please can someone help me i have to have it finished for tomoz thanxs

View 1 Replies View Related

Putting An .mdb On A Server

Nov 7, 2004

soooo now my client wants the program i just wrote on his brand new server that he doesn't know how to use. i've semi-split my db (i kept my lookup tables with the program to save room for data). i'm not very familiar w/networking. my assumption is that i just put the BE on the server and put the FE on their machines, but i was wondering if i could put both the FE and the BE on the server with a shortcut to the FE so that i could update it and not have to worry about making sure everyone has the most recent copy.

anyone have any suggestions on how to make this run smoothly and make it appear as though i have some semblance of what i'm supposed to be doing?

-Jason

View 14 Replies View Related

Putting Queries In A Folder

Jul 31, 2005

Hello,

I have created an Access DB for personal use and I am willing to sort the queries in folders. I haven't found a way to do this, is it actually possible?

Having 40 queries all inside the database window is not so convinient...


Thanks in advance for any replies.

View 1 Replies View Related

Help With Putting A List In Access

Mar 20, 2006

i have started to try putting the concrete records i keep on excel into microsoft acces. for each record, i need to make note of the vehicle registration numbers. what is the best way of doing this? if it is possible

Thanks

View 3 Replies View Related

Putting Row Values Into Columns

Nov 17, 2006

Hi,

I have been trying to figure this out for a long time. Any tips/helps is much appreciated it.

I have a table with 3 columns(SSN,DeductionType,DeductionAmount). Let say I have 100 employees. There are 3 records per employee, because each have 3 different deductionType(TypeA,TypeB,TypeC).

I want to create a queryTable that will result with 1 record per individual, with TypeA,TypeB,and TypeC as column names and the DeductionAmount as their values. Make sense? Below is an example of what the new table should look like:

SSN--------------TypeA-------TypeB-------TypeC
022-58-5898------ $10.35-----$25------------$14
036-89-5487-------$5----------$45.69---------$47.33
...
..
.

Thank you VERY much!

By the way, if QueryTable is not the method to do this, please let me know how.
Joe

View 4 Replies View Related

Putting In A Date Range

Jul 20, 2005

I'm a beginner to Microsoft Access, and I just started working on a project for a marketing company I work for. I have to build them a pretty straightforward database which has tables including Clients, Contacts, Vendors, Employees, Timesheets, etc. The point is to have any employee be able to work with the database and enter any piece of information they have into it. Again, it's a pretty straightforward database. Right now, I am working on a search form for specific jobs. For example, if they need to design a website for a particular company, that specific website job will be entered into the jobs table. I am working on the search form right now so that they can search for specific jobs and they will come up.

One of the sections of the form is a date range, for date received. For example, this would apply if they wanted to search for all jobs that they received between 1/1/05 and 7/10/05. In the query that I am designing for this form, I have the table entry "Date Received" apply to both of the two boxes in the form (I titled them "What Date Received 1" and "What Date Received 2"... my boss advised me to title the boxes in the search forms "What ___" to not get them confused with the forms displaying the information). In the query, the code I am using right now for Date Received is this:

Between [Forms]![Search Jobs]![What Date Received 1] And [Forms]![Search Jobs]![What Date Received 2]

I've also tried this code:

(Between [Forms]![Search Jobs]![What Date Received 1] And [Forms]![Search Jobs]![What Date Received 2]) Or IsNull([Forms]![Search Jobs]![What Date Received 1]) Or IsNull([Forms]![Search Jobs]![What Date Received 2])


The first code works if I have things entered into these boxes. However, if I try to search and leave these blank, I never get any results. I tried playing around with some "IfEmpty" statements, but none of those worked. The second code doesn't work either. Does anybody know how I should modify this statement so that if the "Date Received" boxes are empty, it just ignores it? Thanks a lot.

View 2 Replies View Related

Putting 0 Where Field Is Empty

Jan 12, 2006

I have a query which has a field where it shows reservations. if there is no reservation the field is empty.

how can I achieve getting a 0 in this field when it is empty?

View 14 Replies View Related

Putting A Graph In Form

Apr 14, 2005

Hi,

I would like to display a graph in a form along with the fields from a table. The user will be allow to update the table and the graph will be updated. So far I am able to display the graph on the report but I cannot find a way to display the graph on the form. Can somebody help? Thanks in advance.

View 2 Replies View Related

Putting A Query Into A Form

Aug 9, 2006

I would like to put a query or some look up device into my form so that a certain part number can be found and its form opened for changes. How should I do this?

View 1 Replies View Related

Putting A Counter On A Form

Sep 16, 2007

Hello everyone, new member here. I am in charge of a student sign in sign out database at the college where I work. This database has two forms and one table. What I would like to do is include a text box on the first form, which is the sign in form that will display a running total of the students that are signed in. This text box should count 1, 2, 3 etc. each time a student clicks the sign in button. Thanks for the help

View 4 Replies View Related

Putting A New Line Into An Email Messsage

Feb 1, 2006

Hi.
I am just setting up a command button so when it is pushed, outlook opens and I can send a message.
The code for this I got from another thread.

I am sure this is a simple one (?) but in the message of the email, I want numerous amounts of lines, not just the one.

This is the code for the message subject (taking from the thread)

strMessage = "Hello" & " " & Me.cboChampion.Column(1)


I want about 10 lines, not just the one. I tried copying the same line again, but that didn't work

I am sure this is basic coding....just can't find the answer.

Hope this makes sense.

Thanks.

Frank.

View 2 Replies View Related

Putting My Database Online.... My Options??

Feb 13, 2007

I would like to put my database that I have created online so I can update it from anywhere, and was wondering what are my options - does access have a feature to do this? Or will it involve using dynamic coding to update the tables? I would like to use the forms that I have already created etc ... but is this possible?

I have my own server if this helps?!

thanks

d

View 3 Replies View Related

Putting Query Result In One Field

Nov 7, 2005

Hi,

I have a two column table and I want to display all records in the second column but I want it to be displayed in another single field.

Anyone has a trick on this?

Example:

Column1 Column2

001 Basket
002 Jar
003 Pillow
004 Hat


Result should be something like this:

Basket, Jar, Pillow, Hat

View 1 Replies View Related

Putting Command Buttons On Forms

Aug 4, 2005

I ma going to sound a complete idiot with this question, but I have been working on a database for some time now, successfully putting buttons on forms with the wizard, jumping from form to form, form to report, basically the button wizard used to work now it doesn't and I don't think I have done anything stupid. (I hope). The wizard was brilliant, I'm lost without it. How do you restore it?

Thanks in advance guys. :confused:

View 2 Replies View Related

Putting In The Date After Field Is Input

Jan 26, 2006

Sorry guys, I thought this would be simpler than it was!

Basically I just want to update my "Resolution date" field with the date or time now (which I know how to do) but AFTER I input data in my "Resolution" field ie I want a field to automatically record what time I am entering the text in my "Resolution" field?

How do I do this, and can I do it without writing a macro? I thought it was along the lines of After Update, but now I am confused!

Thanks again - I am learning just slowly!

View 5 Replies View Related

Getting Value From Form And Putting It As The Field Criteria?

Jul 11, 2006

Somewhat simplistic question, but I can't seem to get it to work correctly.

SELECT Field1, Field2
FROM Table1
WHERE Field1 = [Forms]![Form1]![Text1];

Form has two quieries, named Text0 and Text1. Text0 contains the Field info for the query to search under.
How do I change it so that this will work.

SELECT Field1, Field2
FROM Table1
WHERE [Forms]![Form1]![Text0] = [Forms]![Form1]![Text1];

Presently I am getting nothing but blank queries. I'm sure its some simplistic thing but I can't figure it out atm.

View 4 Replies View Related

Forms :: Putting Text Into Combo Box?

Apr 5, 2015

I have a combo box with an associated label.

I want to eliminate the label and have the label text be part of the row source of the combo box.

The combo box is based on a select statement.

View 14 Replies View Related

Putting Linked Tables Into One Table?

Sep 17, 2013

I have multiple tables that are linked to excel. I am creating a product selection tool to make it easy to find the products contained all these linked tables. They are necessary as they contain pricing data and information necessary to be kept in excel which is regularly updated.

Is there a way to create one table containing data from all these linked tables? I tried using an append query but realise that when the linked tables are updated the table containing all the data wont be?

View 3 Replies View Related

Tabbed Form

Apr 15, 2005

I have 7 tabs on my frmQuestions. They all the same layouts (see attached). Each tab has its Save_Button (e.g. CmdSave1, CmdSave2, ... ,CmdSave7). I do not want to write the same procedure on each CmdSave1_Click(), CmdSave2_Click() ..., CmdSave7_Click(). Are there any alternative ways to do this such as concate the string or ?

Thank you very much!

View 7 Replies View Related

Tabbed Form

Oct 17, 2004

When I load my tabbed form, it always scrolls it down a bit and cuts off the tab. The user has to scroll up to show the tabs. I have tried any number of things and cannot get the form to open with the tabs showing. Is there a setting I am missing??

View 7 Replies View Related

Putting The Same Text Into Every Cell In A Query Column

Jul 22, 2005

Putting the same text into every cell in a query column

Hi All,

I sometimes have to mark every record in a query with the same text in a field, when the field is either empty or contains whatever text.

At present I do this by copying the text, and then pasting it (ctrl-v cursor-down, a thousand times) into every cell in a column.

How can I do this in a more efficient way?

Thanks for your help.

Adrian

View 8 Replies View Related







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