Recent content by james5478
-
J
Form not Opening in Parameter query
Aside from a missing paren after "FROM DD_MaxEffDate", the query appeared to run fine. I tested a couple scenarios selecting a date in the combo vs. leaving it blank and everything ran fine. Thanks -
J
Form not Opening in Parameter query
I'll make note of posting my own threads next time. I meant no offense and apologize if that upset you spikepl. I wouldn't want to "threadnap" anymore and end up on Oprah. FYI, the "solution" you posted doesn't work. -
J
Form not Opening in Parameter query
Hi Paul, I wanted to post a question I had that is related to what tb1 posted above. I wanted to know if maybe you could offer some insight as you have helped me out in the past (question for assistance not only directed towards Paul either fellow forum mates-please chime in if you wish). I... -
J
passing date criteria to query from control on form
Hi all, I hope you guys are doing great. I have a form I am working on and need some help. To give you an idea on the structure, the form is based on a query, which in turn is based on a table. On the form, I have a StartDate and EndDate textbox (formatted Short Date) where users can... -
J
Auto populate Text box from Combo.
I thought about the Nz() function, but when I tried to integrate it into the code I already have, I ran into issues. Can you give me an example? Thanks Paul. -
J
Auto populate Text box from Combo.
Hi Paul, I have another question I thought you might be able to help me with. On the form in addition to the text boxes populating off of combos, I have a couple text boxes I need to populate based on another text box and one text box that needs to be a concatenation of a text box and a... -
J
Auto populate Text box from Combo.
Hi Paul, Thank you for responding so quick! I actually figured it out a few minutes ago and did exactly what you mentioned in the link. What I did was create a combo box based on a query (so the list is dynamic and can change when needed based on the data) and pull all fields desired from... -
J
Auto populate Text box from Combo.
Hi Dave and Everyone. I am new to the forum. I have experience with Access and other apps, but haven't had to use it in a while (working more with SQL and other reporting apps). Recently, I have found need to leverage Access again (2010 specifically) and need to build some forms for users to...