| Thread | Last Post | Replies |
|
| Link to a folder based on an autonumber | 12 Jul 2008 07:06 GMT | 2 |
I have a form that will automatically assign a Project Number (autonumber). Within that form I want to have a link that will open a folder on my network that is titled the same as my project number. For example:
|
| look for agent | 12 Jul 2008 07:02 GMT | 1 |
Oneself isn't a money, did IT at first because of liking a computer, want to do the business of this aspect for the others or the unit now, with perfect from have already lived an arrangement. Contact mailbox:wangda84@yahoo.com.cn
|
| enabling field | 12 Jul 2008 06:22 GMT | 1 |
In a database I'm creating I have a scroll down field with fixed values. When a certain value is selected I want some other fields to become enabled. I want these fields to be disabled unless that value is selected. I'm sure I need to run some kind of a macro or something but ...
|
| How to attach file into email | 12 Jul 2008 06:12 GMT | 3 |
I would like to know how to write VBA to attach file then send it email. I use sendobject method as the code following this DoCmd.SendObject acSendReport, "<reportfilename>", acFormatRTF, "<sender email>", "", "", "TEST", "Testing", True
|
| Simple form to update a table of dates | 12 Jul 2008 05:51 GMT | 8 |
This should be simple but it isn't for me. I have two tables. tblClient ClientID Name
|
| Mystery Problem Could not update currently locked. | 12 Jul 2008 05:14 GMT | 2 |
I have a database that about once a day encounters a problem. The first two times it happened there were 2 people working at the same time. Today there was only one person who was logged in. The error comes up when the user clicks in a cbobox to select an appointment type. The ...
|
| How do I carry out an e-mail merge from Access | 12 Jul 2008 03:45 GMT | 2 |
I want to send the same e-mail to a number of different people by using their e-mail addresses that are held in an MS Access 2003 database. I'll be using MS Outlook Express to send the messages. How do i do this?
|
| First field is left blank in combo box | 12 Jul 2008 03:35 GMT | 15 |
I have searched for this and could'nt find the answer I'm in need of, so here is my question. I'm using Access 2007 and have a combo box referencing a query. The correct result is showing up in the combo box, but the first "row" is blank. I need
|
| Error Msg Box | 12 Jul 2008 03:10 GMT | 4 |
I trying to use custom error message boxes. I tried using a syntax i wrote: Iif(<> 000000000;;_MsgBox(“Field Must Be “9” Digits!”, “Warning!”, “TIN Field”) I have no idea if I’m on the right track.
|
| Three fields to represent a date? | 12 Jul 2008 02:53 GMT | 5 |
I am creating a table that needs to have the date (i.e. 01/31/2008) stored as three separate fields as follows to be consistent with an older database. Month, length of 2 and can have 01-12 or 99 for unknown month (i.e. 01). Day, with a length of 2 and can have 01-31 or 99 for ...
|
| need guidance | 12 Jul 2008 02:52 GMT | 1 |
I have two forms. One for information then other for a picture. I'm using a query that has 5 fields in it. They are: Staff id, fname lname together, lname, fname, and idpict. The query is set up so if there is no picture ="na.bmp" it will display those with no picture. When the ...
|
| can't open ACCESS2003 database due to error 3197 | 12 Jul 2008 02:46 GMT | 2 |
Online help sez I need to update database security. How can I do that if the ACCESS2003 database won't open due to error 3197 ( MS Jet engine stopped due to you and another user trying to access...) There is only one use of database.
|
| getobject | 12 Jul 2008 02:20 GMT | 6 |
is there a way to use the getobject function to bring up a box that allows you to search for the file that you want to get? Thanks all Brennan
|
| DoMenuItem Error | 12 Jul 2008 02:10 GMT | 7 |
I am getting an error similar to the error where me and another user are modifying the same record. But there was noone else modifying the record. Below is the code where the error came from: DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_SELECTRECORD_V2, ,
|
| SQL/Query to retrieve top two records from a panel of data? | 12 Jul 2008 01:16 GMT | 2 |
I have a panel of data organised as follows: id1, 1990, 100 id1, 1991, 101 id1, 1992, 100
|