Need help with company database and form setup

[flyers123]

maybe you can use this remark in a SQL query as Rowsource for the combo? Active = 1, notActive = 0

SELECT Services.Service, Services.Price, Services.ServiceID, Services.Active
FROM Services ORDER BY Services.Active DESC, Services.ServiceID

Hi Gemma,

Thank you for the suggestion.

It seems valid point, however I was having hard time implementing the code behind the logic.

Can you please me help me understand how could I implement this code into Mike's example database above.

Thank you for your help in advance.

 

[mike60smart]

Hi Gemma,

Thank you for the suggestion.

It seems valid point, however I was having hard time implementing the code behind the logic.

Can you please me help me understand how could I implement this code into Mike's example database above.

Thank you for your help in advance.

Hi
My original database modified so that you can now add a Service Date for each Service.

When you select a Customer it displays the customer selected
It also displays the Previous Service's for the Customer Selected
To add a new service click the Add New Service Command Button.

Once you have added all details required you can then click the Preview Invoice Command Button

Again this is just one way to do this.

 

[flyers123]

Hi
My original database modified so that you can now add a Service Date for each Service.

When you select a Customer it displays the customer selected
It also displays the Previous Service's for the Customer Selected
To add a new service click the Add New Service Command Button.

Once you have added all details required you can then click the Preview Invoice Command Button

Again this is just one way to do this.

Hi Mike,

Appreciate your update with this database.

However, after adding the service massage in 3 invoices, when i made massage service inactive in the table "tbluservices" it disappeared from the invoices and shows blank fields.

I have attached the database for you. That is the problem i was having to understand how to display the service that has been made inactive the previous invoices.

Thank you for your time and efforts

 

[arnelgp]

so don't flag any as Inactive. only you knows who is Active or Inactive.
your customer don't know about it.

 

[mike60smart]

Hi Mike,

Appreciate your update with this database.

However, after adding the service massage in 3 invoices, when i made massage service inactive in the table "tbluservices" it disappeared from the invoices and shows blank fields.

I have attached the database for you. That is the problem i was having to understand how to display the service that has been made inactive the previous invoices.

Thank you for your time and efforts

Hi

OK Check this version

 

[arnelgp]

i have not used any of your table.
this is but a demo.
what i mean is pay attention to your Forms and Reports.
must be user-friendly.

 

[flyers123]

Hi

OK Check this version

Hi Mike,

That's perfect and works like a charm!

I'm extremely grateful to you for your time.

I have 2 more questions, hope you don't mind.

Question 1) Can the same thing be done for employee and contractor dropdown box as well as it does for services. meaning after the contractor or employee has been made inactive it still shows the historical information for past invoices.

Question 2) When a service is selected from dropdown, it has price set already and auto populates in the price field.

Thank you in advance.

 

[flyers123]

Hi

OK Check this version

Hi Mike,

I haven't had any update since last 2 questions.

I guess you might have been busy.

Can you please assist with

Question 1) Can the same thing be done for employee and contractor dropdown box as well as it does for services. meaning after the contractor or employee has been made inactive it still shows the historical information for past invoices.

Question 2) When a service is selected from dropdown, it has price set already and auto populates in the price field.

Thank you in advance

 

[mike60smart]

Hi

Check this version