Search results for query: *

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...

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...

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...

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'm having some problems with inputing criteria on a date calculation function. I have a query with the expression: DaysOut: DeltaDays(Now(),[SuspenseDate]) This displays the number of days between today and [SuspenseDate] excluding weekends, and holidays. The function works great, but I get...

I'm sure someone is going to make me look stupid for asking this, but here's the situation: I recently acquired a laptop with Windows XP Pro, and Office XP Pro. I am currently using this same configuration on my home computer, and had no problems with the workgroup file. On this laptop...

I have a pretty complex set of tables that have pretty complex relationships, so this one may not be real easy to solve, but one can hope! Every now and then (translation: I don't know what's causing this to happen) when I open my database, the "main" table that other relationships...

This is a general desing question. I have a project which involves a front / back end database (both access 2K). The back end resides on a server on "network #1" Due to some pretty strict security settings in our organization, we also operate "newtork #2" This is the...

Hello again. This one should be pretty simple. I have a front-end db (2000) which I want to audit the use of. I have a proceedure which gives me NT logon, db logon, machine name, and time in. This data is loaded into a table, and is set when the opening form of the database loads (OnLoad)...

Hello all, I'm a newbie to VBA, and am slowly picking it up, but I need some help on this one! The basic situation is this: I have a form (form1) which contains a combo box that is Limited to List. OnNotInList, a Sub will ask the user if they wish to add a new value. If yes, a form opens...

Here's my problem: Apparently, I somehow changed a property somewhere which makes my application open with forms maximized (which I want); however, when I open reports, they take on the same traits, and open with ONLY a "Restore" button. I have to click restore in order to get the...

Hello again. This one has me puzzled. I have a form (form 1) which is used to select data, and input "temporary" information in order to print a memarandum. I am using a form (form 2) to display and print the selected memorandum. I have the same issue when form 2 is created as a...

Hello agian, I have a project I am working on that has two forms which are giving me trouble. Whenever I open either of the forms, some of the text boxes on them will not display, or will display in a different font and size than they are supposed to. Once this happens, ALL text on ANY form...

I am trying to figure out the best way to: 1. Check nightly to see if my databases are opened 2. If not, run Compact / Repair on front-ends and backend 3. Back up folder on newtork drive to my local disk 4. Create a log with status...success / error / etc. I'm using a network with fairly...

Hello all, I am wondering if there is a way to call .LinkPoke from within VBA or a Macro in Access 2K. I know VBA doesn't support using .LinkPoke, but is there a way to call it from VB using Access?? Specifically, what I'm trying to do is initiate a DDE channel from Access 2K to WinFax Pro. I...

Hello all, I have a database I am attempting to use to send faxes via WinFax Pro. I'm trying to use DDE to send fax number / etc. to WinFax. I can make the below code work successfully in Visual Basic, but not in VBA, and am guessing it has something to do with a reference loaded in VB, but...

I'm trying to figure out a way to open a MS Word document template from within access (from command button) so it opens as a new document. I have it set up currently to open the template, but it actually opens the template for modification, I need it to open a new document from the template...