access fields

[philquad]

hey guys, im a real access noob


sort of failed it at tafe, excel im ok

after a bit of help if someone has time

i have a cms access database i had made long ago, & id like 1 of the fields that i can see in the backend only, to show in a field that exist in the main form?

eg. next-service to show in start-date < as its not used. but i have no idea how sorry

thanks in adv.

[Micron]

to show in a field that exist in the main form

This means you have a control on the form already but it doesn't show anything? Assuming the form is bound to a table or query that contains that field, then in form design view you select that control, use the drop down on the property sheet in the control source row and pick the field you need. If that's not it, then I don't understand what you want to be where.

[philquad]

This means you have a control on the form already but it doesn't show anything? Assuming the form is bound to a table or query that contains that field, then in form design view you select that control, use the drop down on the property sheet in the control source row and pick the field you need. If that's not it, then I don't understand what you want to be where.

i sort of get it but unsure where to find it
can i upload it ? i see in the forms it shows a next_service_date, but on the front\input side of it, its not there, i would like it to appear in the unused "start date" column - do i make sense?

https://nbay.com.au/xxx/

[ArviLaanemets]

... of the fields that i can see in the backend only, to show in a field that exist in the main form?

The only date control in Main form I can see is [date added] - based on tables shown on background of your picture, it looks like the date you registered this customer the field dat_added of customers table). Do yo really want to replace this date in Main form with date of next service for this customer?!

... eg. next-service to show in start-date

This part of post probably refers to field start_service_dat in service subform (Btw, it looks like you use a Datasheet view for subform. I myself never use this view, so I'm not entirely sure here.). It looks like the subform has only service start date (start_service_dat of services table) displayed. Probably the field next_service_dat is generated automatically by some event of subform, whenever a new record is created or saved. Based on this part of your posting, the another possible action you do want is to have set start_service_dat equal with latest previous next_service_dat. Are you sure the next service will be always started on predetermined date? Or can it be started earlier, or later? And when yes, then how must access handle this? But generally this is possible - you have to edit the same event which did set next service date for first service. The event has to check, is the service entry for this customer the first one, or following one. When 1st one, then it probably sets service start date as current one, and calculates the date of next service and stores it. When it isnt 1st service, it reads latest next_service_date for this customer from service table, sets it as start_service_dat value for new entry, calculates next_service_dat for this entry, and saves it into new record of services table (or sets a value of hidden subform control linked to next_service_dat equal with calculated next service date - the saving is done when the record is saved).

[philquad]

The only date control in Main form I can see is [date added] - based on tables shown on background of your picture, it looks like the date you registered this customer the field dat_added of customers table). Do yo really want to replace this date in Main form with date of next service for this customer?!

the saving is done when the record is saved).

hi, i did reply before but i uploaded it to my website with a link, the db broke the 500kb rule? its about 3mb, but it seems it was not allowed

i have never really looked at the forms etc (not savvy) but the idea is & has been, you put in the 1st service date & say 6 monthly or 12, it sends out a email & sms to the car owner, has worked since 2014 but a new skin & my finally looking at the backend? its quite a mess, altho it still seems to work. basically im trying to establish that once it hits the send out that it "should" update the "unseen" next service date, & reset the check boxes.
wish i could upload it.

[isladogs]

Try removing most of the data, compact the DB and then zip the file before uploading.
Make sure none of the data is for real customers

[pbaldy]

Post 3 was moderated, I'm posting to trigger email notifications.

[philquad]

The only date control in Main form I can see is [date added] - based on tables shown on background of your picture, it looks like the date you registered this customer the field dat_added of customers table). Do yo really want to replace this date in Main form with date of next service for this customer?!
is saved).

simply ? yes, sorry i dont explain things very well.

the frontend? really only needs plate no. & service\rego dates to function, it would be good if the (hidden) next service date appeared here also (can use the brake start date)



whats confusing me is in the original database, i have tested & it shows the next service date on the customer-details table after email sending automatically



but after the new skin, im not sure if it is doing the same as the old database, it "should" show the next service date (6 monthly etc) & untick the checkbox as the email reminder has been sent, yes?

[ArviLaanemets]

the frontend? really only needs plate no. & service\rego dates to function, it would be good if the (hidden) next service date appeared here also (can use the brake start date)

I see your services table contains service info, and car info! In principle, this is a bad solution. We can assume, that a customer can have more than one car.
So either you have a single row for every car this customer has in your services table, and the service info for this car is owerwritten every time the car is serviced - i.e. you'll have no history of services for any car;
Or you have several service rows for every car, where the same car info is entered repeatedly (a no-no for relational DB!).
And with both cases, the date of next service for which car, of several this customer has, must be displayed on customer form? There is no way to do this in a way which covers all possible situations!

With normal relational DB design, you need:
a table where all customers are registered;
a table where all cars owned by customer are registered;
a table, where all services made/planned for specific car are registered (You make service for car, not for customer! Services for customer are made by entirely different kind of firms - unless your customer is a robot )

i have tested & it shows the next service date on the customer-details table after email sending automatically

This means, the procedure which sended the mail out, also updated the services table, and entered the date of next service there!

but after the new skin, im not sure if it is doing the same as the old database

Depends on how much of code you did take over from old version mail sending procedure, and how well is it working with new version!

[philquad]

[CODE]the frontend? really only needs plate no. & service\rego dates to function,

i can relate to what your telling me, mostly
it was never meant to be a complex thing, just send out a email\sms when the date comes, its worked fine since 2014, & i cant find the original person who made it for us sadly.

but ive worked out through trial & error that the old 1 gives a new date after it sends out, yea? thats fine, no need for old records, & i think the new one, that i just wanted a nicer looking front input (we never,ever went into the tables etc)
has somehow joined the doovey tables your telling me about, & broke the generate a new service date part, even though it still sends out fine, it doesnt update, & that will be messy later on.
oh dear, is it fixable, & is there someone i can hire to. i cant do this.
ps, yes theres options for more cars