Search results

Your MS Access Condition to Test is made up of two Logical results combined with OR. The first is the IsNull, and the second is the IIf(). In the previous response, I addressed the IIf() only, In MS Access, IsNull uses a single parameter, and returns a Boolean result. In SQL Server, IsNull()...

In General, The Simplest form of IIf() is similar to what is posted below. A representation for this that is compatible with SQL Server Views or T-SQL follows. Of Course, more complex examples may require more complex resolutions. -- Rookie IIf( { Condition to Test }, { Value if TRUE }, {...

I would love to be able to have something like this, but the only Windows 8 PC that I have left crashed with disk errors and I do not have any way to check the disk for reason of failure. I can take it to a repair shop that will gladly tell me for a cost of about $179 American, either...

Welcome to the Forum! Feel free to search and Browse the library of existing content to obtain ideas and directions for how you can proceed. If you are not able to find ideas from the experiences of other users, there are many people here that will try to assist you. All you need do is ask a...

As pbaldy said, because you have used spaces in the name. the reference to your master table needs brackets ( [master estock report] ). In addition, to prevent any issues regarding Field contents and intent, I have each Union subquery use the same Field Names (via Aliases when required) for...

Actually, I am curious as to what some people seem to know that the rest of us underlings have not found out yet. If there is a crash course available (dummies style of course), I am sure it could turn out to be useful. -- Rookie

Most of your Where Statement is fine, and but the last part should use the In() Function. Check out this tutorial and see if you have any further questions. http://www.tutcity.com/access/using-an-statement-vba.36065.html

If you change the values returned by the Query or Table controlling a Dropdown box of any kind, VBA Code like me.ComboboxName.Refresh should update the list without having to close and open the form.

I am not a VB.Net Expert, so I am not sure that I understand what the complete scope of your issue is, but the link below may apply to your situation. -- Rookie http://www.tutorialspoint.com/vb.net/vb.net_combobox.htm

BlueIshDan's idea works in a Company Network situation, and does not apply to normal web based systems. Your idea will work, but leaves open the possibility that a user could select an incorrect name. I assume that your system (as with any good web based system) verifies the identity of...

frmMsgBoxUpdateSpreadsheet is an expected name for a Form or Sub-Form in Access. Is it also the name of the Control on your Main Form that contains the Sub-Form? If so, then what pbaldy said should work for you. If not, then if you change frmMsgBoxUpdateSpreadsheet to the proper Subform...

I would like to agree with Ranman that splitting the database is always the first choice when there are multiple users on separate machines. Having said that, let me address your two issues separately: When 2 users opened the database on different machines at the same time, a warning message...

You did not specify the nature of your error(s), but it is known that DoCmd.TransferSpreadsheet can have trouble under Access 2010 when there is a hidden worksheet that is "seen" as the first worksheet. This condition previously was ignored by Access 2003 and before. If you think that this...

I can't believe that I am saying this (since it violates proper normalization rules, and I am still not sure what you want to do), but did you try to use the Instr() Function to locate the Model Number? Once you search your data for the Model Number, you can determine the best way to use your...

Try using the Function InstrRev() where you currently are using the Function Instr() and see if that makes a difference. -- Rookie http://www.techonthenet.com/access/functions/string/instrrev.php

Am I missing the LOOP Here? I would think the process would want to loop back to retry and count the iterations. Consider the following Pseudo-Code as a starting point. -- Rookie Dim MaxFailsAllowed AS Integer Dim FailCount AS Integer Dim ValidID as Boolean MaxFailsAllowed...

I am glad that I was able to assist. The only thing that I can think is that there are Null or other non-visible characters before or after June in the strings. Perhaps you might want to check the length of the strings to see if they are greater than 4 characters.

By the normal rules of Access Database Splitting, there should be little or no issues in doing what you want using a form. In most cases, MS Access users do not notice any difference when using SQL Server as a back end. If you are having issues, then first make sure all affected users have...

I did not see that this has been covered yet, but the pieces of your new Serial Number are not all strings. If you are going to concatenate, then all of the pieces will need to be strings, since a string cannot be concatenated with an Integer (or any other type of number). When a value is an...

Obvious is a relative term, but one thing that I find missing from this code fragment is the definition (type and content) of the variable strSQL. The assumption that it will be a string and has an assigned value is not always going to be valid for every context. If the variable strSQL is...