| Thread | Last Post | Replies |
|
| Coding issue for a search | 15 Mar 2007 17:21 GMT | 4 |
I am working on a database to organize a set of books. Access generated the following code for a combo box to locate a record by it's title: Private Sub Combo127_AfterUpdate()
|
| adding a new record by code | 15 Mar 2007 16:13 GMT | 3 |
I'm using a form to enter data in several fields, such as the category, product name, price, & etc. Obviously the "category" field will have repeated values. I want to have a table, say named "Category", to collect all the different values of Category I entered. I'm thinking at ...
|
| Print form before closing... | 15 Mar 2007 16:11 GMT | 1 |
I have a form that I need the user to print before they close. The only way for them to close the form is by clicking the "X" button in the top right corner of the window. I have to code set up as:
|
| Do Got Focus and Lost Focus DO anything? | 15 Mar 2007 16:03 GMT | 3 |
I have been rather frustrated by the inability to cause a form that serves as a switchboard (my design, not the automated version) to do anything when I open another form on top of it. First I couldn't keep it maximized (not even with DoCmd.Maximize in the Load event, and DoCmd ...
|
| Add text to Memo field | 15 Mar 2007 15:58 GMT | 4 |
I have 2 check boxes. If you check the box the on lick event adds text to a memo field. This issue is the last box checked text overrights the first. How would I add the additional text without removing the first?
|
| Default Value to Currency | 15 Mar 2007 15:08 GMT | 2 |
I have this query that I'm using in the form. The two fields "Travel" & "Misc" is defined as currency but when I run the query it shows as blank. What I want to accomplish is to use this query as template to build the records with this two fields all showing zero dollar. so, ...
|
| Set date to Date and time picker | 15 Mar 2007 15:03 GMT | 1 |
I have access application with Date and time picker object inside. I can bound it to table. But i can't set value to it. I tried this Sub Form_Load()
|
| export subform data to a text box or to a file | 15 Mar 2007 13:43 GMT | 4 |
I have here a problem that is: I have a form called frmGames with a combo box called cmbGameType, so when i change the value of my cmbGameType, a sub form called subfrmGames, based in a query(qryGames) shows the correct data.
|
| How to open Microsoft Word documents from a Microsoft Access Form | 15 Mar 2007 13:24 GMT | 8 |
I have a Form (Sales Orders) which contains a Sales Order number field. The number in this field is used as the Delivery Note number when an item is Despatched to a Customer. E.g. Sales Order number = 123456, Delivery Note Number = 123456
|
| How to export filtered query results ONLY | 15 Mar 2007 11:02 GMT | 3 |
I have an unbound main form (frmSearchDatabase) with a number of criteria and a subform (fsubRecordSearch). The control source for the subform is a query (qrySearchDatabase). The criteria is used to filter the query. What I need to do is export the filtered results to Excel. I ...
|
| Find the closest Matched Record | 15 Mar 2007 03:24 GMT | 1 |
Wild card look up's. I want the user to be able to enter a number or part of a number and the system to find the first match or if it can't find a match to find the next one that is close. Can this be done. Below is my current code that works great if you have the
|
| Capturing keystrokes in textbox | 15 Mar 2007 02:22 GMT | 1 |
Is there any way I can capture the value being entered into a text box character by character as it is entered? The solution needs to take into account backspacing, the home key, the delete key etc. I'd rather not try to do this via Keypress event. I tried the On Change event but ...
|
| Set Value in a Subform using VBA | 14 Mar 2007 21:57 GMT | 1 |
I have a data entry form that contains a subform. The main form has a save button for saving information. The subform is used primarily for illustrative purposes, but contains a Yes/No Check Box.
|
| Run calculator from button | 14 Mar 2007 21:54 GMT | 2 |
is there any way to create a button in a form that automatically opens up the windows calculator?
|
| Code from 2003 no longer works on 2007 | 14 Mar 2007 17:31 GMT | 1 |
I barely know enough about Microsoft Access to get by and I created a program for work that keeps track of inventory and uses a visual basic code to pull up pictures in forms. This has always worked great on Access 2003 but since we upgraded to 2007 this no longer works. If ...
|