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!

Register Log in
  • Congratulations derfloh 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: lewie
  • Content: Threads
  • Order by date
  1. lewie

    record source for subform

    I have some forms that have subforms. What is the correct way to determine the record source of a subform. Can i select properties on the main form, scroll down to the subform name select it and find the record soure under properties or do i need to open the subform independently. Thanks. lewie
  2. lewie

    Is there a way to place like name field in the header of report

    I have a report and I would like to place a list of affected areas at the top of the report. These would be one field from the query. So #1 do i need a subreport in the header and #2 how do i make a report list the names on a line one right after the other. not one record per line. You'll have...
  3. lewie

    assigning captions to buttons from a name field in a table

    I numbered my buttons btn_1 btn_2 ect. I was wondering how to loop through them using a for loop. i have tried the below but keep getting errors: Private Sub Form_Open(Cancel As Integer) Dim rst As ADODB.Recordset Dim ID As Integer Dim big As Field ' Dim endoffile As Integer '...
  4. lewie

    how to pass data from current open button

    When I click on a button I want to run a query which will use the current buttons name or caption in it's criteria section. I can do it for a button. How do i do it for the currently selected button. Thanks Lewie
  5. lewie

    a form to look up records

    I want to make a main form with buttons on it and each button brings up a record. I want the caption on the button to be the name field in the record it brings up. So i essentially need to alter the caption property of a button based on a field in a table. Please Help... Thanks Lewie
  6. lewie

    when searching a memo field how do i move to the next line

    I have a text field with name address city ect. I am extracting the pieces and building a new table with name, address, city state, zip fields. I loaded the first line in to fname and lname what code to i use to start at the second line so i can read that. is it chr(13) and Chr(10) but how do i...
  7. lewie

    I am trying to pass 2 parameters in a sub routine

    I have the following code: Public Sub ExportADOXML(strTableName As String, f As String) ' Export the specified table as XML, using the ' ADO XML format rather than native Access format Dim rst As ADODB.Recordset On Error GoTo HandleErr Stop Set rst = New...
  8. lewie

    updating form fields from a table based on a combo box selection

    I am new to vb. I have a shipping form with a combo box for contacts. When a selection is made I want to fill in the information for a contact from a contact table into the forms text boxes. I can do it with an update query but then I have to requery to get it to show up and I don't feel like I...
  9. lewie

    tracing

    When i am using a query, Is there a way to find out which forms use that query???without opening every form and checking the properties. TIA Lewie
  10. lewie

    I want a problem report to color code different faults

    I have a query that checks for 3 error conditions. I have a report based on that query. What is the best way to include the condition that caused the record to be printed; on the report. Like green lines for one etc. I saw nothing in the query that could be used. would i have to restate the...
  11. lewie

    changedate field

    Hi I put a text box named changedate on a form. It is a bound form and the box is bound to the changedate field. I put a line of code changedate = date in the afterupdate event. It updates the field but it is then stuck in that record. What do I need to add to make this work properly. Thanks Lewie
  12. lewie

    enter a field value in criteria of a query

    How do i enter the value of a field into the criteria box of a query? Lewie
  13. lewie

    Is there an easy way to convert a db's fields into records???

    I have a db where alot of entries were placed into fields. They should be records. is there an easy way to transfer them other than transcribing them. TIA Lewie
  14. lewie

    how to increment a field in a form when the number is used

    I have 2 tables one btv with title tapetype and tapeid one called type table with tapeid type and last#. I have a form with title tapetype and tapeid fields. First i enter a title. then when i enter a tapetype i want it to generate a tapeid consisting of tapetype + last # so each tapetype will...
  15. lewie

    how can i document who last changed a record and at what time

    I need to add a last user and last time changed to my db. I think when they update a record i can just let [lastdate] = date but how do i document the current user. Thanks Lewie
  16. lewie

    how do i represent a variable in a do command line.

    I am doing these queries based on the value txttapetype if txttapetype is DTR it will perform these. I tried replacing DTR in the query names with the variable but it didn't recognize it. do i have to annotate it somehow so it knows its a variable. This way i can use one set to run them all...
  17. lewie

    process multiple entries on a form with one module

    I have a form where people enter new records. They can enter maybe 10 or 20 at a time. I have a button that creates a unique number using entered information. I can make it work for the open entry on the form but if they entered 10 new records it only works on the current form. How do i...
  18. lewie

    Is there an easy way to convert query to code

    I converted macro's to code using save as module; Is tyhere an easy way to convert queries also. TIA Lewie
  19. lewie

    crystal licenses hang over time

    Does anyone know of a problem that could cause licenses not to be released over time. Usually in about a month our license usage approaches our limit of 15 even though there are only maybe 3 or 4 people on it. Any ideas??? Thanks Lewie
  20. lewie

    what is the assignment operator

    I have a form with a date field which through the recordsource I have assigned today's date. I want to load it into a field in a table on form close. What is the assignment operator since = is a logical compare. Thanks

Part and Inventory Search

Back
Top