Search results

  1. A

    Is this on the right lines

    Hi, I am just trying to normalize these data here: An initial call is logged by a first line support analyst who assesses the severity of the problem and places the call in a pool. The call is picked up by a problem analyst who in turn allocates it to a specialist analyst based on their...
  2. A

    Query to add data from form into table

    Hi thanks for the reply, I just downloaded that but it only inserts the date. Is there a way to do this with an ActiveX controller?
  3. A

    Query to add data from form into table

    Ok no need to worry about the reservation problem anymore i have doen that. However does anyone know if it is possible to insert the date AND time into a text box with a date picker?
  4. A

    Query to add data from form into table

    Hi, I am trying to create a simple library system that allows loaning returning and reserving CD's So far i have done issueing and returning loans. However i am a little stuck on how i would reserve a CD. So far i think it would be best if lets say the user opens a form and their will be two...
  5. A

    Query to insert data from form into table

    Hi thanks for the quick reply. However is there anyway of doing this via a query, cause i cant use any VB code
  6. A

    Query to insert data from form into table

    Hi, I am trying to create a simple library which allows issueing, returning and reserving loans. So far i have been able to do issueing and returning. However how would i go about making a query so that when a user opens the reservations form there will be two list boxes, one full of...
  7. A

    Query adding content to two fields?

    Thanks again. This sites been a REALLY big help.
  8. A

    Query adding content to two fields?

    Thanks that works a treat now. Just one more problem I have got a return loan form with a drop down box with a list of borrowers who have a loan and a listbox which will be populated based on the dropdown box. However if for example a borrower has two loans they will appear twice on the drop...
  9. A

    Query adding content to two fields?

    I have unbound it now (I de-selected record source on the form?) but now it wont let me select anything in the borrowers list box?
  10. A

    Query adding content to two fields?

    Hi, I am trying to create a simple library system that can issue and return loans. At the moment i have created a working system to issue loans. I have created a query that inserts the correct information into the borrowers table but for some reason it inserts the borrower ID into the first...
  11. A

    Return Item Query

    Hello, I am creating a basic library database that loans out CDs to borrowers. At the moment i am trying to create a return query so CDs can be returned. I need to Append the values (AccessionNo, BorrowerID, DateIssued, Date Due) into the LoanHistory table whilst also adding data to the...
Back
Top Bottom