Search results for query: *

RoyVidar & danvlas, Alright - now we are getting somewhere...!! Thanks for the fast responses... Here is where the fun starts... RoyVidar - I think I do need for the record source to be changed BEFORE the form opens... On frm2, I have code for the "On Currrent" event. Which is shown below...

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...

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...

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...

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

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...

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...

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

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...

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...

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...

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...

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, " & _...

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

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...

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...

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...

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...

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

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...