Active 4 years, 7 months ago. Viewed times. Requery End Sub I have a feeling that it has something to do with the order of the quotations ' vs " but I haven't been able to figure it out. Improve this question. Sami if you are adjusting a form record source and not executing a query, I don't think you can use parameters. Add a comment. Active Oldest Votes.
See if these simple changes will fix your problem. Improve this answer. SandPiper SandPiper 2, 4 4 gold badges 24 24 silver badges 42 42 bronze badges. Erik A Erik A I did not know that. However, no, this still doesn't bring up any results. Is there any better way to debug why not? That's it! That works! Only, it won't update on hitting enter. I have to go back and select the text box before it updates the subform.
Is having this code run on "Enter" a bad idea? TDolph TDolph 49 5 5 bronze badges. Watch out for ads on the site that may advertise products frequently classified as a PUP Potentially Unwanted Products. Thoroughly research any product advertised on the site before you decide to download and install it. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. Ken Sheridan. You might like to take a look at FindWords. If you have difficulty opening the link, copy the link NB, not the link location and paste it into your browser's address bar.
This little demo file illustrates use of a FindWord function, which you'll find in the basFindWord module in the database, and which, unlike the LIKE operator or Instr function, is not subject to possible specious substring matches. This site in other languages x. If you only want to display the numbers to the left of the hyphen, you need to do a calculation each time to find out where the hyphen is.
One option is to do something like this:. Subtract 1 from that value and you get the correct number of characters for the Left function to return. Seems a little complicated at first, but with a little experimentation you can combine two or more expressions to get the results you want. For more information about using string functions, see Using string functions in your Access SQL queries. Creating expressions. String functions and how to use them.
Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you!
Any more feedback? The more you tell us the more we can help. Can you help us improve?
0コメント