| Thread | Last Post | Replies |
|
| Default to current date | 05 Oct 2005 13:16 GMT | 5 |
I have an "Account Receivable" form that is filtered based on the customer's unique ID. I've added a "SetValue" statement in the macro to add the current date on the "Payment Received" field when I open the "Account Receivable" form. This works fine on the first record that ...
|
| Form Scalling up and down the page HELP HELP HELP | 05 Oct 2005 12:26 GMT | 4 |
I have a form that has several subforms on it. As the user enters data the cursor movements are fine UNTIL the bottom of the current screen size is reached. The cursor continues to move from field to field properly however the user can not see this. They have to use the ...
|
| Print to PDF file | 05 Oct 2005 12:20 GMT | 2 |
I am ussing Access 2003, and have Adobe Standard 6.0 installed. I can use the File - Print - select the printer "Adobe PDF" - Selected Records - (then add file name and location) to save and "print" a form Adobe PDF is the vertual printer name installed by Adobe.
|
| Time Expired on a Service Record to Calculate SLA | 05 Oct 2005 10:10 GMT | 7 |
I am trying to calculate the time a service record falls outside an SLA. I have the following fields in my form; Call Opened (Time field) Call Closed (Time Field)
|
| allow additions problem with subform field | 05 Oct 2005 09:20 GMT | 2 |
I have a continuous subfrom on a main form. This subform is is set not to allow additions. A button on the main form then allows additions on the subform. On this subform is a single field with an input mask >AAAAAAAA (ie 8
|
| Can I Edit or Add the form which the data source is from two linke | 05 Oct 2005 07:48 GMT | 1 |
Hi: I have a form, the data is from two linked table (using primary key and foreign key), it is very good for me the navigate those record, but I find I can't edit or add new data through this form.
|
| Property window popping up | 05 Oct 2005 01:33 GMT | 1 |
I recently upgraded from 97 to A2k3. Sometimes when I open a form in form view (not design view) the property window opens. I don't want my users seeing this box ever. Why is it doing this and is there a way to prevent it from happening.
|
| how can i make a master table that connects to all of the forms? | 04 Oct 2005 22:45 GMT | 1 |
I am making a database, and i would like to know if there is a way to make a master table that connects to all of the forms. I need to enter many names everyday and it takes really long when i have to enter the same names and addresses into 7 different forms, if there is a way ...
|
| Error Message Link is Broken | 04 Oct 2005 22:27 GMT | 4 |
When the access database is open I have it open to a certain form. On my computer it works fine and opens to with that specific form. When others try to open the database they get an error message saying the link is broken. Is this a database problem or an Access problem? If ...
|
| Sharing with non-access users | 04 Oct 2005 22:23 GMT | 5 |
I have a form used for data entry that I want to share with others in our office. I also want to allow them to run reports off my main table. What is the easiest, most effecient way to share my database with non-access users?
|
| Keyboard shortcuts | 04 Oct 2005 22:22 GMT | 1 |
As I was tying in a form field, I inadvertently touched keys that automatically opened my address book in Outlook. I thought this was great, since I wanted to copy the field information into my Outlook Address book. I cannot retrace my steps and find the keys I pressed to get ...
|
| Better Way to Code this? | 04 Oct 2005 21:53 GMT | 4 |
I'm using this code that works. Is there a better way to do this? It checks 3 Listboxes and then acts accordingly. Thanks DS
|
| Flip control between bound and unbound | 04 Oct 2005 21:17 GMT | 2 |
Access 2003. Looking for possibility to use VBA code to flip a control between a bound and unbound control depending upon certain conditions. I know opening a form in AddNew mode can change a control from display to data entry, which is my objective, but I want to work around ...
|
| Validate data | 04 Oct 2005 20:58 GMT | 9 |
I have created a form for a user to enter data. Once they type in all the information for a record, they click an 'Add Record' button which saves the record and moves the user to a blank, new record. I'm writing this in VBA. The fields that determine a duplicate record are ...
|
| Showing more than 30 days (format "dd") | 04 Oct 2005 20:58 GMT | 7 |
I want to return a number indicating total days and hours between 2 date/time entries which were created using the Now() function. The resulting number may be something like 77.25. How do I format that result in a form textbox to show "77 days, 6 hrs"? According to the help file, ...
|