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 17 of 17
Search took 0.01 seconds.
Search: Posts Made By: alastair
Forum: Access VBA December 20th, 2006, 06:19 PM
Replies: 3
Views: 42,940
Posted By alastair
Thanks for your suggestion, the public variable...

Thanks for your suggestion, the public variable worked with a little extra trial and error. The only combination I've found that works has all the code in the first form (form2, which opens form3...
Forum: Access VBA December 17th, 2006, 05:39 PM
Replies: 3
Views: 42,940
Posted By alastair
How to put a value into another form's text box?

I have a form (form2) with a listbox of names. What I want is that when users wanting to edit a name in the list can double-click it to open a second form (form3) in which the name is shown in a text...
Forum: Access VBA August 20th, 2006, 11:25 AM
Replies: 9
Views: 138,919
Posted By alastair
Found the answers at: ...

Found the answers at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaof11/html/ofobjFileDialog_HV03083230.asp
Forum: Access VBA August 12th, 2006, 03:40 AM
Replies: 2
Views: 11,930
Posted By alastair
Here's the answer: ...

Here's the answer:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office09072000.asp
Forum: Access VBA August 11th, 2006, 03:43 PM
Replies: 2
Views: 11,930
Posted By alastair
PS I just found the "Kill" way to delete files...

PS I just found the "Kill" way to delete files (see topic "Writing VBA Code for DOS Commands" in this forum) but would still like more info on DIR, CHDIR etc.
Forum: Access VBA August 11th, 2006, 03:21 PM
Replies: 2
Views: 11,930
Posted By alastair
How to run DOS file commands using vba?

I'd like my db to run various dos file-management commands, including dir (so it can detect and process whatever files are in the directory), and to be able to delete files.

Can anyone point me to...
Forum: Access August 3rd, 2006, 08:04 AM
Replies: 2
Views: 2,932
Posted By alastair
This will work. I chose to call the columns ...

This will work. I chose to call the columns

"Start" "End" "Minus30" and "Plus30"

1. Make a query in design view
2. Save it
3. Double click each of the four fields to a column in the query...
Forum: Access January 30th, 2006, 04:01 PM
Replies: 4
Views: 1,804
Posted By alastair
1. The reason DATE worked where NOW didn't is...

1. The reason DATE worked where NOW didn't is that NOW includes the time. So if the date is represented by an integer, let's use 12345 as an example, then if you call NOW at mid-day the value would...
Forum: Access January 25th, 2006, 05:53 PM
Replies: 7
Views: 2,443
Posted By alastair
Thanks as ever !

Thanks as ever !
Forum: Access January 25th, 2006, 01:33 PM
Replies: 7
Views: 2,443
Posted By alastair
Thanks again Bob. It looks like the functionality...

Thanks again Bob. It looks like the functionality of a listbox is more constrained than Microsoft let on !

I've spent some time trying to find information on this from the obvious sources - do you...
Forum: Access January 20th, 2006, 09:15 PM
Replies: 7
Views: 2,443
Posted By alastair
Bob, I'm grateful to you for your reply. Your...

Bob, I'm grateful to you for your reply. Your code is similar to mine, but even with yours a couple of problems remain:

1) The afterupdate event for the listbox causes the listbox to behave...
Forum: Access January 19th, 2006, 05:32 PM
Replies: 7
Views: 2,443
Posted By alastair
Listbox

I'm using a listbox to display names: the user clicks a name and various fields from the chosen person(address etc) are shown on the form.

The form has 3 toggle buttons which determine whether the...
Forum: Access January 15th, 2006, 06:37 AM
Replies: 5
Views: 5,613
Posted By alastair
1. I don't understand exactly what the code has...

1. I don't understand exactly what the code has to do so I'd need some samples of the input (number) and the text you want it to generate. How does the 'currency' function display 12.34, 1234.56...
Forum: Access January 14th, 2006, 07:14 PM
Replies: 5
Views: 5,613
Posted By alastair
Hi Civa, here's your answer and a few other...

Hi Civa, here's your answer and a few other points too.

1. The function doesn't return any text because "Exit Function" happens before "Getwords = Words" has run. Move the assignment in front of...
Forum: Access January 3rd, 2006, 09:30 PM
Replies: 4
Views: 2,929
Posted By alastair
It sounds like you want to combine records from...

It sounds like you want to combine records from two tables (so if one contains records APPLE, ORANGE, PLUM, and the other contains records LETTUCE and ONION you want a single recordset containing...
Forum: Access December 29th, 2005, 06:04 PM
Replies: 2
Views: 2,228
Posted By alastair
Thanks, that's got it. As for the other problem,...

Thanks, that's got it. As for the other problem, I think there's something weird with the form so I'm going to start over.
Forum: Access December 27th, 2005, 01:31 PM
Replies: 2
Views: 2,228
Posted By alastair
Select an particular item when a listbox opens?

1) I have a listbox of names which is populated by one of several queries, selected by VBA according to the user's selection on a form. I want to fix it so that when the listbox opens the item...
Showing results 1 to 17 of 17

 


All times are GMT -4. The time now is 08:13 PM.


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