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 34
Search took 0.01 seconds.
Search: Posts Made By: ozPATT
Forum: Access VBA January 20th, 2006, 11:17 AM
Replies: 11
Views: 2,156
Posted By ozPATT
woohoo!!!!! i did what you did, and passed the...

woohoo!!!!! i did what you did, and passed the form me to the function, and all of a sudden it all just worked!! thats brilliant... thanks so much for your help and patience. :D

Visit my site:...
Forum: Access VBA January 20th, 2006, 10:37 AM
Replies: 11
Views: 2,156
Posted By ozPATT
cool, i think i am getting somewhere......

cool, i think i am getting somewhere... unfortunately not quite there yet... i have the following now:

With frmMain!SubForm.Form
.txtGeneralCustomerName = rst("customer")
.txtGeneralProjectName...
Forum: Access VBA January 20th, 2006, 09:00 AM
Replies: 11
Views: 2,156
Posted By ozPATT
hey thanks so much, i am a complete novice at all...

hey thanks so much, i am a complete novice at all this kind of thing, so to be honest, i am a bit out of my league with the project I have taken on board, but it seems to be going ok so far...
...
Forum: Access VBA January 20th, 2006, 05:25 AM
Replies: 11
Views: 2,156
Posted By ozPATT
i have another problem now regarding the code...

i have another problem now regarding the code above. The recordset is populated now fine with the data from the database, however when it comes to populating the form controls, nothing seems to...
Forum: Access VBA January 19th, 2006, 09:39 AM
Replies: 11
Views: 2,156
Posted By ozPATT
hi there, thanks for the reply. the intProjID...

hi there, thanks for the reply. the intProjID gets set as a global variable when they select the project they want to work with...

actually, thanks to your reply, I have checked the intProjID and...
Forum: Access VBA January 19th, 2006, 06:55 AM
Replies: 11
Views: 2,156
Posted By ozPATT
Firing Blanks...

hi everyone,

I have managed to get by over the last couple of years by knowing only basic sql. However, following a change in job role, it is becoming more and more necessary to know more complex...
Forum: Access VBA January 4th, 2006, 05:39 AM
Replies: 3
Views: 1,464
Posted By ozPATT
passing variables through a combo box

hi all,

i am wondering how to pass the id of a combo box item to an sql statement.

I have a cb populated with a list of departments, pulled from the departments table. i want to display the...
Forum: Access VBA December 21st, 2005, 09:20 AM
Replies: 2
Views: 1,519
Posted By ozPATT
thats great thanks very much. i have a form...

thats great thanks very much.

i have a form in the database that opens on startup and closes obviously when you exit. the only way you can close the form is by closing access (except for using...
Forum: Access VBA December 21st, 2005, 06:52 AM
Replies: 2
Views: 1,519
Posted By ozPATT
capturing activity

Hi all,

I am needing to capture as much activity as I can within a database, and insert into a hidden table within the db.

you know how on all other microsoft apps you can run macros when the...
Forum: Access VBA December 13th, 2005, 05:16 AM
Replies: 2
Views: 944
Posted By ozPATT
hi, I have found a way to search it, thought of...

hi, I have found a way to search it, thought of it last night and have just tried it and it worked. Basically, although access displays the date in dd/mm/yyy format, it must still store it as...
Forum: Access VBA December 12th, 2005, 09:11 AM
Replies: 2
Views: 944
Posted By ozPATT
searching tables

hi all,

i am trying to pull from a table where the start date is greater than/equal to a specified 'from', and the start date is less than/equal to a specified 'to'.

problem is, it is...
Forum: Access VBA December 8th, 2005, 06:03 AM
Replies: 0
Views: 980
Posted By ozPATT
Opening Project from Access

Hi all again,

New question... I need to open a project plan, and display a form contained within that project plan, all from a form in access.

I learnt how to open an excel spreadsheet from...
Forum: Access VBA December 7th, 2005, 11:16 AM
Replies: 3
Views: 4,354
Posted By ozPATT
HI, thanks very much for your reply. While I was...

HI, thanks very much for your reply. While I was just copying some code for you, I realised what I had done wrong. I forgot to set one of the objects. The code I have used is as follows:

'EXPORT...
Forum: Access VBA December 7th, 2005, 10:07 AM
Replies: 3
Views: 4,354
Posted By ozPATT
Loop Through Queries

Hi All,

I am trying to work out how to export all queries in a database that start with "Lookahead Report", to Excel, with the click of a button.

I have worked out how to export them using...
Forum: Access VBA November 23rd, 2005, 08:27 AM
Replies: 1
Views: 1,659
Posted By ozPATT
Dynamic Filename

Hi all,

I have been doing a lot of work in Excel, and have found that using application.getopenfilename gives more control to the user as the program is more dynamic.

I am now doing some work...
Forum: Excel VBA November 16th, 2005, 10:54 AM
Replies: 4
Views: 1,518
Posted By ozPATT
fantastic. thanks yet again for your replies. I...

fantastic. thanks yet again for your replies. I have used the above example and it has worked fine. Thanks so much.

Patrick

Visit my site: http://www.drybonesuk.com
Forum: Excel VBA November 16th, 2005, 09:51 AM
Replies: 4
Views: 1,518
Posted By ozPATT
finding a worksheet

Hello! Firstly thanks everyone for their help so far with my many questions. I really appreciate it and I am learning loads as a result.

i have a slightly more complex question i think...

i...
Forum: Excel VBA November 15th, 2005, 08:28 AM
Replies: 1
Views: 4,006
Posted By ozPATT
data binding a combobox

Hi,

I have managed to build myself a combobox using data from another worksheet as the source data. is it possible to sort the list in the combobox by name? i am thinking that as i am using a...
Forum: Excel VBA November 4th, 2005, 06:11 AM
Replies: 2
Views: 2,197
Posted By ozPATT
thats fine thanks. used that as a base and played...

thats fine thanks. used that as a base and played around a bit and have it working fine now. my code is not very dynamic, but hey, at least it does the job for now. :o)

thanks

Visit my site:...
Forum: Excel VBA November 2nd, 2005, 11:50 AM
Replies: 2
Views: 2,197
Posted By ozPATT
arrays

Hi again,

could someone help me out with an array in vba?

I have about 15 words that I want to search for in an excel spreadsheet.

for each word in the array, i want to search the sheet...
Forum: Excel VBA October 31st, 2005, 12:03 PM
Replies: 2
Views: 948
Posted By ozPATT
thanks very much, that worked a treat! Visit...

thanks very much, that worked a treat!

Visit my site: http://www.drybonesuk.com
Forum: Excel VBA October 31st, 2005, 05:26 AM
Replies: 2
Views: 948
Posted By ozPATT
Date Formatting

Hi all,

I have written a vba macro that takes dates from two seperate workbooks and pastes them into a new workbook.

the 2 source workbooks both have the date format as dd/mm/yyyy, and the...
Forum: Excel VBA October 18th, 2005, 03:34 AM
Replies: 1
Views: 1,321
Posted By ozPATT
creating toolbars

hi,

I would like to create a toolbar with various buttons on it when the project is opened. i keep getting an invalid procedure call or argument error. My code for the toolbars is :

Public...
Forum: Excel VBA October 14th, 2005, 05:49 AM
Replies: 1
Views: 1,030
Posted By ozPATT
moving around a page

hi again,

i am sort of getting the hang of this vba business now... thanks for all your help so far.

how do I go about changing the flow of how the code runs? for example, i would like to have...
Forum: Excel VBA October 14th, 2005, 04:49 AM
Replies: 0
Views: 890
Posted By ozPATT
overwriting file

hi people,

i know this is the excel forum, but there isnt a forum for MS Project, and I am exporting to excel so perhaps that falls into the ok category?? ;)

i am using the mapedit method in...
Showing results 1 to 25 of 34

 


All times are GMT -4. The time now is 07:43 AM.


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