Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | 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 25 of 53
Search took 0.01 seconds.
Search: Posts Made By: damnnono_86
Forum: Access January 27th, 2004, 10:47 PM
Replies: 1
Views: 1,284
Posted By damnnono_86
update records error

I've got a form on which I use a combo box to assign the value to the textfields... I want to allow user to edit the records in the database using this form.

it works fine... but for some reason,...
Forum: Access December 28th, 2003, 10:18 PM
Replies: 1
Views: 1,256
Posted By damnnono_86
check subform fields

hi, how do i check if the fields in the subform is empty???

pls advice
nono
Forum: Access November 28th, 2003, 04:43 AM
Replies: 23
Views: 5,792
Posted By damnnono_86
switchboard error

hi,

i have a database and i created a switchboard. but whenever i exit from the switchboard, an error msg will appear.

msg displayed:

You can't exit microsoft access now.
If you are...
Forum: Access November 28th, 2003, 04:39 AM
Replies: 2
Views: 948
Posted By damnnono_86
time displayed

hi,

how can i retrieve the time to display as 11.30.29am in the manner of hour.minute.seconds format??? i want it to be 11.30.29am not 11:30:29am.


pls advice
nono[?]
Forum: Access November 16th, 2003, 10:47 PM
Replies: 10
Views: 6,126
Posted By damnnono_86
hi, i have try the method ... regarding the...

hi,

i have try the method ... regarding the "AllowBypassKey"

but how do i use the special keys (eg.shift key) to open the database???

pls guide me.
nono
Forum: Access November 16th, 2003, 09:51 PM
Replies: 2
Views: 1,945
Posted By damnnono_86
hi, yes, your methods works!! thanks!! ...

hi,

yes, your methods works!! thanks!!

cheers,
nono
Forum: Access November 14th, 2003, 05:12 AM
Replies: 2
Views: 1,945
Posted By damnnono_86
print form

hi,

i have a form which i have created; the width is too wide so whenever i want to print the form in ONE page, i have to go to change the settings before i print. how can i fixed the printing...
Forum: Access November 13th, 2003, 11:45 PM
Replies: 10
Views: 6,126
Posted By damnnono_86
hi creating mde file is a good one. i have...

hi

creating mde file is a good one. i have another question that pops up on my mind when trying the methods..

this database are meant for normal users (those who have no access to coding/tables...
Forum: Access November 13th, 2003, 10:09 PM
Replies: 10
Views: 6,126
Posted By damnnono_86
hi U.N.C.L.E., i have heard alot of people...

hi U.N.C.L.E.,

i have heard alot of people saying abt the shift key, could u tell me how can the shift key be used to bypass the autoexec function????

and of course could u guide me on the VBA...
Forum: Access November 12th, 2003, 11:18 PM
Replies: 10
Views: 6,126
Posted By damnnono_86
prevention of edit forms/tables

hi

how do i prevent user from entering into the 'design view', 'datasheet view' of my form??? how can i prevent them for entering to the database window (where you can choose to create table in...
Forum: Access November 10th, 2003, 10:32 PM
Replies: 6
Views: 3,256
Posted By damnnono_86
hi Mixirica, thanks, your method really...

hi Mixirica,

thanks, your method really works! bravo!!!

cheers
nono
Forum: Access November 5th, 2003, 04:07 AM
Replies: 3
Views: 1,394
Posted By damnnono_86
hi all, the problem is solved by using...

hi all,

the problem is solved by using DLookup.
Your help is greatly appreciated.

Cheers!
nono
Forum: Access November 3rd, 2003, 10:35 PM
Replies: 3
Views: 1,394
Posted By damnnono_86
hi, in my branchtable, i have : -...

hi,

in my branchtable, i have :
- branchCode (pk)
- branchName

in my staff_table, i have : (these are the fields that will be on my main form)
- staff id
- name
- contact no
Forum: Access November 3rd, 2003, 05:35 AM
Replies: 3
Views: 1,394
Posted By damnnono_86
fields from tables to update

hi all,

i have a form where there are fields like name, id (staff_table), Accountno (staff_Account_Table), branch code (Branch_Table) etc. they are from 3 different tables.

the form will have...
Forum: Access November 2nd, 2003, 09:37 PM
Replies: 6
Views: 3,256
Posted By damnnono_86
hi i dont see a need in the filter to be place on...

hi i dont see a need in the filter to be place on the after event of my primary key becoz in my situation, the data is already filter properly and the only thing i want to solve is to actually inform...
Forum: Access October 30th, 2003, 10:52 PM
Replies: 6
Views: 3,256
Posted By damnnono_86
hi, i am not checking if my subform has any data...

hi, i am not checking if my subform has any data anot. i actually wanted to check if there are any records in my database. if records matches then it will display otherwise an error msg will be...
Forum: Access October 29th, 2003, 09:52 PM
Replies: 6
Views: 3,256
Posted By damnnono_86
record source

hi,

how do i check if a record source is blank???

pls advice
nono
Forum: Access October 29th, 2003, 09:17 PM
Replies: 4
Views: 856
Posted By damnnono_86
yes sal, the commission will increased as...

yes sal,

the commission will increased as time goes.
and i have 2 tables and now the problem is solved by just grouping up the primary keys together to get the sum of commission.


thanks...
Forum: Access October 29th, 2003, 05:04 AM
Replies: 4
Views: 856
Posted By damnnono_86
query

HI

how do i create a query where i want a sum of commission of a particular person?

eg of records.
personID = 123456
salary = 3000
commission = 100 (one row in CommTable)
commission = 200...
Forum: Access October 29th, 2003, 02:48 AM
Replies: 7
Views: 1,425
Posted By damnnono_86
hi, - the importing will be done frequently...

hi,

- the importing will be done frequently almost everyday.
- it will not be the same excel file.
- automate in the sense that when the user want to import the file, he will go to the import...
Forum: Access October 28th, 2003, 11:26 PM
Replies: 7
Views: 1,425
Posted By damnnono_86
hi sal, no that is not what i want. i do...

hi sal,

no that is not what i want. i do not want the linking to be done manually. i want it to be base on a command button click. when the user click on the command button-import, the system...
Forum: Access October 28th, 2003, 09:15 PM
Replies: 7
Views: 1,425
Posted By damnnono_86
hi sal, i am importing excel files. as u...

hi sal,

i am importing excel files. as u have mention as to link instead of importing. if i do the linking of files, then will the data still be inserted into the database if no matches were...
Forum: Access October 28th, 2003, 05:01 AM
Replies: 7
Views: 1,425
Posted By damnnono_86
Table comparison

hi,

i have a database where i want to import files into my table.
however it is hard to stop the user from importing the same data. so i would need to import all the data into a temp table,...
Forum: Access October 28th, 2003, 02:17 AM
Replies: 5
Views: 2,284
Posted By damnnono_86
u really read my mind. Got it! my radio...

u really read my mind.

Got it! my radio button works now!!!

thanks!!!
nono:D
Forum: Access October 27th, 2003, 11:48 PM
Replies: 3
Views: 1,753
Posted By damnnono_86
hi sal, i have 2 radio button and 2 textbox...

hi sal,

i have 2 radio button and 2 textbox which is link to the radio button.
when the user click on radio button 1, the first textbox will be enable for user to enter the search criteria. after...
Showing results 1 to 25 of 53

 


All times are GMT -4. The time now is 03:04 AM.


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