Viewing 15 posts - 61 through 75 (of 594 total)
Tools ~ Scripting Options ~ Object Scripting Options ~ Script Permissions
set that to True, then you won't lose the access rights.
November 30, 2011 at 4:36 am
ok, understood.
=FormatDateTime(DateAdd("d", -(WeekDay(Today(),2))+1, Today()),DateFormat.ShortDate)
November 23, 2011 at 7:12 am
The syntax stays the same, it is only the format code that has to change. Two ways to get there:
#1 right-click on the text box, click properties to bring up...
November 23, 2011 at 6:35 am
logicinside22 (11/21/2011)
Hi ,it creates two file in backup device so how the automated restore process knows which is new one and which is old one?
Take a look at the syntax...
November 23, 2011 at 6:20 am
Back to the microwave thing...sometimes coworkers will "pause" before the timer runs out, remove their food & walk away, leaving "00:21" or something on the display. I feel compelled to...
November 23, 2011 at 6:04 am
Welsh Corgi (11/18/2011)
I need to Format Date Expression in Text Box to omit the Time SQL Server 2005
The letter d will format the date without the time.
Similarly, to format a...
November 23, 2011 at 6:00 am
Jan Van der Eecken (10/26/2011)
WILLIAM MITCHELL (10/26/2011)
#1 says "UDT" but the reference says "implemented as a .NET common language runtime (CLR) data type in SQL Server." what am I missing?
...
October 26, 2011 at 11:19 am
#1 says "UDT" but the reference says "implemented as a .NET common language runtime (CLR) data type in SQL Server." what am I missing?
October 26, 2011 at 6:28 am
WendellB (10/12/2011)
Unfortunately, the font color property of the text box on a continuous form applies to all of the records being displayed
Yes, that is why you would use TWO text...
October 12, 2011 at 10:05 am
if all the fields for id, sp1, and text10 are available in the form's record source, you could do something like this:
create two text boxes, same size, overlay them one...
October 12, 2011 at 8:37 am
Here are the column, row and cell limits of Excel:
Excel 2003:
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx
Excel 2007:
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx
July 28, 2011 at 6:16 am
If you open the CSV file with Excel, does it look normal? If it was saved with Unicode encoding instead of ASCII, all the data will appear in the first...
June 29, 2011 at 6:41 am
Jeff Moden (6/26/2011)
As a side bar, you might want to avoid using ORDER BY X where X is an integer.. . . and, second, it's been deprecated. 😉
Jeff,
Can you cite...
June 27, 2011 at 6:33 pm
If you wanted to add a timestamp to every user table that does not already have one, you could use this script:
SELECT 'ALTER TABLE [' + OBJECT_NAME(t.object_id) + '] ADD...
June 23, 2011 at 6:51 am
If you are not using Access WorkGroup security, the default user name is Admin and the password is blank.
June 21, 2011 at 6:42 am
Viewing 15 posts - 61 through 75 (of 594 total)