Here's one for you guys:
My vision-impaired staff are having trouble seeing the blinking caret when they tab over to the next field in a form. Is there a way to highlight the newly-selected field instead of just having a thin blinking caret to guide the way?
I have an Access form that is tied to a recordset. When I Set Focus on 1 text box in particular, I move the caret with the keyboard arrows left-right, and the caret moves and flashes on top of the text characters, basically overlaps the character. When I then try to delete or edit the text, it moves the caret by itself to a different location in the text box and starts adding the text to that location. When I finally get the text how I want it, I set focus on another control, and it occasionally deletes random characters in the text box.
The only way I have been able to work around this is to copy and paste the current text into Notepad, edit it there, and then paste it back into the text box.
When tabbing through a form is it possible to highlight the field you have tabbed to?
View 1 Replies View RelatedI have a Text Box on a Form set to change color after an update changes the text to read “OK”. The Font changes from black to white and the background from white to red.
I want to make this blink/flash and need to have a button/action to stop/pause this for a set time (about 1hr.) so the update will not be able to start it blinking again.
I had made a splash screen to blink so you could see the Text Box that had the trouble and would stop when the Text Box changed from “OK”. Then I made a splash screen that came up and stayed on with the label that blinked until the Text Box changed.
The Form that I want to uses has the timer set to run an update and do not know if this will run on the same Form. Let me know if anyone has tried this and post a sample.
Thank you, JWT
Hi all, this is very uncommon...
I have a form. Inside this form i added a subform whic works perfectly. However, if i add a third subform, both subforms start to blink and i cant use them.
In the form i have information about a task (primary key: change_id from newchange table). In the first subform i have information about subtasks (primary key: change_id2 + subtask from change_desc table) and in the new subform i have a trail log of the ticket (primary key: historyID from history table).
any help?
I am trying to use a tabbed form, but the labels that are not associated with a text box or other control (like titles, etc) seem to aquire hyperlink properties which blink horribly when the cursor enter and leaves the label area. The two hyperlink properties are blank and I sure don't need them for anything. I tried associating the labels with a text box (which already had a label normally associated with it) and the hyperlinks and blinking goes away, but Access will only let me associate one label per control. When I have the same situation but not on a tabbed feature the hyperlink property is there, but no blinking occurs. I really - really would like to be able to use the tab style for these very busy forms. Can't imagine why a non-associated label must have hyperlink properties, or why this happens on tabbed pages and none others. GRRRR! HELP!!!
Thanks a billion!
Kye
I have a single text box with a vertical scroll bar being used as a user guide. The Locked property is set to Yes so no user input can be made.
How do I prevent the blinking cursor from appearing?
In a date field is it possible for a date that is in the future to be hi-lighted in a different colour.
E.g. todays date is 25/03/14
So anything with todays date or previous would stay in black
24/03/14
25/03/14
but anything from 26/03/14 forward would be in red
26/03/14
Then will change to black when the 26th comes.
I have a table called welding, I want to create a user friendly form for input. The database ultimately wants to go on share point so I am building it in the web database option.
One of the fields is called location, if the location is 'Field' I want 10 more fields to appear for data entry such as weld reason, rail temperature etc . If the location is 'Depot' I want these fields to be hidden as they aren't relevant.how would I do this?
I am trying to run graph on a report from query but what's happening is query shows name but report on graph shows ID'S of the field .
Below is my query
SELECT tblMainTWTTPSheet.txtRootCause, Count(tblMainTWTTPSheet.txtRootCause) AS CountOftxtRootCause
FROM tblMainTWTTPSheet
GROUP BY tblMainTWTTPSheet.txtRootCause, tblMainTWTTPSheet.Date
HAVING (((tblMainTWTTPSheet.txtRootCause) Is Not Null) AND ((Count(tblMainTWTTPSheet.txtRootCause)) Is Not Null) AND ((tblMainTWTTPSheet.Date) Between [Forms]![frmStratificationOfRootCauses]![startDate] And [Forms]![frmStratificationOfRootCauses]![endDate]));
My bound column on main menu form and back end table is 1
column count 2
column width 0;1
I was wondering if it is possible to determine weather to show a field based on the values from another field.
Field1, SHOW_Field1, Field2, SHOW_Field2
Field1 and Field are text, SHOW_Field1 and SHOW_Field2 are Boolean values
So if SHOW_Field1 is true, then show Field1 in the query else hide. I was wondering how to do this, I seem to not be able to do this for some reason.
I have an unbound field that counts the number of records (=count(emplnumber)). When I open the form the value in the field is not there, if I click on the field the value appears.
It's almost like the field is being highlighted by the cursor and covering up the contents, but the cursor has it's focus set to another field.
Oh, the field is on the form footer if that matters.
Anyone know what I am talking about?
Thank you
Hi guys and Girls
I have a txt box on a report which should show comments..
In the background table the field this txt box is bound to has a data type of memo. Yet the txt box on the report stops showing any more than 255 characters! any clues? I know 255 is the field size set for my Txt fields but memo fields should be able to display 65000000000000000 trillion characters with no problems.
When I look at the table the memo field has all the txt in it, it just wont display all the txt on the report.
Thanks for any help guys.
In my table, which I have been using for about five months, I have been importing excel files into it, 6 so far. Included in this table are a number of fields which are caluclated, taking the information from other fields like 0, 15, 9, 3...etc and then deciding on what answer should populate the field through an IFF statement. This has worked splendidly so far. Then, just this morning, I imported a 7th excel file into the table. It all looked fine, except when i went to make sure that the numbered fields from before were not populating the caluclated fields AT ALL. Because the other groups 1-6 above this were still calculated, I determined it was not the codes fault, at least directly.
View 2 Replies View RelatedI am doing some ICT coursework and I a bit stuck.
I am creating a database that will allow users to log in and submit bids on houses. There are only a certain amount of house plots available, but I cannot seem to make the database find the top bidders within the plots available, for example the top 5 bidders or top 7 bidders, depending on how many plots available.
I have 4 fields, from two different tables. I have a bidder ID field, House Type ID field (which I use "[please enter house type ID"]), a bid amount field and Number of plots field.
I want the query to select the top "x" amount of bids that it says in the number of plots field, e.g. 5.
How can I do this for all the different house types?
I have a form field with a date in it, is there any way I can make the value in that field display one thing, but still run a query based on the original text?
for example:
txtDate is 1/1/1000
if txtDate = 1/1/1000 then display = "*"
but the query still runs on 1/1/1000
I am asking this because I am trying to run a between statement for a date range and the only way I can do the entire range of dates on my table is to use the highest and lowest date possible (1/1/1000 and 1/1/3000) but I only want the users to see "*" so they are not confused.
One of my forms in the database is not showing some records in a particular field. Although those records are entered through the same form and are shown in the table, yet some of them are not visible in the form.
This is happening only in a particular field, and in that field, some records are shown , and some are not shown.
However, the data is now showing on the generated invoice.The rest are showing up but one.I went back to the tables to check and there is data present.It used to work until recently.
View 3 Replies View Relatedok.. i am storing CD info in a database, including track lengths, these are obviously in minutes and seconds.. I cant use short time because that is hours and minutes, which means any track longer than 24 minutes doesnt work.. i cant simply use text with an input mask because i want to be able to calculate the total length of the CD by adding the track lengths together.. if i use Long Time it also shows hours, which will confuse the user, and create more scope for errors.. any suggestions? I hope I am making sense here.. thanks for any suggestions :D
View 2 Replies View RelatedI'm trying to create a query which will only show fields that have information in them, but I can't figure out how to do it.
View 2 Replies View RelatedI am trying to show the Current Repair Estimate total in currency form on my report. The attachment shows my criteria, which works on the query, but does not show in the report. The second attachment shows what pops up when I try to view the report. What can I do to get this current rep estimate to show correctly in currency form on the report?
View 8 Replies View RelatedI'm working with a report that totals the number of times a topic is returned from a query. If a topic is not returned at all, i don't want it to show at all. Currently it is showing a blank field for that topic name and blanks in the count as well. Here's the filter i've put in to pull the right data out of my query: =Sum(IIf([Caller Used Resources]="No",1,0))
View 2 Replies View RelatedI have an Access 2010 report that is pulled from a dedicated query. When i run the report, one of the fields pull the information in both the numerical ID number and the Field information. For example, the field in question is a field for "business type"......the report comes back in some lines as Manufacturer, Supplier, distributor, or contract. In other lines it comes back as either 1, 2, 3, 4...which is the ID number form the table. I have gone through all the properties and data source and can not figure out my the information is being returned so differently.
View 1 Replies View RelatedHi,
I am looking for Idea's of how to create a report.
Basically the report is a league table showing Month and YTD, this is the easy bit.
The part I need suggestions and guidance on:
The report also needs to show peoples movements in the league table i.e: whether they have moved up, down or not moved at all from the previous months position.
I was thinking of creating 2 tables: Current Month + Previous Month, in each table the persons position is indicated (an ascending record number is created throughout the table - not sure how to do this yet)
Then using code, lookup each persons position in previous month and write that position number against the persons UID and current position in current months table.
Am I on the right tracks or does someone have an easier solution?
Thanks in advance.
Darrell....
I need to show an image called PAID if my hidden field Paid Date has a date in.
I thought this would be straight forward but so far nothing.
I have my images within the database itself on Access 2010, so I am not referencing any in a C drive or other location.
Code:
Private Sub Report_Current()
On Error GoTo ErrHandler
If paiddate = Date Then
Paid.Visible = True
Else
Paid.Visible = False
End If
ErrHandler:
MsgBox "Error detected, error # " & Err.Number & ", " & Err.Description, vbOKOnly, "Error"
End Sub
But with no joy.
I have a report which when I open it by clicking the button in the form shows what looks like Chinese text in the memo field. To open the report the following is in the event properties for the referencing button
Code:
Private Sub cmdPrintSumReg_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
[Code] ...
When I open the same report from the reports menu on the left of the database it is just fine. But obviously it is showing information for all contracts and not the any one contract.
I haven't changed anything in the table that contains the memo field and this only started happening yesterday afternoon after using this db for over a year.
I found an earlier post in this forum with a similar problem but the only difference I see is that the user changed the field from a text to a memo. I haven't.