Pls help, i need to make this program work asap.

[homer.favenir]

agehoops,
what if i make 3 more forms just like the one you made, but with different tables.
e.g.
1. dl.tbl to lv.tbl (you made already) (form 1)
2. lv.tbl to lv done.tbl (form 2)
3. lv done.tbl to callcenter.tbl (form 3)
4. callcenter.tbl to yh update/QC (form 3)
5. yh update/QC to Upload (form 1)

how am i going to copy the code and make it work the same with dl.tbl to lv.tbl?

pls help

thanks

homer

 

[agehoops]

Well after looking at the database every table has all the same field names correct? Makes it a lot simpler

If you go into the OnClick event of the buttons on the form i worked on, you'll find all the code which is used.

Copy it all, and paste it into the OnClick event of the button you're working on.

Now there's a few things to do:

1. Go into the properties of the list, and ENABLE the column heads (this means you can actually delete the first record you have in the table which contains the data of the head names unless they're needed for other things)

2. Rename all the references in the code to the new list boxes. So for example, where it would currently say DL and LV, change them all to CallCenter and yhUpdate or whatever they're named. Just make sure to get them the right way round depending on which way you want to copy them.

3. Create a new Delete Record based on the table you want the data deleted from. Add all of the fields, and in the criteria of the ID field, set it to the text box on the form below the list box which shows the ID that is selected.


Hopefully it should then work as it does with the form I worked on

 

[homer.favenir]

how about the queries? the delete dl and delete lv?

should i copy paste it also in the queries?

thanks

 

[agehoops]

Nah don't copy the query, just create a new one. Delete queries are easy.

If you create a new query in design view, and add the table you want to delete the record from. Then at the top of the screen you should find the query type, if you change it to a Delete query then set the criteria

 

[homer.favenir]

Nah don't copy the query, just create a new one. Delete queries are easy.

If you create a new query in design view, and add the table you want to delete the record from. Then at the top of the screen you should find the query type, if you change it to a Delete query then set the criteria

the only problem is deleting the records in done lv.
pls see attached file.
check lv form

thanks

 

[homer.favenir]

sorry, what i mean is the only problem is deleting the records in lv when i move it to done lv.
pls check my db
thanks

 

[agehoops]

There ya go. All was correct, only that the query was still looking at the ID field on the other form, not that new one

View attachment tracker.zip

 

[homer.favenir]

thanks agehoops,

i have 2 more forms to make, and what should i do is to copy the code of the command button and paste it to the new one, then edit the code, make a new query for the new form.
am i right?

thank you so much.

 

[homer.favenir]

and also how am i going to make another return button? just like the dl files form, it has return record button.

thanks

 

[agehoops]

Yea that's exactly right. To create the other button do exactly the same thing, only copy the code from the return command button, and again just alter it to have the same names as the list boxes you're using

 

[homer.favenir]

ive just copied the code and looked at it, only the is it the table name or list box name that im going to change in the code?

thanks

 

[homer.favenir]

and also i have to put a refresh button to make the new records appear, how am i goint to make a autorefresh?

thanks

 

[homer.favenir]

a little more adjustment

and also i have to put a refresh button to make the new records appear, how am i goint to make a autorefresh?

thanks

agehoops pls check my db.
i cannot make the button work.
i copied and edit the code it didnt work.
i think just a few adjustments.

pls see attachment
thanks

 

[homer.favenir]

agehoops, the dl files form return button stop working.
pls check.

thanks

 

[homer.favenir]

code for transfer buttons

im glad that some of the buttons already working, however, i cannot make the button work even if i copy the code and paste it to new button,i cannot figure it out what seems to be the problem.i really tried my best but nothings happens and im willing to learn it.
pls. help me make all transfer buttons work.
i know your good and you can do it.
attached file is the layout of the db.

pls help.

thanks

homer

 

[homer.favenir]

code for transfer button

agehoops, im glad that some of the buttons already working, however, i cannot make the button work even if i copy the code and paste it to new button,i cannot figure it out what seems to be the problem.i really tried my best but nothings happens and im willing to learn it.
pls. help me make all transfer buttons work.
i know your good and you can do it.
attached file is the layout of the db.

pls help.

thanks

homer

 

[homer.favenir]

bumping this thread...

 

[agehoops]

Hey sorry about the long time reply causing you to bump. Been a li'l busy.

Have got all your buttons working, hope it's ok


View attachment tracker.zip

 

[homer.favenir]

Thank you very much!!!

agehoops, thanks a lot! you are a very big help. i can now make some adjustments for the control panel and some forms for finalization and present it to my manager. i hopy she will like the idea and of the program. i will try to present it today. and sorry for the late reply, ive been into a 3 day vacation. the program you made is perfect.

thanks a lot.

BTW i saw your website and youre a very good photographer, very professional images. i like your website.

homer

 

[agehoops]

Glad it's all working. Let me know what she says to it. Glad to help

Thanks for looking, i'm about to upload a good hundred or so more from our holiday to Canada so keep checking it They're much better than what is on there