Search:
Type: Posts; User: salvelinus
Search:
Search took 0.92 seconds.
-
Thanks, that worked great!
-
Why, in the code below, does the outermost div tag, the one with the border style, only enclose the first inner div tag? I want the outer div to enclose all elements, which it looks like it should...
-
You might try using pixels or some type of absolute measurement instead of percents. Different browsers, screen resolutions, etc., may render some things differently. Getting back to IE again, I...
-
Don't know the answer, but IE6 is notoriously non-compliant with many internet coding standards. Probably no browser is 100% compliant, but there's almost a cottage industry of hacks addressing it....
-
I have a table created in php. The corresponding css file highlights a row when the mouse hovers over it. That works ok, except the last two rows, one of which is blank and one with a button, should...
-
However,if you write it in a formula in a cell, you would use Upper(A1), at least through XL 2K. And if you were writing VBA (macro) code, that is what you'd need.
Not sure if you're running XL as...
-
Can't you do a INSERT INTO tbl2 SELECT * FROM tbl1? Or am I misunderstanding?
If you don't plan to insert all the values from tbl1 into a matching design tbl2, you need to specify all values....
-
Technically, it changes the query in SQL to add the ORDER BY clause. Whether or not you save that change is another matter. End users may not want/be able/capable of doing that themselves, and I've...
-
Where did my earlier reply go?
Anyway, when you sort the query, are you doing that by using an ORDER BY clause in the query, or just sorting by selecting a field to sort by in the query datasheet...
-
INSERT INTO table2 (FieldID, field9, field8...)
SELECT Table1.FieldID, Table1.Field1, Table2.field2...
FROM Table1
Unless you have a specific reason, there should be no reason to insert more...
-
Look up CREATE TABLE Sql syntax
-
Pretty much, but I wouldn't declare sqlStr as a constant. Not sure adCmdTable is correct. Someone will no doubt chime in on that.
Whoops, my bad, I mixed up which code snippets you wanted to...
-
si is correct, no control arrays in VBA (unless the newest versions of Office support them).
Didn't check out koolsid's link, but modified his code in case you have lines you don't want affected.
...
-
That's another method too. Or to a new table. Doing either you'd need to watch your field names, in case any queries/recordsets reference the field name.
-
You might also look at GROUP BY, depending on your needs.
-
Not really from a macro. The easiest way to do so would be with an ALTER TABLE Sql statement. You could write that as a saved query and call it from a macro, but it might be problematic with varying...
-
Unless it's just a matter of posting format, you need spaces in places, i.e. "...(CLINICS.DATE)<#1/1/2001#)..."
Dates have been the subject of many questions lately. There's a good FAQ here....
-
If nothing else, your line continuation character is wrong. It's & _ not just _
-
You may do better in this forum.
-
Your SQL is still wrong.
"SELECT * FROM Sfusers WHERE Supervisor LIKE '%" & textbox1.text & "%'"
-
What is your error now?
Caveat re VB.Net above, try using .Value instead of .Text. Should be no need for brackets around .Text, anyway.
If this code is in your form, replace form1 with Me.
Put the...
-
Your SQL:
'SELECT * ' & _ 'FROM Sfusers ' & _ 'WHERE Supervisor LIKE ''%' & form1.textbox1.[text] & '%'''
looks incorrect, but I don't know if that's just the formatting you used to post it....
-
Iif will check whether the first clause is true or false. If true, it will then do the next clause (Credit, in your example). If false, it will do the last clause (Null, in your example, although...
-
This may be Access version dependent, but you could also try Me.yourFormName.yourTextboxName.
Or use .Value, like anhn suggests.
Either way, first check to make sure some value is there. We have...
-
I don't understand your question.
If this is Excel, which I don't know that well, the problem may be in using iff in your formula. I think Excel in this case just uses IF
...
-
You probably don't want Max - 1 - there may be no records corresponding to that. If Max is 10, there may be no 9. What I think you want is the 2nd record in a set ordered by someField DESC.
You...
-
If the values aren't going to change, declare them as constants, rather tham variables.
Public Const CEOHr As Integer = 1
Public Const ChairmanHr As Integer = 2
This will eliminate the need for...
-
I'm not sure you're allowed to start field names with a number. Can You SELECT on them w/o the SUM?
-
Assuming you mean the string can be anywhere in the contents of the memo field, use LIKE:
SELECT yourMemoField FROM yourTable
WHERE yourMemoField LIKE '*yourString*'
-
You'd have to do that manually, something along the lines of
UPDATE yourTable SET yourNumberField = yourNumberField + 1
WHERE yourNumberField >= newNumberToInsert
You'd have to do this...
-
Well, wouldn't that return just one record for each CRN_ID? Each CRN_ID in the result would be unique.
Maybe I don't understand what vijay wants. I suppose my query would also return a result for...
-
Echo Hack. There's generally no "standard value" for a field (maybe Null is the default, but whatever).
If you design a table in Access, I believe you can give a field a default value, which may be...
-
SELECT FIRST_NAME, LAST_NAME, PAN_No
GROUP BY CRN_ID, LAST_NAME, FIRST_NAME, PAN_No
Haven't tested, but that should do what you want. You could change the order of the last three fields in the...
-
"select * from Products where UnitPriceDhs = " & Val(txtSearchValue.Text)
Val can be replaced by CLng, CInt, CDbl, etc, as appropriate.
-
Not to be pedantic, but you should know why anhn's solution worked.
Users enter something in a textbox. They may enter the characters 123. That entry is a String, or Text, datatype. It isn't the...
-
On the data tab of the property box of the textbox, you can set Input Mask to short date. Presumably you can set the property via code, but don't know why you'd bother.
-
That works and is a more elegant solution than mine, except I don't see a reason to store Year, since you can get it with a function at any time.
Storing just one record in a table seems odd, but...
-
You can use multiple fields as a primary key (aka a compound key as Gary says), and that combo of fields would automatically be indexed as well.
You can also set indexes on non primary fields,...
-
De nada. It's annoying, but there's probably a mathematical set based reason for it si or someone could explain.
Although if you've already used an aggregate function on the field in the SELECT, you...
-
You'd have to do it manually each time you INSERT a record, or UPDATE that field. It would require a search for any existing records containing that new value, or at least finding the last one and...
|
Click Here to Expand Forum to Full Width
|