Search results

Thanks for the response! Where do I add the Docmd? In the fields themselves or in the field I use to populate them? How do I know if they are bound to a table?

How can you modify this to clear all checkboxes?

Hello all, I wouldn't call myself a beginner at Access but I am nowhere near a skilled programmer. I have a database I have to finish in the next several days and have some challenges that I have searched and searched the forums for answers to and can't seem to find the answer. Maybe I am not...

You mean keep all the tables in one on the server and the forms, etc (linked tables) on their harddrives right?

Hello, I have a wierd problem I am hoping someone can help me with. Our company database is stored on the server. The problem is that I can open it when no one is in at and then they can all get in after I open it. If everyone else is in it, I cannot access it at all until they close out, I...

At least I think it is....I'm just stuck, I swear I have done this 20 times and can't figure out why it is not working today. I have a WorkOrders table which has: WorkOrderID (auto number) Car Number Arrival etc..... and a table which has: GEID (auto number indexed field) WorkOrderID Date...

I must be doing something wrong...when I did a search for references...this was the only post that came up. UGH! I did find out that we are running MSACC 10.0 and he has MSACC11.0. Could that be it?

Do they have to match? I checked there and one is running Microsoft Access10.0 and the other is running Microsoft Access 11.0.

Yesterday I redesigned some of the forms in our database and all was working fine. It works fine on every pc in the office except 1. On his pc he gets the following error when opening the database: "An error occurred while loading form_ContractChargessub. Do you wish to continue?" If you...

Thanks! I know how to use the wizard. I'm sorry, I probably didn't explain myself. I want the subform to be hidden unless a button is clicked that makes it appear. Thanks

Hello all, I know I have seen this before and I have searched the forums several times and cannot find it now. Maybe I am searching the wrong thing. Can someone point me in the right direction? I need a button on my form that opens a subform or subforms when clicked. How do I set this up...

Hello, I am working on an inventory valuation summary report which calculates totals based on two subreports. All is working great for items that have usage and current purchase orders, however, if there is no value in the subreport. For example, we don't have any purchase orders for that...

What is the best way to change that then?

I have a form that we've been using for a while now. I want to add a multi-select box to find records on the form. While this works great on other forms in our database, when I use the wizard on this particular form it doens't give me the "find a record on my form based on my selection option"...

What is the best way to go about doing a 2.0 version of a database? When I wrote ours I was a newbie. Not that I am an expert now or anything but things could definately use an upgrade!!! I need to clean up the forms, etc. Do I just dump all the tables in from the old one and start over? I...

THANKS! I'll check it out!

Umm...because I have no idea how to to that. lol I use alot of surfing the forums and cut and paste. If you think that would work better, just tell me how and I'll change things that way. Thanks for your reply!

Hello, I currently have a combo list on a purchase order form that has the following event procedure(s) in it so as to open the inventory window as needed to add/edit inventory. Not in List: Private Sub Combo55_NotInList(NewData As String, Response As Integer) MsgBox "ERROR: ITEM not in list...

Howdy....this is a revisit to this topic...I don't know if I need to post a new one or not. How to I make this auto-update? Can the if/then statement be put into the table itself?

I currently have a form to manage inventory. On the left side of the form, I have a list box that shows all of the items in the database and finds the record on the form based on the selection. I would like to have toggle boxes or something underneath the list box that when clicked will sort...