A customer's name is SZEE. Seek him through the SName textbox with Find, and Access can't find him. (Same in the table.) Seek him with a wildcard Sz* and there he is.
I've tried it on another machine - also with Access2k - and it's the same.
Is it an Access quirk? Is there an answer? (The client asks why. Be good to be able to say.) Cheers.
Can anyone help me in creating a field from a query which will pull the first word only from a specific field.
Thanks.
Hello,
I asking to see if it is possible to run a query on a memo field. For an example I want to pull all records where the memo field contains the word "Test".
Is this possible?
Thanks!
Fen
I need to find whether a memo field contains a specific word. I know how to find whether it contains a specific string.
Let's say I am looking for the word "run." I would not want a positive result when searching "I don't like gerunds," but I WOULD want to find the records with "I know how to 'run' a search."
So I am looking for WORDS, not matching strings.
I am perfectly willing to use a user-defined function, to put involved processing into the query, such as
Code:
...
WHERE FieldHasWord("run", memoField) = True
AND ...
I've almost completed the DB I'm working on, but still have a few loose ends to tie up that I can't seem to figure out. I've spent many hours already on this forum searching for solutions, and have tried a few different things, but I still can't work out these bugs.
First, I need my form to open with the latest records filtered first, so that the most recently added records will be easiest to find and edit. I'm not sure how exactly to do this. I've tried a run query when the form is opened, but I still need all the records displayed or accessible. The form is called frmDenial, and I would like it to be looking in the DateLogged field of the form. Any suggestions?
Second, I have command buttons that will export data in the fields to MSWord Templates via bookmarks. The button runs well by opening the document, inserting the data, and printing. I have also tried several different code syntax to close word once it is done, but it is still staying open after printing. Here is a sample of the code:
________________________________________
Private Sub Print_Letter_Click()
Dim objWord As Word.Application
'Start Microsoft Word 2000.
Set objWord = CreateObject("Word.Application")
With objWord
'Make the application visible.
.Visible = False
'Open the document.
.Documents.Open ("G:PharmacyPrior Auth Docs and DataRevised Pharmacy Denial ProcessesKAN Not Nec or Benefit2.dot")
'Move to each bookmark and insert text from the form.
.ActiveDocument.Bookmarks("bmkFirstName").Select
.Selection.Text = (CStr(Forms!frmDenial!MBRFirst))
.ActiveDocument.Bookmarks("bmkLastName").Select
.Selection.Text = (CStr(Forms!frmDenial!MBRLast))
.ActiveDocument.Bookmarks("bmkHRN").Select
.Selection.Text = (CStr(Forms!frmDenial!MemberNumber))
.ActiveDocument.Bookmarks("bmkAddress1").Select
.Selection.Text = (CStr(Forms!frmDenial!MBRAddress1))
End With
Print_Letter_Click_Err:
'If a field on the form is empty, remove the bookmark text, and
'continue.
If Err.Number = 94 Then
objWord.Selection.Text = ""
Resume Next
End If
objWord.Application.Options.PrintBackground = False
objWord.Application.ActiveDocument.PrintOut
objWord.Application.ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges
'Quit Microsoft Word and release the object variable.
objWord.Quit
Set objWord = Nothing
Exit Sub
End Sub
_______________________________________
Finally, I have two cascading combo boxes set up that will auto pop related fields based on the selection made. But, if an item is not in the list, I would like the user to add it to the linked table to appear in the list. I also have this working well, with a pop up asking the user if they want to make the addition, type in the new item, and add to the list without requiring the user to refresh or exit then re-enter the form. But it will only add the item name, and not the item description (another field in the form and another column in the table). How can I modify the code to prompt the user to enter these other details? I can link it to a pop up sub form to enter the data, but if possible, would rather the boxes pop up to have the user type in the data. Here is the code I have so far in the NotInList Event...
__________________________________________
Private Sub DrugName_NotInList(NewData As String, Response As Integer)
Dim DB As DAO.Database
Dim rs As DAO.Recordset
Dim strMsg As String
strMsg = "'" & NewData & "' is not an available Drug" & vbCrLf & vbCrLf
strMsg = strMsg & "Do you want to add the new Drug to the current Database?"
strMsg = strMsg & vbCrLf & vbCrLf & "Click Yes to add or No to re-type it."
If MsgBox(strMsg, vbQuestion + vbYesNo, "Add new model?") = vbNo Then
Response = acDataErrContinue
Else
Set DB = CurrentDb
Set rs = DB.OpenRecordset("tblDrug", dbOpenDynaset)
On Error Resume Next
rs.AddNew
rs!Drug = NewData
rs.Update
If Err Then
MsgBox "An error occurred. Please try again."
Response = acDataErrContinue
Else
Response = acDataErrAdded
End If
rs.Close
Set rs = Nothing
Set DB = Nothing
End If
End Sub
______________________________________________
The two other colums in the tblDrug that I need the user to be prompted to fill are Denial Reason (column 3) and Alternative (column 4). What would be the best way to accomplish this?
I would really appreciate any help or suggestions with any of these problems. Thank you so much! :o
I have 5 textboxes and a multiline textbox in a form in my Access Database. I am going to type several keywords in those textboxes and I am going to type an article in the multiline textbox.
What I need to do is I want to calculate the keyword density in the article. I can do that if i know how to search the whole text in the article and count the specific word. And I want a function to count all the words in the article too.
I have been working on a simple data base for some time now (beginner level) and am still trying to improve it. I would like to do something but before that I would like to have your opinion to know if it is even possible?I have a query QryMainReport:
Start Date/Time
End Date/Time
Employee
At the moment this is what the format of my report looks like (I removed other unnecessary fields):
StartTime----------EndTime---------------Employee
12/06/2014 01:00--12/06/2014 03:00------John Smith
12/06/2014 04:00--12/06/2014 06:00------Jane Doe
13/06/2014 02:00--13/06/2014 05:00------John Smith
13/06/2014 08:00--13/06/2014 08:00------Jane Doe
I would like to do as a report. (Dates would always be from Sunday to Saturday). I am not sure it is possible to do that. I suppose first it would mean:I would have to do a query to separate the times from the dates?I would have to find a way for Access to find the unique dates and unique names?Does it mean I have to use cross tab queries?
Is there any way I can do a search that lets me put in a section of a part number and the part number be found? I only see how I can find the number if I put in the entire number.
Thanks
I think this is fairly simple, but being as I haven't ever done it! I want to do a search to find all records less those called "Default". As I say I just cant think how to do it. Any help appreciated. Thanks
View 2 Replies View RelatedHey everyone,
Im creating a database for college using MS access 2003.
I have 3 table that contain data and i am building form to allow a user to search for a particular customer. The customer ID in my customer table is an auto number.
I have a button on my form and it shows the find and replace box when pressed which is what i want but i then want it so that when a user types a customer ID number in to that find and replace box and it is an exact match for the find and replace box to auto close else show an Error message and allow the user to input another customer number,
Im sure there is macro code to do this so im asking if anyone knows or has any better ideas?
Thanks for your time
Hello Expert,
I have attempted for two days to following codes. I am still unable to get the way out. Would you give me a help?
The field fund_cd is a combo box of transaction table to look up reference table called fund_type. Here is the structure of fund_type:
fund_cd text 3
fund_desc text 50
fund_currency text 5
My needs are to pull both values of fund_cd and fund_currency to transaction table, so 1 combo box cannot meet my needs. As such, I write following codes to base on selected fund_cd to find appropriate value of fund_currency in fund_type.
From the code below, I meet the run-time error ‘3001’ and I am not sure can I finally get fund_currency using method of GetString.
Dim strSQL As String
Dim strccy As String
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
rst.ActiveConnection = CurrentProject.Connection
rst.CursorType = adOpenStatic
rst.Open "Select * from fund_type"
strSQL = "fund_cd = " & Me.fund_cd
rst.MoveFirst
rst.Find strSQL, 0, adSearchForward
strccy = rst.GetString(adClipString)
Thanks very much!
martinaccess
I am trying to code a combo box control to find a record. This is incredibly simple but for some reason it won't work. Could you tell me what I am missing.
I have put the following code in the after update of the control
Dim rs as Object
Set rs= Me.Recordset.Clone
rs.FindFirst "[ContestNo]='"&Me![Combo23] & "'"
Me.Bookmark=rs.Bookmark
I don't get any errors but it won't work either...any ideas??
thanks in advance,
Brenda
I have an unbound text box. I want the user to
be able to type in all or part of a title for a movie.
Hit the find button and then have a form open
with entry's based on the text box.
Thanks Tukewa
Hello to all,
Little new in Access i would like to know how to use the key to find directly to a record in a table.
ie : i have a table where the primary key (unique) is a date, using VBA i would like to know the instruction to find directly the record 01/06/2004 for exemple.
Thanks in advance.
VINCENT
I realize this probably isn't the right place for this, but...how do I find all of my posts, whether I started a new post or responded to someone else's post?
Thanks in advance to whoever replies :D
I have a find command button that appears to call the find and replace message box. It should be a search for anything in my query. The code behind the button looks like the find and replace message box in the office suite. I believe I am trying to create a message box where you add an entry and it searches then lauches a subform with my entries.
When I checked the button it had the following code:
Private Sub cmdFind_Click()
On Error GoTo Err_cmdFind_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_cmdFind_Click:
Exit Sub
Err_cmdFind_Click:
MsgBox Err.Description
Resume Exit_cmdFind_Click
End Sub
I read a few of the lookup queries but they only give me a drop down. Is there some way to customize the box comes up without altering all of Office or do I just sound lost.
Ok, so I made a registration website with FrontPage and published it. The registration page has several text boxes and a submit button. I was testing it out and entered a few dummy names. The conformation page popped up and said everything was ok. So I'm assuming the data successfully uploaded into the Access DB that I linked it to while in development.
My problem is when I go to the folder where the DB resides there so no data in the tables. I'm thinking that maybe when the website gets published a copy of the DB is moved somewhere and I'm looking in the wrong place? This is the first time I have made a webpage or used FrontPage so please excuse my ignorance, hehe.
Ok, so I made a registration website with FrontPage and published it. The registration page has several text boxes and a submit button. I was testing it out and entered a few dummy names. The conformation page popped up and said everything was ok. So I'm assuming the data successfully uploaded into the access DB that I linked it to while in development.
My problem is when I go to the folder where the DB resides there so no data in the tables. I'm thinking that maybe when the website gets published a copy of the DB is moved somewhere and I'm looking in the wrong place? This is the first time I have made a webpage or used FrontPage so please excuse my ignorance, hehe.
Hi all
This message has suddenly started to appear when clicking on a shortcut to all my mdbs.
Windows cannot find [path] .mdb
I click OK and the db continues normally.
the message does not appear when opening a mdb directly.
odd huh?
any thoughts on how to resolve this annoying problem would be appreciated
Hi, I am inputing addresses into a massive databse, through a form, does anyone know a way, that i can get it to do a search for the address based on the postcode, like how googlemaps does it or something?
Thanks
Alex
I have some database, I need to replace empty cells one column with some data.
But Access does not do it.
Any suggestions?
I need to add a Form to an Access database designed by others. In the form design view, there is no toolbox shown . If I go to View menu, toolbox is greyed out.
Can anyone please advise how to locate the toolbox?
Hi,
I have a database created in Access 2000. It works OK on computer number one. When I copy the data base to another computer and open it, the table can not be found. The error message is "D:DocsdgrDocent Library Nov 2005 is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which it resides" The path mentioned is the original path on computer number one. The DB opens but it will not find the table or the queries etc. I thought that moving the DB had something to do with it but when I copied the DB to an external HD and then opened it, it works fine. But when I connect the external HD to the other computer it doesn't find the table.
Both computers have Access 2000.
Number one is XP and number two is W2000.
David G Rhoades
dgrjazz@sbcglobal.net
Thanks:)
Hello everyone.
I've got an VB app that uses an Access db that sits on a sever. The owner of the app has no Access installled on site. The prior consultant created the app and used MS Access.
Is there a way for me to determne what version of Access this db was created in?
Thanks
Dom (new to Access)
I have created a DB with many tables and I want to find a way where I can retrieve all the emails from every table (each one has a column with emails). Does anyone know what to do? If a record doesn't have an email address do I have to type N/A or just leave it blank?
View 1 Replies View Relatedis there any simple way to find and replace wildcard character- I have a large data table with text as sample below- I would like to remove |00
2901-0206|00
Thanks