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 55
Search took 0.01 seconds.
Search: Posts Made By: chacquard
Forum: Access VBA February 7th, 2007, 10:01 AM
Replies: 4
Views: 2,080
Posted By chacquard
I forgot to mention that the type of ticket (or...

I forgot to mention that the type of ticket (or category) is a value entered by the user in the main form.
Forum: Access VBA February 5th, 2007, 11:22 PM
Replies: 4
Views: 2,080
Posted By chacquard
If the checkbox is true, I run a query to get the...

If the checkbox is true, I run a query to get the price of the ticket and display it in the unbound field. The price changes depending on the event and the type of ticket (this value is in the main...
Forum: Access VBA February 2nd, 2007, 04:29 PM
Replies: 4
Views: 2,080
Posted By chacquard
unbound field in subform

Hi,

I would like to have an unbound field in a continuous subform, but the value this field can be different from one record to the other. More specifically:

date Event checkbox price...
Forum: Access VBA February 2nd, 2007, 11:38 AM
Replies: 7
Views: 1,014
Posted By chacquard
I am trying to make this thing work, but I am...

I am trying to make this thing work, but I am against a little glitch: how can I had a subform in a form with unbound fields... in other words, in my main form I have no field in common (yet) with...
Forum: Access VBA February 1st, 2007, 11:03 AM
Replies: 7
Views: 1,014
Posted By chacquard
Thanks a lot ltdavecass, I will try this and...

Thanks a lot ltdavecass,

I will try this and let you know if it works but it is exactly what I am trying to do.

Chantal
Forum: Access VBA December 14th, 2006, 04:29 PM
Replies: 7
Views: 1,014
Posted By chacquard
If I don't need to, I prefer not changing the...

If I don't need to, I prefer not changing the Ticket table. It would have a big impact.

Hence, I am still trying to work on this thing...

I have an INSERT INTO statement to add the ticket to...
Forum: Access VBA December 14th, 2006, 01:55 PM
Replies: 7
Views: 1,014
Posted By chacquard
A little challenge...

I am not too sure how to go about this.

[u]First:</u>
I have 2 tables: "Shows" (Id, Name, Date of event, time, place, type of event...) and "Tickets" (ticketId, showId, ticketNumber, level,...
Forum: Access VBA December 14th, 2006, 01:11 PM
Replies: 5
Views: 1,185
Posted By chacquard
When I wrote "it doesn't work" I meant that the...

When I wrote "it doesn't work" I meant that the reports don't print at all...

I tried the wait event and it works fine now.

Thank you!
:)
Forum: Access VBA December 12th, 2006, 01:24 PM
Replies: 22
Views: 3,374
Posted By chacquard
Maybe I am wrong about your questions, but you...

Maybe I am wrong about your questions, but you can also go in the
"TOOLS" menu, select "OPTIONS", then select the "UPDATE/SEARCH" tab (The name of the tab might be a little different - I use a...
Forum: Access VBA December 12th, 2006, 01:12 PM
Replies: 5
Views: 1,185
Posted By chacquard
I sure would appreciate having your help on this...

I sure would appreciate having your help on this one... it is a real problem for me here !:(

thanks!
Forum: Access VBA December 6th, 2006, 08:16 PM
Replies: 5
Views: 1,185
Posted By chacquard
I usually send the report to the printer with ...

I usually send the report to the printer with
"DoCmd.OpenReport stDocName, acNormal"

I use this code to print reports on a click of a control button (1 report per button), and it works fine. ...
Forum: Access VBA November 30th, 2006, 04:55 PM
Replies: 5
Views: 1,185
Posted By chacquard
Control button to print 20 reports - doesn't work

Hello,

I have a control button. If we click on the button, it should print about 20 different reports, but it doesn't. If I use the debug, and step through the vb code, it works fine,...
Forum: Access VBA November 21st, 2006, 04:29 PM
Replies: 1
Views: 1,207
Posted By chacquard
form/subform problem

Hi,

I have a form and a subform. When I open the form, I want do display messages in a text field. The messages depend on the content of the subform. For example:

Message1 will display if...
Forum: Access VBA November 21st, 2006, 12:27 PM
Replies: 3
Views: 1,720
Posted By chacquard
That is what I currently do, but I end up with...

That is what I currently do, but I end up with several versions of a form. When I need to do a change in the original form I have to do the same changes to all the copies and this leaves room to...
Forum: Access VBA November 21st, 2006, 11:51 AM
Replies: 3
Views: 1,720
Posted By chacquard
Activate or Deactivate controls on forms

Hi,

I don't know how to go about this: I have an order form that can be accessed by different menus. If the order form is opened from MenuA, I want certain controls to be invisible and...
Forum: Access VBA October 9th, 2006, 11:57 AM
Replies: 1
Views: 1,208
Posted By chacquard
index lost when export to csv file

Hello,

I have a number of indexed tables I need to export in a csv file. But for some reason, the index is "lost" during the export.

Here is my code:

DoCmd.TransferText acExportDelim,...
Forum: Access VBA June 29th, 2006, 02:59 PM
Replies: 2
Views: 891
Posted By chacquard
I've runned into the same problem yesterday. ...

I've runned into the same problem yesterday. For some reason it seems that there is a lock happening even if there is no real lock. I "temporarily" fixed it by compacting the database (in the...
Forum: Access VBA June 29th, 2006, 02:50 PM
Replies: 2
Views: 983
Posted By chacquard
Creating table with SQL to transfer to a CSV

hello,

I use a huge query to add records to a table (previously emptied) that I export as a CSV. This CSV is now too big. It has information on events. My boss wants me to create a csv for each...
Forum: Access VBA September 9th, 2005, 10:59 AM
Replies: 7
Views: 5,994
Posted By chacquard
To save some space on the form... right now, i...

To save some space on the form... right now, i have a text field with the value (for example = 5) and a control button right next to it, to open a form that displays the "5" records...
Forum: Access VBA September 9th, 2005, 10:56 AM
Replies: 1
Views: 1,240
Posted By chacquard
Page Header

Hi,

I have a report and I don't want the page header to show in the goup footer. How can I do that ?

Thank you

Chantal
Forum: Access VBA September 5th, 2005, 11:03 AM
Replies: 3
Views: 1,140
Posted By chacquard
Hi, I did try to use the stLinkCriteria in...

Hi,

I did try to use the stLinkCriteria in the "where" section of the docmd.openform... but I get a message because my form is not linked to a query or a table. The "destination" form is some...
Forum: Access VBA September 5th, 2005, 08:51 AM
Replies: 7
Views: 5,994
Posted By chacquard
Hi, This works partially. All 125 records...

Hi,

This works partially. All 125 records of the continuous form have the same button with the same caption i.e. the value of the record that has the focus (for example 9). Hence, when the...
Forum: Access VBA August 29th, 2005, 07:44 PM
Replies: 3
Views: 1,140
Posted By chacquard
passing a value to a field in a unbounded form

Hi,

I have a continuous form (bounded to a query that is a result of several queries) and when I click on a control button, I would like to have the value of the EventID field passed to the field...
Forum: Access VBA August 29th, 2005, 07:37 PM
Replies: 7
Views: 5,994
Posted By chacquard
Control button caption and visible property

Hi,

This is a two part question:

1) I have a continuous form that is a result of several queries. I would like to add a control button that opens a specific form (that part I have no problem...
Forum: Access VBA June 20th, 2005, 01:45 PM
Replies: 2
Views: 1,862
Posted By chacquard
Too few parameters. 1 expected !!!

I am trying to run an SQL Query in VB access but I keep on getting this message -- Too few parameters. 1 expected. I tested the SQL in a query and it works fine. What is it I am missing...
Showing results 1 to 25 of 55

 


All times are GMT -4. The time now is 03:15 PM.


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