Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 14 of 14
Search took 0.01 seconds.
Search: Posts Made By: utarian
Forum: Access VBA April 6th, 2005, 08:18 PM
Replies: 4
Views: 1,325
Posted By utarian
hi mmcdonal, ok, now i want to do adding new...

hi mmcdonal,
ok, now i want to do adding new record. In the form there have several textboxes in the main form and also a subform with several textboxes inside. All textboxes are UNBOUND... (include...
Forum: Access VBA April 6th, 2005, 10:19 AM
Replies: 4
Views: 1,325
Posted By utarian
hi mmcdonal, Thanks for your reply. i dont know...

hi mmcdonal,
Thanks for your reply. i dont know much about VBA as i m new to access.
i wrote the codes as below, with those codes i am just able to do inserting for the main form...
Forum: Access VBA April 5th, 2005, 11:08 PM
Replies: 4
Views: 1,325
Posted By utarian
SQL for subforms

hi,
i have created a form with a subform. how do i write the SQL statement in the procedures code for ADD button? how do i insert into two tables at once?
Thanks in advance.
Forum: Access March 28th, 2005, 09:42 PM
Replies: 2
sum
Views: 1,208
Posted By utarian
Thanks Mihai B , i got it

Thanks Mihai B , i got it
Forum: Access March 28th, 2005, 04:16 AM
Replies: 2
sum
Views: 1,208
Posted By utarian
sum

hi,
I have a table with 2 fields here : ID , Number
how can i sum up the Number where by the ID is the same in a query?

For example:

ID Number
------- -------
A 5
B ...
Forum: Access March 28th, 2005, 02:24 AM
Replies: 2
Views: 3,680
Posted By utarian
Thanks a lot for your help Uncle Gizmo

Thanks a lot for your help Uncle Gizmo
Forum: Access VBA March 28th, 2005, 12:42 AM
Replies: 13
Views: 2,289
Posted By utarian
hi savi317, Thanks for your reply. For yr...

hi savi317,
Thanks for your reply.
For yr question, it would be A00010.
Basically i know what are you talking about in that principle. I am a new learner of access so I still dont know what I have...
Forum: Access VBA March 27th, 2005, 11:59 PM
Replies: 13
Views: 2,289
Posted By utarian
hi SerranoG, Thanks for your reply. I have to...

hi SerranoG,
Thanks for your reply.
I have to put it backwords because in the default value in the property of that textbox I set it as "=GetNextNum()" and then I save the newly generated document...
Forum: Access VBA March 24th, 2005, 12:00 AM
Replies: 13
Views: 2,289
Posted By utarian
Thanks SerranoG.. Now I have applied the...

Thanks SerranoG..

Now I have applied the NewDocNo, but i got the error 13 : type mismatch.

NewDocNo = DMax("DocNo", "receive") + 1
GetNextNum = "A" + Format(NewDocNo, "00000")

I declare the...
Forum: Access VBA March 22nd, 2005, 11:11 PM
Replies: 13
Views: 2,289
Posted By utarian
i have successfully generated the continuously...

i have successfully generated the continuously number by using Dmax function, but i dont know how to set the format to "A00001"..
anyone can help me plz?

the function looks like this:...
Forum: Access VBA March 22nd, 2005, 09:00 PM
Replies: 13
Views: 2,289
Posted By utarian
Thank you SerranoG

Thank you SerranoG
Forum: Access VBA March 20th, 2005, 08:18 PM
Replies: 13
Views: 2,289
Posted By utarian
Thanks for your replies

Thanks for your replies
Forum: Access VBA March 16th, 2005, 08:08 PM
Replies: 13
Views: 2,289
Posted By utarian
why the autonumber cant display as what i have set

hi,

I have put the format of an autonumber as "A0000" , in the table the results are "A0001, A0002 ....(and so on)" when i bound to a form it will display only "1, 2 ... (and so on)". Why i...
Forum: Access March 15th, 2005, 03:59 AM
Replies: 2
Views: 3,680
Posted By utarian
auto generate an number

hi,
I am creating a system by using A2k. I want to assign a document number (sample : A001) to each record that has been added. Is there any way to auto generate a document number in access? which...
Showing results 1 to 14 of 14

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.