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

    Hey Nick Sorry it took so long to get back to you, and thank you for the help. What I ended up doing was calling a java script to populate 1 text box, which in turn called another script to populate the next box and so on and so on until all text boxes I needed populated were. Not the...
  3. S

    Fill text field from listbox selection

    I think I understand what you're getting at, but how to implement it is another. I pretty new to the web development and learning as I go. Here's the php that's being used to build the list and output/alert the information that is selected. echo '<select name="usernameselection" size="14"...
  4. 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...
  5. S

    Basic PHP/MySql Connection

    Peregrin: Thanks for the help man and sorry for getting back to you so late. Never got it working directly on my PC/Server, but as soon as I upload my files to our hosting site it works flawlessly. A little annoying at times but good ol FTP helps out with that. Thanks again.
  6. S

    Basic PHP/MySql Connection

    Ok had a chance to work on mysqli and appears I'm getting the same issue as before, screen just shows up white with no information on the connection. Any thoughts?
  7. S

    Basic PHP/MySql Connection

    Hey guys sorry for the delay and thank you for the responses. Peregrin: I’m currently using an Access program as the front end to the same SQL server using an ODBC Driver. This works correctly on multiple computers but we’re trying to get away from the ODBC and Access for this and go to web...
  8. 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...
  9. S

    Connect to Access back end from Outside VPN

    Hopefully you guys are hanging around still as I have another genius idea. :D I have a MySQL db that I can use but can only make a PHP connection to it. Is this possible? Basically want to have linked tables through PHP. I apologize if I'm trying to use/reference PHP in a way that is not...
  10. S

    Connect to Access back end from Outside VPN

    Thanks spike, I didn't have my hopes up on that one don't worry. We had talked along the lines of DropBox. Either that or manually importing may be the way to go. Thanks for the help guys.
  11. S

    Connect to Access back end from Outside VPN

    Looking for 2 way replication as much as possible but it's looking quite problematic. Simple solution at this point is looking like using spike's idea and manually importing data. Pardon any of my ignorance in ideas I come up with as I'm not a VB programmer by trade but more or less got thrown...
  12. S

    Connect to Access back end from Outside VPN

    Thanks for the replies, by no means am I saying anything is wrong with your replies, just not a road that I want to go down, if avoidable. The way the db is set up is that we (in company) create employees and add points to their file. They (outside company) needs the ability to see how many...
  13. S

    Connect to Access back end from Outside VPN

    Not something I thought about but won't work very well. That would require me to give them credentials to log in via RDC. TeamViewer and GoToAssist are more troubleshooting than access and along the same lines as RDC. I'm trying to give them as little access as possible by only giving them...
  14. 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...
  15. 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...
  16. S

    Random sum = X

    Aj & Bilbo, thanks for your responses. I figured there is a way to VB code a macro or what not to do what we are looking for but as you both said, too time consuming to be worth it. And yes Bilbo, I agree, shouldn't be our responsibility to "guess" at what they are paying but sometimes you...
  17. 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...
  18. S

    SQL 2005 Year End issue

    Makes sense. In fixing that I think I have found some other problems created by the original programmer that may be causing it as well. Thanks for the help and quick repsonse.
  19. 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...
  20. S

    Exclusive Access

    Thanks for all of the help and suggestions. Ended up creating a shortcut with a /excl switch, which now warns when the file is in use. Thanks again.
Back
Top Bottom