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 | 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 15 of 15
Search took 0.01 seconds.
Search: Posts Made By: JonniP
Forum: Access January 6th, 2007, 04:21 PM
Replies: 2
Views: 822
Posted By JonniP
simplest thing would be to use the wizard to...

simplest thing would be to use the wizard to create a combo box, on the toolbar where you would select the combo box click on the wand on the top, then select the combo box,

Hope that helps
Jonni
Forum: Access January 5th, 2007, 01:57 PM
Replies: 15
Views: 5,412
Posted By JonniP
i will try that, just to say i really appreciate...

i will try that, just to say i really appreciate all your expertise on this,
have a nice weekend
Jonni
Forum: Access January 5th, 2007, 09:07 AM
Replies: 15
Views: 5,412
Posted By JonniP
Hi Mary That causes a error "object required" i...

Hi Mary
That causes a error "object required" i think i will just leave it with the "error resume" as it is doing all that i need it to.

Another question - When i create a folder, it takes info...
Forum: Access January 5th, 2007, 09:01 AM
Replies: 6
Views: 1,295
Posted By JonniP
sorry i was not sure how to formulate my question...

sorry i was not sure how to formulate my question (obviously)
its working now,

Dim strShortcut As String
strShortcut = Me.txtShortcut

Call Shell("explorer.exe " & strShortcut,...
Forum: Access January 4th, 2007, 01:48 PM
Replies: 6
Views: 1,295
Posted By JonniP
cheers how can i call the folder from a string?

cheers how can i call the folder from a string?
Forum: Access January 4th, 2007, 01:35 PM
Replies: 15
Views: 5,412
Posted By JonniP
no difference im afraid

no difference im afraid
Forum: Access January 4th, 2007, 11:11 AM
Replies: 15
Views: 5,412
Posted By JonniP
do you mean Dim objFSO As Variant Dim...

do you mean
Dim objFSO As Variant
Dim objFolder As Variant
Dim objCopyFolder As Variant

sorry im new to this! but no that doesnt make a difference, the error is in the objcopyfolder line
Forum: Access January 4th, 2007, 08:22 AM
Replies: 6
Views: 1,295
Posted By JonniP
opening a folder location

hi,
would like a button that opens he folder created earlier by a procedure.
My question is what is the VBA to open a folder, im sure its a easy question for you guys!

Cheers
Forum: Access January 4th, 2007, 08:17 AM
Replies: 15
Views: 5,412
Posted By JonniP
Hi, Am still wondering about the type mismatch...

Hi,
Am still wondering about the type mismatch error?
it works fine with "on error resume next" but if it can be fixed rather than hidden!
Cheers
Forum: Access January 3rd, 2007, 03:11 PM
Replies: 15
Views: 5,412
Posted By JonniP
ok fixed it i was messing around with the string...

ok fixed it i was messing around with the string earlier and put in "\\resrslavingt002\u_datacentre\MM" & " took it out and of course it works fine now DUH.
Cheers again
Forum: Access January 3rd, 2007, 03:03 PM
Replies: 15
Views: 5,412
Posted By JonniP
Amended Private Sub cmdMkDir_Click() Dim...

Amended

Private Sub cmdMkDir_Click()
Dim newFOL As String

newFOL = "\\resrslavingt002\u_datacentre\MM" & " \ " & txtHrmRef & " - " & txtName & " - " & txtBenCode
'On Error Resume Next
...
Forum: Access January 3rd, 2007, 02:58 PM
Replies: 15
Views: 5,412
Posted By JonniP
Hi, My end goal is to create a new folder with...

Hi,
My end goal is to create a new folder with a name based on 3 txt box elements from my form,
then 2 folders get copied into that folder.

So far i can create a folder (i put a dummy name in...
Forum: Access January 3rd, 2007, 02:13 PM
Replies: 15
Views: 5,412
Posted By JonniP
ok that works thank you very much! my question...

ok that works thank you very much! my question now is using FSO how can i incorporate my newFol string?
Many thanks
Forum: Access VBA January 3rd, 2007, 11:14 AM
Replies: 1
Views: 2,141
Posted By JonniP
Creating folders on network share

Hi, using this as my code, for somereason it goes ok with no error messages but doesnt create a folder, confused! it works fine if i set the path to the C:\xxx\xxx but using the network name no joy,...
Forum: Access January 3rd, 2007, 08:42 AM
Replies: 15
Views: 5,412
Posted By JonniP
Accessing Network Share with Access VBA

'***make directory TEMP
Dim newFOL As String

newFOL = txtHrmRef & " - " & txtName & " - " & txtBenCode
ChDir "\\resrslavingt002\u_datacentre"

MkDir (newFOL)

Hi, using this as my code,...
Showing results 1 to 15 of 15

 


All times are GMT -4. The time now is 12:17 PM.


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