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 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: jw5107
  • Order by date
  1. jw5107

    Change Forms Record Source from another Form

    ...this makes sense... danvlas- I'm not sure what your example is doing...?? Can you elaborate..?? Thanks for the help from both of ya..!!! jw5107 ***frm2 - On Current Event*** DoCmd.Hourglass (True) Dim db As DAO.Database Dim rstAlloc As DAO.Recordset Dim ctrl As Control Dim varMultiUsage As...
  2. jw5107

    Change Forms Record Source from another Form

    There has got to be a better/more effiecent way of doing this.... On a form (frm1) - I have a command button. With this button I would like to be able to open another form (frm2). This form needs to "share record sources". The record sources are tables. I'm tryin' to use 1 form instead of...
  3. jw5107

    Linking to Delimited Text File

    Remou, Any other suggestions..... Are we sure that the code I'm working with can't link to a delimited(";") text file, that has a header, and not text qualifier....?? I have tried the code from the tread you posted, but its lengthy and creatin' more havoc tryin' to get IT to work...
  4. jw5107

    Linking to Delimited Text File

    Below is code that I'm working with that creates a link to a text file. The text file I'm working with is delimited with a ";". The first row of the text file is the field names and their delimited with a ";". When I run the below code, it puts the entire text file into 1 field in the...
  5. jw5107

    CheckBoxes on a SubForm - Items to be on Report

    remou, Awesome, your examples worked perfect..!!! Thanks for droppin' knowledge about the rs.Edit/rs.Update part... I better understand how that works now..!! Star for ya..!!!!!!! Thanks, jw5107
  6. jw5107

    Append query from a form

    dhookum & Golom, Schweeeeeeett..!!! Appreciate the fast reponse from both of ya..!!! I have done what dhookum suggested and now I'm finding out what Golom mentioned....!! I know get an error stating "argument not optional" and it highlights Me!cboGTWY... When I take that out it then gives the...
  7. jw5107

    Append query from a form

    Below is a SQL that I pasted from design view of an Append query - I am tryin'to run this query from a button on a form. I keep gettin' a "join expression error" or a "syntax error on the FROM part"..... Any suggestions or examples I can mess with...?? thanks in advance..!! jw5107 DoCmd.RunSQL...
  8. jw5107

    Delete selected items from listbox

    I am trying to utilize a multi select listbox to select records and then delete all that has been selected... Any suggestions on how to set this up or where I can find some examples - I have searching the formums for quite some time now... Thanks in advance..!! jw5107
  9. jw5107

    CheckBoxes on a SubForm - Items to be on Report

    I have a main form w/ a subform - the subform is a continous form with a query for the recordsource. There is a checkbox for each record on the subform. I would like for the user to be able to "check" each checkbox - then click on a command button to view a report. This report is to show each...
  10. jw5107

    Loop thru Form Controls

    Below is what I am working with... I need to warn the user to save the record (if the controls have data in them) before they close out of the form, otherwise if the form is blank (or all the contols contain null data), then just close the form... I just can't get this to work...!!! Any...
  11. jw5107

    String Parse - with commas into another table

    I have data structure like so: IID AllocMstr 2550004146936 SDF,SJU,SLC I would like for the data to be structured like so: 2550004146936 SDF 2550004146936 SJU 2550004146936 SLC Below is what I'm working with.... rst1.MoveFirst Do...
  12. jw5107

    label color change on each record

    The AceMan1, The form is a single form.... Below is what I am working with right now - with the OnCurrent Event of the form... The form is bound to a table, and a query is used for the "label color change".... This appears to be working... still testing... Just runs slow and not so sure...
  13. jw5107

    Call Module within query

    Golom, Below is what I'm working with per your example... Thanks again by the way..!!! The query below erros and highlights [IID] stating its an external name that can't be defined....??? DoCmd.RunSQL _ "INSERT INTO GTWYUsage ( IID, InstallGTWYs ) " & _ "SELECT [4qryUsageCntsIID].IID, " & _...
  14. jw5107

    Updating Control Properties

    PHV, Just Awesome...!!! Thank you very much..!! Worked perfect..!! Star for ya..!! jw5107
  15. jw5107

    Call Module within query

    Golom, Just AWESOME..!!!!! I really appreciate it...!!!!! How much different would a simialar query be if I were to add this module: Function Concatenate(pstrSQL As String, _ Optional pstrDelim As String = ", ") _ As String Dim rs As New ADODB.Recordset rs.Open pstrSQL...
  16. jw5107

    Call Module within query

    Golom, I have tried your example... And I'm still having troubles... I keep getting syntax errors... This is what I got: DoCmd.RunSQL "INSERT INTO WWRHistoryPrep (WWRID, IID, AllocMstr) SELECT WWRID, IID, IIf(Nz([Allocated])<>"", [IID] & RemoveSpace([Allocated]), [IID] & [Allocated]) AS...
  17. jw5107

    Call Module within query

    Below is what I'm working with.... I'm trying to learn how to call a procedure/module from a query in VB... Any suggestions or examples..? Thanks...!! jw5107 Below is the SQL from an append query created using the wizard - "RemoveSpaces" is the procedure/module I'm tryin' to call.... INSERT...
  18. jw5107

    Updating Control Properties

    jebry, I have been using your example and now need to do a similar thing for a report. This is what I'm working with... Private Sub Command1_Click() Dim ctl As Control DoCmd.OpenReport "HistoryProMap", acDesign For Each ctl In Reports!HistoryProMap.Controls If ctl.ControlType = acTextBox Then...
  19. jw5107

    label color change on each record

    easyit, Does Conditional Formatting even work with labels...? If it does - do you have any or know of any examples I can work with...? Thanks, jw5107
  20. jw5107

    Create records from forms Label Captions &amp; Textbox Names

    Below is code I'm working with... Not sure if I'm doing this right... I need to be able create records based on the forms label captions and textbox names... If there are labels that are blue in font color, then that labels caption will be saved as a record, and if a text box equals any labels...

Part and Inventory Search

Back
Top