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 24 of 24
Search took 0.01 seconds.
Search: Posts Made By: ermy78
Forum: SQL Server 2005 February 19th, 2008, 02:55 PM
Replies: 2
Views: 2,124
Posted By ermy78
Forgot to post the error: Alter failed fo...

Forgot to post the error:
Alter failed fo rDatabase 'OPC' (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.connectionInfo)...
Forum: SQL Server 2005 February 19th, 2008, 02:43 PM
Replies: 2
Views: 2,124
Posted By ermy78
Mirroring SQL 2005

I've setup the mirroring and everytime I try to connect it says it can't establish a connection. I verified that the Database Mirror Endpoints are listening by running "netstat -a". however, the...
Forum: SQL Server 2005 February 18th, 2008, 02:41 PM
Replies: 0
Views: 967
Posted By ermy78
Automatic history removal

I've been having a problem with SQL Server Agent, the log files are growing too big for the local partition. I know I need to put them on another non-critical partition and am in the process of...
Forum: Access December 18th, 2006, 06:32 PM
Replies: 13
Views: 2,257
Posted By ermy78
Try picking the first ISBN and verify that the...

Try picking the first ISBN and verify that the FindFirst function works. Say your ISBN is 1234, do rst.FindFirst("1234")
see if it'll bring up your entry. Also, put your ISBN in the watch window and...
Forum: Access December 18th, 2006, 06:19 PM
Replies: 2
Views: 1,215
Posted By ermy78
It Does indeed. Thanks mmcdonal :)

It Does indeed. Thanks mmcdonal :)
Forum: Access December 15th, 2006, 02:47 PM
Replies: 13
Views: 2,257
Posted By ermy78
rst.FindFirst calls for a string. Try creating a...

rst.FindFirst calls for a string. Try creating a string variable and type

strISBN = [ISBN]
rst.FindFirst(strISBN)


That should work.
Forum: Access December 15th, 2006, 12:31 PM
Replies: 13
Views: 2,257
Posted By ermy78
To lookup the information I would have them type...

To lookup the information I would have them type the ISBN into the text box. Your code would then be:

rst.FindFirst([ISBN])
[Title] = rst("Title")
'etc.

rst.close

As for the rst.Edit...
Forum: Access December 15th, 2006, 11:49 AM
Replies: 13
Views: 2,257
Posted By ermy78
Since your form is not directly tied to the...

Since your form is not directly tied to the table, all you have to do is after rst.close (before end sub) set all of your fields = to NULL or False i.e.

[customer #] = NULL
[Order #] = NULL...
Forum: Access December 15th, 2006, 10:35 AM
Replies: 13
Views: 2,257
Posted By ermy78
I would make the form access the table...

I would make the form access the table indirectly. Add buttons for them to click through the records like I was saying in the second post. To add records you would use the code in the first post. To...
Forum: Access December 14th, 2006, 09:57 PM
Replies: 13
Views: 2,257
Posted By ermy78
I just thought of another thing, if you want to...

I just thought of another thing, if you want to use just one table, you could use record navigation/search buttons to access one database but it would not write to it unless they click the button I...
Forum: Access December 14th, 2006, 09:44 PM
Replies: 13
Views: 2,257
Posted By ermy78
If you don't directly access your table with the...

If you don't directly access your table with the form, meaning you use code to write to it, you can have a button that updates the entries into the database. I did this with two separate databases....
Forum: Access December 14th, 2006, 09:09 PM
Replies: 2
Views: 1,215
Posted By ermy78
visibility dynamic in report

Hello all,
I've got a report I have setup to create labels. In the detail section I have 4 text boxes setup as following:
'''''''''Device Header''''''''''''''''''''''''''''''
Name
Location
Text1...
Forum: Access December 14th, 2006, 12:49 PM
Replies: 17
Views: 2,164
Posted By ermy78
I'm not sure that + works in Access, that was a...

I'm not sure that + works in Access, that was a typo I missed when posting. Sorry about that. I've got it 95% worked out now. Just playing with some visibility and I'll be done. I appreciate all your...
Forum: Access December 13th, 2006, 05:01 PM
Replies: 17
Views: 2,164
Posted By ermy78
Each Device/Type combo will have at minimum 1...

Each Device/Type combo will have at minimum 1 Tag/Comm but could be up to 4.

Here's what I have setup.
tblDevice
DeviceID = PK
Type - text


tblDevice+AllInfo
DeviceID
Forum: Access December 13th, 2006, 04:25 PM
Replies: 17
Views: 2,164
Posted By ermy78
Okay. I've created the table with only the...

Okay. I've created the table with only the Device/Type. I did a lookup and now I'm using Tag as the unique identifier (some tags share comm's) and labled it Tag. I now have a drop down list (combo...
Forum: Access December 13th, 2006, 04:00 PM
Replies: 17
Views: 2,164
Posted By ermy78
No, they're not lookups. I don't know how to do...

No, they're not lookups. I don't know how to do that yet. There's a max of 4 tags/comms per Device/type pair. If there's an easy way to make it a lookup I'd be more than happy to design it that way.
Forum: Access December 13th, 2006, 03:45 PM
Replies: 17
Views: 2,164
Posted By ermy78
Not really. I already tried using the shrink...

Not really. I already tried using the shrink property. How would I go about using code and temporary table?
Forum: Access December 13th, 2006, 12:51 PM
Replies: 17
Views: 2,164
Posted By ermy78
The label is setup to receive 4 lines. I figured...

The label is setup to receive 4 lines. I figured out how to group like you said mmcdonal. Thank you :) but that does not completely solve my problem (another one arose in the process). I have labels...
Forum: Access December 13th, 2006, 10:20 AM
Replies: 17
Views: 2,164
Posted By ermy78
Grouping Within a Report for labels

Hi all,
I've got a question that's been a bit difficult for me to figure out. I've got a table structure like the following:

Device Type Panel Tag Location Comm
Yellow ...
Forum: Access VBA October 20th, 2006, 08:58 AM
Replies: 3
Views: 67,301
Posted By ermy78
strDevice = Array("CS", "CS-A", "CS-B", "CS-C",...

strDevice = Array("CS", "CS-A", "CS-B", "CS-C", "CS-D", "CS-E", "CS-F", "IO", "IO-A", "IO-B")

Each value of the array (CS, CS-A, etc.) is a field (combo box) in form A and also a column in table...
Forum: Access VBA October 19th, 2006, 04:44 PM
Replies: 3
Views: 67,301
Posted By ermy78
Switch Case statements

Is there a way to do a switch case statement in VB like you can in C++ or do I need to write a bunch of If Else statements? I tried to do this line and it doesn't look like it's actually looking at...
Forum: Access VBA October 19th, 2006, 02:08 PM
Replies: 3
Views: 1,488
Posted By ermy78
mmcdonal, Thanks for all your help! I...

mmcdonal,

Thanks for all your help! I finally got it all figured out. I'm not sure why I didn't look there sooner, but all I had to do was amend the one line from
DoCmd.OpenForm stDocName, , ,...
Forum: Access VBA October 19th, 2006, 01:08 PM
Replies: 3
Views: 1,488
Posted By ermy78
How do you open Form B on the PK, because that's...

How do you open Form B on the PK, because that's what it should be doing as is.

stLinkCriteria = "[Conveyor]=" & "'" & Me![Conveyor] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

or am I...
Forum: Access VBA October 18th, 2006, 04:25 PM
Replies: 3
Views: 1,488
Posted By ermy78
Record Delete on Form Opening

Hi all,

I'm trying to open a form (Form B) from another form (Form A). They're linked by similar fields (Conveyor) in two different tables (Table B and Table A respectively). I use a button with...
Showing results 1 to 24 of 24

 




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