Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MBall2003

    Open Dialog Window on user click

    Hey I want to open a dialog window on user click of a toolbar button. I know this is very easy but i just dont know the correct code to do it. any help would be appreciated thanks
  2. MBall2003

    php upload file, gets everything but the file contents

    i can get the filename, filesize and filetype but i cant get the file contents this is my code $handle = fopen ($_FILES['docData']['tmp_name'], "r"); $data = addslashes( fread ($handle, filesize ($_FILES['docData']['tmp_name']))); $docType = $_FILES['docData']['type']; $docName =...
  3. MBall2003

    connecting to a database

    I am very new to php and sql, let's say about 2 days of reading the PHP4 Bible. I have previously only worked on MS Access as my only database knowledge. I have a temp database in my companies localhost folder this is the pathname to where the db is G:\FoxServ\mysql\data\mball_db how do i...
  4. MBall2003

    Saving Access Reports as Word Documents

    I searched in the forum and i dont think i found anything that I needed so this is why I am posting this. My boss wants me to run an invoice report for all our clients from access but he wants me to save them as word documents. Now i saw in other forums how to export manually is there any...
  5. MBall2003

    setting permissions for users of a database

    I'm setting up a Billing/Salary Database for my company. I need to be able to have our accountant and my boss have full access to everything in the database, but my boss is thinking about hiring a new assistant and he only wants her to have limited access (can't see salary rate, billing rates...
  6. MBall2003

    inputting zip-code leading zero gets dropped off

    thanks works fine now mball
  7. MBall2003

    inputting zip-code leading zero gets dropped off

    I have a text box on my form for the addresses zip code the input mask is 00000\-9999;;_ my problem is when the zipcode starts with a zero, ex. 07654 or 09356-9856 the following gets inputted into the table 7654 and 9356-9856 how can i get the leading zero to stay ...
  8. MBall2003

    get timestamp into query

    I want that each Id have the CLientId & Date & Time calculated when the query is ran. i have this as my fieldname ExpenseId: [ContractNum] & "-" & [Date] & "-" & [Time$()] am i using the time function correctly any help would be appreciated thanks mball
  9. MBall2003

    linking tables from another database

    i am currently working on a billing database. i need to pull out two tables of information from a purchase order database on a user event. it would be nice if i could link the tables from my d-base to the PO (purchase order) d-base but i cant because the user isn't always going to be on the...
  10. MBall2003

    unselecting selected items in a listbox

    got it to work thanks
  11. MBall2003

    unselecting selected items in a listbox

    i use that code and i get this error, lstClients_AfterUpdate[2115] The macro or function set to the BeforeUpdate or ValidationRule Property for this field is preventing microsoft access from saving the date in the field i dont know what that means
  12. MBall2003

    unselecting selected items in a listbox

    is there anyway, to loop through a list box and if there is an item selected, unselect it?? any help would be appreciated thanks mball
  13. MBall2003

    inputbox format

    is there any way to have an input mask for an input box?? like i am asking for a date and i want the date to be a short date any help woould be appreciated thanks mball
  14. MBall2003

    crosstab queries

    I have table that has contract info it looks like this contractnum date travel webcosts e-mailcosts 123 01/01/03 $5 $6 $7 123 02/01/03 $10 $16 $17 is there anyway to make a crosstab query(or something that acts like a...
  15. MBall2003

    copying complete table over, changing the dates

    i have a table with about 40 clients contract information, and the contract information only changes monthly for about 10 clients. i need to copy all of them because for my report its by month so i need that info in there each month what i want to do is copy over the current 40 clients...
  16. MBall2003

    summing two cross-tab queries together

    I have two cross-tab queries, with two differnet types of expenses, is there any way to sum the two queries so i can have one total cross-tabbed query? any help would be appreciated thanks mball
  17. MBall2003

    listboxes

    sorry i post this on accident i already got it working sorry again
  18. MBall2003

    listboxes

    i have a list box populated with employee names, about 20 employees. how do i get it where when the last item in the list box is selected and the user presses down they go back to the first item vice versa for when the first itme is selected and the users presses up, go to the bottom...
  19. MBall2003

    Data By Month--with a variable as parameter??

    when you're in the query design jsut put the variable that you want to check for criteria, in the Total row , pull down and select where that put your criteria in the criteria field
  20. MBall2003

    Data By Month--with a variable as parameter??

    yes you can do everything that you can do in a normal query pretty much after going through the cross-tab query, in the query design you can put your Where conditions there mball

Part and Inventory Search

Back
Top