Recent content by kfenner

Never mind...........I figured it out!

I have created a form and made several of the fields combo fields. I defined the values to be in that field. When I switch to edit view, I click the drop down arrow in these fields and choose the value I want, but when I tab out of the field, it returns to blank. I can type the values in the...

Cool, then I actually managed to fix a problem on my own! Yea for me! I feel like I really accomplished something. You all must be teaching me well! : )

Will it hurt anything or cause any problems to not unlock it before running the query? I'm just learning so much here : )

Ok, I fixed this problem, and this seem to be working well. There is only one more issue. I'm sure it is a simple fix. I tried one way, and it works, but just want to make sure there isn't a better way to do it. There is a button on this form to enter a new record. You use that, then fill out...

Ok, I think I'm following you. Not to backtrack, I did try the other code and replaced "attach" with "open". It still gave the unknown identifier syntax error. Now, the report was designed built on the "newclient" table. So, how do I make it based on the answer...

Ok, I tried that. It brings up boxes with the value of the current record, then you have to click "ok". However, when the report is created, it still has all the records on it, instead of just one record.

<SIGH> I got excited too soon. The button works, and creates the report, but, it creates a report for every record, not just the current open record. what's up with that?

Woo hoo. Your help, and along with the fact I had a missing colon in my actual code.........has now fixed the issues! Thanks so much! I was about to give up!

Ok, changed that, but still get the error &quot;you have tried to access a document that is not open&quot;.

Ok, guys, I'm about to give up! (by the way, congrats Kilot on the new addition! ). I think I am in way over my head here. I just couldn't get the original code I was trying to work since my form is set up as a single record form and has no tableframe or MRO. So, I tried the other code...

My brain is working now. Sometimes it just takes you guys to jump start it. I'll work on this some more, and as always, if I run into anymore issues, I'll be sure to let you know! : )

Ok, I am just stupid here. But, I have no idea how to find what you are talking about. I know how to do it in a form, but not a table. Can you help this novice out?

Ok, here is my problem. Code reads as follows and I'm sure you will be able to spot the problem right away, as my novice eyes can't: var roi ReportOpenInfo rpt Report tc tCursor endvar tc.attach(newclient) ; have tried newclient.db also with same issue as I will describe...

Makes sense now. Thanks for your help and your patience!