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 | 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 22 of 22
Search took 0.01 seconds.
Search: Posts Made By: snoopy92211
Forum: Access VBA February 25th, 2005, 03:46 PM
Replies: 1
Views: 3,455
Posted By snoopy92211
Update and Inner Join Question - Access 97

Howdy. I'm trying to figure this out; I keep erring out at the code.

Here is what my code's trying to accomplish.
1. Import a file
2. once that file has been imported, create and add the...
Forum: Excel VBA January 10th, 2005, 05:53 PM
Replies: 1
Views: 1,066
Posted By snoopy92211
Password Protection and Other Items

Hello All. Here's my issue

I have a spreadsheet, a portion of which is shown below. All of the columns in the worksheet have an auto filter. I want my analysts to be able to filter any and all of...
Forum: Access VBA November 18th, 2004, 12:28 PM
Replies: 1
Views: 4,443
Posted By snoopy92211
Hide Tabs in a Form Based on a field.

I would like to hide a tab based on a combo box.

my filter is based on a field, fruit.

if i filter my records on apples , I want the tabs apple1 and apple2 to be visible (and orange...
Forum: Access VBA October 13th, 2004, 02:13 PM
Replies: 0
Views: 4,262
Posted By snoopy92211
Calculate Business Days - MS access 97

Help! I have a module that shows how to calculate business days. However, I don't know how to refer to it.


I have a table (named ITEMS) with values
ID Date Received Date Submitted ...
Forum: Access VBA October 12th, 2004, 04:01 PM
Replies: 1
Views: 1,362
Posted By snoopy92211
Omit negative values in Queries - Access 97

This is driving me nuts!! how do you omit negative values in Access.

Specifically,

I'm calculating the days between dates. However, if value1 is later than value 2, the diffdate returns a...
Forum: Access VBA October 11th, 2004, 01:38 PM
Replies: 1
Views: 1,975
Posted By snoopy92211
DCOUNT Issue - MS Access 97

Greetings.

I am trying to figure out this DCOUNT Issue. I'm trying to (in a report) count the number of items in the item table where the completion field is NOT withdrawn

Here's my control...
Forum: Access VBA September 29th, 2004, 11:40 AM
Replies: 1
Views: 1,234
Posted By snoopy92211
Preventing Database Conversion

Hello fellow coders :)

Is there any way to prevent database conversion? For example, my users are using an Access 97 database, and they only need to use it on Access 97. One my users opened the...
Forum: Access VBA August 18th, 2004, 01:47 PM
Replies: 1
Views: 7,413
Posted By snoopy92211
Compare two recordsets to check for duplicates

Howdy. :)

I am trying to basically compare two types of information. I import about 10 tables that need to be appended to a master table. but before I can append these tables to the master...
Forum: Access VBA July 20th, 2004, 03:15 PM
Replies: 1
Views: 1,005
Posted By snoopy92211
Eliminating spaces in a query - ???

Hello.

I have a query, in which i'm trying to select a number that has the value of 'x'. But since the file specs for this particular field has a text value of 20. I tried using trim for this...
Forum: Access VBA July 14th, 2004, 01:27 PM
Replies: 0
Views: 2,552
Posted By snoopy92211
MultiSelect List Box and Other issues...

I have a form, frmMain, that has the following items.

State checkbox and state combobox
divisions checkbox and divisions multiselect listbox.

The user is supposed to do several things.

1....
Forum: VB Databases Basics June 30th, 2004, 08:27 AM
Replies: 10
Views: 4,625
Posted By snoopy92211
Good point... but even when i changed the...

Good point...

but even when i changed the variable to dim lstperiod as a listbox, it still didn't work correctly.
Forum: VB Databases Basics June 29th, 2004, 04:08 PM
Replies: 10
Views: 4,625
Posted By snoopy92211
Ok..this thing is driving me NUTZ! Two...

Ok..this thing is driving me NUTZ!

Two Issues: I can't make this into a listbox (with checkboxes) My form would look messy...I have way too many date ranges to check. I have to use this type of...
Forum: VB Databases Basics June 29th, 2004, 02:16 PM
Replies: 10
Views: 4,625
Posted By snoopy92211
i'm doing vba for access 97.

i'm doing vba for access 97.
Forum: VB Databases Basics June 29th, 2004, 02:07 PM
Replies: 10
Views: 4,625
Posted By snoopy92211
thanks. [:I]unfortunately my vba experience is...

thanks. [:I]unfortunately my vba experience is little to none. you've got to explain that in laymen's terms... :)

how would i do that?
Forum: VB Databases Basics June 29th, 2004, 01:03 PM
Replies: 10
Views: 4,625
Posted By snoopy92211
Thanks Tom. I'm still stuck....maybe you...

Thanks Tom.

I'm still stuck....maybe you can help with this as well. :)
Here's what I have so far...and I'm getting this Runtime Error (91): Object Variable or With Block Variable Not Set.
...
Forum: VB Databases Basics June 28th, 2004, 02:09 PM
Replies: 10
Views: 4,625
Posted By snoopy92211
Multi Select List Box Coding Errors...

:(

I'm trying to figure out this piece of code...

Here's what this piece is supposed to do. On my form, I have a multi select list box with Dates, named lstPeriod. the user is supposed to...
Forum: Access VBA June 24th, 2004, 03:57 PM
Replies: 4
Views: 17,734
Posted By snoopy92211
Bob, Thanks for the help. To answer your...

Bob,

Thanks for the help. To answer your questions.

1. I have actual tables that I programmatically import into the database.
2. However, I created a table with all the table names so the...
Forum: Access VBA June 24th, 2004, 08:51 AM
Replies: 4
Views: 17,734
Posted By snoopy92211
thanks Bob! Forgive me for sounding like a...

thanks Bob! Forgive me for sounding like a complete putz (I've been doing VBA for a little over a month now), but... I tried to compile this and I got this error: Syntax Error in Drop Table. Where...
Forum: Access VBA June 23rd, 2004, 08:26 AM
Replies: 3
Views: 1,052
Posted By snoopy92211
thanks so much! :)

thanks so much! :)
Forum: Access VBA June 23rd, 2004, 08:25 AM
Replies: 4
Views: 17,734
Posted By snoopy92211
Access VBA Delete Query Issue...

I am trying to import tables into a database. and i also want to create a query on the fly to delete the imported tables. don't need the tables, just need to extract the information from the tables. ...
Forum: Access VBA June 22nd, 2004, 03:21 PM
Replies: 3
Views: 1,052
Posted By snoopy92211
one more thing...i'm using access 97.

one more thing...i'm using access 97.
Forum: Access VBA June 22nd, 2004, 03:18 PM
Replies: 3
Views: 1,052
Posted By snoopy92211
Syntax Error

HELP! I'm trying to figure this out. This is what I'm trying to do. I have a group of tables with the same specs. I want to programmatically append the information in these tables into a master...
Showing results 1 to 22 of 22

 


All times are GMT -4. The time now is 03:57 AM.


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