| Thread | Last Post | Replies |
|
| Using arrays in reports and forms | 02 Jun 2005 11:24 GMT | 1 |
We have an application that displays some complex data stored in several arrays. The arrays are displayed in three activeX list controls. We would like to put the data into reports without dumping them into tables. Is there some way to put the data from the arrays on a report?
|
| Help needed with form (little or no experience) | 02 Jun 2005 07:41 GMT | 9 |
Hi I have a table called clients these are clients of an insurance brokerage, the brokerage has no control over the format of the reference applied to each client. these take the form of the first two letters of surname followed by
|
| Calculating week end date - always a Monday | 02 Jun 2005 06:51 GMT | 2 |
Is there a way to have Access fill a field with a date that is calculated to the following Monday of the date entered? for example. I type in 06/01/05, then access calculates and replaces that date with 06/01/05, the Monday FOLLOWING that date.
|
| open form at key value but not filtered | 02 Jun 2005 03:37 GMT | 1 |
i'd like to toggle between two forms and keep them in sync via a shared key field. both use the same table. using link criteria applies a filter that i don't need.
|
| DCount Expression Help Needed | 02 Jun 2005 03:00 GMT | 2 |
I have my main for named TimeCards and on it is a sub-form named Time and Hours On the main for there is a control named Rate which shows the customers rate On the sub-form there is a control named EmployeeID which looks up the
|
| Resizing Popup/Modal forms | 02 Jun 2005 00:35 GMT | 3 |
I created a data netry popup/modal form but I am having dfficulty making it the exact size I want. I have opened it in form view, resized it the way I want it, then show it in design view and then changed the border style to Thin; then saved it. The
|
| Command Line Switch | 01 Jun 2005 23:11 GMT | 7 |
Is there a switch command to open a word template in print preview. Dim objectWord As Object Set objectWord = CreateObject("Word.Application") objectWord.Documents.Open "C:\Database\Documents\Sample Template.dot /?"
|
| Option Groups | 01 Jun 2005 22:44 GMT | 1 |
I'm still having problems with my option group the check box is blank. The following is my code. Please help!!! Thank you!!! Private Sub PendingandClosed_AfterUpdate()
|
| Enter a date in a drop down box | 01 Jun 2005 22:39 GMT | 1 |
I'm working in Access 2002. I am building a form that requires the input of an activity date - the date can be something other than the current date. I'd like to set this up so when the user clicks on the arrow for the drop down box, a calendar pops up and he/she can select the ...
|
| Barcode reader | 01 Jun 2005 22:29 GMT | 1 |
I've created a main/subform (order and orderdetail). In de orderdetail i enter the productID by scanning the barcode on the products. The situation now is that the reading of the barcode goes well, the focus
|
| Subform popup window | 01 Jun 2005 20:52 GMT | 5 |
I'm familiar with using subforms on a main form and using a command button to open another separate form. How can I open a subform using a command button and still keep it linked? Is there a wizard for this in 2003? Thanks in advance.
|
| inputing data into text boxes is disappearing | 01 Jun 2005 20:31 GMT | 1 |
I have a Sub -form that is linked to the main form by the fields that are the same in the main form. If I enter information into the text boxes that are not linked to the main form, the data gets placed in the table, however it disappears from the text box on the form. Why is ...
|
| Form_Current() Event | 01 Jun 2005 19:52 GMT | 4 |
I have a form with code in the Form_Current() event. When I open the form I'm using where condition that only returns one record like this: doCmd.OpenForm "formname", , ,"[ID] = Forms![formwithlistbox]![lstID]" When users use the Scroll Wheel on the mouse I get 'Error Number 3021 ...
|
| Pop up Subform | 01 Jun 2005 19:22 GMT | 2 |
I am running out of room on my main for (general information about a donor) and need more space for telephone numbers. I don't know how many I telephone numbers the donor will have.
|
| Automatically add data from one table to another table | 01 Jun 2005 19:19 GMT | 5 |
I have created a database in Acess 2003 with all information related to our company's projects. In the main table, I have a column for "Clients" and a column for "Consultants." I have created a table for "Clients" and a table for "Consultants" each table including the contact ...
|