| Thread | Last Post | Replies |
|
| Quote combo box entry in message box | 04 Jul 2005 20:14 GMT | 1 |
I have some simple code that produces a message box to warn the user of the ramifications of what he is about to do with data from a cbo selection. Is there a way to quote the cboBox data in the MsgBox? Many thanx,
|
| DAO in Access Data Project | 04 Jul 2005 18:38 GMT | 10 |
Does DAO not work in Access Data projects? God Bless, Mark A. Sam
|
| Rounding Time | 04 Jul 2005 18:23 GMT | 5 |
I would like to round the time to the nearest quarter hour. Example: round 01:08 PM to 01:15 PM, round 01:07 PM to 01:00 PM.
 Signature Thanx!
|
| Visible | 04 Jul 2005 18:08 GMT | 4 |
Hi. I'd like to set up my form so that if Ongoing = yes, certain fields are grayed out. For example, if Ongoing = no, I'd like the user to be able to enter the [Date], but have the [StartDate] grayed out (not available for entry).
|
| transferdatabase error | 04 Jul 2005 16:55 GMT | 2 |
I am using the following code to transfer database objects to a new database. When the first DoCmd.TransferDatabase line is run, I get a run-time error 3024 saying that the file can't be found. The file is there so I'm not sure what is happening. Also, although I check that ...
|
| database prevented from being opened or locked | 04 Jul 2005 15:05 GMT | 1 |
I am testing a routine in ms access 2000 that will post to a database table information on a form. There is a line of instruction in the routine I created that opens the connection like that: dim cnn as adodb.connection
|
| Copy/paste a phone number | 04 Jul 2005 12:28 GMT | 1 |
I have 2 forms : Argumentaire form and Client form. When the user enters the phone number in the Argumentaire's form, I'd like to copy the phone number field already entered in Argumentaire form, and paste in the phone number field in client form(after he pushs a button in ...
|
| form wont disappear when it has lost focus | 04 Jul 2005 11:19 GMT | 3 |
Hello everyone, Im working on a database for a company that does student accomodation and to take care of the multitude of different things that can be paid ive used a main ReceiptForm from which you can select what you are paying for and it
|
| Null Value | 04 Jul 2005 07:34 GMT | 3 |
I have code in a combobox AfterUpdate that I want to update a yes/no field if the user enters certain values in the Diagnoses field. The problem I am having is if the user makes a mistake and deletes the value He/She chose in the combobox creating a null value, I get an error ...
|
| User-supplied filename for TransferSpreadsheet option | 04 Jul 2005 04:16 GMT | 6 |
What is the code for a user to specify the path and filename that will be imported into Access from an Excel spreadsheet using the TransferSpreadsheet method? Example:
|
| Labels Question | 04 Jul 2005 04:09 GMT | 3 |
Using VB, how can I change the text in a label that's linked to a control? The label name is: lblAddItem -Simon
|
| Opening a Word Document from Access | 04 Jul 2005 00:39 GMT | 2 |
I am trying to Open a Word Document from an Access form "User Documentation" I get an Automation Error. I am using Access 2000 for testing. However, it will be installed using Access 97. Could some one please help: Private Sub Command0_Click()
|
| Coding Problem in Combo Box | 04 Jul 2005 00:04 GMT | 7 |
I have 2 cascading combo boxes. Thr first calls all 50 states in the US.(I am using States as the parent combo box instead of Zipcodes as many do because I need to break down my zipcodes into maneable numbers. There are 47,000 of them) The Second is "Supposed" to called the call ...
|
| form header/footer | 03 Jul 2005 23:52 GMT | 4 |
Is there a way to turn the Header/footer from a form on and off using VBA code? thanks Steve
|
| Multiple assignment of selected record | 03 Jul 2005 22:26 GMT | 3 |
I have a Form (bounds to a junction table) which has txtbox1 and txtbox2. Attached is a subform which has a txtbox1sub (related to txtbox1 of the Main Form) txtbox2sub , txtboxA and txtboxB. I have a command button in the Main Form that assign value(SETVALUE) to txtbox2 which is ...
|