Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 162
Search took 0.04 seconds.
Search: Posts Made By: winshent
Forum: Modules & VBA 09-18-2015, 05:52 AM
Replies: 19
Views: 3,233
Posted By winshent
Re: ADO Error Saving Memo Field

I finally managed to get some time on this (I'm moving across to a Cognos TM1 developer role) and get this working using ADO parameters...

Took some inspiration from the following thread.. ...
Forum: Modules & VBA 08-27-2015, 07:06 AM
Replies: 5
Views: 1,118
Posted By winshent
Forum: Modules & VBA 08-27-2015, 06:25 AM
Replies: 5
Views: 1,118
Posted By winshent
Re: .BOF/ .EOF Giving false results with WHERE statement

Will give that a try but thought JET uses '*', Whereas SQL Server uses '%' ??
Forum: Modules & VBA 08-27-2015, 05:45 AM
Replies: 5
Views: 1,118
Posted By winshent
.BOF/ .EOF Giving false results with WHERE statement

I'm quite confused by this..

I am testing if a sql recordset contains records.. normal stuff..

The WHERE statement is based on input parameters and will insert either 'LIKE' or 'NOT LIKE'...
Forum: Modules & VBA 08-12-2015, 06:08 AM
Replies: 2
Views: 395
Posted By winshent
Re: 3 seperate folders to send PDF files

Use an array...

dim varFolder(2) as string

varFolder(0) = "C:\Users\User\Documents\ invoice"
varFolder(1) = "C:\Users\User\Documents\cofc"
varFolder(2) = "C:\Users\User\Documents\despatch
Forum: Modules & VBA 08-12-2015, 06:03 AM
Replies: 19
Views: 3,233
Posted By winshent
Re: ADO Error Saving Memo Field

So i could never get this working without closing the bound form frmProfiles first..

Cheers VBAInet for your help.. I can't upload a copy here as it will be flagged as a security breach.
Forum: Modules & VBA 07-13-2015, 06:22 AM
Replies: 43
Views: 1,276
Posted By winshent
Re: Error 424 when opening .xlsx from Access 2010

Filepath length over 250 characters ?
Forum: Modules & VBA 07-13-2015, 05:29 AM
Replies: 43
Views: 1,276
Posted By winshent
Re: Error 424 when opening .xlsx from Access 2010

Security related issue ?

Is it a trusted document/ location ?
Forum: Modules & VBA 07-13-2015, 03:00 AM
Replies: 43
Views: 1,276
Posted By winshent
Re: Error 424 when opening .xlsx from Access 2010

Try
.Parent.WindowState = xlMaximized
Forum: Modules & VBA 07-13-2015, 02:33 AM
Replies: 43
Views: 1,276
Posted By winshent
Re: Error 424 when opening .xlsx from Access 2010

I tested the code with Office 2003 (don't have 2010 here)...

As long as Excel Object Library is added to the list of references, code works fine here.

Suggest maybe an install problem.. try...
Forum: Modules & VBA 07-13-2015, 02:19 AM
Replies: 43
Views: 1,276
Posted By winshent
Re: Error 424 when opening .xlsx from Access 2010

If you comment out....

.WindowState = xlMaximized
Forum: Modules & VBA 07-13-2015, 02:07 AM
Replies: 43
Views: 1,276
Posted By winshent
Re: Error 424 when opening .xlsx from Access 2010

So if you comment that line out the code runs fine ?
Forum: Modules & VBA 07-13-2015, 01:38 AM
Replies: 43
Views: 1,276
Posted By winshent
Re: Error 424 when opening .xlsx from Access 2010

That line is not part of the code posted by vbaInet
Forum: Modules & VBA 07-10-2015, 07:04 AM
Replies: 8
Views: 1,722
Posted By winshent
Re: Postcode Validation

Why not download the postcode data and then validate against real data..
Forum: Modules & VBA 07-10-2015, 06:42 AM
Replies: 43
Views: 1,276
Posted By winshent
Re: Error 424 when opening .xlsx from Access 2010

Have you tested with a blank workbook instead of WorksPrice.xlsx?
Forum: Modules & VBA 07-10-2015, 05:37 AM
Replies: 43
Views: 1,276
Posted By winshent
Re: Error 424 when opening .xlsx from Access 2010

Does this help you?

http://www.eng-tips.com/viewthread.cfm?qid=19576
Forum: Modules & VBA 07-10-2015, 02:10 AM
Replies: 1
Views: 388
Posted By winshent
Re: Unbound Textbox To Recordset (Vice Versa)

Firstly rename the subform control as 'frm_Main_Sub'..

To do this, put the main form in design mode and right click on the subform to go to properties. Set the name of the subform object in the...
Forum: Modules & VBA 07-10-2015, 01:45 AM
Replies: 7
Views: 1,206
Posted By winshent
Re: Parse UDT as parameter

This is now fixed... Turns out the code was working, it was an issue with the excel output code.. sorry for wasting your time guys...

Marked as solved..
Forum: Modules & VBA 07-10-2015, 01:16 AM
Replies: 11
Views: 727
Posted By winshent
Re: Over Night Error

What happens when you run this yourself on a test environment, changing the output paths etc...

By "Overnight" are you implying this is a triggered batch job somehow called from a scheduler or is...
Forum: Modules & VBA 07-10-2015, 12:55 AM
Replies: 7
Views: 1,206
Posted By winshent
Re: Parse UDT as parameter

Yes its all in the same module so is all in scope...

I have stepped through the debugger... Like I say, the parameter pudtOutputRows within mOutputToExcel does not contain any data when loaded.. ...
Forum: Modules & VBA 07-09-2015, 07:59 AM
Replies: 7
Views: 1,206
Posted By winshent
Re: Parse UDT as parameter

The assignment of data is within another block of code:

If !RACFException = 0 Then

j = j + 1
mudtOutputRowsMatched.Count = mudtOutputRowsMatched.Count + 1
ReDim Preserve...
Forum: Modules & VBA 07-09-2015, 07:32 AM
Replies: 7
Views: 1,206
Posted By winshent
Parse UDT as parameter

I have a User Defined Type which stores an array..

I have 2 instances of this UDT, one storing matched data, the other storing exception data

I was to parse these arrays to an Excel output...
Forum: Modules & VBA 06-30-2015, 07:14 AM
Replies: 19
Views: 3,233
Posted By winshent
Re: ADO Error Saving Memo Field

Still struggling with this... anyone else have ideas ?

ETA, didnt realise you had responded again as it rolled over to 2nd page vbaInet...

I've been looking at this example... ...
Forum: Modules & VBA 06-10-2015, 05:35 AM
Replies: 13
Views: 2,734
Posted By winshent
Forum: Modules & VBA 06-10-2015, 02:43 AM
Replies: 19
Views: 3,233
Posted By winshent
Re: ADO Error Saving Memo Field

Hi

tried this example... this is my code (DAO).. still get the error


.Edit
!Access = txtAccess.value
strPermissionString = Trim(txtPermissionString.value)
!Dataset =...
Showing results 1 to 25 of 162

 
Forum Jump



All times are GMT -8. The time now is 02:52 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World