Search results for query: *

I have a database that was using replication until last night. I created a new database and imported everything from the old database to the new one to remove replication. Worked great, or so I thought. What is the exact percedure for making an MDE? Do I need to split the database out first...

My forms were not linked on their properties to the proper link field. Changed them both to RCustomerID and they work great!

NM...I fixed it! Thanks anyway.

I have a form that contains a subform. They have a field of RCustomerID in common. Everytime I select a customer on the form and click on the subform to add data, it updates fine. Now I want to take it a step further. I want to add another subform into the original subform. Now I have a...

THANKS SO MUCH! I thought I had tried that before, but obviously not. Works great!

I have a table called tbl_Percentage. The property is set as a Number field, as an Integer, with a format of Percentage. Regardless of what I enter into the field, it multiplies by 100 and returns a very high value. If I enter one, I get 100%. I would like a table that lists percentages...

I have a combo box that is building a list from a query and when I select something from the list and run the code, my code says the combo box equals empty. What would cause it to return empty instead of either null or what it actually contains.

I have a form called frm_Customer. Inside of this form, two subforms are linked. One subform is called frm_HWQuote and the other is frm_SWQuote. What happens is this...I open the frm_Customer, search on my customer, select the customer and then aprox. 6 fields of information appear such as...

Thanks so much! I do have my control names without spaces. I failed to report that to you...sorry. One more thing....How would I alter the above thread. The one pertaining to the "LostCustomer" to give me a message box that says: "Changing The Customer Type To...

That worked great! Now another...Now I have two check boxes. They read: "Quote Won" "Quote Lost". There are a few fields that go along with them. They are: "Percentage Chance To Gain Sale" "Proposed Win Date" "Proposed Won Amount" &...

I'm not for certain if I completely understand. My combo box, "CustomerType" has 4 choices; Existing, Potential, Lost, Unable To Help. The second field is the "CustomerPurchaseDate". The Customer in my system could possibly be, "Existing" with a purchase date of...

I have a combo box with three choices and a field that is set to read the date. I would like to have the date clear when one of the choices is selected. Any thoughts?

I have an Access 2000 database. I am trying to create a criteria form to pull reports from. The fields on the report are: OfficeTypeID & Zone. They pull from a Query called: qry_SiteVisit. In the Query, the Field Names are: ZoneDesc and OfficeTypeID. No criteria is established in the Query...

Okay...I need more help. I have a form created with two fields on it. They are called; Zone: and Office Type:. They are both Unbound fields. They are combo boxes so the user can select which zone and what office type. My problem...I don't know how to make the form select on the zone that is...

I have reports created that pull from queries. I would like to create a form that would allow a certain criteria pulled from aprox. 5-6 fields in the query to access the report many different ways. I was wondering if creating a new form (not based on a certain table or query would be the way...

Nevermind...I got it! I just changed my report query to pull the customer name from the customer table and the name defaulted perfectly.

I have a database with several tables. All the tables are associated and related to each other by their CustomerID. My primary table has CustomerID information and CustomerName information included. I would like the CustomerName to default to each table so it will pull in on the reports I...

I have a report created and it works great! My problem is this...I would like to create a form that will allow a user to open the form, select a criteria (by range, date range, zone range, etc.) and then run the report. Can anyone help?

I have a database that is listed as a .mdb. I tried to click on tools, database utilities, and then make .mde and it says; "Unable to create .mde". Any thoughts? When I create a brand new database it creates perfectly.

Okay..I got my tables to have a one-to-many relationship. That's good. I'm looking for the differences in the forms now. I am definitely open to changing the original design, the only problem is that the majority of information is copied from another database.