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 159
Search took 0.01 seconds.
Search: Posts Made By: Vince_421
Forum: VB Databases Basics October 29th, 2008, 03:24 PM
Replies: 2
Views: 1,888
Posted By Vince_421
Thanks very much. This solved my problem :)

Thanks very much.
This solved my problem :)
Forum: VB Databases Basics October 26th, 2008, 07:25 AM
Replies: 2
Views: 1,888
Posted By Vince_421
empty string

Hi,

I'm new to programming with visual basic.
I used Access before.

In acces the code to test for empty or null string should be:

If me.txtName = "" or me.txtName is Null then

But this...
Forum: Access VBA November 2nd, 2007, 09:36 AM
Replies: 0
Views: 1,265
Posted By Vince_421
export data to excel using templates

Hi,

I'm trying to export data to an Excel template and saving it to the right location. Everything works fine, except for the exportation itself. Opening the template, saving it to the location,...
Forum: Access VBA June 29th, 2007, 10:27 AM
Replies: 5
Views: 370
Posted By Vince_421
Sorry for the late response, but I was really...

Sorry for the late response, but I was really busy with another problem to solve...

Your thing works great, thanks very much for your help.
Forum: Access VBA June 26th, 2007, 09:55 AM
Replies: 5
Views: 370
Posted By Vince_421
ok, but how does step 3 work? I can do the...

ok,

but how does step 3 work? I can do the others, but don't know how to do the thirth. Do you need more info to do this or not?

Thanks so far...
Forum: Access VBA June 26th, 2007, 08:31 AM
Replies: 5
Views: 370
Posted By Vince_421
using debug.print

This might seem stupid, but I never used this command.

What I would like to do is that when I create a new record with DAO, I can get the autonumber of the created field to be put into a variable?...
Forum: Access VBA June 11th, 2007, 04:57 AM
Replies: 3
Views: 4,753
Posted By Vince_421
What I think you should do is: Put the...

What I think you should do is:

Put the enabled property of the check box to false first.

I'm guessing the combo boxes or not cascading? If yes, only put the code on the last one, else put it on...
Forum: Access VBA June 9th, 2007, 04:11 PM
Replies: 3
Views: 1,453
Posted By Vince_421
On the second one, with the vba, I guess it has...

On the second one, with the vba, I guess it has to be put on the 'form error' event?

For the first one, do I have to give in a 'validation rule' for the 'validation text' to work? Or if I fill in...
Forum: Access VBA June 7th, 2007, 04:22 PM
Replies: 3
Views: 1,453
Posted By Vince_421
data type error message

hi,

got a question. When on a form I format a text box to for exemple 'short date' I get an error message to tell me if the format is wrong.

So here I have to input something like 10:00. If the...
Forum: Access VBA June 5th, 2007, 05:30 AM
Replies: 4
Views: 2,289
Posted By Vince_421
What I think you should do is: dim...

What I think you should do is:

dim intSupplierID as integer 'cause I guess it's a number
dim intProductID as integer 'same as previous line

intSupplierID = me.combo1
intProductID = me.combo2...
Forum: Access VBA June 5th, 2007, 04:11 AM
Replies: 6
Views: 2,877
Posted By Vince_421
If you want to populate a list box, you can do...

If you want to populate a list box, you can do that the same way.

Is everything clear to you or not? If you still have some problems or questions, let me know
Forum: Access VBA June 4th, 2007, 04:24 AM
Replies: 6
Views: 2,877
Posted By Vince_421
So what I think you should do is: in the...

So what I think you should do is:

in the first combo box you list all tables (don't know if you know how to do this).

On the after update event of the first combo you put this code:

dim...
Forum: Access VBA June 2nd, 2007, 03:58 PM
Replies: 6
Views: 2,877
Posted By Vince_421
Little question: If you do not select a value in...

Little question: If you do not select a value in the first one, will the user be able to select a value in the second one? Or will the second one be empty until a value is choosen in the first one.
...
Forum: Access May 30th, 2007, 04:11 AM
Replies: 2
Views: 958
Posted By Vince_421
Multiple relationships from table

Hi,

just have a question.

I have a table that has a 1 to many relationship with another table on the 'CreatedBy' field.
I also have a 'ChangedBy' and a 'CheckedBy' field on this same table.
...
Forum: Access VBA May 23rd, 2007, 09:26 AM
Replies: 3
Views: 2,475
Posted By Vince_421
This could look like a stupid question, but are...

This could look like a stupid question, but are you trying to do this on the check box itself or on the label of the check box?
Cause if you are trying to do this on the check box itself, I don't...
Forum: Access May 23rd, 2007, 09:01 AM
Replies: 10
Views: 2,232
Posted By Vince_421
ok, this is what you should do: First of...

ok, this is what you should do:

First of all, leave your list box rowsource empty.

On the on click event of your command button, put this code:

dim sSQL as string
dim sInput as string
...
Forum: Access May 23rd, 2007, 03:50 AM
Replies: 10
Views: 2,232
Posted By Vince_421
The string of words you want to search for, do...

The string of words you want to search for, do they have to follow each other, or can there be other words between them?

For exemple if you are looking for 'a b c', will it return:

p a b c f e...
Forum: Access May 22nd, 2007, 05:35 AM
Replies: 8
Views: 900
Posted By Vince_421
An other way to do this is to make a sql-string...

An other way to do this is to make a sql-string first when you press the action button and give this string to the on load event of the second form, so you can only have 1 record shown, since your...
Forum: Access VBA May 11th, 2007, 12:52 PM
Replies: 3
Views: 1,366
Posted By Vince_421
If you know where the file will be put and what...

If you know where the file will be put and what the name is, you just have to add some code after the one you already have to open the excell file...

So on the same action button you put the 2...
Forum: Access VBA May 10th, 2007, 08:46 AM
Replies: 8
Views: 1,951
Posted By Vince_421
I'll start with the thing you said and I'll try...

I'll start with the thing you said and I'll try to complete the rest. If I find the solution I'll lett you know...

Thanks for your help so far...
Forum: Access VBA May 9th, 2007, 08:18 AM
Replies: 8
Views: 1,951
Posted By Vince_421
Just a little thing I forgot, on this exemple in...

Just a little thing I forgot, on this exemple in that program, when I start typing, the combo opens by itself and then stays open and is 'filtering' the data with each lettre I add. It closes if I...
Forum: Access VBA May 9th, 2007, 08:15 AM
Replies: 8
Views: 1,951
Posted By Vince_421
I'm not sure we understand each other here, so I...

I'm not sure we understand each other here, so I made some pictures so you can see what I mean...

Image1, combo is empty:
http://img515.imageshack.us/img515/5237/cboemptyvd9.jpg

Image2, combo...
Forum: Access VBA May 8th, 2007, 10:00 AM
Replies: 8
Views: 1,951
Posted By Vince_421
I don't really know how many would have 'ro' (or...

I don't really know how many would have 'ro' (or whatever I type) in the list, because the list will evolve, and this could be really quickly...

So yes, what I meant was that if I type something...
Forum: Access VBA May 8th, 2007, 03:54 AM
Replies: 8
Views: 1,951
Posted By Vince_421
values in combo box

Hi,

I have a combo box with the next sql:

SELECT tblVisitorsBezoekers.BezoekerID, tblVisitorsBezoekers.BezoekerNaam AS [Naam bezoeker], tblVisitorsBedrijven.BedrijfNaam AS [Bedrijf bezoeker]...
Forum: Access VBA May 6th, 2007, 01:29 PM
Replies: 17
Views: 2,034
Posted By Vince_421
Made it able to work thanks to you... Thanks...

Made it able to work thanks to you...

Thanks very much
Showing results 1 to 25 of 159

 


All times are GMT -4. The time now is 11:32 PM.


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