Search results

To expand on what CJ_London said, try a wildcard compare using the Like statement, and see if you can locate the word June that way. I believe that the appropriate syntax for you would be '*June*' (or '*une*', or '*Jun*'). If you are unaware of how to make the suggested changes, I hope that...

You say that the database can be used by more than person at a time. Is everyone using the same version of the database file, or has the database been split with each person using their own Front End, and sharing the Data in the Back End? Your symptoms are consistent with the single...

the shire of

by a stranger

The Standard IIf() Function has three parts: IIf(Condition to Test; Value If TRUE; Value if FALSE) If I read this correctly, your IIf() may be improperly formatted. Below you can see how the first of the two IIf() statements appears to have 4 parts instead of 3. (C1)...

Looks like you made a good start with the Last Name. In a similar manner, you can use the RIGHT() and InstrRev() Functions to get the First Name from the end of the String. Look at those two Functions and get back to us if you need any further assistance. -- Rookie UPDATE: Looks like Brian...

I see that Uncle Gizmo still knows all. -- Rookie

Thanks BigHappyDaddy, I believe that is what I was trying to get abzalali to try. Now all we need to do is wait to see the results -- Rookie

Methinks we are SIMPLY going to need more info to help out on this one. -- Rookie

While BigHappyDaddy makes an excellent point, you might be able to get your existing structure to work for you. One problem that you are having is that each of the Queries uses a different Field name for its data, which prevents them from being related after the Dataset is completed...

It is possible that the position of your Wildcard markers is creating at least some of the problems. See what happens if you do the following (refer to the colorful Text above) Change *' to '* Change '* to *' -- Rookie

I believe that what MarkK has been trying to tell you is that while you may not feel that the Table Names are at issue, they are, at least to a degree. More importantly, the Table Structures are certainly at issue. We would really like to assist you in this, but more information will be needed...

Greetings and welcome to the Forum. It was not so long ago that so many of us found ourselves in a similar position to you. Tell us more about your issues and I am sure we will do out best to get your pointed back in the right direction. -- Rookie

vbaInet: I have no idea. It did not look like that when I posted it or I would have corrected it like I did after you pointed it out. Perhaps there is a curse on post #13? -- Rookie

Greetings to all. I encountered an interesting issue on a project today. We have an MS Access 2010 Database that uses Local Tables, External MS Access Tables, and ODBC Linked Oracle Tables (Accessed for Read Only). The unsual issue occurs with the ODBC Linked Oracle Tables. One of the more...

MS Access uses a mildly different set of "Basics": IF { condition } THEN result ELSE consequence END IF Try to do it in a similar manner, and let us know what happens. Remember that the position of the Keywords will be important

It looks like you used the Instr() Function correctly It looks like you used the UCase() Function correctly. It looks like you did not use the Mid() Function correctly. I had another thought in the time since my last reply. A much better Function for you to research might be the Replace()...

I would like to expand on what jdraw said. You can use the Instr() Function to determine if "London" is found anywhere in the Textbox You can use the Mid() Function to determine where "London" is found in the Textbox You can use the UCase() Function to change "London" to "LONDON" Take time to...

As part of a previous project that I worked On, I needed to generate Bar Codes using MS Access 2003. I soon discovered that it was as easy as obtaining a new set of Fonts for my computer, and assigning the Bar Code Font to the Label that contained the Bar Code. I suspect that this method will...

Have you considered the TAB Stop Property? I believe you should be able to use that to skip a Field despite the Tab Index Value of the Field. I assume from the conversation that you are using the Visible Property to hide the Fields, so whenever you set the Visible Property = NO, also set the Tab...