Search results

Not quite sure I understand how your forms are set up, but try Requerying the underlying tables in the afterupdate event of the form. Or try refreshing the form: form.refresh. Hope this helps.

Have you tried setting the input mask for the field to 99/99/00? You can do this in the query's underlying table.

Hi Everyone: Just wondering if there's an easy way in Access 2000 to resize listbox columns if necessary to show all information - like you can in a table by clicking, or by the columns autoformatting. Thanks for your help.

You are awsome! That worked perfectly. Knew it was something that should be easy, but I'm not very good at writing sql. Thanks! You made my day!

Hi everyone. Hoping for some help here as I have exhausted all other resources. I have a form containing combo boxes used to filter a list box that uses an sql statement based on a table as its recordsource. I have these combo boxes: 1. cboOperation 2. cboCustNme 3. cboPartNo 4. cboPartDesc...

Pat: Thanks for your reply. I didn't explain well, but was going to set up the tables the way you suggested, but was still hoping to get a count of how many shipments came in for that PO. After talking to production, we are going to have to think through if we really need to do this at all...

Haven't been able to find an answer to this one. I have a subform that is related to the main form by order number. In the subform, user will enter qty received for a po. Because we may not receive entire quantity for po at once, we need to add a number or letter to the end of the order...

I think you have two options: to have a yes/no field for each of the optional services in your main client table. Or you could have a record added for each client in the detail tables whether or not they have the service. You would add a field named CellPhone (or whatever), in the...

Your field in your table should be yes/no datatypes. Drag your field onto your form. When the record is pulled up, if the criteria is "yes" the checkbox will have a check. If "no", there won't be a check.

Thanks RG. I thought of that after my post. I'll go ahead and do that since you agree. I have also gotten a lot of help from your posts to other members questions. I appreciate you sharing your knowledge. Thanks a lot!

This seems like it would be easy enough, but I can't seem to find an answer. I'd like to put a tab control on one page of a main tab control. I've tried to select the page and create a new tab control and cut and paste existing tab control, but in both cases the tab control pastes into the...

Thanks a bunch!

Thanks for your response. I had thought of that, but also trying to give user ability to enter new addresses if needed. However, perhaps I should make that part a separate entity. Curious what the search pop ups your refer to are. I appreciate your input/help.

Have looked for an answer using all my resources and can't seem to find an answer to this one. I'll try to explain clearly... I have a main form ("Form 1") with a subform ("Form 2"). The form 2 has a subform ("Form 3"). The purpose of these forms is to create a customer PO. Form 1's...

Why would you want to use the delete button while in the combo box? Are you thinking a user might press it?

There is no need to view historical pricing. We are creating an entirely new quote. Copying the original pricing (and the quote information) just saves the user from having to reenter much of the same information. If our charges have changed from the original quote, they will be updated. This is...

I have a quote form with many subforms. The subform's recordsource is a pricing table. I have a procedure that copies the quote and updates pricing where applicable using a recordset (edit, update). All is good with that part. Here's the issue: If I close and set the rs to nothing at the end...

Hi All: I have a form that at certain times, requeries tables to update pricing. My problem, I have now found, is if users access this form at the same time (even if they are accessing different records) the second user will get error message 3009: "You tried to lock table while opening it...

Not sure what to call this "phenomenon" so haven't had any luck searching for an answer. I have a form (form1) that has a close button with code behind it. When the button is clicked, it takes a few seconds for the code to run. When form1 closes, all is well up until: There is another form...

Me Too! I have the exact same problem on a database I am working on. The subforms are not modal or popup. If I select a field and don't update it, the only way I can get out of the subform is to press the escape key twice. If I do update the value, I'm am ok to go anywhere I want by clicking...