I'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.
I have an expression below that I am trying to use to extract text from within parentheses in a field, but it is leaving the last ")" on the extracted text. Can anyone help me determine what I need to do to just return the text? Thanks.
The length of the field is 100.
Mid([SIDE_DRUG_DESC],InStr(1,[SIDE_DRUG_DESC],"(",1)+1,Len([SIDE_DRUG_DESC])-(InStr(1,[SIDE_DRUG_DESC],"(",1)+1))
I have a small school with number of teachers, every teacher has a specific number of observations in the semester, i need a small project that when i query a bout a teacher, a form appearing with his name and the remaining hours of observation
what i did is i made two tables
teacher (id, name, total number of observations in semester)
observation( Oid, name of teacher, date and time of observation, remaining observations)
I dont know if i have to make a counter or what !!-- Now what i need to do is a form when i enter the id of the teacher, it shows automatically the name of the teacher, and the number of remaining observations
How can i join the two tables and show the results ?
I would like my table to show the result of a calculations (or a formula). I surmise that you can not have a column cell calculate data, however if I can do this in the Form View and on a Report - can it just SHOW on the Table so I do not have to keep switching back and forth to see the information.
I am new to Access and think the forum will be a big help to me.
Thanks
The following query works, I'm just wanting to add a date parameter (below)...When I add the data parameter it seems to ignore that criteria.
I just want to add this:
Event_Date Between [Enter Start Date mm/dd/yyyy] And [Enter End Date mm/dd/yyyy]
WHERE (((tblContacts_Speakers.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_1.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_1.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_2.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_2.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_3.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_3.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_4.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_4.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_5.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_5.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_6.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_6.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_7.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_7.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_8.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_8.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_9.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_9.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname]));
I have a subform based on a query. That query contains a couple of calculations that end up in textboxes on the subform. The problem is that the calculations require me to enter 2 dates that are on the subform. If these are not entered before the calculation is performed I get a "Cannot update record" error message and then #error in both Lease cost and Discount Cost textboxes.
View 6 Replies View RelatedI am very new to access less than 1 week since i started trying to build an horse racing database, i am trying to link data from 2 different sources via the horses name however one source displays this with the horses country of origin in parenthesis foe example FRANKEL(GB) and the other source displays the name as just FRANKEL, to be honest i haven't yet tried the link but guess it will fail.
I am therefore looking to get rid of the parentheses and their contents from an access table field and create another field without them.
In Excel i use the formula B1:
=TRIM(REPLACE(A1,FIND("(",A1&"("),FIND(")",A1&")")-(FIND("(",A1&"(")-1),"")) and that works fine.
I guessed the solution for Access would be newname:
TRIM(REPLACE([frhorse.NAME],FIND("(",[frhorse.NAME]&"("),FIND(")",[frhorse.NAME]&")")-(FIND("(",[frhorse.NAME]&"(")-1),""))
But this doesn't work as in returns undefined function "FIND" in expression error.
I have solved the problems getting values on the subform. I have not in getting values on the subform.For instance, on the one titled phone use the formula in the tutorial is:
=[sbfCustomerRoomUse].[Form]![txtTotalPhoneUse]
#Error results when the doc is put into a form mode.
Now when I input each value in the equation above separately.I still get no entry.
For " = sbfCustomerRoomUse" , I get #Error;
and for "= txtTotalPhoneUse", I get #Name.
CustomerRoomUse and txtTotalPhoneuse are from the subform that was dropped into the customer form in a previous step. It shows that explicitly when designed sbfCustomerRoomUse on the main that CustomerRoomUse come from a subform. This does not seem to need to be done with txtTotalPhoneuse, and I am not sure why. Neither one gives me a desired calculation result.
I 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
Hi there. I'm just jumping into Access and have the following question. In my Purchase Order Table, I have a date field calcualated as text, i.e. "01/12/04". I need to convert this to a date format in my queries so I can do calculations, i.e. 01/12/04 - 01/05/04 = 7 days. Can someone help me with how to convert this text date to a date format. Sorry if this is an easy question. - AJS
View 4 Replies View RelatedI have an odd problem that has stumped me for several days. I'm working on a form that contains a chart. The chart is based on a query, which is based on another query, which is based on a table. In the top query, I need to put some calculated fields that operate on other fields. But when I try to multiply two fields together, I get Null. I'm pretty confident that the fields I'm operating on are numerical.
The fields of the query should be:
MaxOfEverInSchool
MaxOfSurvivalToGrade
MaxOfEverInSchool
With these being the calculated fields:
MaxOfSurvivalToGradeCum: MaxOfEverInSchool*MaxOfSurvivalToGrade/100
MaxOfCanReadCum: MaxOfEverInSchool*MaxOfSurvivalToGrade*MaxOfCanRea dCum/10000
Any insight would be greatly appreciated--I just can't understand why Access would suddenly refuse to do math.
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
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 RelatedHow 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.