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 Chriss Miller 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: *

  • Users: MICKI0220
  • Content: Threads
  • Order by date
  1. MICKI0220

    query that uses multiselect from form

    I have a form that I need the user to be able to choose what ever they want to fill in to manipulate the query. Currently I can only get a few combinations to work. All combinations require the date range and the employee id range. Currently I can only get the combination of the jobNo to work...
  2. MICKI0220

    autonumber on form from SQL Backend

    I have a form that I input records. It doesn't allow me to save a record because it is not auto populating the field with the automatic number from the sql backend. When I open the form it opens on a new record. How do I get it to automatically assign the number so it will save a record?
  3. MICKI0220

    Change a make table fields data type through code

    I have a table that is created and dropped each week. It is used as an export to populate and update fields in another program. Unfortunately one table has the field as a memo and the table it is going in is a number data type. I manual change the datatype of the memo field to number before I...
  4. MICKI0220

    edit crosstab query by form

    I have a crosstab query that I need the date to be taken from a form when it runs. This is the current code. TRANSFORM Sum(HrsForCrossTab.Hours) AS SumOfdHoursWorked_qty SELECT HrsForCrossTab.EmployeeId, HrsForCrossTab.JobNo FROM HrsForCrossTab GROUP BY HrsForCrossTab.EmployeeId...
  5. MICKI0220

    Create a string from several records

    I have a work table which has two fields in it, a person's id and the deduction description. The person's Id is the matching field in all records. Basically I could group on this field if the other field was a sum or some sort. However the Deftinition is text and I need to create a string of...
  6. MICKI0220

    filter records that have zero across all fields

    I am fairly new to crystal reports. Here is the situation. We use a canned program that creates crystal reports. I can modify the reports but the data coming in is something I cannot change on the backend. Basically the crystal reports data is a temp table that is created by a procedure and...
  7. MICKI0220

    Place a zero when dlookup has no results

    I have a field on a report that references a query. if the query produces an empty results list, I get a null value in my field. How do I set this property to place a zero in this field if the value of dlookup is null? =dlookup('comm', 'qryInvoices') Thank you for you assistance in this...
  8. MICKI0220

    If Then in a table update

    I am having a brain lockup. I have been writing this program using alot of sql updates to make a work table. Right now I am coming into a problem with a calculation on commissions. Here is my problem. I have a commission database that salesmen recieve a commission when a payment comes in on...
  9. MICKI0220

    Create a view that passes windows authentication as a criteria

    I am trying to restrict what a user can see and edit on an access form and reports. My front end is Access and the data is stored in SQL 2008. I was thinking that I could make the view restrict what is seen by using windows authentication in the criteria. Basically, my users are supposed to...
  10. MICKI0220

    Use list box to edit query in code

    I need to write code to modify a make table query through code. What this should do is look at the values in a list box and take those values as the criteria as what jobs appear in the table. Then I will use that table as a joined table in the rest of my program. The problem I am having is...
  11. MICKI0220

    filter out zero's across a record set

    I need to suppress any row that the value fields in the detail section are all zero's. We only want to see the records where activity has happened.
  12. MICKI0220

    Create an import Specification from an excel

    I need to create an import specification on an excel file that a user can type in the month and year.. Here is the situation. I have a report that is created in excel every month. I wish to create a command button that will bring it in. the excel sheet always starts with %com than the month...
  13. MICKI0220

    changing parameters for query

    I have created a form where a user fills in several boxes as parameter criteria in the query that populates a report. Currently the criteria in the query has a between statement, giving the user the information for the jobs that are in that range. The user wants to be able to select, lets say...
  14. MICKI0220

    search for dates in a text field

    We have a field in a table that's data type is Text....The users of this field put a date in it until the unit is loaded on a truck and switch the date to "LOAD"...This apparantly is why it is a text field and not a date field....I have a user who needs a report based on when and what dates are...
  15. MICKI0220

    Update field with consecutive numbers in order

    I have a field with an id number. The table has 145 records. I would like to update that id number field with consecutive numbers. For instance I would put in a number in record one and then I would like each consecutive row to update that field with the next number. Any ideas would be...
  16. MICKI0220

    Split record into two or more records.

    I need some advice on how to handle a coding situation that splits a record into two or more records.. Here is the situation...I have a program that imports invoices and payments on contracts for a given period. Each Contract has a "contract type".. 01, 02, 03 etc...based on the contract type...
  17. MICKI0220

    Dlookup syntax issue

    I am not sure if I am writing the correct syntax for this code =(DLookUp("Balance","[tbl_ats_SlsRep]","Sls_RepId= [tbl_ats_SlsRep]![Sls_RepId]")) What it is trying to establish is get the [Balance] from the table [tbl_ats_SlsRep] Where the reports [Sls_RepId] is the same as the table's...
  18. MICKI0220

    getting rid of Error on reports of no records

    I have a report that calculates text boxes. If a report has no records then an error appears where the text box calculation is. How do I get this to either display 0 for no records or just blank in those fields?
  19. MICKI0220

    count the distinct number of employeeid

    What syntax do I use to count the distinct number of employees. I created a report and the report my have many employee id records. I am trying to count how many employees worked that week. I tried =count([employeeid]) in the control source of the text box, but that counts up all the records...
  20. MICKI0220

    change color of tab when it has focus

    I have a form that has 8 tabbed pages to it. My user would like the tab to change color when it has the focus. Does anyone know how to do this? Thanks in advance for any help Micki

Part and Inventory Search

Back
Top