| Thread | Last Post | Replies |
|
| Adding textbox in Forms | 16 Jul 2007 17:35 GMT | 1 |
How can I add via code a textbox in my form? And the new textox is a unbound form? How can I vincule it with a field in my table? Thanks.
|
| how to add a column to an existing record? | 16 Jul 2007 17:06 GMT | 4 |
I've made a union query and I want to add now a column to this query Beside I want it to get the table name beside each record because these records belongs to different tables as I said in the begining it's a union query.
|
| Go to Record | 16 Jul 2007 17:00 GMT | 2 |
I want to go to a record by double clicking a field with that record in it. I have a form which has a self join on it called 'Link'. This is a combo box field that contains a drop down box of the other events in that table. When events are linked, it is selected by the user. I ...
|
| how to get the table name in a query? | 16 Jul 2007 16:47 GMT | 1 |
I want a query that can get me the table name that I'm querying on it can I do this?
|
| Date Calculations | 16 Jul 2007 16:16 GMT | 1 |
I have a shipdate field and want to run a query on dates that are 30 days or more from shipdate to today's date. Can anyone help?
|
| Remove a filter | 16 Jul 2007 16:02 GMT | 1 |
A table was opened and a filter used on the table and upon exiting Access asked if the design change was to be saved and mistakingly I hit yes. Now when I open the table it is always limited to the filter. How can I remove/undo this? Thanks.
|
| New record does not update all subforms | 16 Jul 2007 15:52 GMT | 5 |
I am new to Access and this is my first post. I have created what should be a relatively straight-forward database, but one thing is eluding me. I have thought about what I want to accomplish and have set up my tables/forms in the following way that
|
| I want to send a report to everyone at one address... | 16 Jul 2007 15:28 GMT | 2 |
I want to send one letter to the client address and list the Beneficiaries for that address. Each Beneficiary is attached to its own Client record. that is how the data was imported.
|
| Trying to create a interest rate tracker for a mortgage co. in acc | 16 Jul 2007 15:16 GMT | 3 |
I am currently working on a new project at work and want to do it in access. I currently have a table with the consumers information and i was wondering how to set up something to alert the user when a certian number appears in my "targeted rate" column. It could be a flash to ...
|
| Control Field Validation | 16 Jul 2007 15:13 GMT | 7 |
I am trying to put some VB code in as a form of validation on an Access form. What I am looking for is essentially the ability to check 5 different controls for data contained within. The controls are for dates that are tied to a table that records the training completion dates ...
|
| Getting Started with a Membership database | 16 Jul 2007 14:49 GMT | 11 |
Access newbie here. We've got a calligraphy organization with app. 450 members. All the data (for the last several decades) is living in a handwritten, spiral-bound notebook, about 6 inches thick <g> We figure its time to get a grip on things and get our membership data into
|
| Can I use a colon in the text of a query column heading? | 16 Jul 2007 14:38 GMT | 1 |
Can I, and if so, then how, have a colon in the text of a column heading, in a query? I now have the following USE: Sum of usg_mins
|
| Exporting qry to DBF and changing the formating of the number columns | 16 Jul 2007 14:04 GMT | 1 |
I'm exporting a query to DBF IV. And it works fine, except that it makes every number column 5 decimals. I need all of them to have zero decimal places, except for two columns that i need to be 4 decimals. Is there any way of specifying this during the export, or thru code,
|
| SendKeys Action doesn't work | 16 Jul 2007 13:57 GMT | 1 |
When I run a Access 2002 database on a computer running Vista, I get an error message when using a macro (or event procedure) using SendKeys. The same macro when running the database on a Windows XP machine runs fine. Any ideas? Thanks for whatever help is given.
|
| Running Sum on a report | 16 Jul 2007 13:50 GMT | 4 |
I have a report that has a running sum (Over Group) for an element that is has been told to total on a monthly basis. It is listed on a weekly basis and totals fine for the monthly total. However, What I want is to take the total generated on the monthly level and use it as the ...
|