Search results

I have some fields on my report that get totaled in the date footer, but i want to have a grand total at the bottom of the page is this possible.

I would like to be able to click on these sub form records and have it open up a Editing_record form with the record that was clicked showing. Editing_record form:

I would like to count just the total of 'JL' in each row. right now i can only to get it to sum the total. Any help would be appreciated.

I am having trouble with this function of checking books out. I am getting a syntax error I will post pictures of all the tables I use in my database and the form and help would be appreciated. My thought was to have a form where user inputs ISBN and UserName then clicks an OK Button which...

Here I am working on a practice database doing a Library management System. I have an attached database (working on making test data for the tables will upload when finished). I am trying to figure out a way I can do the book checkout and book reserve buttons. some thoughts i had on how to do...

Here is what I have started with in that attachment, I am having trouble with figuring this out in the 'Check Books In/Out' Form **VBA challenge coding/getting amount owed if book is overdue Need to subtract 2 date/time format fields and get a number If that number is over (7 days) then a...

i have a combo box that finds a record on my form based on order number i select in the drop down , is there a way i can get it to auto populate if i search part of the order number instead of the whole thing. EXAMPLE: instead of typing 000018052913 in the combo box i would like to type in 2913

Hello guys i have a duplicate button with some SQL code embedded into it and i cannot get the sql code to execute here is a copy of the code Private Sub Duplicate__Record_Click() Dim fullpath As String Dim dirs(0 To 2) As String Dim s As Variant Dim onn As String Dim strSQL As String onn =...