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...

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...

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...

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...

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...

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.

I have a database that contains 9 subforms. The main form is called, "Customer Information". This form is linked to the tbl_Customer. Two of the columns in this table are Customer ID and Customer Name. When I open the "Customer Information" form and select a customer...

I have created a database that will be used by four workstations in my companies home office and four copies loaded on laptops out in the field. Once a week I need to have the four laptops out in the field to download their database information without causing any damage to the version...

I have a database that contains a "Cutomer" table. This table contains several columns. Two of which,are "RCustomerID" & "CustomerName". I use these columns repeatedly through out several tables. My problem is this...When I enter a record into one of my tables...

I created an e-mail field in my database. I set the format of "Is Hyperlink" to "Yes". My problem is that when I enter an e-mail in the field it tries to send me to an http. I would like Outlook to execute on this field everytime it is clicked and I would like whatever...

I've created a hyperlinked field for an e-mail address in my database. I would like to click this link and execute Outlook. So far I have been able to do this. However, I can not get the e-mail address to default in the mail to field. I don't want to designate one address only to default...