| Thread | Last Post | Replies |
|
| remove filter on a form when closing | 26 Sep 2007 19:41 GMT | 2 |
I have form "frmRecipes" that can be called from two different places: from a button on a form named "frmUserRecipes" and from a button on the main switchboard. From "frmUserRecipes" I use this code to take me to a specific record:
|
| Times Addition | 26 Sep 2007 19:25 GMT | 2 |
I need to know how to add 3 times : 8:00+2:00+3:00=13:00 Thanks
|
| single table or multiple tables? | 26 Sep 2007 19:14 GMT | 3 |
I’m creating a new access 2007 database, my question is simple. From a functionality standpoint and taking database size into consideration. Is it better to have one table with repeating field values or setup a second table to hold these values using a lookup.
|
| Adding a link to a form...is it possible? | 26 Sep 2007 18:24 GMT | 12 |
We are creating a database for our special programs. I have a from setup, however, we want to add a button that, when pushed, will pop up the actual document. Is there a way to do this?
|
| Converting Hours in decimal format to Hours and minutes (short time) | 26 Sep 2007 17:42 GMT | 2 |
I want to find the elappsed time betwin StartTime and EndTime which are in a table. I can get the answer in a Form using the startTime and endTime with ' =([EndTime*1]-[StartTime]*24)', but the answer to that function naturally is in decimal hours. e.g. StartTime is 08:00,
|
| Run a "macro" in a module | 26 Sep 2007 16:47 GMT | 1 |
I wrote some code in "Module1" in the Modules tab in access. Here is what I wrote Option Compare Database Sub SetOff()
|
| Turn off prompts that alert | 26 Sep 2007 16:26 GMT | 2 |
I have a Macro in the "Macro" tab in acess that runs 3 queries. When I run the macro it asks "Do you want to delete Table XYZ" and "You are about to add XYZ rows to table". How do I turn off these prompts, because if they were off the macro would
|
| New User - simple expression | 26 Sep 2007 16:26 GMT | 1 |
Need to only have items that begin with "Pa" to show up in my query. Can someone tell me how? Thank you.
|
| Disabling fields with focus | 26 Sep 2007 16:18 GMT | 4 |
I have a form with several subforms on it. When the main form's record is in a certain state, I disable the various fields on the form and subform. However, since the subforms get focus as well as the main form, when I go to disable them I get an error saying you can't disable the ...
|
| Query DOBs for those in a specific Month | 26 Sep 2007 16:18 GMT | 1 |
Hello, I have a column in a table for Date of Birth ( DD-MM-YY). Is there a way to have a user inout a month and query for the birthdays within that month?
|
| Combining Tables | 26 Sep 2007 16:16 GMT | 5 |
Is there an easy way to combine multiple tables into one single table?
|
| Relationship or Join | 26 Sep 2007 16:14 GMT | 5 |
Why would someone use a relationship instead of a join (left or right)? I'm trying to grasp relationships better. Thanks!!!
|
| Access 2003 Mail Merge to Word 2003 using query to locate the specific record being displayed | 26 Sep 2007 16:14 GMT | 8 |
After spending ALL DAY searching the entire WEB I have found a lot of posts asking this same question but not one answer. I thought I's throw it up again. The button on my form does this. * From Mergit() *
|
| Access Relationships | 26 Sep 2007 15:46 GMT | 16 |
Could someone please show me to correct way to create a relationship in Access. Everytime I create a relationship I get error messages
|
| Hyperlink field display | 26 Sep 2007 15:16 GMT | 1 |
Hi. I have a table that has two fields: 1) "School name" (text field) and "School Web Site" (hyperlink field). I would like to create a query that would display the value in the "School Name" field but link to the URL defined in the "School Web Site" field. I am using Access ...
|