Search results

I have two textbox controls on my report used to display calculated values. One control displayes the value with a single decimal point and does not round. The second textbox rounds the number up and does not display the decimal portion. Both boxes appear to have their properities set the...

Is there a way to monitor the printing of a control depending on weather or not it contains a value. I am printing a users address using two address lines, if the second address line is blank then I do not want to print it. Is there a way I can prevent it from being printed so that there is...

I have developed a form that is bound to a table utilizing a combobox to select a record to examine. Everytime I select a new reord to examine with the combo box I am unable to view the record I have selected. I tried using an openform command in the afterupdate event but I get a message that...

Where shouls I type this command.

I have a database application that is ready to distribute to the users but I have been unable to stop the access window from being displayed. I have unchecked the display database window box in the startup option but the window itself is still displayed. How can I stop the database window from...

I have created an access application for use around the office. Everyone currently has a licensed copy of Office XP on their PC and I would like to place my application on the server so that all users can use the application. I does not appear that the deployment wizard is available with XP...

I have included a not in list event associated with a combo box on my form and have included a message as part of the event. When ever my message is dispalyed and answered the system message box appears telling the user that the item they entered is not on the list. Is there a way I can turn...

Are there events associated with the use of a navigation button. I have a form and when the users uses a navigation button to enter a new record I would like to update a field on the file. I have looked through several books and have been unable to find much regarding the use or custmazation...

I have created a system that is used by our service department and would like to deploy this system over the network without the database window being displayed. I went to startup and unchecked the boixed for display database window but that didnot seem to make a difference. Wihtout purchasing...

I changed my form so that is is unbound and have tried to run the parameter query after the user selects a customer from a combo box on the form, but I still cannot get the correct data to show on the form. Once the user has selected a customer I use the on change event for the combo box to use...

I have a form based on a parameter query that that uses several fields on the form; entered by the user, to provide the required information. Every time I open the form it ask for the parameter before the form is opened. How can I get around this so that the form will open and allow the user...

I am developing a form based on a query that joins two tables to display service call information. The customer requesting service is selected from a combo box and then their service records are displayed. If the customer has never requested service the previous customers service records are...

I have a form used to enter service information. If the user enters a customer that does not exist on the customer file a second from opens allowing them to enter necessary customer information such as the address. After they have entered the required customer information the form is closed...

Is there a way I can get rid of the access window. I have developed several applications for use in house and while its not a big problem I would like the only thing the users see is the forms and repots I've put together. Basically I would like the user to select the icon and see my switchboard.

I am trying to open a report from a form. The report is based on a query that uses several fields from the form as criteria. I am having trouble using the openreport method using multiple fields from the form. I keep getting an error that tells me my expression is to complex. The expresion I...

I have a query used as the record source for a report. This report is called from a form, the query using a field from the form as a parameter. I am now developing another report that is called from another form that would use the same information as a subreport and would like to use the...

Changed the criteria as you suggested and also changed the event to perfrom a requery with the structure you suggested but I still have no results. When I ran it through debug the requery action is perfromed without error but I still have no records to look at. With my test data I should have...

I had a feeling that might be my problem but after making the change I am having some problems getting the form to perfrom the requery and display my information. The criteria on my form is structured as follows: forms!frmOrders!cboCustomer.Text This structure seems to work when I...

I have a form that uses a query as the record source. This query is a parameterized select query that uses two tables. Table no 1 is used to display order information and can be written to or updated; the form is used for entering/updating orders. Table no 2 is used to obtain the customer name...

I'm not sure? The user selects an item from a combo box that is also on the form. The value they selected is moved to a textbox that is a parameter for the query the form is based on. The form is they requeryed to use the records the user selected and it is after the requery has been perfromed...