Forms :: Strange Font Effect While Running Through Records

Nov 28, 2013

It is a strange effect I get when switching among records.

In a form I have a TAB Control with some pages, when I open the form everything is ok:

But, when switching continuosly among records, the font becomes strange, looking like being bold.

It seems to happen only when using TAB control or, if you prefer, only on every TAB control's page except for the first one. Tried on different pc with different resolution.

View Replies


ADVERTISEMENT

Forms :: Running Code On Individual Records

Mar 20, 2015

So in my database i'm creating a live form that will open up a list of patients and when they are seen. one of the bits is a button that before they arrive says "Not Arrived" and after they arrive it says "Arrived". The code works fine:

Code:
Private Sub Command68_Click()
Dim C1 As String
Dim C2 As String

[code]...

The problem is after clicking the button on any of the records, it changes the text on all records, to wit: I tried to attach images or links to images, but my post-count is too low. The before-click screenshot is /3QnBkgG on imgur. The after-click screenshot is 9VZWzzp on the same site.

Bear in mind I've only clicked the button (it's white, so it doesn't look like a button) on the top record.The form is set to continuous forms, not sure if that has anything to do with it.how I can get the code to run on individual records, rather than applying the first-record's results across all records?

View 12 Replies View Related

Forms :: Running Net Value Field In A Subform For All Records

Sep 25, 2014

Is there a way to add a field to a subform that preforms a net value calculation on all the records in that subform?

Fields:
Record ID ItemAmt PaidAmt Need a Net field here? (not part of form; description only)
1 500.00 100.00 400.00 500.00-100.00
2 500.00 50.00 350.00 400.00-50.00

The Item Amt is referring to the main form and should be the same amt.I need the Net field to act as a running balance.

View 11 Replies View Related

Font Type In Form Changes When Change Font Colour

Aug 1, 2014

I am experiencing a problem in MS Access 2013. I have a form which was working just fine until now. It has form labels in Calibri font and their font colour is one shade lighter than black. Today, I changed the font colour of the form labels to be Automatic - black (shows as 'Text 1' colour in the form properties). I did this in Design view.

I find that when I switch to layout view, the font of the labels appears as Century Gothic. This is the font that appears in the Form view. So while the font colour is correctly changed, the font name is not what I had set in the Design view. When I go back to the Design view, and change the font colour back to the original colour which was one shade lighter than black (Text 1, Lighter 50%), the font is correct in the Layout view and the Form view (Calibri).

So it seems that there is some sort of binding between the font colour (black) and the font name (Century Gothic). When I change the font colour, the font also changes. When I restore the original colour (one shade lighter than black), the font Calibri is correctly retained.

View 4 Replies View Related

Making Some Specific Records With Different Font Style

Nov 18, 2007

Hi ,I have to make some specific records in a table in bold.Can any body suggest me how to make a particular record in bold or set some color fonts in order to high light the record.
I have to design a report which shows some priority records with different font style in ms access

Regards
sam

View 5 Replies View Related

Making Some Specific Records With Different Font Style

Nov 19, 2007

Hi ,I have to make some specific records in a table in bold.Can any body suggest me how to make a particular record in bold or set some color fonts in order to high light the record.
I have to design a report which shows some priority records with different font style in ms access

Regards
sam

View 2 Replies View Related

Strange Behavior Adding Records

Aug 31, 2005

My client wants a data entry application, but he wants the previously entered data to remain on the screen since he usually only wants to change a couple of the data fields. So, I created a form (.mdb) and add the record via vba code.

I have the autonum field turned on and have set the form parameters to:

edit = no
delete = no
additions = yes
Data Entry = yes

Now, say the next autonum should be 50. When I add a record, the autonum used is 51 and as I continue adding records, the autonum increases properly. However, when I close the form (via the X or via a close button) record number 50 is created with the exact data in the last record added.

I can filter this out with a distinct query, but I really don't want this data and so far I have been unable to stop this from happening.

Does anyone have any idea as to what is really going on here?

View 1 Replies View Related

Strange JOIN And Strange Realtion Of Tables

Sep 9, 2005

I have a table called 'students' with the appropriate fields. There is another table named parents_prof which contains records of common professions. The tables are related through the 'ID_parents_prof' of the 'parents_prof' table to two fields on the table 'students', thus 'students.father_prof' and 'students.mother_prof'.

1st question) Is that possible? Is it possible to create a relation between the key field of one table to two different fields of another table? Is it a good practice?


I did this because I want to build a query which checks for both fields together, meaning I want Access to return a record if the appropriate profession is in either field of mother's or father's profession.


SELECT students.surname, students.name, students.father_name, students.father_prof, students.mother_name, students.mother_prof

FROM parents_prof INNER JOIN students ON (parents_prof.ID_parents_prof = students.mother_prof) OR (parents_prof.ID_parents_prof = students.father_prof)

GROUP BY students.surname, students.name, students.father_prof, students.mother_prof, parents_prof.parents_prof

HAVING (((parents_prof.parents_prof) Like "*" & [enter profession] & "*"));


Access cannot represent the above graphical, so I had to enter the

OR (parents_prof.ID_parents_prof = students.father_prof)

in the SQL formula.

2nd question) Is the above proper query, according to the rules?

View 11 Replies View Related

Show All Records... Highlight Specific Data Using Red Font

Mar 6, 2008

Microsoft Access 2003

One more question... I'm loving Access... much more than Lotus Approach!! :-) Here's something I've wanted to do in Approach... how do I do this in Access???


REPORT showing all customers

1. John Doe, owes 9.00
2. Jane Kane, owes 10.00
3. Rob Johnson, owes 30.00
4. Albert Icar, owes 22.00
5. Johnny James, owes 5.00

Query all customers owing more than 10.00 (in this example it would be Rob and Albert).

In the report, I want Rob and Albert's name to be red font only, while everyone else is just regular black font.



Thanks to all posters who have assisted me thusfar, and anyone that can help with this.

View 1 Replies View Related

Weird - Font On Text Labels Gets Bolder As I Move Through Records

Oct 19, 2005

Hi all,
title says it all!

I've got a form with numerous controls and labels. When i first open the form, all looks fine - all labels are Black Arial 8 Bold. But when i start scrolling through the records, the text on three of my text labels gets bolder. I haven't a clue what is causing this - the labels are just standard - two are associated with controls and one is all on its own.

I have no code written to do this, and in fact i'm not sure you could write code to do this. I've tried renaming the labels, changing the font, deleting and recreating them, but it's always the same three that get darker.

Ideas?

P.

View 1 Replies View Related

Forms :: Toggle Box That Changes Color Font?

Aug 2, 2013

I created a form that has about 200 fields and all the fields are utilized at a point depending on the work order assigned to us. I wanted to know if it's possible to put like a toggle box or a check box etc. next to the field so if it is checked it would be in a Dark color and the ones not utilized are in a shade of gray. All the fields are coming from the same table. Another thing it's an estimate worksheet so a row would have something like, Labor, QTY, HRs, Overtime, total as columns, so I would want a check box to have control over those but one for each row, EX contractor, locksmith.

View 3 Replies View Related

Forms :: Some Fields Have Gray Font Instead Of Black

May 7, 2013

I have a form that some fields have gray font instead of black. All of the properties seem to be the same as the other fields. The issue has to do with the 'Manage Sales Order' Form in the 'Products' Database.

Customer ID
Payment Type

View 8 Replies View Related

Forms :: Theme Font Not Being Applied To Control

May 20, 2015

I have sever forms and selecting a Theme Font work fine with all except one form.

The field is a Memo Field (I have other forms with different memo fields and they are fine) that just doesn't want to use the Theme Font(s). I have several Theme Fonts and it doesn't work with any of them.

So far I've deleted the control saved it and then put it back... no good. I even created a new form and the same thing happens.

View 5 Replies View Related

Forms :: Label Font Change On Disabling A Field?

Jan 23, 2015

I am creating a form and I have some fields I don't want people being able to change so I selected to disable them in the datasheet but now the labels have a strange double text, it looks different than all the other labels and is driving me nuts. when I enable it the font on the label goes back to what the others are but once I change it to disabled it goes funky again. how do I fix this?

View 4 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

Forms :: Change Font And Background Color Based On Date?

Mar 28, 2013

I would like to change the Font and background color based on dates.

-I have a text box (Training Event) on a form populated from a field (Training Dates) in a query.

- I need the font and/or the background in that text box to change to red when the date is 12 month past, yellow 11 months past, white 10 months past and green for 9 months past.

View 3 Replies View Related

Mouse Over Effect

Jul 4, 2007

Hello, I have two images (img1 and img2) and I want to have img1 visible when the form opens and when I run the mouse over img1 it changes it to visible = False and img2 is visible = True. Also when I mouse off the image it changes back to img1… How is this done? Thanks!

View 8 Replies View Related

Forms :: Change Font Color And Appearance While Entering Data Into A Form

Mar 13, 2013

I would like to be able to change font color and appearance while entering data into a form (example: italicize a word). Is there any way to activate the font format while in a form?

View 2 Replies View Related

Reports :: Barcode Font - Generate Number As Barcode On Report Records

Jun 8, 2013

I am using a barcode font in order to generate a number as a barcode on my report records. In order for my barcode scanner to read the barcode it needs an asterisk at the beginning and at the end.

So, if my record ID is 62 - in order for the barcode to be displayed correctly, it needs to be on the report as *62* .

Without digressing into a discussion on barcode methods in Access, how can I precede and succeed each ID number field with an asterisks?

View 4 Replies View Related

Read Only Effect In Query...

Jun 22, 2005

Hello,
I'm having a little problem with an Access Query. Simple table design, with relationships as normal, using a junction table for a many-to-many link.

Table1
Field: Area (Text)
Field: T1_ID (AutoNumber)

Table2
Field: T2_ID (AutoNumber)
Field: Value (Double)

Table3Join
Field: Area_ID (Long Integer) *Rel: Table1.T1_ID
Field: Value_ID (LongInteger) *Rel: Table2.T2_ID

Table4
Field: T4_ID (AutoNumber)
Field: Area (Number) *Rel: Table1.T1_ID
Field: Description (Text)

Query1
Sources: Table4, Table3Join, Table2, Table1
Fields: Description, Area, Value

SQL:

SELECT Table4.Description,Table4.Area,Table2.Value
FROM Table2 INNER JOIN ((Table1 INNER JOIN Table4 ON Table1.T1_ID = Table4.Area_ID) INNER JOIN Table3Join ON Table1.T1_ID = Table3Join.Area_ID) ON Table2.T2_ID = Table3Join.Value_ID;


However, with this design as it is, I cannot "edit" the Description field, or change the Area field. The entire Query becomes read only. Why is this? And how should i re-write this to allow me to use the relationships which Link Table2.Value to the appropriate Table4.Area (and display them both in one query), while allowing me to edit all the sub fields.

Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner

Using: Access XP 2002 (10.4302.4219) SP-2

View 3 Replies View Related

If/Then Effect Only Current Button

Oct 25, 2005

I am trying to write code to change the color of the text on a button on a continues form. I only want the button for the specific record, that meets the requirements of the if/then, to be effected. The code below will change the button for every record if one record meets the requirements.

If Me.datPMDueDate = Date Then
Me.cmdAccessMaintenance.ForeColor = 65280
Else
If Me.datPMDueDate < Date Then
Me.cmdAccessMaintenance.ForeColor = 255
Else
If Me.datSMDueDate = Date Then
Me.cmdAccessMaintenance.ForeColor = 65280
Else
If Me.datSMDueDate < Date Then
Me.cmdAccessMaintenance.ForeColor = 255
Else
Me.cmdAccessMaintenance.ForeColor = 0
End If
End If
End If
End If

View 5 Replies View Related

Forms :: Command Bars Custom Shortcut Menu - Font Color Picker

May 15, 2014

I am currently in the process of creating a pop-up menu to allow my users to do some simple text formatting.I have used the following code to do so:

Code:

Dim cmbShortcutMenu As Office.CommandBar
' Create the new pop-up menu instance
Set cmbShortcutMenu = CommandBars.Add("popupFormatMenu", msoBarPopup, False, True)
' Add the bold button

[code]....

The problem is that I now want to add the FontColor picker control and I keep getting an error.I think the problem lies in the type of control I want to add. According to the Microsoft support files I downloaded the fontColor control is of type Gallery and ID = 11949, so the code should look something like this:

Code:
cmbShortcutMenu.Controls.Add Type:=msoControlButton, id:=11949

I need to replace msoControlButton with something else.

View 1 Replies View Related

Queries :: ORDER BY Statement Seems To Have No Effect

Oct 15, 2014

SELECT Count(Query1.Route) AS NumberofReRoutes, Query1.Route
FROM Query1
WHERE [Start Date] <= #9/30/2014# AND [End Date] >= #9/1/2014#
GROUP BY Query1.Route
ORDER BY "NumberofReRoutes" DESC;

The last line seems to make absolutely no difference. I can change it to ASC, or I can remove the line entirely, and nothing changes. I need these sorted by the NumberofReRoutes field, but this method isn't working!The output at the moment is two columns: Route, and NumberofReRoutes.

View 3 Replies View Related

Hyperlink Roll Over Effect On The Access Form

Nov 11, 2005

Hello,
I have a MS Access form with a few hyperlinks on it. I have tried to achieve effect similar to hyperlink roll over effect on a web page: when mouse pointer goes over a hyperlink it changes colour, etc.
Unfortunately, all I could find was MouseMove event:
Sub Label_MouseMove
Label.ForeColour=vbBlue
End Sub

But in this case hyperlink stays blue even after mouse pointer leaves it. And I would like hyperlink get back it's initial colour.

Thank you

View 2 Replies View Related

Textbox Values Not Valid Because Of Misterious Side Effect

Feb 26, 2007

Hello the problem I am having is that when I imported data from excel, it somehow placed carraige return at the end of the text box ( this is what I believe), this is a problem because in that field is a drop down box and it complains about my value not being valid. I press the del key behind the value and it doesnt complain. Can anyone help me?

View 1 Replies View Related

Tables :: Change In Sharepoint List Not Taking Effect?

Jul 24, 2013

I am importing data from a sharepoint list on to Access 2007, as linked data where any changes I make on Access is made to the list and vice versa. However, I recently made a change to one of the column types and this change is not being made on Access. I have changed a column type from choice to single line of text but I still see the list of choices when I access the list on Access 2007.

I have refreshed the list by right clicking the linked list and pressing refresh list. The list is set to not cache the list and is not set to work offline so cannot see why the change is not being made. I don't want to mess with the list be removing it and re-adding it as I have multiple queries set up which are being fed in to an excel file I use to create reports from the data. I have no knowledge of VBA, so there is none of that being used on Access.

View 1 Replies View Related







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