Search results

  1. S

    Sum amounts based off of date query

    So I'm not sure that is the best title, but couldn't think of anything much better. Here's what I'm trying to accomplish. I have a table that stores all of my units and their rent amount for the month: RentAmounts ( UnitNum, -- IE (1A,2A,3A,4A) RentMonth, -- IE(1,2,3,4) RentYear, --...
  2. S

    Fill text field from listbox selection

    Ok so here goes. I have a page with a form on the left and list box of users on the right. The list box is populated by a php mysql query as soon as the page is loaded and the page is used to administer users for the site. What I'm trying to do is make the page a little more interactive. As...
  3. S

    Basic PHP/MySql Connection

    Ok guys been working on this for a bit now and keep running into different issues. First the basis of everything. Building a web page in Expression Web 4 running the development server for testing. Using PHP 5.2.17 currently. PHP code being used is pretty basic and is posted below. The...
  4. S

    Connect to Access back end from Outside VPN

    So here's my problem, I have an access db (split in two) that is currently used in house. All network connections are in house so using linked tables isn't a problem. The problem I'm trying to find a solution to is that I need to give the front to an outside source that will have no way of...
  5. S

    Look for date in date range

    Tried to come up with the best title that would fit the solution I'm trying to find and I apologize if it does not appropriately fit. DB is MSSQL 2005. What I have is a table that holds my unit location assignment and the date it was assigned there. As the unit is re-assigned locations a row...
  6. S

    Random sum = X

    Good afternoon to all. We have a report that shows all of our customers and their AR amounts in an excel spreadsheet. All is fine on this part. The problem we have on occasion is our customer writes us a check to cover some (not all) of their invoices but have no indication of what invoices...
  7. S

    SQL 2005 Year End issue

    Wondering if anyone has heard of such a problem before. I'm running SQL 2005 and it appears I am having 2 similar issues. If I run a stored proc looking for anything with dates between 2008-DD-MM and 2008-12-31, I get no results. Also, if I attempt to run with dates between 2008-DD-MM and...
  8. S

    Exclusive Access

    Hey guys Thanks in advance for any help and suggestions. I have a MS Access DB set up and working fine except that I need to to open exclusively on the PC that opens the file. It is uploaded onto a server where a dozen users will have access, but only one can be in at a time to "approve"...
Back
Top Bottom