Forms :: Possible To Show Difference Between Entering Actual NO And Never Ever Visiting Box In First Place

Jun 14, 2013

My friend uses quite a lot of tick boxes for Yes/No questions. he asked me if it was possible to show the difference between entering an actual NO and never ever visiting the box in the first place. I replied "that's easy you need tri-state".

I can switch tri-state on all right but the table field is still Yes/No so it does not save the third state. Second attempt is to replace the tick box with an option group showing yes/No/Not clicked. Now I find that I am trying to use the "improved" version 7 interface and I can't get the option group wizard to work at all.

View Replies


ADVERTISEMENT

General :: Difference In Size Between Actual Access Database And Its Backup

Aug 19, 2014

I am using Access 2007 database in work environment. When one of my colleagues tried to update some records in a table, it created a backup of the database.

The issue is that the size of the actual database is much smaller than the size of the backup. However all the data are present and I don't think any data has been deleted.

But I don't know why there is a difference in size?

Some of the tables in the database are linked from MS SQL Server.

View 4 Replies View Related

=Weekday([Date]) Show Actual Day Not Number

Apr 5, 2006

I am currently using the =Weekday([Date]) formula to show which day of the week is it, but is it possible to show the actual day not a number?

Eg instead of "1" it shows "Sunday"

Cheers

View 1 Replies View Related

Queries :: Expression To Show Years And Month Difference Between 2 Dates?

May 6, 2014

I am wanting to get an expression that will return the difference in years and months between 2 dates. Specifically, I want to know peoples ages in years and months based on a person's D.O.B and todays date. I have managed to do it in years:

Expr1: DateDiff("yyyy",[TBL_EmployeeDetails]![D_O_B],Date())

and in months but I would like to know how to return the difference in years and months.

View 1 Replies View Related

Queries :: Calculate Time Difference And Show Result Under Certain Criteria In Query

Jul 9, 2013

ID Up Time Down Time
John 18:00 15:00
Kelvin 08:00 08:05
Melisa 23:00 02:00

This is the Table , i need the Query result show IF [Up Time]-[Down Time] is >=3 hrs

Like Below :

ID Up Time Down Time
John 18:00 15:00
Melisa 23:00 02:00

IDUp TimeDown TimeJohn18:0015:00Melisa23:0002:00

I tried DateDiff("h",[Up Time],[Down Time]) in Field but POP out with error "Syntax error (comma) in query expression 'Table1.[DateDiff("h",[Up Time],[Down Time])]' " ...

View 9 Replies View Related

Forms :: Conditional Formatting On Actual Data Control

Apr 1, 2013

I inherited an Access 2000 (2002?) database that uses a textbox behind another to change the background color based on two different fields.

The Format property is set to: "[Green];"[Yellow], the Data ControlSource is set to:

=IIf([chkCheckedIn]=True,1,IIf([PassExpired]="NO",1,-1))

I understand the IIF(), but what's happening with the crazy characters? (It works the text changes from yellow to green). I tried replacing it with conditional formatting on the actual data control. That only changes color when I click on the control. The above shows the color all the time.

View 1 Replies View Related

Forms :: Textbox With Exclamation Mark If Value Is Negative Or Actual Number If Positive

Nov 5, 2014

Is it possible to format a textbox such that a negative value doesn't show numerically but in some other form (like a cross or exclamation mark from the Wingdings font, for example?)

I have a couple of textboxes which take their values from a function. The function is designed to return a long integer value which should always be greater than or equal to zero (the function counts the number of outstanding e-mails in a given Outlook folder, hence it should always be zero or higher)

However, as part of my error handling, if the function can't connect to the Outlook folder for whatever reason (for example, if the user does not have the appropriate permissions, or they do not have it mapped etc.), then it returns -1 (so I have some sort of value to identify a fail)

So currently, if such an error occurs, my textbox(es) will show -1 (and I can use conditional formatting to highlight this)

But it would be nice if it showed an "X" or "!" instead, and only showed the numerical value for 0 or positive. Is this possible?

View 14 Replies View Related

Forms :: Set Decimal Place Property Of A Text Box To 2

Mar 9, 2013

I have set the decimal place property of a text box to 2. Then when i run a query that puts data in that box, the deci places are still well over 2..It lokks to be over riding it, how do I stop this?

View 4 Replies View Related

Forms :: Force A Start Place In A Textbox

Jun 26, 2014

I have a textbox (Odour), that contains one of four words (Cadaver ( ), Drugs ( ), Explosives ( ) or Money ( ) ), the word is written in by pressing one of four buttons, this works fine.

I now want the user to write in between the the brackets and only the brackets. For example:

The textbox contains Cadaver ( ), I want the user to be able to write between the brackets "Blood".

I seem to recall that there is a way of only allowing the user to type in certain places within a textbox.

View 2 Replies View Related

Forms :: Place Cursor At The End Of First Line In Memo Field

Dec 2, 2014

I have created a button that takes the contents of a memo field and adds a new line of text at the top with the date, time and initials of staff member. So far, so good...

However I want it to end with the cursor ready at the end of the first line (to type the note) The following code does everything but ends by putting the cursor right at the end of all of the text in the memo field (instead of the end of the first line):

Code:
Private Sub Command59_Click()
Me.Note = Format(Now, "d mmm yyyy hh:nn") & " - " & "(" & DLookup("[login]", "logintable") & ") " & Chr(13) & Chr(10) & Me.Note
Me.Note.SetFocus
Me.Note.SelStart = Len(Me.Note)
Me.Note.SelLength = 0
End Sub

View 6 Replies View Related

Forms :: Stock Number - Place Information In A Field Automatically

Feb 7, 2014

I have a stockist which includes " stock number", " description"

When I use these parts to create a "bill of materials" for a job I am presently selecting the material and this data is going into the table and the stock number just goes in the form not the table, is there a way that when I select the "stock number" the material will still go in the table and the stock number stays on the form. or also go into the table

The reason I want to do this is because the stock number is easier to remember than the description ...

View 3 Replies View Related

Forms :: Place Values Of A Concatenated Combobox In Respective Fields

May 15, 2013

I have a form in which I have a combobox. The code in the row source is:

Code:
SELECT [tblBooks].AuthorFirst & " " & [tblBooks].AuthorLast AS Expr1 FROM tblBooks GROUP BY tblBooks.AuthorLast, tblBooks.AuthorFirst HAVING (((tblBooks.AuthorFirst & " " & tblBooks.AuthorLast)<>"") And ((Count(*))>1)) ORDER BY tblBooks.AuthorLast, tblBooks.AuthorFirst;

This is an unbound box.

The rest of the form contains bound textboxes and other bound comboboxes.

This form is processed by the following VBA code:

Code:
Private Sub cmdAddBook_Click()
'Place the authors first and last name in an array
splitAuthor = Split(cboAuthor.Value, " ")
'Create a new record with the form information
DoCmd.GoToRecord , , acNewRec

[Code] ....

What happens is that it places all the records (Except those in the array) in a field and overwrites the values in that field.

I have used the same GoToRecord statement on other databases and it works just fine. I suspect that it is due to the unbound combobox.

What I need to find a way to place all the data in the corresponding fields of a new record including separating the author's first and last name when retrieved from the combobox. I just need to figure out how to get the data in the table somehow.

View 2 Replies View Related

Forms :: Display Number Of Events Taking Place Today

Dec 17, 2013

I'm creating a database for a music store which also does music lessons. In the header I wish to display the number of lessons that are taking place each day, the number will be dynamic as the number of lessons vary from day to day. I obviously have a table with all the lessons that have already taken place, as well as lessons that are taking place in the future.

I've attached the header (isn't the final version) as an example.

View 1 Replies View Related

Forms :: Entering ID But Displaying Name

Oct 1, 2014

I have a table that holds the ID to another table where I pick up the name to display instead of the ID. If a name is added or changed then the ID needs to be added/updated.

The name (and other details) are displayed on a form from 1 to ,many rows.The field that holds the name is a combo box and I can change that field by selecting the bane from the combo box or typing the name in. What I want to be able to do is type in the ID (I'm actually scanning it in from a bar code) but display the name. How do I do this.

As I say this currently works if name is typed (Or scanned in)and the ID is written to the table.On the data tab for the field I have as the control source the ID itself. In the Row Source I have select 5 fields from the second table which includes the ID and name (both from 2nd table). The Bound Column is set to 1. In the Format tab Column count is 5 and column widths is set to 0cm;3cm;0cm;0cm;0cm. This allows the name (2nd column) to be displayed. But the 1st column to be stored on table 1. However I can't scan in the ID which I want.

View 3 Replies View Related

Forms :: Calculate Difference Between Records

Jul 25, 2014

I have looked all over for a way to calculate the difference between water meeter readings. My brain may be Friday slow, but all I can find is for calculating differences in dates. My water table has 3 fields: ReadDate, Reading, Calc1

ReadDate is the date the water reading occurred
Reading is the meter reading
Calc1 is calculated (when I find out how!) by subtracting the current reading from the previous day's reading.

I would like to add the write script in my form so when the readings are entered, the calculation auto populates the field for the user.

View 6 Replies View Related

Forms Should Load On Entering Values

Dec 24, 2007

Hi!,
I am trying to make something to make my job easier. To be honest I am a beginer in this field. I am having a field, when I enter one value ( let that be 10) it should pop up one form and if another value ( let that value be 20) it should pop up another form.
or else I can explain in this way
If data field value = 10 then it should run macro 1
& if data field value = 20 then it should run macro 2

thanks
Pillai

View 1 Replies View Related

Forms :: Entering Default Values

Apr 17, 2014

I have a 1 row table as a result of 2 queries that give me the 'MaxYear' AS 'DefaultYear' and 'MaxWeek' AS 'DefaultWeek' in that year for a selected retailer and stores, from a master table.I want the default Year and Default Week text boxes to display the values of these

I have tried pointing to a table holds the results and pointing to the queries for each box...I have used Form.Refresh and Forms.Requery but nothing picks up my values.

View 2 Replies View Related

Forms :: Entering Data Into Drop Down Box?

Aug 29, 2014

I have made my first form and I did not to bad (?). I am thinking there is a faster way to enter data into my drop down box. I have set the tabs in the order I like but I have to tab to the next dropbox, then double click to open the box, then double click on my choice then double click on the next one. Is there a quicker way to go through 25 dropboxs?

View 6 Replies View Related

Forms :: Entering New Records In The Form?

Jun 26, 2015

I've created simple data base with 2 connected table with relationship one to many, then I have built the querry based on those 2 table and then I have done the form based on this querry, so there are fields from those 2 tables in the form.

When I try to fill in the fields with information I get error message:

"You can not add record (records); missing foreign key in the table"

When I checked relationship property window everything seems to be ok.

View 9 Replies View Related

Forms :: Date Difference In Tabbed Form

Mar 10, 2014

everything has been working perfectly except for date diffs.I am simply using an unbound text box with a date diff as a calculator of sorts, which meets the form's purposes. Everything works fine when the two dates are on the SAME tab using the formula ' =DateDiff("d",[DOB],[date of treatment]) ' entered in the textbox.

The number of days between treatment and DOB pops up immediately.

However, when trying to create a second date diff between two source text boxes on SEPARATE tabs, (i.e. DOB on Tab 1, and date of treatment and the unbound date diff calc box on Tab 2) the date diff does not work unless the form is opened, and closed again. As in, the only time the number of days pops up is if the form is closed and opened again.

View 3 Replies View Related

Controls For Entering Information In Tabbed Forms.

Aug 5, 2007

I'm not a complete Access beginner, but I'm also far from an expert and not much of a programmer. So I feel that there's a chance this might be a relatively simple issue I'm merely making more complicated than it should be. But hopefully someone can at least point me in the right direction. (For the record, I'm using Access 2007.)

I've created a form to which I've added three tabbed pages. Each of these pages contains a subform the user can use to enter data into three different tables. The tables' relationships look to be set up properly, and there doesn't seem to be a problem with typing the information into the subforms. However, I want a single button press to update the information across all the tables and clear all the fields in the subforms so that the user can then go about entering the next person. I can't seem to figure out how to do this.

I downloaded a number of template databases from Microsoft, and some of them have exactly the kind of functionality I'm looking for: a "Save and New" button that inputs all the data across the tabbed pages and then lets the user start over from scratch with blank forms. I've spent a fair amount of time studying the various forms in the Student template, but I'm having absolutely no luck replicating that functionality. I basically want everything to work almost exactly the same as that, except with different field and table names (of course).

Can someone please explain what I'm doing wrong and how I might fix things, or at the very least how to look at the Students template database to get the information I need on how to do this myself? I'd be very grateful for any help on this matter. Thanks.

View 1 Replies View Related

Forms :: Opening Subform After Entering New Record

Feb 17, 2014

What is the best way to open a linked subform using a button while in a newly created record?

I thought a simple

Code:

docmd.save

command would do (either in the "current record" or the "after update" event)

View 4 Replies View Related

Forms :: Disabling A Control After Entering Data

Jan 16, 2015

I know some basic code to disable a control after updating but, I have 20 or so controls that I want that to happen to as the record is updated over time. Is there a way to group all those controls and have them evaluated after going dirty instead of having to code each control?

View 4 Replies View Related

Forms :: Message Box Pops Up When Entering Field

Aug 2, 2015

I have message box come up in the On Enter of field (ContactTypeID):

Code:
Select Case MsgBox("Take care when editing this field!", vbOKCancel Or vbExclamation Or vbDefaultButton1, "Access DB")
Case vbOK
Case vbCance
Me!Listing.SetFocus
End Select

to warn the user that this will change the contact type of the record.When I click the field everything works fine except I'm not able to enter the next field. All other fields I'm able to enter. Also, when I try top enter the next field (Phone) I get the message box for the other field even though I have nop message box function for that field.

View 2 Replies View Related

Forms :: Calculate Integer Difference Between Due And Result Date

Sep 20, 2014

Trying to calculate the integer difference between Due_Date and Result_Date excluding weekends and holidays.

I have a table (Holidays) with the dates of the holidays in it. The table looks like:

ID Description Holiday
1 New Years 1/1/2014
2 New Years 1/1/2015

So, if Date_Due: 9/25/2014 and Result_Date: 9/29/2014, then TAT = 2

Since 9/27/2014 and 9/28/2014 are weekends they are excluded from the calculation and only that Thursday and Friday are used in the calculation.

Code:
Private Sub Result_Date_AfterUpdate()
[TAT] = NETWORKDAYS(Due_Date, Result_Date, tblHolidays)
End Sub

View 7 Replies View Related

Forms :: Difference Between Shared And Embedded Picture Type?

May 29, 2013

For my database, I would like a picture as my background but I don't know if I should use embedded or shared?

View 2 Replies View Related







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