| Thread | Last Post | Replies |
|
| Calculate time based on an integer in another field | 17 May 2005 04:53 GMT | 4 |
I am trying to generate a field in a table that is a time (e.g.,8:15 AM). This time is to be calculated from another field which contains an integer. I want the time generated to be 7:30 AM plus 7.5 minutes times the number in the other field (group number). Can anyone tell me ...
|
| Does table update trigger an event? | 17 May 2005 02:34 GMT | 2 |
Is there anything that triggers event when tables are updated? What I want to do is log the activity any time a record is inserted or changed in a table. I'm not sure of everyplace this table is updated so an after update or after insert event would be perfect but I don't know ...
|
| Update Query | 17 May 2005 02:31 GMT | 1 |
Can i create an update query to add a new record with one filed (location ID) to a table if it is not present. For example i have a table of locations visited in a specific year. I need to allow users to create estimates from a query based on those locations then create a table ...
|
| Calculating a percentage based on a field that has the sum of 0 | 17 May 2005 02:21 GMT | 1 |
I am trying to do a calculation in a query that will determine a percentage. The problem is in that some of the fields there may not be responses, thus the sum of those fields would equate to 0 for that record. Now if I do a sum of column1 \ sum of column2 to get my percentage, ...
|
| Syntax Error - Comma | 17 May 2005 02:19 GMT | 6 |
I have failed to get this working: =IIf([CharterMember]=-1,"Joined " & [ClubName] & " " & Format$([DateJoinedThisClub],"d mmm yyyy ")","CharterMember ") Error message reports syntax error, comma etc.
|
| I'm looking for the flat share. | 17 May 2005 01:35 GMT | 4 |
I desperately need to find singe room from 50 to 70 pounds in SW london. Can you help me? Yours sincerely Svetlana
|
| Report not printing unless I exit form and reload | 16 May 2005 20:45 GMT | 4 |
I am using the following code to print a report from a query. Dim stDocName As String DoCmd.Save Me.Refresh
|
| how to imbed file to windows media player | 16 May 2005 17:51 GMT | 1 |
have windows media player on web page but cannot get video file to imbed so it will play for others. the media player will only pull from my file instead of from web. Any help in this matter would be appreciated.
|
| Class Schedule | 16 May 2005 17:28 GMT | 8 |
I am trying (alot of emphasis on "trying") to create a database of students and the classes they are taking. Basically I need to be able to printout a students information plus the classes they chose (from a list of 28 classes) on a sheet of paper. The schedule will be handed ...
|
| Max function in calculated field | 16 May 2005 15:26 GMT | 1 |
I have set a calculated field in a report. Max([Action.Date]+ 180). This works fine in the report, but I want to change it to 6 months. Would someone help me with this? I do not know code.
|
| How to create a data base for CME's tracking? | 16 May 2005 05:34 GMT | 2 |
I would like suggestion on how to create a database so that I can keep track of all my CME's ( continued medical educations) and have a way to retrive it whenever and however I want.
|
| Date Format | 16 May 2005 01:12 GMT | 8 |
I have a database that has run quite successfully for about 18 months. We do have several different operating systems ie windows nt, windows 2000 & windows xp. Over the weekend the database has moved to a different server and now when i
|
| How can I get access to put only the current year in a field? | 15 May 2005 22:55 GMT | 9 |
I'm having problems forcing acces to put only the current year in a field of each record of my database. At the moment I solved this by changing the properties of the field as follows: "Format: yyyy" and "Default value: =Date()", and this works just fine, but when I want to use ...
|
| MS Word templates imported into access | 15 May 2005 22:27 GMT | 4 |
Newbe I just won't to know if there is a way to import a fillable word template into my database Thanks for any help
|
| Still in Training - Need help linking 2 tables and checking for a duplicate | 15 May 2005 21:10 GMT | 3 |
Still in training , but I have almost everything done except for 1 thing. I would like to be able to type in a SS#, and access to check to see if I already have an entry with that SS# in it - If I do, I would like to go to that record, and if I don't I would like it to allow a new ...
|