Search results

I wish I could say the same thing, but with -20C (~0F) to -30C (~-20F)with the wind factor. We stayed inside.

My resolution is to lost weight. I am actualy at 260 pounds and I want to be 180 for december 2006. That is 1 pound and a half per week. Yesterday, right after midnight, they served a cold buffet and that was very tempting. Everyone was telling me that resolutions start the morning after, but I...

I've seen somewhere that you have to use the «with» function to make it work. With appXl .visible [...] .quit End with I don't remember the exact reason, but I'll look for it and send it to you later on.

Public Function StraightTimeLookup(ByVal UName As String, ByVal dat1 As Date) As Integer If IsNull(dat1) then StraightTimeLookup = 0 Else StraightTimeLookup = DLookup("[StraightTime]", "StraightTime", "[User] = '" & UName & "' AND [Date] = #" & dat1 & "#") End if End...

I often start my posts with phrases like: I think that... Maybe.... I am not sure, but... I believe that, although some of my first thoughts are wrong, my posts might bring some hints or, at least, show the person asking for help that his thread wasn't unnoticed. Also, the fact that I give some...

You'll have to create a macro that you also call «Autoexec» which you make execute the function «Autoexec()». By the way, to use the «SetMDIBackGround» function, you'll need a specific DLL which I don't know the name. If you don't have it in, you'll receive a message that would say that it can't...

Create an «Additional_Registrant» table that contains these three fields: Additional_Registrant_Number - Autonumber - PK Registration_Number - Number - FK (FK=Foreign Key) Additional_Registrant - Text Then join the «Registration_Number - PK» with the «Registration_Number - FK»

OK! Open your database and create a new module. Then, add this code on the new page: Public function Autoexec() SetMDIBackGround (16777215) End function That should do the job, although I haven't tested it yet. Come back if you still need help with it.

Sorry, but I cannot understand your need here. Might be that my English isn't good enough or that the wine is. Maybe some more details would help me fully understand what you really want to do.

Using the taskplanner, make it open this VBScript: Option Explicit Dim Compacting Const AccessPath = "C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" Const UserName = "MyName" Const UserPassword = "MyPassword" Const DBPath = "MyDatabasePath" Const MdwPath = "MyMdwPath" ''''''''''''...

Since you are good with Access, may I suggest that you do your query in Access then switch it to SQLview. It will add some «()» for nothing, but it will give you what you want.

1) If you need to show ALL the books in your form, why do you ask for the ONLOAN books in your query? 2)Create a function named «Autoexec» in a module and put your code in it. BTW: Why would you want to change the color using code on startup? Wouldn't it be easier to use the properties of your...

Still, I don't know how a man as young as Rich could have so much knowledge in Access. :D

Happy holiday season to you all. 2005 was a bit hard on me. I worked real hard and had no time left for myself. But 2006 is comming up with the hope that the hard work will pay off, giving me some time to spend with my girlfriend. Hey, Lister! Doesn't it feel a bit weird having XMas in summer...

We celebrated our 15th three weeks ago.

In the Content property of the combobox.

Select Distinct Month(MyDate) & "/" & Year(MyDate) as MyNewDate From MyTable;

OK! I think I see where you are going to... First, you can't use a [Date] field as it is a reserved word in VB that means «Today's date». At least replace by [MyDate]. Even better, replace by something that you would understand if you go back to that database in 5 years. (ie: Start_Date...

I am not sure that I fully understood, but here is what I think you're looking for: Create a field called MonthWanted and add [Which month do you want? 1 to 12] in its criteria field. Then add this line instead of yours. IIf(Month([Date])=MonthWanted Or (Month([Date])=MonthWanted-1 And...

I should have gone to church when mom told me to. If only I've known. :D