Search results

Thanks Paul, All the names and data types look to be the same. Can you explain a bit more what you mean by this? I specifically don't understand what you mean by "requery the textbox".

I inherited an .aacde database file. I am nervous that I cannot look at nor update the VBA modules. There is seemingly precious little information online (and I can't find ANY in the Access online help) that explains what the purpose of .aacde is and how you would create one. Can anyone shed...

Upon further review, it appears relevant that this is an .aacde file. Is there any way I can turn this into some other kind of file? It doesn't appear to let me save as nor convert! ETA: Once I got this far, I then could understand what the issues are.

When I right-click on a module in the Objects column, "Design View" is greyed out. When I go to Database Tools--Visual Basic, double-clicking on any object brings up a pop-up saying "Project Locked: Project is unviewable". When I click Help, just the regular table of contents comes...

Thanks for the replies. I've gotten a bit more information...apparently double-clicking on the field in question brings up a Materials continuous subform (this still works), and then once one or more materials are added and the subform is closed, the top one appears in the main form's field...

I inherited a database; its form has a Materials field with the expression =IIf(IsNull([ID]),"",DLookUp("[Material]","Materials","[ID] = " & [ID])) A user told me that she could no longer input data into the field. I looked at the query, and the Materials table was no longer listed; it's very...

Thank you! I will give that a try.

I posted this in the Excel forum, but didn't receive any responses. Is this forum for Excel VBA as well as Access? This is the third in a series of threads...I'm way over my head on this, and seem to be wasting countless hours. Thread one...

This is the third in a series of threads...I'm way over my head on this, and seem to be wasting countless hours. Thread one: http://www.access-programmers.co.uk/forums/showthread.php?t=194313 Thread to: http://www.access-programmers.co.uk/forums/showthread.php?t=196358 Helpful users have...

Great idea! Thanks!

On one of my spreadsheets I have a timer that times people out of a spreadsheet after a certain amount of time...I had some help here: http://www.access-programmers.co.uk/forums/showthread.php?t=194313 But I would like to reset the timer any time a key is pressed. So the user will only be...

OK, I stand corrected. The hyperlink does still work (I missed a security pop-up behind the scenes), so it needs to be removed since we don't always want to follow it.

Looks like the build event works and the hyperlink no longer works. I'll have to add a hyperlink to the VBA, which should be simple.

If I put a build event on these hyperlinked buttons, do you know which will come first upon a click?

Hadn't been familiar with the Nz command, either. For the most part, I've only done the very most basic stuff in VBA. Thanks again!

OK, I'll check out DCount. I hadn't been familiar with that command. Thanks!

I inherited an Access database that has a switchboard with clickable links to Minitab statistical software executable macros. Long story short, Minitab breaks if certain involved Access queries contain no data (I'll be happy to provide more information if desired) Minitab customer support says...

Great! Thank you very much!

I have an Excel spreadsheet on a share drive that is used by many people. I really don't want to share the spreadsheet, but at the same time I need to do something about the problem when users stay logged in to the spreadsheet and then others can't make any changes until they find the person...

I will try that out. Thanks for your quick response!