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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.