Search:
Type: Posts; User: Gruff
Search:
Search took 0.10 seconds.
-
Jumping in here JM.
In your Select query use a calculation. I believe mySQL has a number of date & time functions.
The following will return a new column called difference that contains the...
-
Just my opinion, but I would use one main table for storing the main user data with several fields that denote parent child relationships. Perhaps a field that holds the user id of the parent.
...
-
How's that old engineering joke go...
Optimist: That glass is half full.
Pessimist: That glass is half empty.
Engineer: That glass is twice as big as it needs to be.
-
Yep,
Pretty much what I was doing in Post#3 (Minus the dbnull check.)
-
You could very well be right, though the last time I used it was version 2000.
I don't have that version on hand so....
In any case I think access has always been the odd duck of the Office VBA...
-
Well that was a couple of painful hours I will not ever get back!
Access VBA has changed a lot since I played around with it years ago. I had to unlearn a buttload of VBA code.
First there are...
-
What version of Access are you using? I only have Office Pro 2010 to test with.
Is Office installed as 64 bit or as 32 bit.
(Typically it defaults to 32 bit installation even when installed on a...
-
You are mis-using the try-catch statement.
Never use one if you do not have code to put in the catch segment.
The main reason being you can hide other errors you might need to know about.
This can...
-
Hope you do not mind westconn1. :)
First I would ask how you are populating List63.
Is it being driven from a field in the database, or are you filling it from code?
If it is driven from a...
-
Kind of an import part to omit when trying to trouble shoot. ;)
-
I come from a family with three generations of postal workers. My old man put in 30 years. He'd roll over in his grave if he saw what it has become.
-
It would be nice if you told us what you expect your code to do and what is doing when you run it.
-
Yes, The cell formatting event fires for every cell one at a time.
You do not write a loop inside it.
Public Class Form1
Private Sub DataGridView1_CellFormatting(sender As Object, e As...
-
Wasn't there a Microsoft product that did this sort of thing?
I'm thinking 1990 something.
-
??? I don't think I've ever tried to make a class that inherits from a form.
Usually I create all my forms and dialogs at design-time in the form graphics deisnger and create instances of them at...
-
Lately I have had dealings with the USPO and I cannot believe how backward, in-efficient and non-customer oriented they are. Oh! Did I leave out inflexible?
There was a time when they were the...
-
Never cared for moore himself either. *Grin*
I've always worked with higher end hardware or people who use higher end hardware.
Bottom necks anywhere can limit what passes for perceived speed,...
-
Normally warnings do not stop you from compiling or running,
but they will keep popping up until you resolve them.
Open your project. Select Quick Find from your edit menu.
In the find dialog...
-
Are they errors or warnings? There is a difference.
What does it actually say? Pretty hard for us to guess. :)
-
Weeks do not fit neatly into months. You get days left over.
Also What do you consider the first day of a week? Sunday? Monday? ...
By your definition does week one start Jan 1 regardless of...
-
Offhand I would say your Patient_ID is an integer value field.
Your trying to push text into that field.
Try converting your text to a number and see if that works.
RS!patient_id =...
-
As Tyson says there is no good way to determine the count or how long a query will take due to server load or the content of the database. Most people use a marquee progress bar to show something is...
-
I do not know if it makes a difference but you are not taking advantage of your table name aliasing.
The only time you need a table name prefix is to clear up ambiguity if there is duplicate field...
-
mcsmba1,
All you have done in VB.NET 2013 so far is read a text file. That is easy.
As I said before VB.NET does not have any built in tools to read an Excel workbook file.
As far as I know...
-
Nice. Good to see you give it the old college try.
-
The following is rough, but shows the Excel solution thought process.
It assumes Column A contains the Excel number data and that the first row is 1 and that row data is in column B.
...
-
Frats? I didn't know they were a college town.
---
I always got a kick out of George Carlin and his observations on humanity.
"When two people are in an elevator and one of them rafts......
-
Realized I didn't map the listboxeditorcore listbox control events to the usercontrol.
Updated the zip attachment in the previous post to include listbox specific events.
-
Probably there is a certain air about the place.
-
Right. You can do it much simpler in Excel VBA than in VB 2013.
You would write your program as a global excel program that works on any excel workbook you load. You would use Excels VBA forms to...
-
Finally found some time and re-thought the entire listboxeditor control.
I basically re-designed the control from being a single derived control to a UserControl that is constructed from.
1)...
-
So sad.
Last time I called someone Toots HR wrote me up.
-
As you are being very very non-specific I do not think I can help you.
From what you have said I do not even see where MS word comes into the solution.
-
Here is a small proof of concept for writing UDTs from a class.
The file IO would be better if encapsulated in the custom collection class.
It is just a silly test so go easy on the code comments....
-
I believe my app which I cannot locate converted UDT code into get/let property lists not public variables.
This saved one heck of a lot of typing and made the conversion a lot less painful.
I...
-
I have no clue as to what your last paragraph means.
What kind of automatic system message? What is the source?
Are we talking email HTML format or something else?
If this is email what is the...
-
personally i would write the entire thing in Excel VBA.
You have all the tools to do the job in VBA and it would be a lot easier than trying to automate Excel from VB.NET 2013.
Create a form in...
-
Somewhere in the attic is a dusty box with a floppy that has a small program written in VB6.
It converts UDT definitions to class properties and loads them onto the windows clipboard for pasting.
...
-
If your trying to make a help interface for a program I would suggest converting the word document into a rich text document and using the RichTextBox control to display it.
Another option is to...
-
"My favorite part of 'gator? That would be da snout."
|
Click Here to Expand Forum to Full Width
|