Search results for query: *

I have searched in the forums and the FAQ's for this answer and can't seem to find what I need so if I've missed something, my apologies. I have the code to calculate age using a date of birth. I want to display it on a report in a textbox named txtage. The report uses a query as it's record...

I have a main form and a subform. The main form has a SAVE command button as I do not allow automatic updates on it. But, when I tab or click in the subform, any changes that I made to the main form are automatically saved. I tried to handle this by putting some code in an event that would be...

I have an application in Access 2003 with several input forms and a report run from a form after the user inputs a date. I created toolbars for the forms and the report page. Examples of names for the toolbars that I use are MainForm Toolbar, History Toolbar, and Report Toolbar. The MainForm...

Hello, I have an unbound OleObj (object frame) in a form that I link to a Word Document. The Word Document is several pages long. I can only get the first page of the document to display. I have changed the size mode to Zoom and experimented with some of the other properties but can't seem...

I have an Access report with a calculated field called txtrptage. It is calculated using the DateDiff function in the Control Source property of txtrptage. If it calculates to a number less than zero, I want it to display **** instead of the negative number. I put the following code in the...

Hi all, I'm hoping someone out there can help as I have been reading all morning so now I need some advice. I have a table where I have defined the primary key as a combination of 2 fields in one table -- the year and a container number(contno). The table holds 4 years of data. A container...

Hi all. Is there a way to make the cursor automatically go to the next field when using an Access form to enter data? In other words, if I am entereing data into a field with a length of 3 and I enter 3 characters, how do I make it go the next field in the tab order without pressing enter or...

In the Before Update property of my form, I am using With and For Each along with Case and a value in the Tag property to validate all of the required fields on my form. I've got it working to display the control name/field name in the error message by using the Name property. This displays...

I have a primary key in a table comprised of 2 fields. Fld1 by itself can be a duplicate and Fld2 by itself can be a duplicate but together they must be unique. Fld1 must have a value entered but Fld2 does not always need a value entered. Is this possible? I can't seem to get it to work. I...

Please help me on this. I am sooooo frustrated. I have a form bound to a Date/Time field in my table with a format of Short Date with no input mask. I want the date to be stored and displayed as mm/dd/yyyy. The date field is also part of the primary key on the table along with another text...

Forgive me if this question is a repeat. I have spent the last several hours searching FAQ's and posts but still have some questions. I am learning Access and VBA. I have a form with bound controls for user input. I am using VBA to do validation and want to return an error message to the...

I have a date/time field in my table called haziddate. I define the format in the table as dd/mm/yyyy which is how I want it to display to the user. I was having trouble when I defined an input mask so I removed it but I would like to use one to make it more user-friendly. I want the user to...

I am new to this but am struggling along. I have 2 questions. I use a Main Menu form instead of a switchboard to navigate through my database. The Main Menu from has a button to go to another form for database maintenance. The Database Maintenance form has command buttons for Find, Add...

I am trying to secure my Access 2003 database (test.mdb). I have done all of the steps of adding a new administrative user (MyAdminsUser) and adding it to the Admin group, assigning a password to the Admin user, and using the Security Wizard to create a new workgroup file. Through the wizard...

I am learning Access so if you can help me, please give me some details. I have recently taken 4 different level classes in Access and am now working on my first database. I am converting INFORMIX databases to Access. Currently in INFORMIX, the users are able to query using a form. They can...

I am learning Access and am designing an application for users to search, add, update, or delete their data. I used the Form Wizard to create the form for data entry. I am reading for help and during my reading I read -- If you are creating a form meant for data entry for the...

We are trying to use Migration Workbench with INFORMIX-SE 7.3 but it seems that it is only compatible with INFORMIX Dynamic Server? Can it be used with SE? If so, what do we have to do to make it compatible with SE? Thanks.

Can INFORMIX-SE (as opposed to INFORMIX Dynamic Server) be used with ORACLE Migration Workbench?

I'm new at Access and trying to set up a relationship between two tables using referential integrity. The two tables are related by the column stockno where the 2nd table should not have any stockno that is not in the 1st table. The data was loaded from a UNIX box where this wasn't enforced...

Could someone please read the thread that I posted on May 29 about trying to create a stored procedure in INFORMIX-SE? I really need some help on this one. Thanks.