| Thread | Last Post | Replies |
|
| date function? | 06 Sep 2004 16:17 GMT | 1 |
I would like to create a function that calculates fixed periods of time for recurrent events, I mean something like that: -I enter the frequency, either in days or in months, like every 1 month. -Then I enter the first date, say 01-Jan-2004 (and the agenda event like
|
| frontend and backend | 06 Sep 2004 10:39 GMT | 1 |
I created a database, with tables, queries, forms..., now that I would like to create a replica I read that it is better to have a "frontend" and a "backend" db. How can I do that? Do I need to create 2 db and in the frontend use "link tables"?
|
| Open to a new form | 06 Sep 2004 05:04 GMT | 1 |
I have a database based on one form with about 4000 entries. On opening the database, I wish it to go to a new blank form, rather than Entry No.1. How can I do this?
|
| Date Restriction in SQL query | 06 Sep 2004 05:02 GMT | 1 |
I have the following SQL query on a database and would like to restrict data from a given date. ie. I would like to insert >#31/05/2004# into the statement below. SELECT tblEnquirer1.*, tblEnquiryType1.EnquiryType
|
| combinding text and date fields | 06 Sep 2004 04:51 GMT | 5 |
I wish to make a combo field consisting of field datefield and field namefield in my query, i.e. [namefield]+"-" + [datefield]. It won't take. How do I convert datefield temporarily into a text field so I can
|
| DB and the web | 06 Sep 2004 01:51 GMT | 2 |
I am looking for a place to go on the web to find out how to use Databases such as Access to be used with a web page on the internent. I have been looking for quite a while now (Google and MSN search) and have some
|
| attachments in outlook | 06 Sep 2004 00:12 GMT | 1 |
I am unable to open attachments in outlook, or msn
|
| How do I config my pc to surf better | 05 Sep 2004 19:46 GMT | 1 |
I recently got dsl and at first it worked fine. so I threw in zone alarm and something happend. Now when I use the net is all slow and crazy. then my roomate changed some of the other configs in propeties tab. Im totally lost
|
| Access/VB code error | 05 Sep 2004 13:27 GMT | 3 |
Help would be greatly appreciated with the following. I have created a database with a form and tables. On the form I have created a test button. The code below (fragment)is from an example in access (Index Property).
|
| auto filling bookmarks in word2000 | 05 Sep 2004 08:08 GMT | 1 |
I am trying to automate the filling in of bookmarks in a word document with information in my access table. This is the coding I am using, but something is wrong with it. What happens is I get a dialog box telling me I can only open in read only
|
| How do I create a calender in Access? | 05 Sep 2004 04:12 GMT | 8 |
I am trying to create a calender in Access, but am unsure where to start. I am a novice in Access. I haven't created any forms in my database yet, because I am unsure how to manipulate the forms/tables etc. Can anyone tell me how to set up a calender in a way I can understand?
|
| Inputing data to 3 tables from one input form | 04 Sep 2004 21:51 GMT | 1 |
I am trying to update 3 tables from one input form, however the help file tells me I cannot do this. I have tried to get round it by joining 2 querys together, which also does not let me enter data. I have tried using a sub form, which does work, but I really wanted the data
|
| multiple entries for a search field? | 04 Sep 2004 19:43 GMT | 3 |
I have an access database with a name field. Is there a way to set it up so I have multiple names for the same database record. Its simply a name and multiple stage names?
|
| database structure | 04 Sep 2004 15:45 GMT | 3 |
I'm setting up a staff database and need some advice on how to structure it. As well as listing names, addresses, telephone numbers, etc., I want to use the database to define the management structure. The company is split into
|
| IIf(IsError... in a query | 04 Sep 2004 08:53 GMT | 1 |
I am trying to use the two functions IIf and IsError in a query in this way, which is wrong (since it doesn't work): Total: IIf(IsError([field1]/[field2];0;[field]/[field2]) my intenttion is that, if the result of the division is "error", for example
|