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 | 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 25 of 51
Search took 0.01 seconds.
Search: Posts Made By: sdilucca
Forum: Oracle June 15th, 2007, 08:43 AM
Replies: 1
Views: 3,608
Posted By sdilucca
by the way, the relational database management...

by the way, the relational database management system is ORACLE RDB.

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
Forum: Oracle June 15th, 2007, 08:23 AM
Replies: 1
Views: 3,608
Posted By sdilucca
MSAccess pass-through query to Oracle ODBC

I connected to an ORACLE ODBC using MS Access. I am creating pass-through queries in MS Access. I understand that the SQL used in MS Access is different from ORACLE SQL. All I want my query to due...
Forum: Access February 23rd, 2006, 12:28 PM
Replies: 1
Views: 1,716
Posted By sdilucca
Linked Table

Is there any way to edit the path of a linked table?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
Forum: Access February 22nd, 2006, 12:07 PM
Replies: 1
Views: 1,318
Posted By sdilucca
Importing Delimited Text

Certain values are missing when I import a pipe-delimited text file into access. I don't understand why this is happening. It works fine when I delimit the text in Excel. Why would Access omit...
Forum: Access VBA August 11th, 2005, 02:44 PM
Replies: 12
Views: 2,952
Posted By sdilucca
actually have you tried to requery right at the...

actually have you tried to requery right at the end of your code under the NotInList event?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
Forum: Access VBA August 11th, 2005, 02:39 PM
Replies: 12
Views: 2,952
Posted By sdilucca
have you tried to requery on Before Update? ...

have you tried to requery on Before Update?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
Forum: Access VBA August 11th, 2005, 02:03 PM
Replies: 12
Views: 2,952
Posted By sdilucca
i don't see what the purpose of rlRecordSet is. ...

i don't see what the purpose of rlRecordSet is. I figured you were going to make it the RowSource for your combobox. But I don't see you doing that. Does anything actually change when you run this...
Forum: Access VBA August 11th, 2005, 01:42 PM
Replies: 12
Views: 2,952
Posted By sdilucca
i know this is kind of getting of the subject,...

i know this is kind of getting of the subject, but i guess i have the right to learn too :-) .... what is the purposed of cmdCommand? I never actually see you use it? still working on ur stuff
...
Forum: Access VBA August 11th, 2005, 12:32 PM
Replies: 12
Views: 2,952
Posted By sdilucca
show me your GetRecords code Julio Cesar ...

show me your GetRecords code

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
Forum: Access VBA August 11th, 2005, 10:45 AM
Replies: 12
Views: 2,952
Posted By sdilucca
you should requery your controls if you change...

you should requery your controls if you change the data behind them. are you doing that?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
Forum: Access August 11th, 2005, 10:19 AM
Replies: 14
Views: 2,256
Posted By sdilucca
dude... i kind of replicated your database and...

dude... i kind of replicated your database and form... my previous suggestion seems to work just fine, and you don't need any vba... what's ur status?

Julio Cesar

-"Bueller.............
Forum: Access August 11th, 2005, 10:02 AM
Replies: 14
Views: 2,256
Posted By sdilucca
quick try..... have you tried to set the 'default...

quick try..... have you tried to set the 'default value' property of the idUser textbox (you should have this, even if you have to hide it) to the idUser on the main form. ei....
Forum: Access August 11th, 2005, 09:36 AM
Replies: 14
Views: 2,256
Posted By sdilucca
dude... i think you should VBA this... I have had...

dude... i think you should VBA this... I have had instance where i used subforms to show attributes of an entity... the way i added additional attributes was using VBA to copy the ID value in the...
Forum: Access August 11th, 2005, 09:26 AM
Replies: 14
Views: 2,256
Posted By sdilucca
the subform is being fed by tblUser2Role right? ...

the subform is being fed by tblUser2Role right?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
Forum: Access August 11th, 2005, 09:15 AM
Replies: 14
Views: 2,256
Posted By sdilucca
ok... are you using a combobox in your main form...

ok... are you using a combobox in your main form and that filters the subform?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
Forum: Access August 11th, 2005, 08:55 AM
Replies: 14
Views: 2,256
Posted By sdilucca
are you normalizing your data? what i mean is... ...

are you normalizing your data? what i mean is... ei. is your tblUsers consisting of idUser (a number) and txtUser (actual text)? The same scheme for tblRoles. Then you just refer to the ID's in the...
Forum: Access August 11th, 2005, 08:39 AM
Replies: 14
Views: 2,256
Posted By sdilucca
are you using VBA at all? Julio Cesar ...

are you using VBA at all?

Julio Cesar

-"Bueller.......... Bueller.......... Bueller.......... Bueller.........."
Forum: Access August 11th, 2005, 08:25 AM
Replies: 14
Views: 2,256
Posted By sdilucca
that M2M relationship doesn't sound kosher to me....

that M2M relationship doesn't sound kosher to me. Assuming that the table that links users and roles is called tblUserRoles, then... i feel you should have a 12M between tblUser and tblUserRole,...
Forum: MySQL August 9th, 2005, 03:09 PM
Replies: 6
Views: 1,772
Posted By sdilucca
order of operations shouldn't matter... (X*7)/47...

order of operations shouldn't matter... (X*7)/47 = (X/47)*7 ..... What exactly is it you are looking for? Do you just want the currency symbols? Ellaborate.

Julio Cesar
...
Forum: VB Databases Basics August 9th, 2005, 02:36 PM
Replies: 4
Views: 909
Posted By sdilucca
a recordset is a "thingy" in programming that you...

a recordset is a "thingy" in programming that you instantiate and can make it take the shape/identity of an existing table in access. The recordset behaves pretty much like the table. It has rows...
Forum: SQL Language August 9th, 2005, 01:08 PM
Replies: 2
Views: 1,192
Posted By sdilucca
ok... i'm going to take a crack at this... I...

ok... i'm going to take a crack at this...

I have used the expression "COUNT(distinct" in the past and it has given me problems. Maybe it's not giving you problems. Not sure.

I would use the...
Forum: Access VBA August 8th, 2005, 03:26 PM
Replies: 2
Views: 1,687
Posted By sdilucca
you should check out the msdn link ...

you should check out the msdn link

http://support.microsoft.com/default.aspx?scid=kb;en-us;202563

Julio Cesar

-"Life is a Database"
Forum: Access August 8th, 2005, 01:37 PM
Replies: 7
Views: 19,205
Posted By sdilucca
sounds to me like you'd need to store Inches per...

sounds to me like you'd need to store Inches per Character instead of Characters per Inch in order for bytWidth to give you an actual length. What do you think?

"Life is a Database"
Forum: Access VBA August 4th, 2005, 12:58 PM
Replies: 3
Views: 1,567
Posted By sdilucca
are you sure you're not mixing up which...

are you sure you're not mixing up which database/table has which fields? I tried your code and it works. Also, make sure you have DAO library loaded in your References.

"Life is a Database"
Forum: Access August 4th, 2005, 11:00 AM
Replies: 11
Views: 1,733
Posted By sdilucca
actually, now that i think about it... splitting...

actually, now that i think about it... splitting up this particular table does have undisputable advantages. You need a foreign-key to prevent a manager w/ subordinates from being deleted. You...
Showing results 1 to 25 of 51

 


All times are GMT -4. The time now is 08:18 AM.


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