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 32
Search took 0.01 seconds.
Search: Posts Made By: Derek_05
Forum: Visual Basic 2005 Basics September 19th, 2006, 05:22 AM
Replies: 3
Views: 4,564
Posted By Derek_05
Hi Brian, Thanks for your reply, i have gone...

Hi Brian,

Thanks for your reply, i have gone into the enterprise manager and granted access to my username on the domain. however i still cannot access it. I hav also shared the MS SQL Server...
Forum: Visual Basic 2005 Basics September 15th, 2006, 07:29 AM
Replies: 3
Views: 4,564
Posted By Derek_05
VB 2005 connect to server 2003 with SQL database

Hi there,

I wanted to ask whether it is a limitation of VB 2005 or am i doing something wrong? I basically am trying to from connect from a PC (PC1) to a .MDF database on a server (running MS...
Forum: Excel VBA July 9th, 2006, 05:29 PM
Replies: 1
Views: 4,560
Posted By Derek_05
Automate 'Merge and Center' in VB

Hi there,

Does anyone know whether it is possible to automate Excels 'Merge and Center' cells function in Visual Basic?

I have a daily report imported in html format, and when this is cut and...
Forum: Access VBA June 23rd, 2006, 08:00 AM
Replies: 2
Views: 1,202
Posted By Derek_05
Date problem

Hi there

I am having a problem where the following coding

NextMonth = DateAdd("m", 1, (date))

works on all computers but one. when the code executes i get the following eror:

Complie...
Forum: Access VBA June 1st, 2006, 03:22 AM
Replies: 3
Views: 1,716
Posted By Derek_05
Hi echovue, the _SMDBA_._COMPANY_ table is a...

Hi echovue,

the _SMDBA_._COMPANY_ table is a linked table from an external sql database. I currently have my fields from that table in my forms and are updated. I can add new records if I open the...
Forum: Access VBA May 31st, 2006, 01:54 PM
Replies: 3
Views: 1,716
Posted By Derek_05
Im sorry I forgot to say thank you to anyone who...

Im sorry I forgot to say thank you to anyone who may shed some light on this. I hit the post button instead of preview.

anyway...

Any help or advice will be greatly appreciated, thanks for your...
Forum: Access VBA May 31st, 2006, 01:51 PM
Replies: 3
Views: 1,716
Posted By Derek_05
Create record in linked SQL table

Hallo,

I wanted to ask what code is required to create new records in a linked SQL table using Visual Basic. I can retreive specific data and append it but cant create new records. here is what i...
Forum: Excel VBA May 31st, 2006, 01:25 PM
Replies: 5
Views: 6,159
Posted By Derek_05
thats excellent jrogers, thanks very much for...

thats excellent jrogers, thanks very much for your time and help!!!
Forum: Excel VBA May 31st, 2006, 11:01 AM
Replies: 5
Views: 6,159
Posted By Derek_05
Hi jrogers, Its on just 1 sheet, thank you.

Hi jrogers,

Its on just 1 sheet, thank you.
Forum: Excel VBA May 31st, 2006, 05:55 AM
Replies: 5
Views: 6,159
Posted By Derek_05
Import Excel data into a workbook

Hallo,

I want to ask how one can import data from a workbook (.xls) that is not open into another currently working workbook with visual basic. So far I have only managed to look for the file and...
Forum: Access VBA March 24th, 2006, 01:27 PM
Replies: 1
Views: 1,639
Posted By Derek_05
VB SQL search similar records

Hi there

I am trying to seach for similar records in a database, so for example, if the user searches for 'Dere'
it will return records that are similar like:

Derrick
Dereck
Derick
Derik
Forum: VB Databases Basics March 6th, 2006, 01:50 PM
Replies: 1
Views: 1,079
Posted By Derek_05
Sorry, when I said that it only works for some...

Sorry, when I said that it only works for some UserName values, i was referring to the synchronization. The procedure retrieves the wrong record for some and works fine for others. I have tested this...
Forum: VB Databases Basics March 6th, 2006, 01:45 PM
Replies: 1
Views: 1,079
Posted By Derek_05
FindFirst retrieves wrong record

Hi there,

I have the following code to sync the 'Detailed User Report ALL' form with the selected Username in the combo box in the 'main menu' form, which you then click to sync.

...
Forum: Beginning VB 6 February 20th, 2006, 11:40 AM
Replies: 1
Views: 1,709
Posted By Derek_05
Visual Basic & Sage

Hello,

Is it possible to use VB6 to show record data from Sage?
I read that u can intergrate VB in Sage but is it possible to pull data from Sage itself?
Thank you, your help and advice is much...
Forum: Access VBA February 14th, 2006, 01:36 PM
Replies: 1
Views: 1,737
Posted By Derek_05
change the 'From...' field in email

Hi there,

I wanted to ask whether it is possible to change the senders email address in Access VB when sending emails from VB in Access?

Thank you

Derek
Forum: Access February 7th, 2006, 06:59 AM
Replies: 4
Views: 2,132
Posted By Derek_05
oh and when I open the mdb again its in read only...

oh and when I open the mdb again its in read only state. just tested it. thank you
Forum: Access February 7th, 2006, 06:57 AM
Replies: 4
Views: 2,132
Posted By Derek_05
.mde problem

Hello,

I am trying to convert my .mdb > .mde and have 'converted it to 02/03' version as well as 'compacted and repaired'. It is free from compile errors and I get no message saying that it cannot...
Forum: Access February 2nd, 2006, 08:47 AM
Replies: 8
Views: 2,373
Posted By Derek_05
Hi again... After doing some reading on...

Hi again...

After doing some reading on SQL/Query updates I have got my forms/subforms to allow update now based on the Query. The cause of my problem was beacuse the SQL design had more than 3...
Forum: Access February 2nd, 2006, 05:18 AM
Replies: 8
Views: 2,373
Posted By Derek_05
Sorry Loralee, I am using Access '03, but...

Sorry Loralee,

I am using Access '03, but the .mdb is in 2000 format.

Del
Forum: Access February 2nd, 2006, 05:16 AM
Replies: 8
Views: 2,373
Posted By Derek_05
Hi all Thanks for taking time to reply. Im...

Hi all
Thanks for taking time to reply. Im very sorry to hear that you all have the same problem without any solutions to it.

I have however found the cause of my problem. The Query!
Data was...
Forum: Access February 1st, 2006, 11:54 AM
Replies: 8
Views: 2,373
Posted By Derek_05
subform update problem

Hi,

I am having problems with updating my database from a subform derived from a Query. It worked fine before and previous versions work fine also. But all of a sudden editing just suddenly isnt...
Forum: Access VBA January 19th, 2006, 09:35 AM
Replies: 2
Views: 1,983
Posted By Derek_05
could it be the anti-virus application running...

could it be the anti-virus application running with an email-related component that blocks scripting?

Would that block the CreateObject?

because my Firewall/AV software has this:
EMON (Email...
Forum: Access VBA January 19th, 2006, 09:25 AM
Replies: 2
Views: 1,983
Posted By Derek_05
Outlook '03 automation from Access '03 error

Hello,
I am running into problems with creating a new outlook session where i get the error message:

Run-time error '-2147024770 (8007007e)':
Automation error
The specified module could not be...
Forum: Access VBA January 17th, 2006, 10:54 AM
Replies: 1
Views: 950
Posted By Derek_05
Hi there, I have found the solution to my...

Hi there,

I have found the solution to my problem:
created a sub with timer to delay program and refreshed it there.
works fine now. thanks and sorry for the post.

Derek
Forum: Access VBA January 17th, 2006, 09:39 AM
Replies: 1
Views: 950
Posted By Derek_05
splash form property changes problem

Hi again,
im sorry, but i have yet encountered another problem.

Basically I made a form when upon loading calls a set of sub-routines to update the DB, each routine is a task that is reflected...
Showing results 1 to 25 of 32

 


All times are GMT -4. The time now is 10:09 AM.


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