I need some help with my DB
This is my database cotroller
15937
the next and back button work fine. the trouble i have is with the bleu balls when you focus on one of the balls a text must come to the text field. i used a label and an caption code but i dont get it to work i still need to click for it appears. And thats what i dont whant because when you click another form i beiing opened.
Please assist i thik this is a real challange
How to Change focus to another form and show only certain records...
View 1 Replies View RelatedWhen I mouse over TEXTBOX1 I want it to display the phrase Hello World in TEXTBOX2.
When the Mouse moves away from TEXTBOX1 I want TEXTBOX2 to go back to normal.. (Empty)
How can I get the below VB to work? Or something similar.. I'm assuming a mouse move event or something
Code:
Private Sub TEXTBOX1_GotFocus()
Display Hello World in TEXTBOX2
End Sub
Code:
Private Sub TEXTBOX1_LostFocus()
Clear TEXTBOX2
End Sub
I have a continuous form with a combobox and a text box. In the after_update event of the combobox I want to setfocus on the text box - of the specific record that I'm on. I tried using Me.CurrentRecord but that returns me to a completely different record than the one I was on. How can I setfocus to the text box of the record I am on?
View 12 Replies View RelatedI have a form with two text boxes in which I would like to insert the current date automatically when the text box has got focus. Default value doesn't work because the current date may occur on two different days, and the default has to be null until the current date is inserted.
Can someone walk me through the process? Thank you.
how to set focus in first or last line, but I need set to second.
View 11 Replies View RelatedWhat do I need to put into a macro attached to a command button to set the focus to a text box once the button is clicked?
View 1 Replies View RelatedI have a form and one of the text fields I need to verify against data in a table. I think the best way is to check the field once it loses focus on that text field. If the data is not in the table then the user is prompt with a msg "Invalid data, Please try again". I'm using Access 2010 to develop. I need query to run the validation.
View 1 Replies View RelatedI have a form where I want a textbox [txtMaxOrdLimit] to be visible only if another text box on the same form [PaNumber] contains the letter D in the string. This is the code I have on the forms On Current property but I'm missing something because textbox [txtMaxOrdLimit] doesn't show on the form at all.
If Me.PaNumber = "*D" Then
Me.txtMaxOrdLimit.Visible = True
Else
Me.txtMaxOrdLimit.Visible = False
End If
-How can I address the fields on my forms? I just want to create a button that increases a value by one on click.I tried
FORMNAME.FIELDNAME = FORMNAME.FIELDNAME + 1
FIELDNAME = FIELDNAME + 1
FORMNAME!FIELDNAME = FORNAME!FIELDNAME + 1
but the button does nothing. And that is all I found by googling.
-How to focus a field at the beginning? I want to be able to start writing always in the same field.
FIELDNAME.SetFocus
does not work. I dont know if I made any mistake during creating tables and forms, but these codes should actually work, shouldnt they?
Ok, so I'm pretty new at this stuff, and while I'm sort of familiar with VB, I feel like there should be a fairly simple expression that could solve my problem. I have a calculated text box that is based on what is entered in another text box, like so:
the source number is in a field called Word Count.
my calculated box's Control Source is =([Word Count]/250).
My goal is to automatically calculate the number of pages based on the number of words per page (250). I used Format so the bank rounding problem doesn't effect the outcome, but if the Word Count field is less than 125 the number of pages is 0. which is obviously not the case.
I've tried fiddling around with the rounding, but then it starts rounding higher word counts up too soon.
thoughts, please?
Hi *,OK, still new to Access so I apologize in advance if that is a dumb question ;)I have a table "survey" where I wanna store number values (0,25,50,75,100 respectively). The user is supposed to use a form to input the data into the table. For this purpose, he/she is supposed to use a drop down box.So, is it possible that the drop down box does not show the values but instead a verbal description of these values (very important, important, average, etc.)? What I have tried was to create a table with the number values and use this table as data source for the drop down box... it shows the values but for the end user, verbal descriptions would be better...Thanks!Steve
View 2 Replies View RelatedIn my website I've created a admin login with some ASP pages to edit and update stories.
I use an acces database and installed HTMLarea for WYSIWYG editing.
When I update text, all the HTML tags show als plain text in my website.
For example: I make a headline bold in my wysiwig editor and I update my text, it just shows: <B> here's a new story </B>
If I look in my database I have a field 'text' wich is a memofield and I can see the html tags have been stored into my database. <B>here's a new story</B>
It looks like it doesnt recognize the html tags as HTML, but just as plain text...
Can I use HTML-tags in an acces database and how do I get them to show up right in my website?
I have some vba that ends with a text box being displayed that says "file created"
I would like to add to that text box how long it took.
My initial thoughts are to add to the start of the code a variable that stores the current time (stTime)
and at the line before the text box is shown get the time again (endTime) and subtract one from the other to get the time taken in mins and sec
I have been trying (unsuccessfully) to get an unbound text box on a form to show the average of four other text boxes on that form. A bit of searching led me to the code below as a possible solution, but it isn't working.
Code:
Dim nbrFieldsUsed As Integer
Dim nbrTotal As Double
nbrFieldsUsed = 0
nbrTotal = 0
If Not IsNull(Me!txtEWT_STD_1) Then
nbrFieldsUsed = nbrFieldsUsed + 1
nbrTotal = nbrTotal + Me!txtEWT_STD_1
End If
[code]....
My thinking was to have this code on the 'After Update' event (or maybe On Change?) of each of the four text boxes which would then give a running average in the box that shows the average?
I have two different fields in 2 tables, ICname and WCname, and if there is an instance where they are the same I need to have a textbox on the main form show "Same Name" but if not the box should remain invisible.
I have created a query that searches through all the names and only prints out those that have the same name in each table, but I don't know where to go from here, and I'm not even sure how to do this conceptually. Is using a query the right way to go about doing this?
I created a text box on a form to show the member's first and last name. Works great! I now want to add it to show if they are a Jr. or a Sr. I thought I knew enough to make it work, but now instead of the name it just shows "-1". Here's the expression in the box...(if possible I'd like to keep it as an expression, since I'm still new to the "behind the scenes stuff" and don't know VBA)
=[GoesBy] & " " & [LName] & " " & IIf([IsJr]=True,"Jr",0) Or IIf([IsSr]=True,"Sr",0)
I basically need a text box which is for date/time to disapear/appear when i tick or untick a little tick box.
My tick box is called AlarmResponse and my text box is called CallReceived...
I just got a request to add a new text box to a form called "EstimatedDuration" and trying to a command button that when clicked, it will insert 30 minutes or #00:30:00" into the box. I'll wind having 5 or six buttons with 30 minutes, 1 hour, 1.5 hours, etc. Basically, this will be used for new projects in my database and for management to click one of the buttons to add an estimated time duration of how long the "think" the project will take to complete.
View 2 Replies View RelatedI have a form with combo boxes, each combo box further limits the criteria of a query as selections are made. I have a Me.Requery code for each combo box. - This is working great.
Once all of the selections are complete, I need the result of that query to show in a text box. - There will always be only one result.
Ok, nobody chew me out... I know there's over 500 posts regarding calendars on here because I've read just about every single one and haven't found any answers yet. All of the posts that vaguely resembled what I'm looking for had no replies.
Here's what I'm trying to do:
First I've got 4 tables, each has different data including a start date, start time, end date, end time and description. Each table pertains to a completely different subject. The tables are already populated (imported from excel).
I've got a form with a calendar control (Ms Cal 7) in it... and that's about has far as I have gotten.
I would like to be able to open the form and have the calendar show all events for the current date (i found how to make the calendar show the current date, it's just populating the text boxes that I'm having a problem with).
So, here's how I would like it to work...
When the form is opened, you can click on a specific date (or don't click anything and it shows the current date). Then the textboxes show the info for that date.
Example:
Calendar = 4/20/2005 (Calendar control here)
Textbox1 = select from table A where subject="codereds" and start date = calendar control date
Textbox2 = select from table B where subject ="codeblues" and start date = calendar control date
Textbox3 = select from table C where subject="codegreens" and start date = calendar control date
Ok, anybody got a clue on how I can do this because I've had no luck finding it anywhere.
Thanks ;)
I have a form and a text box. I wanna when open this form in the text box my pc processor id will show. I know i have to use form load event but i have not skill in vb.
View 6 Replies View RelatedI'm trying to use literal parentheses within a text calculation, like: Emergency Medicine ([doctors.doctor name]).
But they just won't show. I've tried to use quotation marks around all literal text, like: "Emergency Medicine ("[doctors.doctor name]")" to no avail.
How can i put a fixed time for the current date in a text field.
So the field will be 06:00:00 for the current day when the form is open?
I have query that creates table with 2 records each with 2 columns (2x2) and they do not have indexed ID,and query is related to combo box in other form so results are not always same but it is always (2x2) and value types are always same,
So how to show those results in text box in form,lets say 4 text boxes ,every value in one text box, i assume that i need to use DLookup() but i was able only to show first record,did not know what criteria put to go to second record.
When i select that query and create report i get what i want but i cant copy those text boxes to form that i want.
I would like to input data into textbox and it will automatically open up a new blank textbox for another data.
View 3 Replies View Related