Posts by siddheshkh

Re: $15 Database addition to VBA and userform already created

Waiting for your reply Charles the job is not done yet.

Re: $15 Database addition to VBA and userform already created

sent u PM about the validations to be made which were there already in the file I posted.

Quote from siddheshkh;724185

yes 10 digit would suffice. and plz check timing issues also. entering end time shows error.

Re: $15 Database addition to VBA and userform already created

yes 10 digit would suffice. and plz check timing issues also. entering end time shows error.

Re: $15 Database addition to VBA and userform already created

The file is showing many errors

1. It doent allow me to enter quantities more than 6 digits--- overflow error

2. It is giving error when I select end time

all other functionalities can be checked only after you resolve these 2.

Reply awaited!

Re: $15 Database addition to VBA and userform already created

your payment has been sent! Please upload the file.

Re: $15 Database addition to VBA and userform already created

D-1 is yesterday's date
D-2 is day before yesterday's date

HRMS is Employee ID and combobox can be used instead of textbox. but when I update employee master new rows it should pick up automatically.

Re: $15 Database addition to VBA and userform already created

Hi

One more thing I missed to include.

The employee master will keep on increasing so can u plz add conditions to lookup in the whole column instead of including fixed cell references..

Quote from siddheshkh;724131

Thanks. Let me know!

Re: $15 Database addition to VBA and userform already created

Thanks. Let me know!

Re: $15 Database addition to VBA and userform already created

The money has been sent.

Can I get the final outcome till 26th Aug?

Quote from KjBox;724128

Thanks for the reply. I will get started on this now.

Ozgrid PayPal email ID is "[email protected]"[/email]

Re: $15 Database addition to VBA and userform already created

Posting vba file and employee master in the next comment.[/QUOTE]

forum.ozgrid.com/index.php?attachment/61951/

Re: $15 Database addition to VBA and userform already created

Hi

Sorry for l8 reply

In the new userform

Original Concept: lookup in employee master against employee ID and autopopulate
Operational Concept: drop down (as it is currently for Concept)

Choose Date: drop down for Today's Date, D-1 date, D-2 Date
Employee Name: Lookup in employee master against employee ID and autopopulate

Total qty processed: Auto calculate qty entered into the userform and autopopulate
Total Hrs worked: auto calculate and auto populate as against selected times in userform

Supervisor's Name: lookup in employee master & auto populate when entered employee ID

Activity Code Guidelines: have added a picture file activity code guidelines. the button will redirect the user to the guidelines

Please Post the paypal acc ID of ozgrid so that I will go ahead with the payment

[ATTACH=CONFIG]61950[/ATTACH][ATTACH=CONFIG]61949[/ATTACH]

Posting vba file and employee master in the next comment.

Re: $15 Database addition to VBA and userform already created

forum.ozgrid.com/index.php?attachment/61707/ 1st file named job card has a userform and vba in which database from the other file needs to be added and minor changes needs to be done in the userform. Please have a look and reply back.

Quote from KjBox;722258

I will take a look at a sample workbook if you can attach one, clearly show or explain your desired result.

I have a Excel VBA file in which I want database to be added and linked to a userform already created.

Minor changes in the userform needs to be made accordingly.

I am willing to pay $15 for the same.

Deadline is of 1 week.

Interested developer please reply

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

emptied inbox

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

Thanks Anthony. Good work

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

OK. Please fix 1st one.

For 3rd:
Every time user will have to check if entry is there or not. I am attaching 1 file. I want edit/add functionality like that is there in this file. forum.ozgrid.com/index.php?attachment/61282/. when system comes across the entry for with same concept and employee ID with the same date as on today, it will automatically capture the values already present in the dump and appear in the userform fields.

Quote from smuzoen;718771

I can fix No 1.
2. You never asked for 24 hour time - it was set up as 12 hour time - you should have asked for this in your specifications. I am not going to recode the workbook for that change as it was not part of your specifications
For 3 if you enter the Concept and employee ID then you hit the Add/Edit button and the form will populate with data if there is an entry in the worksheet. Just select a Concept and add the Employee ID and hit Add/Edit and the workbook will populate. That is the functionality you listed under the Add/Edit button in your post above.

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

Changes required

1. start time if greater than end time... error should pop up on clicking edit add

2. If u can make start time & end time 24hr clock type it would be appreciated

3. There is no option to edit/add button. Once U add concept and employee ID on the same day the details should automatically pop up in the userform which gives entry operator freedom to edit details on the same day.

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

For any concept only 1 entry allowed for a particular employee ID on a particular day.

Quote from smuzoen;718344

All of that is fine - only one question:

What if there are more than 1 entry for Concept, Employee ID on the same day or will there ONLY EVER be ONE entry for Concept + Employee ID on a single day?

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

Add/Edit button will reset the userform & user keeps on adding entire data of all employees. then finally hits close. then Read only dump file will appear.

Re: Help for creating a VBA code to enter data into dump file from userform. US$30

Mandatory fields: 1. Concept 2. Employee ID 3. Employee Name 4. supplier 5. Atleast 1 activity out of 20 (IN1, IN2,....) with all 3 values i.e. quantity (whole no, no decimals), Start time, end time.

Optional Fields: remaining 19 activities.

Command Buttons:

Add/Edit: When I hit ADD/Edit details are added into dump file if all mandatory fields are filled. On the same day if I want to edit details of particular employee I just will add Concept, Employee ID, remaining details (entered on the same day earlier) will appear into the userform so that I can edit them. After editing them hitting ADD/edit will update the details into the dump file.

Clear:
Clearing the values entered into userform.

Close:

Closes the userform. and dump file will appear to the user. Dump file Should Be Read Only.