Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 14 of 14
Search took 0.02 seconds.
Search: Posts Made By: utarian
Forum: Access VBA April 6th, 2005, 08:18 PM
Replies: 4
Views: 1,156
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,156
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,156
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, 08:42 PM
Replies: 2
sum
Views: 1,070
Posted By utarian
Thanks Mihai B , i got it

Thanks Mihai B , i got it
Forum: Access March 28th, 2005, 03:16 AM
Replies: 2
sum
Views: 1,070
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 2
Forum: Access March 28th, 2005, 01:24 AM
Replies: 2
Views: 3,506
Posted By utarian
Thanks a lot for your help Uncle Gizmo

Thanks a lot for your help Uncle Gizmo
Forum: Access VBA March 27th, 2005, 11:42 PM
Replies: 13
Views: 2,051
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 to...
Forum: Access VBA March 27th, 2005, 10:59 PM
Replies: 13
Views: 2,051
Posted By utarian
hi SerranoG, Thanks for your reply. I have to put...

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 23rd, 2005, 11:00 PM
Replies: 13
Views: 2,051
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, 10:11 PM
Replies: 13
Views: 2,051
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...
Forum: Access VBA March 22nd, 2005, 08:00 PM
Replies: 13
Views: 2,051
Posted By utarian
Thank you SerranoG

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

Thanks for your replies
Forum: Access VBA March 16th, 2005, 07:08 PM
Replies: 13
Views: 2,051
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, 02:59 AM
Replies: 2
Views: 3,506
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

 


All times are GMT -4. The time now is 08:56 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.