Search results
-
Z
parameter query for date range
Hello all I am trying to write a parameter query that shows me what equipment is booked during a specific time range. For example, the booking table is setup with the EquipmentID, FROMDATE and THRUDATE. EQIUPMENT..........FROMDATE......THRUDATE Equipment A..........1/2/17..........28/2/17... -
Z
Problem with text box positioning
Hello I have been playing around with a timeline report database i found which populates a report in a fashion similar to a gantt chart. I can get most of it to work, but am having a problem for the grow box to position itself correctly. If you look at the attached example, for Event 2, the... -
Z
Need a VBA guru to help solve a problem
Hello I am trying to make a small equipment booking form. The form is unbound, and has a fair bit of vba behind it. I have modified this from a working example that was posted to the public domain some time ago. My problem is this: The original form only had 10 rows in it for equipment. I... -
Z
Form does not update correctly
Hello Hoping someone with a lot more VBA knowledge than myself can help. I am building a small scheduling DB, and have been trawling this site to find some examples. Eventually stumbled upon a great concept form that is essentially a booking calendar. I have attached the database and the user... -
Z
Search box to search from a subform query
Hello all I am having some trouble with getting a search box to work on a search form. Initially, the form was setup with the query on the main form, and the following code below returned the correct search results. Dim strsearch As String Dim Task As String 'Check if a keyword entered or... -
Z
Checkbox Form Filter
Hello all I would like some help with creating a search form using check boxes to select the criteria. I have searched all through this forum, but cannot find anything that is able to help me in trying to get this to work. Basically, what i want is a filter form where the user can select the... -
Z
Calculate number of days with parameters
Hello all First off, love this forum.... has provided so much assistance for me in learning Access! I am having trouble writing a query to calculate the number of days between certain events. Currently i have a table set up that contains: tblMove Object Start Date Move Date Status (can be...