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 120
Search took 0.01 seconds.
Search: Posts Made By: Braxis
Forum: Access VBA September 21st, 2007, 08:53 AM
Replies: 3
Views: 1,410
Posted By Braxis
mmcdonal The code looks good to me. You...

mmcdonal

The code looks good to me.

You should be able to assign the results of executing the command object to a recordset, i.e.:

Set rstResult=cmdCommand.Execute

You can then loop...
Forum: Access July 25th, 2005, 07:14 AM
Replies: 1
Views: 1,941
Posted By Braxis
Try this: Put the following function in a...

Try this:

Put the following function in a code module:
Function GetWhereClause(ctlIn As Control, bolNumericData As Boolean, Optional intCol As Integer = 0) As String
' Comments : General...
Forum: Access February 22nd, 2005, 09:34 AM
Replies: 4
Views: 1,430
Posted By Braxis
Daniel It sounds like you've got code...

Daniel

It sounds like you've got code running in the background whilst you're editing - do you have a form open, with a timer event maybe?

When that code runs the VBE, if open, moves the cursor...
Forum: Access January 24th, 2005, 04:13 AM
Replies: 1
Views: 10,792
Posted By Braxis
As you've discovered, spaces in names cause...

As you've discovered, spaces in names cause problems.

The ideal solution would be to remove them! Assuming you've gone too far to do this without loads of work, just wrap the field names in square...
Forum: Access VBA January 10th, 2005, 10:49 PM
Replies: 3
Views: 1,521
Posted By Braxis
Sven If you send me an email (brian.skelton...

Sven

If you send me an email (brian.skelton at braxis.info) I'll send you an example database that'll let you see how it all works.


Brian Skelton
Braxis Computer Services Ltd.
Forum: Access VBA January 10th, 2005, 09:52 PM
Replies: 5
Views: 2,104
Posted By Braxis
Ken If any of your library references are...

Ken

If any of your library references are missing or corrupted the simple, 'inbuilt', VBA functions tend to stop working. It's usually shows itself with the left/right/mid functions in my...
Forum: Access VBA January 10th, 2005, 01:59 PM
Replies: 5
Views: 2,104
Posted By Braxis
It sounds like your IT people have been updating...

It sounds like your IT people have been updating your company's machines and (deliberatly or not) either moved or deleted one of the dll/ocx files your database is dependent on.

My recommendation?...
Forum: Access VBA January 10th, 2005, 01:53 PM
Replies: 3
Views: 1,521
Posted By Braxis
Here's what I'm using in a similar situation. ...

Here's what I'm using in a similar situation.

I have tables, structured as follows:


tblForm
fldFormUID
fldFormName

tblFormControl
Forum: Access November 26th, 2004, 12:12 PM
Replies: 2
Views: 885
Posted By Braxis
Do you have primary keys defined on your SQL...

Do you have primary keys defined on your SQL Server tables?

If not, Access will present them as read-only.


Brian Skelton
Braxis Computer Services Ltd.
Forum: Access VBA November 22nd, 2004, 05:35 AM
Replies: 3
Views: 1,198
Posted By Braxis
How much is your time worth? For $299 you...

How much is your time worth?

For $299 you can buy FMS Incs. code tools http://www.fmsinc.com/Products/codetools/codetools2000/factsheet.htm#CC_ErrorHandling which does exactly what you want to do....
Forum: Access November 22nd, 2004, 05:31 AM
Replies: 8
Views: 1,234
Posted By Braxis
Clive A97 and A2000 will peacefully co-exist...

Clive

A97 and A2000 will peacefully co-exist on the same PC, as long as they are installed in seperate directories.

What will cause you problems is that each will try and grab the various...
Forum: Access November 15th, 2004, 02:44 PM
Replies: 2
Views: 885
Posted By Braxis
At the risk of sounding like an agent for FMS...

At the risk of sounding like an agent for FMS Inc., their CodeTools product will do this and more...

Go to here http://www.fmsinc.com/products/CodeTools/index.html and scroll down to the Code...
Forum: Access November 15th, 2004, 11:39 AM
Replies: 4
Views: 1,320
Posted By Braxis
It doesn't look as if the MS Forms controls have...

It doesn't look as if the MS Forms controls have a picture property when used in Access...


Brian Skelton
Braxis Computer Services Ltd.
Forum: Access November 15th, 2004, 09:47 AM
Replies: 4
Views: 1,320
Posted By Braxis
The easiest(and possibly only) way to do this is...

The easiest(and possibly only) way to do this is to include the text in your graphic.


Brian Skelton
Braxis Computer Services Ltd.
Forum: Access VBA November 8th, 2004, 12:22 PM
Replies: 3
Views: 1,719
Posted By Braxis
Have a look at Screen.PreviousControl ...

Have a look at Screen.PreviousControl


Brian Skelton
Braxis Computer Services Ltd.
Forum: Access VBA November 4th, 2004, 01:54 PM
Replies: 7
Views: 1,908
Posted By Braxis
There's no way of doing this if the user is...

There's no way of doing this if the user is directly accessing a table. The UI to tables doesn't have an object model and cannot be programmed against.

What you can do is display the same data in...
Forum: Access VBA November 4th, 2004, 09:23 AM
Replies: 7
Views: 1,908
Posted By Braxis
Can you give us a few more details? How is the...

Can you give us a few more details? How is the user selecting a record? Are they using tables directly or through a form? What exactly do you want to do with the selected record




Brian...
Forum: Access November 4th, 2004, 09:13 AM
Replies: 5
Views: 888
Posted By Braxis
That's right - Access doesn't have this...

That's right - Access doesn't have this functionality.


Brian Skelton
Braxis Computer Services Ltd.
Forum: Access November 4th, 2004, 08:28 AM
Replies: 5
Views: 888
Posted By Braxis
Naug I assume you're talking about...

Naug

I assume you're talking about Autonumber fields?

The short answer is no. The longer answer is that you shouldn't want to do these kind of tricks with autonumber fields, as they are not...
Forum: Access VBA November 4th, 2004, 05:38 AM
Replies: 7
Views: 1,908
Posted By Braxis
Have a look at the field property of the...

Have a look at the field property of the recordset object. This is the equivalent to the Excel Cell.


Brian Skelton
Braxis Computer Services Ltd.
Forum: Access VBA November 3rd, 2004, 07:17 AM
Replies: 6
Views: 21,218
Posted By Braxis
Line numbers are very useful if you're using...

Line numbers are very useful if you're using compiled databases (mde 's or ade's) and your users are using the runtime version of Access.

Runtime Access can often generate errors that do not occur...
Forum: Access VBA November 2nd, 2004, 02:10 PM
Replies: 6
Views: 21,218
Posted By Braxis
Is the problem big enough that it's worth...

Is the problem big enough that it's worth throwing money at?

There is a line numberer included in FMS Inc's Code Tools package. The downside? It costs $299 for a single user license.
...
Forum: Access VBA October 1st, 2004, 04:11 AM
Replies: 1
Views: 1,204
Posted By Braxis
This product may help you:...

This product may help you: http://www.fmsinc.com/products/startup/index.asp


Brian Skelton
Braxis Computer Services Ltd.
Forum: Access VBA September 22nd, 2004, 12:10 PM
Replies: 3
Views: 1,790
Posted By Braxis
I'm not sure why you need the milliseconds, so I...

I'm not sure why you need the milliseconds, so I may be totally off base, but I would probably hold the standard date/time data in a date time field and then create a seperate integer field to hold...
Forum: Access VBA September 22nd, 2004, 09:48 AM
Replies: 3
Views: 1,790
Posted By Braxis
Have you tried the GetSystemTime API call? ...

Have you tried the GetSystemTime API call?

Here's the entry from the API Guide:

Private Declare Sub GetSystemTime Lib "kernel32" (lpSystemTime As SYSTEMTIME)
Private Type SYSTEMTIME
wYear As...
Showing results 1 to 25 of 120

 


All times are GMT -4. The time now is 10:40 AM.


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