Search results

A record is a row. Updating here means that whenever the query is run, the column recalculates itselt with the current date(which changes everyday) resulting in the increase in net fine. [Net Fine] is a field

I am trying to create a expression to calculate the net fine of a book by the expression below by using a query: Net Fine: IIf(DateDiff("d",[Issue Date],Date())>7 And [Returned]=True,(DateDiff("d",[Issue Date],Date())-7)*15,"0") The returned field is a checkbox. The expression works but the...

I am trying to create a expression to calculate the net fine of a book by the expression below by using a query: Net Fine: IIf(DateDiff("d",[Issue Date],Date())>7 And [Returned]=True,(DateDiff("d",[Issue Date],Date())-7)*15,"0") The returned field is a checkbox. The expression works but the...

I want to create a search function that will allow me to search for a record on a particular query based on the data on 2 fields on a form. My database has a query named Loan Query. I am created a form of that query that on load will create a new record. 2 fields on the form are Book ID and...

My problem is related with mail merging and I cannot use any third party software or plug-ins. I also don't want to create any queries for the database. I want the mail merging to start when a button on the switchboard is pressed. It would be good for me if VB codes can solve the problem My...

But how do you run a mail merge by a command button. And isn't there any alternative way rather can creating a query.

My problem is related with mail merging and I cannot use any third party software or plug-ins. My database has a query named “Borrow Details Query”. This query has the 2 following fields: Issue Date & Return date. I want to do is that if the difference in days between the Issue Date and...

I am trying to create a code that will allow data to be saved if the condition of the 2 fields is met. The 2 fields are "Copies" and "Borrow". The thing I want to do is as follows: If borrow<3 and return>1 then allow the record to be saved and subtract 1 from the value of return and add one to...

Please can't someone rescue me from this problem. I have a database containing 3 tables: Book, Member, and Loan. A relationship exists between the 3 tables(the relationship has no problems, I have enabled referential integrity). I created a query named Loan Query which uses all the 3 tables...

I am trying to create a code that will allow data to be saved if the condition of the 2 fields is met. The 2 fields are "Copies" and "Borrow". The thing I want to do is as follows: If borrow<3 and return>1 then allow the record to be saved and subtract 1 from the value of return and add one...

I have a database containing 3 tables: Book, Member, and Loan. A relationship exists between the 3 tables(the relationship has no problems, I have enabled referential integrity). I created a query named Loan Query which uses all the 3 tables. In the loan Query, the Member ID field is in Loan...

Thanks a lot raskew. That really works!

I am a novice user and so please elaborate the solution of my problem. I need the entire code. I created a module based on the instruction on Microsoft's Knowledge Base(KB210385) to create a validation rule to accept only alphabetical characters. The code of the module is given below: Option...

I am a novice user and also could not understand the thing you wanted me to do. can you please be more elaborate and send the entire code.

I created a module based on the instruction on Microsoft's Knowledge Base(KB210385) to create a validation rule to accept only alphabetical characters. The code of the module is given below: Option Compare Database Option Explicit Function IsAlpha(MyString As String) As Integer Dim LoopVar As...