Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.05 seconds.
Search: Posts Made By: BlueIshDan
Forum: Modules & VBA 03-24-2016, 08:53 AM
Replies: 5
[SOLVED] Property Problem
Views: 569
Posted By BlueIshDan
Re: Property Problem

Try it out, its nice on these eyes through longer durations and helps me process what I'm seeing more easily.
Forum: Modules & VBA 03-21-2016, 05:19 AM
Replies: 5
[SOLVED] Property Problem
Views: 569
Posted By BlueIshDan
Re: Property Problem

Im dumb, I figured it out.

There is no return datatype on the gets! I've done this right on many other classes, but for some reason, this one is the one to absorb all of my Monday dumbness! Hahaha
Forum: Modules & VBA 03-21-2016, 04:15 AM
Replies: 5
[SOLVED] Property Problem
Views: 569
Posted By BlueIshDan
Property Problem

Hello,

I am building some classes, and I have run into a problem that I don't understand.

The compile errors out on the Private Property Let Description line.

If anyone could point out what...
Forum: Modules & VBA 02-10-2016, 09:52 AM
Replies: 24
Views: 894
Posted By BlueIshDan
Re: [Sub] CreateDirectories - Approve Or Improve Please

Thanks again for the guidance!
Just came back for the function, thought I'd give a thanks. =]
Forum: Modules & VBA 01-05-2016, 04:11 AM
Replies: 14
Views: 70,101
Posted By BlueIshDan
Re: Set field to Null instead of zero length string

If Len(txtBox.Value & vbNullString) > 0 Then
Forum: Modules & VBA 12-24-2015, 04:27 AM
Replies: 5
Views: 604
Posted By BlueIshDan
Re: Design Help Required For: ConvertNumberToDefinition Function

I have it working, I just was wondering if anyone knew of a formula that would be as minimized as the first function's formula. Rather than looping to the highest known factor of the definition...
Forum: Modules & VBA 12-24-2015, 03:40 AM
Replies: 5
Views: 604
Posted By BlueIshDan
Re: Design Help Required For: ConvertNumberToDefinition Function

Its more or less defining a custom set of characters that hold values with respect to their position in the definition. Which follows the same design as what we use today, its just not commonly...
Forum: Modules & VBA 12-24-2015, 03:36 AM
Replies: 5
Views: 604
Posted By BlueIshDan
Re: Design Help Required For: ConvertNumberToDefinition Function

This is for all common, and custom base numbering systems.
A numbering system can be define by placing each of its characters into a string in order from value 0 to Max.

"01" Binary
"01234567"...
Forum: The Watercooler 12-23-2015, 10:29 AM
Replies: 132
Views: 7,614
Posted By BlueIshDan
Re: Is it worth working?

You can become a hell of a lot more of a "human being", a dynamic conversation simplified for now, if you choose to tackle life in the environment of the real world. Being pampered by your country's...
Forum: Modules & VBA 12-23-2015, 10:20 AM
Replies: 5
Views: 604
Posted By BlueIshDan
Design Help Required For: ConvertNumberToDefinition Function

Hello There,

Sometime in the past year, I posted a function that converted non-decimal based string values. Like HEX "0123456789ABCDEF" and/or any other numbering definition you can think of.
...
Forum: Modules & VBA 12-08-2015, 03:06 AM
Replies: 3
Views: 394
Posted By BlueIshDan
Re: Syntax error

You could always make a public function within a module that acts as an interface between VBA and the database engine... Idk what kind of flags that raises for anyone, or if it causes huge...
Forum: Modules & VBA 12-02-2015, 06:57 AM
Replies: 11
Views: 2,228
Posted By BlueIshDan
Re: How to create .HTMLBody tables for Outlook Email

Also to save room, you may be able to use this within your header tags:

.HTMLBody = "<HTML><head><style> th, td { text-align: left;}</style></head><BODY STYLE=......" etc
Forum: Modules & VBA 12-02-2015, 06:52 AM
Replies: 11
Views: 2,228
Posted By BlueIshDan
Re: How to create .HTMLBody tables for Outlook Email

try <th style="text-align: left;">

Some html parsers don't like when you don't finish with ;
Forum: General 12-02-2015, 05:21 AM
Replies: 6
Views: 840
Posted By BlueIshDan
Re: Help wanted, relations between tables

Without having the time to look through your previous suggestions. I noticed that you're attaching linking primary-keys to primary-keys. Be sure to create a foreign key within a table when trying to...
Forum: Modules & VBA 12-02-2015, 03:01 AM
Replies: 11
Views: 2,228
Posted By BlueIshDan
Re: How to create .HTMLBody tables for Outlook Email

your first TR (ROW) should contain all of your TH (Headers)
Each TR after should contain each of your records, in order respective to the headers.


<table>

<!-- HEADERS -->
<tr>...
Forum: Modules & VBA 12-02-2015, 02:58 AM
Replies: 11
Views: 2,228
Posted By BlueIshDan
Re: How to create .HTMLBody tables for Outlook Email

That table is not structured right.
Forum: Modules & VBA 12-02-2015, 02:57 AM
Replies: 11
Views: 2,228
Posted By BlueIshDan
Re: How to create .HTMLBody tables for Outlook Email

if I'm not mistaken, you didnt put <th style="text-align: left">
Forum: Modules & VBA 12-01-2015, 09:41 AM
Replies: 8
Views: 1,052
Posted By BlueIshDan
Re: VBA Enable TextBox with ComboBox Selection

That's because its the same as the code you posted, just shortened.
Forum: Modules & VBA 12-01-2015, 09:16 AM
Replies: 8
Views: 1,052
Posted By BlueIshDan
Re: VBA Enable TextBox with ComboBox Selection

what's with these being in every case?

Me.TextEndResult_Violation_Performance.Visible = False
Me.LabelEndResult_Violation_Performance.Visible = False
Forum: Modules & VBA 12-01-2015, 08:55 AM
Replies: 8
Views: 1,052
Posted By BlueIshDan
Re: VBA Enable TextBox with ComboBox Selection

Compressed Version of what you currently have.

PROBLEM: I do not see your design here. Any way you can screenshot your form layout, and maybe give another description of what it is that you wish...
Forum: Forms 12-01-2015, 08:26 AM
Replies: 18
Views: 774
Posted By BlueIshDan
Re: DCount with multiple createris

janith Could you copy your whole code snippet in [CODE] [/ CODE] braces for us please? =]
Forum: Forms 12-01-2015, 08:24 AM
Replies: 18
Views: 774
Posted By BlueIshDan
Re: DCount with multiple createris

I was far too entertained with createris!
Forum: Modules & VBA 11-30-2015, 01:12 PM
Replies: 11
Views: 2,228
Posted By BlueIshDan
Forum: Modules & VBA 11-30-2015, 11:01 AM
Replies: 11
Views: 2,228
Posted By BlueIshDan
Re: How to create .HTMLBody tables for Outlook Email

Not sure what your question is looking for exactly, but this is how you format tables in HTML




<table>

<tr>
<td>Field Changes</td>
<td>Project Address</td>
Forum: Theory and practice of database design 11-30-2015, 10:48 AM
Replies: 12
Views: 2,193
Posted By BlueIshDan
Re: Word Sentiment Value Tables

FYI, This turned out to be a really cool and informative project for me. I've been able to query my set of 5,000 incoming emails and come up with a spectrum between positive neutral and negative...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 09:54 AM.


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