Search results for query: *

The backend is updated every day and usually all day between 8 and 5, so it takes a fair bit of hammering at times. Could illegal chars in a field; either memo field or text field be the cause of this problem? I am currently campaigning for SQL Server.

I am having problems with corruption in an Access 2003 database. There are 22,000 records in there and can lose multiple records at once. I have tried fixing the problem by compact and repair, also have tried creating new database and importing all tables etc into new database. The latter seems...

Does anyone know if it is possible to change the font on a report control, either a text box or label to be struckthrough . I have to eliminate paragraphs depending on criteria selected, but need to have the paragraphs remain to show the decision made. If it can't be done, it can't be done and...

Thank you for the help and advice. I shall now see what I can do. Have a good 1. Alan

In your opinion would it be better to have a seperate table for each borrow period? Currently all borrows are held in 1 table, would it be better set out as follows: Borrow table1 CustID AS FK ISBN as FK DateOut as PK DateIn Length Have 6 of those tables and have them link into another table...

Yes, but each book cannot be borrowed for more than 12 months in any 36 month period either.

Skip, Thanks for the help, writing it down in this way has helped me see it a little more clearly now, but I am still unsure as to the design of the loans table. I think that is the design flaw that is stopping me. Alan

Like I said, I left college 3 years ago, I didnt say I have been a programmer for all that time. I have just started programming in the last couple of months. You are correct each person borrows a book and can only borrow it 6 times. This is what I must calculate: 1. The date exactly 36 months...

First of all, thank you for your help, but I am not a student of anything but life, I finished college about 3 years ago and I am just starting in the field of programming databases, hence the reason for it not being that logical. The data is in a table. It is in 1 table, but I am not sure...

I have started to create some more code and here it is: Private Sub cmdTotalDone_Click() Dim loan1 As Integer Dim loan2 As Integer Dim loan3 As Integer Dim loan4 As Integer Dim loan5 As Integer Dim loan6 As Integer Dim totalloan As Integer Dim dateout As Date Dim dateback As Date...

Thank you for the reply. The only code I have so far is to work out this date 36 months ago. DateAdd("m",-36,date()) I then need to find out if the person had the book on loan that date, which I am having trouble with.

The problem I have been asked to overcome is the following: A person can loan a book for any 12 months in a 36-month period, the loan does not have to be a continuous loan, and it can consist of various smaller loans e.g. 4 loans of 3 months. I need to be able to calculate how long each person...