In MS Access how can I stop the user from losing focus on a text box if a condition is not met. For example if the box isnull I want a message box to appear and the user still be in the text b...
I have a form where the user enters multiple records and since some fields in each record often repeat they asked for a duplicate button. That part works. However, now they'd like it to auto...
Dear expert!
I am stumped on this one - I have a continuous form, and users happily use the right-click on a given field to sort Asc/Desc on that field.
However, there is a combo box on ...
I use the attached code snippet to change field names and, optionally, to change the field's description. How can I modify the code below to optionally change the field's data type too? Assu...
Hello, experts - I would love your assistance here:
I have a form that needs to (1) be editable, and (2) be filterable by a field that is not in the edited table itself. Is there any way t...
Hello,
I am trying to integrate a mail merge function with Acces 2007. I want my users to be able to narrow the list of contacts that will recieve an email by filtering fields on a form. O...
I have a form that uses two combo boxes to seelct criteria for a query. Then in a subform I use the query in a combo box to make a third selection. However, whenever I make my first two sele...
I've got tabs ("pages") that have data and/or subforms on them. All of them work great. Except when I want a subform to show up in datasheet view. I need them to show up that way. But when...
I want to a have a GUI in access that will have different buttons that will connect to different forms within the same .mdb. How might I go about doing this
Greetings,
I have a form that contains a subform. The form is generated by a query that pulls from several tables along with equations. This works great and the form and subform works fin...
I have a form with a text box control.
The textbox controlsource property is =MyColumn
The form recordsource is not set in design mode.
The form load event sets the form.recordset to a cr...
Hi Experts,
I have a table with several fields that need to be limited with how many places can fall to the right of the decimal. For instance, one field can have four (3.8969) and one fie...
Hi,
I have designed a db in access that uses 2 popup split forms. I am having problems getting the popup split forms to keep their size properly. They seem to resize themselves at will. Even...
I have a Microsoft Access 2003 database.
There is a table Customer that contains a field CustomerName that has data type=Text. In the table definition, the Format value for that field=> (d...
Can't figure this one out...on subforms it defaults to show a header & footer section. But with regular forms, I don't see how to do this. I see where you can go to "view-->page header/foote...
This is the code I was trying to use but it says I cannot disable a control while in focus. Any suggestions to diable that one control on a form with multiple controls?
For some reason for the life of me I can't find how to change the background color of tabs ("pages"). I'm not worried about the color of the actual "tab" controls, but of the contents. It's ...
tblOFInvDetail
OFInvDetailID Auto Key
OfInvDetail
Company Code
tblOFInventory
OFInventoryID Auto Key
OFInvTypeId Not required
OFInvDetailID Numeric key from...
Hi,
I have form which has a list box on which lists all customers in the tbl_contacts table. What i'm trying to do is allow a user to double click one of the customers in the lb and have a...
Hi Again,
I am trying to append a unique invoice number into my an existing table. I have a tbl_InvoiceNumber and tbl_OrdersPlaced. I want the first order to start with the number in my t...
I have a SQL Server Express 2005 database and a Access 2003 application that connects to it. I have a text box that is suppose to handle a text field of 50 chars in length. However, the box is...
Could anyone explain to me if it is possible to set a default form size when a form is opened upon startup. Right now, I have a form that appears upon startup, but it is very wide and takes u...
This database (attached) records how long a particular task has been 'active' and is indicated by the check mark in the frmTasks 'active' check box. Notice though in the screenshot (also atta...
I have a list box whose recordset has been set to an ADODB.Recordset
What is the syntax or code for clearing the listbox items ?
Thanks,
Hello,
Is there a way to have a subform show in datasheet view, while still showing its header and footer?
