Recent content by sirkenj

Hello again. I have a sharepoint services site with several lists I want to be able to link to (with lookup fields) in a meeting workspace. I was wondering if anyone has done this or knows of a way to do this. Right now, in the meeting workspace, I can't see a way to link to a list not...

Hello, fairly new here to sharepoint! I have a strong background in Access, and am trying to make some access data available to Sharepoint. I have found the simplest way (I think!) is to create a list in WSS, then link that list into Access. This lets me update data programatically, but what...

I am using continuous forms, and have looked at conditional formatting. I only posted "part" of the problem...I realize if I'm dealing with only 4 possible variables in txtSrat, I can use conditional formatting. The problem is that there needs to be an If..Then statement before the conditional...

Hello again! Once again, I'm stumped! I'm trying to code a form to do conditional formatting based on the value of a text box. My text box is txtSrat, whose value is derived from a function. The function will return either "S1", "S2", "S3", or "S4". I want to highlight each line differently...

Hello again! Anyone out there that can enlighten me as to how to setup my form so the list box (Simple multilist) will open with several items already selected? I have the multiselect listbox feeding a query, but can't figure out for the life of me how to tell it which items to select when the...

Hello, I have a split database with the backend on a server, and "some" of the front-ends on the server. (most are on each machine though) My question is what are the minimum permissions that must be given to a user or group of users to let them see the file or shortcut, and launch and use the...

Although it's somewhat like fixing a broken leg with a band-aid, I am able to use WebDrive (maps network drive to an ftp site) to link to the database. It's not fast, but does decent. I have managed to use replication to "sync" a local copy and the server copy using WebDrive to assign the ftp...

OK, so what if I create another database on the server on either an FTP or HTTP site, and link to the tables being updated from the website? Could I then open the second database locally / remotely via ODBC or some other method? (or would it still lock the backend to web users? If this is not...

Hello again, all! I am curious if there is a way to link a database on my local PC to a backend on a webserver? I have an .mdb which gets updated through .asp on the server, and would like to link straight to it from my local PC. I have tried setting it up as ODBC to no avail. I know I can...

Thank you all SO much. I ultimately am using CajunCenturions example above. I never thought to approach this from that angle, and somehow overlooked declaring the type of variables (though I took the time to tell you all what they were in my post!)

Hello again! I have the function below contained in a module in my database. It's purpose is to return a value rounded up to the nearest .25. It is currently returning #ERROR, and I am hoping some of you wiser than me might be able to offer me some suggestions as to the possible cause. The...

I compile that code fine, then get a runtime error on: Holidays = DCount(&quot;HoliDate&quot;, &quot;tblHolidays&quot;, &quot;(Date Between &quot; & USAFormat(startdate) & &quot; And &quot; & USAFormat(EndDate) & &quot;) AND (DatePart('w', [Date])-1) Mod 6 <> 0&quot;) The code I'm using is...

I designed this in the query grid inputting it exactly as you typed it above. When I change to SQL view, it automatically puts the other parenthesis in. If I take them away, I get the &quot;Missing ),], or Item in query expression...&quot;

No, I thought of that earlier. The calculation is working, it's the criteria that's throwing it. My SQL: SELECT Taskings.*,DeltaDays(Date(),[SuspenseDate]) AS DaysOut FROM Taskings WHERE (((DeltaDays(Date(),[SuspenseDate]))<=3));

That's exactly what I'm doing. The Field reads: DaysOut:DeltaDays(Now(),[SuspenseDate]) That part of it is working fine though. I put that in the query grid, and in datasheet view, the difference in days is calculated correctly. The problem arises when I try to place <=3 in the Criteria...