Calendar display on a form?

[bazzanoid]

Thanks jdraw

I'm going to have a good play around with the various suggestions and see what works best, although on the face of it isskint's method appears to be the best way, but scalability is a concern if for example it was to be implemented on 100+ vehicles etc.

So far i've got the customer form and vehicle form (and related reports for both) working perfectly (barring one minor pop up prompt for one report that i can't trace anywhere and makes no difference to the report content!)

The idea behind it is to make a decent, user friendly (read: idiot proof) rental system to use in the office to replace our aging software, especially since we need to get off of windows XP!!! Along the way I figured i would keep the best of it (like the calendar view), ditch the worst and add a few extra features that i need to squeeze the best from it.

There's a lot of statistics and information that we have to do manually every month which i intend to eliminate by making it all available at the click of a button - if the data is already there then there is no reason why it can't be manipulated into a report without me having to print out half a dozen sheets of paper and cross reference everything, and even count the pages!

Customer view, with a handy Individual / Business selector which blanks or hides certain fields:

Vehicle view, showing picture of vehicle and damages where available:

That's it so far, i'm in the middle of building the rental creator forms at the moment so will be able to update more once they're done... along with this calendar!

 

[bazzanoid]

Peter has a lot of excellent and clever examples over at UtterAccess
Holiday planner : http://www.utteraccess.com/forum/index.php?showtopic=2001188

I am struggling to find the originals but I know they were released into the public domain.
Let me look further...

Minty, that is bang on what i'm after, fingers crossed you can find the original or a current version i can adapt, would save me a serious amount of work lol

 

[Minty]

I think this is it - It does take a fair bit of fiddling to get working - there are some gotcha's with date formatting I seem to remember. Post up if you get stuck
http://hitechcoach.com/index.php/do...-examples/example-forms/schedule-grid-desgrid

 

[bazzanoid]

Fallen at the first hurdle.. entered in my table names etc and instantly got hit with a runtime error 91 - "object variable or With block variable not set" relating to this line:

Const cUnitPK As String = "Vehicles.CarID"

 

[bazzanoid]

Update:

Sort of fixed that issue. I'm having a right day of it, someone tell me what's wrong with this select statement that only plucks record where the checkbox is ticked please, i'm having a total mindblank on box statuses etc!

SELECT * FROM Vehicles ORDER BY Reg WHERE Available = True;

 

[sneuberg]

WHERE comes before ORDER BY. Try

SELECT * FROM Vehicles WHERE Available = True ORDER BY Reg ;

 

[bazzanoid]

WHERE comes before ORDER BY. Try

SELECT * FROM Vehicles WHERE Available = True ORDER BY Reg ;

Awesome, thanks sneuberg. It now displays the vehicles correctly - gave me a null error but that was where i accidentally deleted a field that's needed!

 

[bazzanoid]

Up next, to add in another 20 rows - 10 is too limiting!

Gives me something to do tomorrow morning i suppose

 

[jdraw]

Can you post a copy--zipped?

 

[Minty]

Up next, to add in another 20 rows - 10 is too limiting!

Gives me something to do tomorrow morning i suppose

I think that might exceed the max number of items ; 20 * 31 = 620 + the other objects on the form could get close ...

You'll obviously need to adapt the code to move around the extra boxes.

 

[Uncle Gizmo]

I was intrigued by your problem and wanted to have a go at solving it for my own amusement. I agree with Sneuberg when he says HERE that you might benefit from using a subform:- http://www.access-programmers.co.uk/forums/showpost.php?p=1495281&postcount=6

I don't know how far you are getting along with it but I suspect it's not easy to marry your system into an existing block of code, unless you have a good working relationship with the code creator. I believe you maybe better off leveraging MS Access to take advantage of the existing functionality.

I've come up with the beginnings of something which I think has potential and you can see a short YouTube video of what I've done here:- http://youtu.be/YZbT41bU79s?hd=1

 

[Uncle Gizmo]

Update:-
https://youtu.be/DTIrf2BuBJk

 

[bazzanoid]

Literally only just caught back up with this, was moving offices and that kind of puts things on hold! Looking very promising Gizmo, I know this can be done somehow as the outgoing software from 1998 (!) does it superbly. It's also a live view and the whole thing is on a custom frontend with an access-driven SQL backend.

The code is all my own so there's no issues with needing to re-invent the wheel if necessary - i can easily rip out or recode anything on here. My problem is that while i have a good head for code i'm a novice to intermediate user and therefore a little lacking in getting it to do what i want it to do once we get to stuff like this!

This is the outgoing:

[/URL]

 

[sharky376]

Guys, this is one of the best forums I've ever attended to... Peter did great tutorials and databases... Please, have anyone seen similar database, but oriented to car rental? So, in basic I need this kind of calendar with registration numbers on the left side, but on calendar side should be included HOURS too... Not only days... Thaks in advance !!! Br..

 

[Pat Hartman]

If the grid doesn't need to be updateable, it is trivial. It is just a crosstab query that you control by a date range of 31 days or whatever will fit on your form. You then double click on the carID to open an edit form to change the date range.

If the grid needs to be updateable, that's a different problem. The calendar suggested looks pretty cool with its scrolling ability but if you are willing to roll your own, I can offer a minimum code option that I call a bound denormalized form. It is a properly normalized table that is displayed as a two dimensional grid but which is still updateable. I've never used it for more than 20 columns but I can't imagine you have so many rows that 31 columns would be a problem so give it a whirl.

Bound Denormalized Form

I've left the old versions here but ALWAYS go to the last post to get the current version. This database contains two examples (using the same technique) of how to take data that is properly normalized and display it so that it looks like a spreadsheet (rows displayed as columns) but is...

www.access-programmers.co.uk