Search results for query: *

Hey all, @Chris, yes, I am planning to have a user input, probably in PHP - also need to learn this. For the moment, I am just setting up the DB. In short, assume a 1-many relationship between users and profiles and profiles and family. A user creates a new record in profiles (via a...

OK, will do. Thanks Vacunita Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!

Hi all, I'm trying my hand at some MySQL. Although I am a seasoned programmer, I have never touched MySQL and I am struggling to create a new trigger using phpMyAdmin. In short, there are 3 tables, "tblusers" "tblprofile" and "tblfamily". Assuming a user is logged in and they want to create a...

Hi all, I'm trying my hand at some MySQL. Although I am a seasoned programmer, I have never touched MySQL and I am struggling to create a new trigger using phpMyAdmin. In short, there are 3 tables, "tblusers" "tblprofile" and "tblfamily". Assuming a user is logged in and they want to create a...

How sure are you that it's returning NULL values and not empty strings? Try: a) IIf(Len([workrvu])<0,0,([workrvu])) - or - b) IIf([workrvu]="",0,([workrvu])) F. Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!

I haven't tried this, but I'm sure I've seen something similar. You've got 2 choices: a) Try IIf([workrvu]=Null,0,[workrvu]) b) Write a short function in VBA to check the value. I think a) wil work as I'm sure I've come across something very similar, yet I can't remember over what. Give it a...

I tried that first of all. It's definately due to the merged cell. I don't have the ability to change it from a merged cell but that's what's causing the issuue. Thanks for your thoughts tho. F. Fitz Did you know, there are 10 types of people in this world: * Those who understand binary...

Hi all, I'm trying to get a value from a closed workbook which is in merged cell B30:G32 and I get error 2015. If I change the reference to "E10" (a non merged cell) it works. Private Function GetValue(path, file, sheet, ref) ' Retrieves a value from a closed workbook Dim arg As String...

Hey all, I'm still struggling with this one. As a temporary solution I've set txtDate as =Format(Now(), "DD-MMM-YYYY") in it's default value which has temporarily fixed the problem. It still allows the ability to change the data via the other "working" form. I could leave this solution in as...

Sorry, I should have shown the rest of the code, I had put it in the top piece and then removed it to save over complicating it. To answer your questions: What section is txtDate located in? Header, Detail, etc.? - Detail Is the field bound? - No - Unbound Does the opened form have a...

Agreed. I like your thinking, but no :-( The "frmBookInOut" form is a single form which has a number of "txtDate" controlled list boxes, however, I have tried waitng for a few seconds and trying again and to no avail. Further investigations: I've set the default value of "txtDate" to be...

Hi Andy, Good call, however, it's not that. I've checked another copy of the same system and it's working fine. . . . . References are exactly the same. F. Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!

Hi All, Hopefully this won't be too confused. I have a "Register" Form to book people in and out using a Bar code etc. This form is called "frmBookInOut". When loading from the Main Menu, this form uses now() to calculate from. If a different date to day is required, another form is loaded...

Found the issue. Incase anyone else comes across this, I had connected to the Server, but had not connected to the database. The FILEPROPERTY "SpaceUsed" returns NULL for any Database that is isn't connected to. ie I needed to specify the connection directly to that DB and then all works ok...

Hi Skip, I'll give it a shot, but the problem isn't with the name or filename fields, it's with the "FILEPROPERTY" part. :-S [bigears] Fitz Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those who Don't!!

Hi All, I wonder if you can help me, I'm trying to return some values using a connection from Excel to SQL Server. The code I'm using is as follows: select name, filename, convert(decimal(12,2),round(a.size/128.000,2)) as FileSizeMB ...

Hi, How do you know your value is null? I've just tried it and the default value is set to 0, which is correct I believe? Let me knwo and I'll try and help . . . . Regards, TheFitz Fitz Did you know, there are 10 types of people in this world: * Those who understand binary and * Those...

Hi All, Here's a good one for you. I've got a report, which for each record,highlights fields depending on the values in that field, think Conditional Formatting, however, I have got this working for a number of different values, for example, I've used percentages in blocks of 10 as below...

Thanks Duane for the info, I've solved it, with was a school boy error in my coding: Function ReturnRST(strSQL As String) As ADODB.Recordset Const DB_CONNECT As String = "Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;Port=3306;Database=EBGSDT;User=****; Password=****;Option=3;" Dim cn As...

Hi, I'm not sure exactly what you are trying to do, however, to me it doesn't quite seem as simple as you are talking. Do you have fields defined in the word document to hold the name and address or is it just free text. If it's just free text, you have no way of defining the actual name or...