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 25 of 149
Search took 0.01 seconds.
Search: Posts Made By: Mitch
Forum: BOOK: Beginning Access 2007 VBA ISBN: 978-0-470-04684-5 June 2nd, 2010, 11:08 AM
Replies: 1
Views: 5,834
Posted By Mitch
Did you ever find a solution? I am...

Did you ever find a solution?

I am interested in this also, but not for a scale.
Forum: Access February 20th, 2008, 06:02 PM
Replies: 1
Views: 5,767
Posted By Mitch
RMA database needed

Hello, I am looking for a free RMA (Return Merchandise Authorization or Return Material Authorization) MS Access database that I can customize, as opposed to writing one from scratch myself.

Can...
Forum: Access VBA September 26th, 2007, 12:05 PM
Replies: 2
Views: 1,273
Posted By Mitch
Convert entry to non-standard date

I have a need to be able to enter "feb 06" into a text field on a form and get "Feb/2006" stored.

Also if they enter just "feb" then the current year be used, so if it was 2007 then "Feb/2007"...
Forum: Access February 19th, 2007, 06:39 PM
Replies: 2
Views: 4,932
Posted By Mitch
Month and Year to Date on a Report

I need a Report that shows the Month To Date and the Year To Date per each Category at the top and along the left all of the individual people.


Life Annuities Securities Group ...
Forum: PHP How-To June 4th, 2006, 10:32 AM
Replies: 1
Views: 1,177
Posted By Mitch
Upload picture

I am trying to make a page where my users can enter a person's name then, otpionally, upload a picture of them. And then write it all to the database and "deal" with the picture.

I allready have...
Forum: PHP Databases June 4th, 2006, 09:25 AM
Replies: 2
Views: 1,196
Posted By Mitch
Thanks very much1 Little by little I will...

Thanks very much1

Little by little I will get there. :)

Mitch
Forum: MySQL June 3rd, 2006, 11:48 AM
Replies: 3
Views: 1,222
Posted By Mitch
Thanks guys, that did it, I did not have enough...

Thanks guys, that did it, I did not have enough values.

Mitch
Forum: PHP Databases June 3rd, 2006, 11:28 AM
Replies: 2
Views: 1,196
Posted By Mitch
Error but it works

I have a page that is generating the following errror and I can't figure out why, especially when I use the same code on another page (but different database) and it does not generate the error, but...
Forum: MySQL May 19th, 2006, 09:32 PM
Replies: 3
Views: 1,222
Posted By Mitch
insert fails

I am getting the following error:

Column count doesn't match value count at row 1

when I try to run this:

insert into onmylist_person values('value1', 'value2')

My table looks like this:
Forum: Access May 8th, 2006, 04:31 PM
Replies: 1
Views: 808
Posted By Mitch
Write Error

I am getting the following error: Write Conflict--This record has been changed by another user since you started editing it....

I think i know why, but I am sot sure what to do about it.

I have...
Forum: SQL Server 2000 December 15th, 2005, 01:55 PM
Replies: 2
Views: 1,202
Posted By Mitch
I just did a sp_recompile on it and that did not...

I just did a sp_recompile on it and that did not work either.

Mitch
Forum: SQL Server 2000 December 6th, 2005, 02:57 PM
Replies: 2
Views: 1,202
Posted By Mitch
SP takes long time but reboot fixes it

I have a stored procedure that normally takes 1-2 seconds to run. It is just a Select, no action.

However, after a couple of days, it then takes 7-8 minutes to run.

The tables are not being...
Forum: PHP Databases November 17th, 2005, 03:15 PM
Replies: 4
Views: 1,569
Posted By Mitch
It looks like when I click on the "submit" button...

It looks like when I click on the "submit" button it is sending everything up to the quote, so I am not sure what to do to correct that.

Mitch
Forum: PHP Databases November 15th, 2005, 10:23 PM
Replies: 4
Views: 1,569
Posted By Mitch
Delete query not working

I am trying to fix my delete function that deletes a string of text that may or may not have single, double quotes, pound signs etc.


function delete_bm($user, $url)
{
// delete one text string...
Forum: Access June 6th, 2005, 09:23 AM
Replies: 0
Views: 825
Posted By Mitch
ADO version of FindLast

I have some ADO code that I am trying to convert to ADO and I am getting stumpt on converting this line:

rstTblFill.FindLast "[Equip] ='" & strCurrLine & "'"

I tried using just:...
Forum: SQL Language May 26th, 2005, 08:40 AM
Replies: 3
Views: 1,325
Posted By Mitch
In the end I had to create the table...

In the end I had to create the table zzT_Schedule_BatchItems by hand first. Then it appended records to it. I would have thought that it would have generated an error if it did not find the...
Forum: SQL Language May 23rd, 2005, 04:01 PM
Replies: 3
Views: 1,325
Posted By Mitch
I have gotten close with this, it runs without...

I have gotten close with this, it runs without error, but I don't see wehre it created the table, if at all.

SELECT ItemID, ItemType, EquipDesc, identity(int, 1, 1) as id into #a FROM...
Forum: SQL Language May 21st, 2005, 03:40 PM
Replies: 3
Views: 1,325
Posted By Mitch
Append records with 1 incrementing field

I am trying to append records to Table A from Table B, And as the records get appended I need a field in Table A to be a number that gets incremented by 1 and starts at a value that is the MAX from...
Forum: Access March 11th, 2005, 10:59 AM
Replies: 1
Views: 918
Posted By Mitch
This seemed to do the trick for me. If...

This seemed to do the trick for me.

If Eval(strInspType & " " & vYellow) Then

I took out the second eval.
Forum: Access March 11th, 2005, 10:04 AM
Replies: 1
Views: 918
Posted By Mitch
Dynamic If...Then using variables

I am trying to make a "dynamic" If...then statement in VBA to evaluate something like: "If -1 >= 0 Then"

I have a table that contains a field that contains a string like: ">14"

So I do a...
Forum: Access March 4th, 2005, 12:57 AM
Replies: 1
Views: 1,435
Posted By Mitch
Query wont work unless I copy and past into new on

I am createing a query in VBA, saving it, then running it, and it does not work.

But if I go into SQL mode, copy and past it into a new query it runs. I have comparied the one that does not work...
Forum: SQL Language February 28th, 2005, 04:33 PM
Replies: 3
Views: 851
Posted By Mitch
Need incrementing number in query

I need to have a field in my query that is an icremental number like 1, 2, 3, 4 etc, but that I can start at a specific value, say 236 so it would number the returned set of records as 237, 238, 239...
Forum: SQL Server 2000 February 28th, 2005, 12:33 PM
Replies: 5
Views: 3,477
Posted By Mitch
Ok, I've gotten rid of most of the errors, but...

Ok, I've gotten rid of most of the errors, but still get these two:

Server: Msg 170, Level 15, State 1, Procedure FN_QCntr, Line 24
Line 24: Incorrect syntax near '@Cntr'.
Server: Msg 170,...
Forum: SQL Server 2000 February 28th, 2005, 10:28 AM
Replies: 5
Views: 3,477
Posted By Mitch
I get the same error in an ADP or in SQL Query...

I get the same error in an ADP or in SQL Query Analyzer:

Server: Msg 170, Level 15, State 1, Procedure QCntr(@X nvarchar(50), @Y int), Line 7
Line 7: Incorrect syntax near 'RETURNS'.
Server: Msg...
Forum: SQL Server 2000 February 25th, 2005, 12:44 PM
Replies: 5
Views: 3,477
Posted By Mitch
I modified the above based on some more research,...

I modified the above based on some more research, but still gettting syntax errors:


CREATE FUNCTION "QCntr(@X nvarchar(50), @Y int)"

/*
QCntr(x, Optional Y As Long) As Long: X will be like...
Showing results 1 to 25 of 149

 




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