Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside. [more inside]
I have two questions about setting up MS Access forms:
1) Currently, I have a form to enter the volunteer id, shift start time and shift stop time, but the client doesn't want to have to look up the id in a report. Is there a way to create a selection list from the volunteer's names? What other options are there?
2) On the "add/edit a volunteer" form, I'd like to be able to choose tasks from a selection list. The tasks table has id and name. The "tasks of volunteers" join table has volunteer id and task id. How do I set this up? I can't seem to get the right combination of configurations. [more inside]
Is there a scammy catch or otherwise bad deal to Starbucks' free WiFi through the Starbucks card and AT&T? [more inside]
Can I do this in Excel and/or Access? 'This' is a bit complicated so it's explained inside. [more inside]
I need the hive's help. Which computer class should I choose: Database Management Systems or Database Management with MS Access? [more inside]
Microsoft Access question: I have an Access 2007 database hosted on a server. I have 10 staff members who use the database. I can get in the database even if someone else is in it. One of my coworkers cannot. Is this typical? [more inside]
Seeking a lightweight web interface to Exchange 2003 server. Need something more usable than OMA, but more smartphone-friendly than Outlook Web Access. [more inside]
My Tivo and 360 can no longer access the internet because my provider has set up a Terms of Service page that you have to click on through a web browser before it will let you access the internet. What can I do to get internet for my browser less devices? [more inside]
What is/are Pipeline Reports? [more inside]
MS Access Alternatives? I have a user that needs to keep data in a relational database, but I'd like to advise her against Access because of it's various limitations. She has no programming knowledge. Any suggestions? [more inside]
I'm an adult education teacher computerizing our attendance recording and reporting using MS Access. The reports need to be laid out in a particular way, and I'm not sure how to make that happen. Can you help me? [more inside]
Dirty database needs a good cleaning. But how? [more inside]
I'm accessing the Internet via a public wireless system with most or all ports blocked except port 80, and perhaps port 443. Mainly I want to do some ftp to my website, or perhaps a remote admin session on my home computer. How can I tunnel traffic through port 80? [more inside]
Norton detected a virus (?), Downloader.MisleadApp, on my laptop. According to Norton, the problem has been "fixed." But ever since then, I cannot access the Internet. How do I get back online? [more inside]
I have become comfortable with maintaining an inventory database using MS Access. I want something more powerful now. Where do I go? [more inside]
How to extract data automatically from a group of HTML pages to an Excel file or to a database? [more inside]
I have a (hopefully easy) SQL question. I'm working in MS Access. Simplifying things a bit, I have a table with a TaskID, and a TaskStatusID. I want to get a list of each TaskID, and the newest TaskStatusID for each. (Details follow.) [more inside]
Network access control on a timer? [more inside]
I use .htaccess files to allow users access to files in certain directories based on their IP addresses/ranges. They are linked to these file from a page (not within the htaccess protected directory) generated in PHP. Is there a way to display a variable on this PHP page based on whether or not the user will be allowed access into .htaccess protected directories? [more inside]
My nice boss has tried to make everyone's life easier by putting work she wants us to do in subfolders with our names on them, in her inbox. We all have delegate read access to her inbox but can't see the subfolders when we go to it. What permissions does she need to set us (or what else does she have to do) in order for us to see the subfolders?
I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? [more inside]
A Visual Basic 6 (ugh) runtime file distributed with our internal Access database has been killed by a recent Windows security update. It's hard to gather support information (especially since VB6 is about 8.7 million years old) and so I was wondering if anyone out there can help me track down a more recent copy of the runtime file in question—msflxgrd.ocx—or otherwise fix the problem? [more inside]
Are there any Kinkos, business centers, copy centers, cybercafes etc. in Los Angeles (downtown, silverlake, west side, ANYWHERE!) where I can pay by the hour to use a really fast (T1) internet access so I can upload 5GB of files to a coworker? [more inside]
My son (12) has saved his lawn mowing money and is buying a refurb Ipod touch. I want to mediate his internet access, if possible, at the router level. [more inside]
How do I put a wildcard into the truepart of an IIf statement of an MS Access 2003 query criteria? [more inside]
I need a one-time conversion of a Access 2003 database file (.mdb) to an Access 2000 database file. I tried OpenOffice to no avail. [more inside]
I have remote access to my work computer from any other computer via Citrix. Would I be able to access my work computer in the same manner from a T-Mobile G1 phone (or from any other similar cell phone)? [more inside]
Dell Optiplex 170,
XP Home SP2,
Out of Warantee,
no recover disk, no way of making one. This was bought a while ago for use as basic internet access. Sat in a corner unused for a long while. Loaded AVG Free and Zonealarm via dialup for anticipated use on cable internet. AVG installation balked.
Had cable installed. The Comcast installer could hold the connection with this unit for less than a minute before it dropped. The connection is stable with both the installers laptop and my SOs work laptop. I removed all personally installed software. AVG and Zonealarm could not be removed. Goback would only go as far as the probable install date of AVG. I get a corrupt install message with both uninstalls.
The latest Windows Installer Cleanup tool did not help. Any suggestions in how to ressurect this beast? Is reformatting and loading Ubuntu my only option?
I've been unsuccessful in getting an old pc up and running with Ubuntu or some other *nix OS. I am wondering. Is it possible to use VPN or ssh from my computer to my Dreamhost account to create a secure tunnel to their servers into to the internet? I'm using 0.00 gb on my account for bandwidth. Sound doable? [more inside]
Any advice on setting up a wireless access point for a cafe for a budget of under $200? [more inside]
I have a really cool job: I help low-income/minority students get into college.
(It's perfect for me because I'm passionate about educational access and I get to work with young people one-on-one, but I'm not tied down to a classroom.)
Right now, my job is short-term, a la Teach for America, but I'd like to stay in the educational field and turn this job into a long-term career.
My question is two fold: How do I go about finding jobs like this and what sort of educational credentials/degrees do I need to qualify for these jobs? [more inside]
Free, non-sucky Microsoft Access repair tool? [more inside]
I am tasked with preparing a multi-category, filterable timeline as a work project. I think Access is probably the best way to do this, but I need some help with the mechanics, or suggestions on where to find a template. [more inside]
I can't believe I don't know how to select many checkboxes in Microsoft Access... [more inside]
How can I grant user access to one directory only, so they can edit a file? [more inside]
I've just arrived in Spain and my iPhone wont access the internet even though it recognizes the hotel's WiFi network. My Apple Air laptop works just fine with this same wifi network. Why isn't my iphone enabling safari or email access on the iPhone? Any ideas would be greatly appreciated. Thanks.
Anyone know where I can find a restoration status map for Comcast after Ike? [more inside]
Our companies IT department can proxy into my computer from1500 miles away and see what I have on it and make changes etc. How does this work? Is it a software program or more a matter of them identifying their computer with the same information (you know, that number that all computers have , their address?) as mine?
Access 2003 UnMatched Query Wizard is not returning expected values. [more inside]
What are some LESS obvious things that can disqualify someone from obtaning a job, car, or an apartment? [more inside]
Are there any free or low cost options for having a Remote Desktop tool for Windows Vista Home Premium? [more inside]
How can I merge two different Access databases? [more inside]
I have a three person Mac OS X office where we need to have remote access to about 4GB of files. I have looked around extensively for a solution and so far have not found an acceptable one. We have tried to use Back to my Mac and Apple Remote Desktop but the other two users are not that technically adept and it seem too complicated for them. Out problem is further complicated by the fact that we sometimes access the same files, so we can have version problems as well. Back to my Mac has never worked period.
Could I use Amazon S3 storage? And manage with Subversion or Git? Are there reasonable clients for Subversion and Git. Drobo with network card seem over the top and too costly.
Having the files on the cloud would be a perfect solution, however a local solution that could be accessed from anywhere will work as well.
To further complicate we are thinking of having one person access via PC.
How do I best store information about transactions with contacts and companies in an Access 2003 database? [more inside]
Can you recommend a forms based database like Filemaker
, MS Access
, or OoO Base
, but lightweight? [more inside]
I am at a new job with restricted internet access. They have a list of white listed sites, but no one seems to know what sites are on the list, and I can't ask anyone because the company uses a third party solution and their website doesn't have a list of the sites..
Is there a program that will determine what sites are on the white list by brute force?
How do you all manage the information that you find in various places, online and off, and make it findable later? [more inside]
Access 2003: I have this database that is truly awesome along with some equally awesome queries. Co-workers have recognized this awesomeness and want to start running their own queries but know nothing of Access. Is there a user-friendly option? [more inside]
Should I worry about a WiFi access point owner spying on me? [more inside]
We use clinical software that uses a MS SQL database. It has a five million records weighing in at 40 GB. The software doesn't have a mobility option but we need one. The company has it on their feature request list but its at least 3-5 years away. HELP. [more inside]