Search results

Since this is a Home Improvement thread, I thought I could post this here and might find some helps or ideas. Our home has a small pantry room built under the staircase that has no lights. The builder told us that they could not put a light in there for safety reasons (city would not...

Link is dead! SJ.

How about closing Form 'A' right after clicking a button to open form 'B'? This can be accomplished by running a macro, not within code of form 'A'. Then open form 'A' back up after clicking a button (or whatever) to copy record and paste. Another alternative, disconnect form 'A' to table...

What's wiki? Can somebody explain? Thank you

Open it up in 2000 then save it as 2003.

I found it quite unfair for those of you (including myself) who posted answers to questions without ever receiving any feedback for the advises. At least, I'd like to know if it worked or not. Can we make this a forum rule?

Run the attached sample then open the table up to see what dates have been recorded or excluded. Good Luck!

That would be a different story, Stoat. Anyway, why did I just help, but not correct? Because I knew that Sarah wouldn't start over her databases, after working with her for quite some times thru PMs and emails. That's it, simple.

If I were responsible for "the wall" then no, I wouldn't. But if not, I would talk to the apprentice about all the rights and wrongs but again, it would be up to the apprentice whether he wants to listen to you or not, right? And if you knew that he wouldn't listen to you then why bother...

Lucky you for having those kinds of customers or bosses. Some are very strict on what they want theirs to be done. Some even go into details like: I want this table and that table and blah blah blah...and this report to contain only this....it's all b...s..t, you know but hey, it's the job...

I totally understand normalization and the advices. In fact, all my databases have been done like so. I also understand the situation that Sarah's been in. What I've been doing is to help someone's need, not to correct their way of doing things. Yes, we can always suggest but it's up to...

It shows Invalid Use of Null message when there is nothing to show. Are you sure your combo box has records in it? Are you having that msgbox statement in your Form_Load or Form_Open or button_Click? How do you pull the data and put in the combo box?

WHAT IS NAME? IS IT DECLARED SOMEWHERE ' If OWNER = "" Then ' NAME = "" 'Else ' NAME = OWNER.Value ' End If ' DoCmd.GoToControl "OWNER" YOU'RE SETTING OWNER.Value TO ITSELF, YOU = YOU, NO CHANGES SETTING A...

Can you post a simple database?

huh??? didn't get a thing!

It wouldn't hurt to see it. Also, can you capture your form's screen and attach it to this. I want to see what kind of data or activeX control is being copied and returned error messages.

You don't have to disable the Record Selector in order to use your navigational command buttons. It should not matter. Or if don't want to enable, try copying each field (in case you have lots of fields, this is not a good way to do). Here's how: Let's say your form has 3 textboxes...

Rephrase: Let's say one combo box has a list of A,B,C,D. User selects A, A shows up in the text box and also show another combo box with the same list of A,B,C,D. Then user selects B in the second combo box, B shows up in the textbox replacing A. Is that what you want to do?

Check to make sure your form's record selector is enable (or set to yes, know how?). I think that's your problem. You got a blank record because only the AddNew code was executed, nothing was copied over. Try it and post back here.

Create a global variable in one of your modules and set it to the value of the textbox after form closes. Set your "fileName" = to the variable within your PO2 code.