- Forms Programming

Thread preview

Thread	Last Post	Replies

changing Unbound combo box to bound combo box	04 Apr 2006 03:22 GMT	2
I have 3 tables that are linked. Category Table: Category ID (primary key) -autonumber Category Name
Extracting records based on date in control on form	04 Apr 2006 02:24 GMT	4
I am trying to create a recordset using a date held in a control on the form to which the event procedure applies. In essence, the code is: Select * From Issues Where Issues.LastUpdate = Forms!IssueStatus!CurrentDate
Running SQL to update field in a second table	04 Apr 2006 02:03 GMT	10
I want to update a table with the max-value from another table. How do I combine the 2 sql-statements? sqlMaxBookingID = _ "SELECT Max(tblBooking.BookingID) AS MaxOfBookingID " & _
DATABASE CURRENCY FIELD	04 Apr 2006 01:38 GMT	3
We use a program a work that enters all of our information on billing clients into a database. You choose a service and the fee is automatically entered into the field according to the service. Most of our fees end with .50. Such as $3.50. When we choose the service, the
msgbox for page	04 Apr 2006 01:12 GMT	2
I have a tab control with subforms on each page. I want a msgbox to pop up when the user clicks on a certain tab. Once only would be the best. Any clues ? Rohan.
How to require and check for two digits.	03 Apr 2006 23:50 GMT	10
I have a textbox that I have set an Input mask of 00;;_ for a two digit station number. I check the range of the entry to ensure it is between 1 and 99, but I want to display my own error message when the user only enters 1 of the required 2
Breaking Up Text (Numbers)	03 Apr 2006 23:01 GMT	3
I'm a bit stuck with this one... I have a field in which I type three sets of numbers in the format 43601-078-00038, and the input mask I use defies logic - but works! The input mask is:
Openform "where" problem	03 Apr 2006 22:49 GMT	2
I am opening a form in either data entry mode or a filtered view, using docmd.openform to set the mode and filter. Dim stName As String Dim lchoice As Long
Printing reports	03 Apr 2006 22:11 GMT	2
Using MS Access 2003 on Windows XP Opening report with DoCmd.OpenReport syntax This always prints to my default printer (as set in Windows). How do I open the printer dialog to allow the user to print to a specified printer?
open record set with sql	03 Apr 2006 21:57 GMT	1
stPlanID = Me!agtplan stTest = "[PlanID] = " & stPlanID & "" this works: rst.Open "SELECT * FROM tblAgtSplits WHERE ([PlanID] = 8)",_
Switchboard page reference	03 Apr 2006 21:03 GMT	2
I am developing a log on routine that requires me to reference a specific switchboard page if a password is entered correctly. i.e. the main switcboard then opens a page. How can I reference this specific page? The openform method is clearly no use as it sees the
Hide the Next Button	03 Apr 2006 21:00 GMT	9
How can I hide the Next and Previous buttons when there are no Next and Previous records? Signature Message posted via AccessMonster.com
Property ControlSource	03 Apr 2006 20:52 GMT	7
I have a combo box that displays Tariff information. I have 4 fields on this particular form, EDLITariff1NumberID, EDLITariff2NumberID, EDLITariff3NumberID, EDLITariff4NumberID. Based on which tariff number they are on, when the user clicks on the combo box, I
Default value for combobox on continuous subform ARRG!	03 Apr 2006 20:50 GMT	3
Hi gang, Banging my head on the wall with this one: I have a main form 'formadmintestmain' which has a continuous subform 'formadmintestpage1' on it. On this subform is a combobox (Combo55) that
Major ADO error between Excel and Access?	03 Apr 2006 20:26 GMT	4
I've been looking at this all day and I'm about ready to scream. I have a form in Excel 2003 that pulls data from Access 2003. I'm using ADO and can connect to the database, no problem. The problem is the data fetch is WRONG. (Like "buggy" wrong):