Search results

Dear people, This discussion started with the question if there is a another way to sort a combobox, to get my teeth in, and now we are all over the place discussing all the things I presumably do wrong. My application works fine, nothing is wrong, and it reacts very direct. I create a new...

You don't have RequestedDeliceryDate in your query and for the combo, just make a list! januari; februari; march; etc

I only need the date for the invoice. I need the weeknumber for my timesheets and invoice, I need the month for invoicing. I use the parts of a date to create week and month for easy use, if I would store a date in my table I have to calculate the only two really important parts of it for every...

@The_Doc_Man I put in the question mark because it is a bit unclear to me if Text11 ever gets focus. I cannot figure out the sequence of events and what goes on after opening the form. The other thing for the question mark was see if OP is figuring out his programming. (i didn't open his file)

Text11_AfterUpdate?

Thanks guys, It did not annoy me for the last five years and worked fine. At the moment I am changing my UI and was curious and look for a way to rework the sorting. Normally I move a table to a backup table with the year as name. As said I am using it in a private application so no harm done...

Thought about that one too! I took the shortcut and added the field 'Year' in WorkHoursjournal. I am not using that in my query but the year is shown.

It surely the most flexible solution. thx @MajP

Well, they had a very decent bass player.

Hi all, I have a small application taking care of my workhours, projects and invoicing. I work for different clients and projects on hourly base. I select a project in a combo which will show all records in my WorkHoursjournal by project. Secondary I create a sql query as rowsource for a...

that's why I reacted with: easy money:D But you did good!

Sorry for the late reply, things to do. I think you should follow @theDBguy . His solution is clear and can be understood by users. Also @Privateer has a good solution, it is the one I use in some applications.

Are you the only one that will use the application? If this will be used by many you can bet on one thing, chaos! People tend to forget your solution when they have a lot of work or are distracted. Writing an application is to make worklife easier or automated. That is the main question for...

Easy money ;)

sorry :cool:

The PK could be to combine class & level. The Rate and Date are the fields that change over the years.

When you would use Combo's, a lot of mouseclicks & scrolling is involved. With a tree 2 or 3 clicks can be enough to reach the info you need. I am used to technical project software. These mostly use a tree as start. From a users standpoint , the tree is a lot easyer to understand.

I am using PDFtk Server for that, via a Shell command. https://www.pdflabs.com/tools/pdftk-server/

Sorry if it looks like I am jumping like a frog in hot water. I think you are trying real hard to give your first idea a chance. You are focussing at the end stage of your proces, the invoice! Take a step back and overlook your complete process; 1. Customer places order for a service and date...

Create a Table 'Request' which creates a unique number, and combines, contractor, client, service, etc. George-Bowyer's solution is looking like that. I have an application that administers my hours worked in a project, it takes me three clicks to have an invoice: Choose Project and Month then...