Search results

Hello, I now have the basic structure in access. please see attached snapshot. i was actually trying to follow the comments posted before. but did not understand. please let me know as how to start from here. i should be able to register the new sample with qty, then reduce the qty if the...

Hello arnelgp, Galaxiom, i am trying with your suggestions. since things are new i am taking more time to fix it on my screen. will post if i am unable to fix it on my own. arnelgp, like before i may ask some basic questions again, so please be kind to me :) Thanks both

Hello Galaxiom, yes, i can group In and out table. aggregate query, just saw few examples on google. As i am new to access programming, unable to understand the trick. Can you support here pls. may be a sample code with major steps.

Hello, I am responsible for managing the sample stock and finding it difficult to find what sample went out and when and which sample came in to store. want to create a access data base to record the information. I have created a table with the fields below for material entry. Lab_Sample_ID...

not sure Minty, i am using SAP logon 740.

i Have Change_Number and Change_Description on the access form which should be copied to SAP CC01. Also add valid from date field in SAP. Request you to post some script which will help me to do this. Thanks

Hello Ranman, The table is not linked to SAP. Yes, i want to input data using SAP front end. Thanks

Hello, I have a access table which is storing the change number and description and would like to link that with SAP transaction cc01. on click of add change number in the access form, it should auto-logon to SAP and copy the change number and description from the form and create the change...

ok, one observation from my side. the numbers are getting incremented on form close and open. but in actual the number should not change until it is saved to the database. I am saving the data with the add new record button.

supper master, now it works. looks like it was a problem with the module. i have it on the form page code and it works sweet.

My understanding is that every time I open the form I see the new change number I the field and I need to update the description to add new record. 1. I did add a button and changed to add new record, does not work. 2. I don't see the incremental value in the field when I open the form. Sorry...

:( does not work, i have inserted 2 records manually in the table A002AA414A/ sample 1 A002AA415A/ sample 2 i can only see these 2 records on the form.

sorry master, i forgot to mention that. i did use your code. while posting i used the latest one. i could see the same error. I also have your code mapped in the module. After the recent changes. in both the cases, the form is blank. does not show up any value.

:), missed it, now you can find the attachment.

Hello arnelgp, June7, I have attached the snapshot of the changes i have made. Hope we can figure out what went wrong. thanks for your support until now

Ya, I know. Auto will help. It's a guideline to follow this format. Also want to link this to SAP change number creation. :)

If you can post some solution to my requirement, it would be of great help. Thanks

It's self initiative to bring in some improvement. Want to change from excel to access and learn also opportunity to learn new things.

This is taken care. I have used underscore as separator. May be I can share the snap shots tomorrow.

Yes, I have made necessary changes to the code posted on this site. I.e changed the table name as change number and field name as change no