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 59
Search took 0.01 seconds.
Search: Posts Made By: JLovell
Forum: Access November 11th, 2004, 07:21 PM
Replies: 4
Views: 1,547
Posted By JLovell
There is no solution with a single parameter...

There is no solution with a single parameter query. To give the user the option to do a search or an exact match, you'll need to build a form. Provide a text box where the user can type the printer...
Forum: Access VBA November 2nd, 2004, 04:19 PM
Replies: 2
Views: 1,189
Posted By JLovell
What is the purpose of the .MoveNext? Because...

What is the purpose of the .MoveNext? Because you just added a record, you're on the "last" one in the recordset, so a MoveNext will get you No Current Record.

And by the way, if this code is...
Forum: Access VBA November 2nd, 2004, 12:07 PM
Replies: 6
Views: 8,892
Posted By JLovell
Well, you're starting with Rownum = 0, and an...

Well, you're starting with Rownum = 0, and an Excel worksheet does not have a Row zero. Because you pasted the field names in Row 1, don't you want to start with Rownum = 2?



John Viescas,...
Forum: Access November 2nd, 2004, 09:15 AM
Replies: 13
Views: 5,935
Posted By JLovell
Mateen- In my previous reply, I said: "The...

Mateen-

In my previous reply, I said: "The form that has the command button to open the form dbo_assignments6 should also have three controls - one each for ContractNo, StartDate, and EndDate." ...
Forum: Access November 1st, 2004, 09:23 PM
Replies: 11
Views: 1,845
Posted By JLovell
Don- The first query makes no sense. You're...

Don-

The first query makes no sense. You're getting all the rows from [Field Totals] (is this the second query?) combined with all rows from [Field Totals2(with boiler model)] (the third query?)....
Forum: Access November 1st, 2004, 08:54 PM
Replies: 9
Views: 3,195
Posted By JLovell
Well, DAPs run on the ADO model, so you probably...

Well, DAPs run on the ADO model, so you probably need an ANSI wildcard in your LIKE predicate (% instead of *). But I didn't think a parameter query would work at all in a DAP - unless perhaps...
Forum: Access VBA November 1st, 2004, 07:14 PM
Replies: 4
Views: 2,049
Posted By JLovell
If you have one form that works, then how are you...

If you have one form that works, then how are you passing the date back in that case? It sounds like you have a separate form with an embedded calendar control that you pop open. You need to pass...
Forum: Access VBA November 1st, 2004, 05:57 PM
Replies: 6
Views: 8,892
Posted By JLovell
Ayup. I don't think Excel 97 supports that...

Ayup. I don't think Excel 97 supports that method. I have Access 97 on some of my machines, but I no longer have Excel 97 installed anywhere, so I cannot test it for you. You'll have to navigate...
Forum: Access VBA November 1st, 2004, 04:45 PM
Replies: 6
Views: 8,892
Posted By JLovell
Help says: If the Recordset object contains...

Help says:

If the Recordset object contains fields with OLE objects in them, this method fails.

Does your recordset contain any OLE Object fields?


John Viescas, author
"Microsoft Office...
Forum: Access November 1st, 2004, 01:49 PM
Replies: 2
Views: 3,961
Posted By JLovell
Crazy-making, isn't it? You can fool it by...

Crazy-making, isn't it?

You can fool it by using DSum:

UPDATE ChartofAccounts
Set ChartofAccounts.[BalCur02] = DSUM("[Value]", "GeneralLedger", "[Period] = 2 AND [Account] = '2120'")
WHERE...
Forum: Access November 1st, 2004, 10:07 AM
Replies: 13
Views: 5,935
Posted By JLovell
Mateen- OK, then using linked tables means...

Mateen-

OK, then using linked tables means you can treat it as though it is an all-mdb setup.

The best way to do this is to remove the WHERE clause from your SELECT statement and provide a...
Forum: Access October 31st, 2004, 11:10 AM
Replies: 13
Views: 5,935
Posted By JLovell
Mateen- This is the first time you have...

Mateen-

This is the first time you have mentioned SQL Server - that's important! Is this code in a desktop database (.mdb) or in a project file (.adp)? And which version of Access are you using?...
Forum: Access October 31st, 2004, 11:01 AM
Replies: 1
Views: 1,406
Posted By JLovell
I don't think it can be done because Access wraps...

I don't think it can be done because Access wraps its own non-standard headers around an OLE Object stored in an mdb. Storing an OLE Object in an Access JET database isn't a good idea anyway because...
Forum: Access VBA October 30th, 2004, 07:29 AM
Replies: 1
Views: 2,105
Posted By JLovell
It doesn't help when you start a new topic. You...

It doesn't help when you start a new topic. You posted this reply both to your original topic and as a new topic. Let's continue the discussion on Topic 21470.


John Viescas, author
"Microsoft...
Forum: Access VBA October 30th, 2004, 07:27 AM
Replies: 4
Views: 19,506
Posted By JLovell
Why not let Access display the related records as...

Why not let Access display the related records as soon as the user picks the Diet (or whatever is the related field) on the outer form? I suppose you could leave the Link Child and Link Master...
Forum: Access VBA October 29th, 2004, 09:57 PM
Replies: 4
Views: 19,506
Posted By JLovell
The code you posted makes no sense. It looks...

The code you posted makes no sense. It looks like you're trying to manually "paste" the data from your recordset into the subform by reading through a recordset. What is the record source of the...
Forum: Access VBA October 29th, 2004, 07:30 PM
Replies: 2
Views: 1,315
Posted By JLovell
Close, but no cigar. ...

Close, but no cigar.

>=[Forms]![Formname]![TextBoxNameStart]

You should also choose Parameters from the Query menu and explicitly define the parameter and its data type.



John Viescas,...
Forum: Access VBA October 29th, 2004, 07:29 PM
Replies: 3
Views: 4,208
Posted By JLovell
David- It sounds like the control isn't...

David-

It sounds like the control isn't registered properly. Frankly, I gave up on the ActiveX controls distributed with Access a long time ago. I now use a form designed as a calendar that I...
Forum: Access October 29th, 2004, 07:25 PM
Replies: 13
Views: 21,988
Posted By JLovell
Morris & Paumir- You'll also get this error...

Morris & Paumir-

You'll also get this error if your project isn't compiled and you have an error in your code. Open any module in the Visual Basic Editor and choose Compile from the Debug menu. ...
Forum: Access October 29th, 2004, 07:05 PM
Replies: 9
Views: 3,195
Posted By JLovell
Open Internet Explorer. Choose Internet Options...

Open Internet Explorer. Choose Internet Options from the Tools menu. On the Security tab, click the Custom Level button. Under Miscellaneous options, Set Access Data Sources Across Domains to Yes....
Forum: Access October 29th, 2004, 07:09 AM
Replies: 1
Views: 8,331
Posted By JLovell
Mohamed- Access is not Excel. You can find...

Mohamed-

Access is not Excel. You can find the Min value across multiple rows, but not multiple columns - at least not using Min. To do it in Access, you have to write an ugly expression using...
Forum: Access VBA October 28th, 2004, 10:57 PM
Replies: 7
Views: 12,178
Posted By JLovell
First, when you use the LIKE predicate in ADO,...

First, when you use the LIKE predicate in ADO, you must use ANSI wildcards - % instead of *. And you don't need the command object. A simple

rstRecordset.Open SQL, conConnection, adOpenStatic,...
Forum: Access VBA October 28th, 2004, 10:44 PM
Replies: 2
Views: 3,269
Posted By JLovell
If you want the result in a variable, open a...

If you want the result in a variable, open a recordset on the totals query. If you want the result inserted into a table, use the SELECT from the totals query in an INSERT query:

INSERT INTO...
Forum: Access VBA October 28th, 2004, 10:30 AM
Replies: 3
Views: 1,436
Posted By JLovell
The combo box wizard can build a combo box with...

The combo box wizard can build a combo box with code behind it to navigate to the record chosen in the combo - is that what you want to do? The code runs in the AfterUpdate event of the procedure to...
Forum: Access VBA October 28th, 2004, 10:27 AM
Replies: 1
Views: 4,981
Posted By JLovell
What is it you're trying to do with this code? ...

What is it you're trying to do with this code? Going to acFirst before doing acNewRec makes no sense. If you're trying to "put" records into a table by assigning values in the user interface,...
Showing results 1 to 25 of 59

 


All times are GMT -4. The time now is 10:52 PM.


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