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 41
Search took 0.01 seconds.
Search: Posts Made By: Figgis
Forum: Access August 24th, 2006, 09:06 AM
Replies: 10
Views: 2,578
Posted By Figgis
I'm not sure about using data from a combo box...

I'm not sure about using data from a combo box but if you are building an SQL statement that has a string you are using to compare against then it has to be in single quotes or it will error. I could...
Forum: Access August 24th, 2006, 08:54 AM
Replies: 16
Views: 2,078
Posted By Figgis
Lee, If you are searching 20 different...

Lee,

If you are searching 20 different fields for particular dates I dont think that a simple query would work. For most queries on a date you are only working with one or two dates. If you enter...
Forum: Access August 24th, 2006, 08:43 AM
Replies: 3
Views: 1,142
Posted By Figgis
If your using AC97 then providing you have it...

If your using AC97 then providing you have it there is an add in for managing linked tables. I think on later versions it is an actual menu item within the tools menu. When you open it you are...
Forum: Access August 23rd, 2006, 04:01 AM
Replies: 9
Views: 2,954
Posted By Figgis
Hi, I managed to figure a way of doing what...

Hi,

I managed to figure a way of doing what I needed by using part of the suggestion above. I manage security on the database by having a menu form. All I do for the various front end versions is...
Forum: Access August 18th, 2006, 03:53 AM
Replies: 9
Views: 2,954
Posted By Figgis
Grrrr. Just tried the solution you suggested and...

Grrrr. Just tried the solution you suggested and it does not seem to be supported in Access'97. Name works with the full file path but the CurrentProject doesnt.


Fig
Forum: Access August 17th, 2006, 06:18 PM
Replies: 9
Views: 2,954
Posted By Figgis
Thanks guys. Seems funny as the application title...

Thanks guys. Seems funny as the application title is stored as a property of the database that you cant dirrectly access it. However as I have the name of the application the same as the file name...
Forum: Access August 17th, 2006, 09:56 AM
Replies: 9
Views: 2,954
Posted By Figgis
Application Title

I have an access '97 database at work which is split across several front ends and one main database. I have a table within the database which is used as an activity log. I have this working finr for...
Forum: BOOK: Wrox's Visual Basic 2005 Express Edition Starter Kit ISBN: 978-0-7645-9573-8 May 18th, 2006, 06:57 AM
Replies: 5
Views: 2,426
Posted By Figgis
I didnt notice your post originally and I posted...

I didnt notice your post originally and I posted this within Chapert 7 topic. But I have exactly the same problem. "I also have nothing displayed on the List when I run the program. I've tried using...
Forum: BOOK: Wrox's Visual Basic 2005 Express Edition Starter Kit ISBN: 978-0-7645-9573-8 May 18th, 2006, 06:49 AM
Replies: 4
Views: 3,116
Posted By Figgis
I have exactly the same Warning. I also have...

I have exactly the same Warning. I also have nothing displayed on the List when I run the program. I've tried using the downloaded code as well as the one I created working through the book and I...
Forum: BOOK: Wrox's Visual Basic 2005 Express Edition Starter Kit ISBN: 978-0-7645-9573-8 May 14th, 2006, 06:36 PM
Replies: 4
Views: 2,404
Posted By Figgis
Andrew, Many thanks for the reply. Does this...

Andrew,

Many thanks for the reply. Does this mean that for each project you can have those options set differently? If we are to use the other projects do we have to check this out first?

...
Forum: BOOK: Wrox's Visual Basic 2005 Express Edition Starter Kit ISBN: 978-0-7645-9573-8 May 4th, 2006, 07:58 AM
Replies: 4
Views: 2,404
Posted By Figgis
I came across that problem too. I did figure out...

I came across that problem too. I did figure out how to get around it and created the buttons that were needed.

However within the same chapter I came across another problem. I have sent this...
Forum: Visual Basic 2005 Basics April 28th, 2006, 03:43 PM
Replies: 0
Views: 1,074
Posted By Figgis
Accessing a Web Cam

I'm new to visual Basic 2005 Express and I am intersted in building a progam that accesses my web cam. Can any of you think of a method for doing this?
Forum: Access January 2nd, 2006, 12:13 PM
Replies: 3
Views: 3,596
Posted By Figgis
mmcdonal, I was sure that VB has it's own...

mmcdonal,

I was sure that VB has it's own version of the Jet engine and would therefore be able to access data from an Access DB without the need to have Access on the machine.

Kamal,

I...
Forum: Access January 2nd, 2006, 11:59 AM
Replies: 1
Views: 1,261
Posted By Figgis
Well the answer is yes you could. you would need...

Well the answer is yes you could. you would need to create some code on one of the event triggers like on insert or on current etc. You'd need to experiment to find the one that works for you. It's...
Forum: Access November 23rd, 2005, 07:01 PM
Replies: 5
Views: 1,490
Posted By Figgis
Malekmac, I take it you are having a similar...

Malekmac,

I take it you are having a similar problem. The report that I was generating was a single line statement that summarised the number of products, the number of cases and the number of...
Forum: Access November 17th, 2005, 06:08 AM
Replies: 4
Views: 2,505
Posted By Figgis
Corey It looks like you have an additional...

Corey

It looks like you have an additional set of"" in the formula. You dont need them in the false half of the equation.

Jim
Forum: Access November 15th, 2005, 06:39 PM
Replies: 1
Views: 1,726
Posted By Figgis
I wouldn't have a clue on this. however there is...

I wouldn't have a clue on this. however there is a .net forum on here and would probably have someone who would be able to help you on there.
Forum: Access November 15th, 2005, 06:36 PM
Replies: 5
Views: 2,319
Posted By Figgis
very odd. Sounds like a corrupted relationship...

very odd. Sounds like a corrupted relationship but I haven't come across that before.
Forum: Access November 15th, 2005, 05:16 PM
Replies: 5
Views: 2,319
Posted By Figgis
Greg, The only times I have come across this...

Greg,

The only times I have come across this sort of error are when as Kevin states there is a relationship that causes a violation of data integrity or when I inadvertently tried to append the...
Forum: Access November 15th, 2005, 12:19 PM
Replies: 2
Views: 1,449
Posted By Figgis
Probably should have mentioned the version I'm...

Probably should have mentioned the version I'm using is Access 97 with Office 97
Forum: Access November 15th, 2005, 11:06 AM
Replies: 2
Views: 1,449
Posted By Figgis
File Browser window

Hi all,

I have a problem that I'm hoping that you'll be able to help me with. I have put together a database that is going to record customer claims against orders. Everything works fine however...
Forum: Access November 14th, 2005, 05:15 PM
Replies: 2
Views: 4,752
Posted By Figgis
Have you tried putting an Exit sub command in the...

Have you tried putting an Exit sub command in the error statement?
Forum: Access November 14th, 2005, 04:24 PM
Replies: 8
Views: 9,195
Posted By Figgis
Loralee, Word merges are completely alien to...

Loralee,

Word merges are completely alien to me but from what you asked you wanted a way to build an option into the sql statement. Presuming you are doing this from a form what you could do is...
Forum: Access November 14th, 2005, 02:50 PM
Replies: 7
Views: 1,949
Posted By Figgis
If you can seperate the data it will probably be...

If you can seperate the data it will probably be better in the long run. It seems a very strange convestion to display numbers like this but then I do not know much about Archaeology. I don't know if...
Forum: Access November 12th, 2005, 07:13 PM
Replies: 2
Views: 986
Posted By Figgis
Are you trying to do something like If it's fred...

Are you trying to do something like If it's fred who opens the form turn is Blue and if its Jill turn it red? You can write code that would do this. If you can tellus exactly what you are trying to...
Showing results 1 to 25 of 41

 




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