Search results

Looking at DoCmd.RunSQL "UPDATE Counts SET Counts.Name1 ='" & strFile & "' WHERE Name1 IS NULL;" Further up the code you have a loop that repeats until strFile is blank so the SQL will never update the field to be a non-blank value It should read DoCmd.RunSQL "UPDATE Counts SET Counts.Name1...

If Warranty is a Yes/No field you should be able to use IIF(Not([warranty]), [partprice]*[discount]*[quantity], 0) Note that I've also replaced the each x with an * - not sure if that was in your actual calculation

Are those freaking American messing with our language again so that display means store?

To clarify, you're trying to update a table in the (external) database 'c:\contacts.mdb'?

Yep, it looks like everything is in that code for you to do what you've asked. Why not make your changes and try it and let us know the outcome?

I'm not sure if you can do it via a query but you could via code http://www.tek-tips.com/faqs.cfm?fid=4310 is almost there

L9 and M9 are not numbers (because G9 and H9/I9 are blank, respectively) in your attachment, maybe you should test for isnumber on all of the cells you wish to add (or use in calculations)?

Are the 'conditional cells' in "I would like blank cells until all conditional cells have data" E13 and E14? If so, I would use "" instead of "0" and change the tests for ISBLANK to ISNUMBER (and swap the true and false values around), ie In F13, -->...

Thanks mdlueck The intention is to use the Localdb functionality when users are out of the office (for reference) so limiting access to the machine it is installed on is fine. Just need to find out if it is possible/easy!

For the usual reasons, I'm looking to upsize my back end Access database to SQL Server (Express), something I've not done before A few of our users spend a lot of their time out of the office and currently take a local copy of the back end and use the FE (which has an option to link to 'Live'...

Do you mean keyboard shortcut? If so, you need to create an Autokeys macro. More info at http://office.microsoft.com/en-gb/access-help/run-an-access-macro-by-using-a-keyboard-shortcut-HA010239111.aspx

As I said before, I'm not sure if the objMessage line needs to be moved. If I had time to research it for you, I would but I'm afraid I don't. As you were sending 2 emails before, it looks like it's working. To get the subject changing, your code would have to change to Public Sub Email()...

The subject isn't changing as the variables in the calculation are not changing as they are set outside of the loop. Even if they were inside the loop, they would calculate the same value as they're basically calculating 'find the first value of the field in the table' - you have no condition...

DiscountedPrice: [Price]*0.95 You may wish to round the above (and use a custom round function like in http://access.mvps.org/access/modules/mdl0054.htm if you don't want to use Access's 'bankers' round)

I've yet to use it but I have a similar problem and have been looking at http://www.lebans.com/textwidth-height.htm which looks like it may help

I would add a new field to your new Names table called inactive and add the old names to the table with the inactive field checked On the form, add code on the current event to change the source of the combo box, something like Private Sub Form_Current() If Me.NewRecord = True Then...

Come again?

You need to create a macro called Autokeys http://eileenslounge.com/viewtopic.php?f=29&t=7927 may help, other google search results available! Note that the process is slightly different in Access 2010 (or at least I found it to be)

Where is the 'subsubform' on the attached image (which looks very nice, btw)?

Add the 'names formerly derived from the Value List' to your new source. If you don't want these old names selected for new records, you could use vba to change the source based on whether the form is in create mode or not (or if the record is new/old)