On my form I have a DatePicker that allows the user to select a date. The combo box also allows for manual entry. Once the user enters/selects a date, I would like to verify that it is the m...
make add / subtract box work for active task
I need to add and subtract time for active tasks based minutes +/- placed in the box at the top right of frmAddTask.
I have a button on my main form that opens another form that contains comments associated with records in the main form. The RecordNum from the main form is selected from a list box, which is ...
How do I create a form that will save data entered to a table only when user clicks save button. So if user clicks "clear form" (need code) or exits the form, nothing is saved. If click on "...
I want to print the form on the Bank Cheque for that i need only data to be printed on the cheque not the label of the data and not even the database control and command button can anybody has...
There is a table in my database that contains information on clients (tblClients). Two fields in the table - ClientName and ClientID - are indexed, no dups allowed. The client name is the firs...
I have a checkbox in a subform which is bound to a Yes/No field, What I would like to do is create a hyperlink if the field contains a yes otherwise if no just display plain text to the user. ...
Access 2003
In the Northwind.mdb database, there is an "Orders" form, and this form has a "Orders Subform"
within it. In the "Orders Subform", there is a field named "OrderSubtotal", and t...
Greetings,
I am trying to fill in a subform by using a combobox for the lookup, and a command button to add the selected item in the combobox to the subform. The first item I select gets add...
In an Access 2003 db, and in the command button that opens a Form, I need to filter the Records for that Form.
I am using Access 2007 as a project (.adp) front end to an SQL Server 2005 Express database.
On an Access Form for a customer order, I have a "combo box" control to fill out a credit card fie...
When I create a command button on one form and ask to display specific data on the other form (button is created via wizard), it does not work. It always displays all records, even and althou...
Hi Everyone,
I have a problem that I'm not 100% sure what is the best way to code.
I have an entry form that could have a dynamic number of media entries. I.e. a subform that will build...
Experts, I seem to have developed an error after adding the me.usage part to the On Current event of the form:
It has worked find without any errors until I added the Me.usage line. The erro...
I have an unbound control [AssignSentDate] in the header of a form.CheckScanTrack.
I need the value of [AssignSentDate] to populate the bound control [Sent] in the continuous form when the un...
On 09/30/2008 I asked for this question I have taken a access 2003 database and moved it into access 2007. By doing this my requery button on my form does not work. What I am trying to do i...
In Access I have a form that is filled with a query. Only one record shows. I can move to another record by using me.dynaset.movenext.
Though I can move to another record, I cannot figu...
On our client database, we'd like to add a column that is automatically populated with date & time when that record changed. How can we do that? I have already created a column and called it '...
Hey Experts,
I just can't figure this out. I want to create a drop down menu for medications on a form and have the corresponding nutritional implication pop up. Here is what I have (it's ...
All examples ive seen show append or update queries which are based on record by record append/update.
I have a table with a lots of records, and if they fail to ALL append or update respecte...
I have a sub form which shows a data table of information regarding a certain batches of files. I would like to be able to double click on one of the batch dates to open a new form showing the...
I'm running Access 2003 with about 15 users. The database is on a server where 14 users are located but I have 1 user that works at home and her connection is slower than the people at the of...
I have a form with a field ClassAge. Currently, I am using a Validation Rule >13 and <=18. The problem is that on the rare occasion, an age may be a bit more or less than the validation. Th...
I am modifying an existing Access 2003 mdb application. I have a form that will appear to the user. This form is bound to a table. When the form appears to a user, it will show one or more of ...
How would you display an OLEObject from Access 2007 into an Access generated report? The documents that are being stores as OLEObjects are WordPad Documents and Images. So, what would be the b...
