Search results

Thank you! This worked!

I'm pulling my hair out with this one. I have this DLookup function in a report field's control source and it keeps showing #Error. I can't figure out what's wrong. Is there anything structurally wrong with this function? =DLookUp("[Raw Number]","tblAudits","[LAST NAME] = SMITH-JOHNSON")

Thank you. Your newer version has worked great. One last (and somewhat specific question) regarding the start form and dual monitors. Whenever I open up forms from the start form, they open up on the monitor where the application window is (but the application is hidden) and not on the monitor...

Okay thanks. One last question...what code in your DB is restricting the user from being able to right click and enter design mode?

Thank you so much. This is extremely helpful. If all I wanted was the 'design' button that you have on the top of the start form, how would you suggest I limit the code to that? All I'm looking for is a single button that shows the app window, the ribbon, the nav pane and drops the form to...

There's nothing else to show though. The only other thing would be the Nav Pane, but that's working fine

Ribbon below. A lot are greyed out and the ones that aren't & the tabs don't do anything when pressed

Sure, but of what exactly? The ribbon? It looks like a normal ribbon. It's just behaving like its not even there though when I try to press a button. Nothing happens. The buttons don't even highlight

I found some code online to show/hide the application window behind my form. Essentially, it boots up with the application window hidden, and then I have a command that, when pressed, shows the application window, the ribbon, and the nav bar. It works except the ribbon at the top is shown but...

One of the users is hard of sight and so a custom one was made with much larger text. My understanding was that this was simpler than trying to increase the text of the built in one, as that affected other built in text (again, this is an inherited DB and situation for me so don't shoot the...

Curious if you could help me with this last bit of 'on current' code..... The form has a custom nav box which shows what record the user is on. The following code is in the 'on current' code. Any suggestions on if this could be done another way? This is the last bit of code that causes it to...

Thank you!

This is in a similar vein to a post I made yesterday. I inherited a DB which has a bunch of code in the 'on current' event of a single record form, which causes the form to flicker when changing records. When I comment out the code, the flicker goes away so I'm trying to figure out alternatives...

Thank you so much; this was exactly what I was looking for. The example DB was super helpful. I ended up going with technique 1 and it worked like a charm. Thanks again

So I have that currently. The issue is that CB2 doesn't update when moving from record to record. I currently achieve that by requerying it in the on current event

How would you suggest coding that? CB1 is called cbCategory and CB2 is called cbSubCategory

I have a combo box (CB2) in my form whose items are dependent on another combo box (CB1). In order to make sure CB2 is always showing the correct items, I have code in the on current event of the form which requeries CB2 as the user changes records. However, this on current code seems to be...

Thank you. Apologies if I didn't label this correctly enough as a cross post.

This worked!! Thanks so much. I found my original code online so I apologize that it was so flawed. This was very helpful

Related to this post I have a class module and a module to automate Outlook. The module is the code to send the email and the class determines if the email was actually sent. I'm trying to declare a variable in the module in order to update a form field if the email was sent. Here is the...