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

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

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

Every time I open my query based form it creates a new record in the file so that the next time I open it I get a duplicate record error. Is there a property I can set in the form or the query to stop the creation of the new record.

I have created a form based on a query that is used to enter and update information about a specific groupd of records. The user uses a combox box, also on the form, to enter criteria for the query. Once a value is entered into the combo box I attempt to requery the form but I keep getting an...

There is a field on my table that allows the user to enter a text description that varyies in size. When I try to associate a text box control with this field on my form it is not being diaplyed to the user and I am not really sure why. Can I set up a text box to display several Lines? Is...

I have a form that is based on a query. The way the query has been designed it should display one or more records concerning a criteria entered by the user. How can I set the form up to navigate through all the records returned by the query? In other words when ran independently the query...

I have created a form used to enter data into a service log for PC repair. Once a pc users Id has been entered how do I use that Id to access a file not associated with my form in order to display information to the service personnel. What I am trying to do is find the users name in the...