Search results

Success, Thanks!

SELECT Contacts.[Mail Address], Left([Mail Address],InStr(1,[Mail Address],"PO Box")) AS Expr1 FROM Contacts; So I got it down to this point, but it still returns the first "P" In "PO Box"

Here is a table I created using dummy data since I will not share real addresses. What I want to do is create query that returns the nearly the same information but with the PO Box section removed. I do not wish to edit the table as there are roughly 238 entries.

That seems like the right approach but how would I incorporate that into the SQL? Select Contacts.Address From Contacts

Is it possible when generating a query to truncate the results using characters/string as a delimiter? I have a table labeled Contacts where names are listed. One of the fields is address and includes PO Box. Each address includes PO Box #####. I would like my query to return to me the addresses...

So my original vision was to have the columns of QueryA into rows of the listbox on FormA. These would list all the documents that existed, so three documents in the case of part number "abc123". It wouldnt need to list all 5 columns since all it would show is 3. Functionally showing all...

I regrettably did not see your comment in my frustration. Setting columncounts to 5 did in fact show all fields. Though I am not as familiar with using columns in a list box. Is it possible to transpose columns into a single row? alternatively I do not know how to remove the empty columns. I am...

SELECT Components.Field1, Components.Field2, Components.Field3, Components.Field4, Components.Field5 FROM Components WHERE Components.PartNumber = 'abc123'; This is the SQL that defines QueryA. It will return the row corresponding to abc123. This part number has content in Fields1-3 but not 4...

I want to list field contents, that way it will return blank fields if they are blank on TableA. I was thinking this could be done using the SQL for the query somehow or manually assigning listbox rows to each field in QueryA since it will be the same size query every time. But I havent figured...

I have a QueryA that lists 5 fields from TableA, lets call them Fields1-5. On FormA I have a button that changes the SQL criteria of QueryA such that only one row of TableA is returned. I want to make a listbox that populates based on the fields that are currently present in QueryA. Simply...

So I ended up using a mixture of cross tab references for more basic text fields and query generation for dynamic lists on my report. The formatting is a bit scuffed but it appears to be working correctly. Thanks all.

Ill give both methods a try and return with results. Thanks

I'll preface this issue that I have little experience with reports in relation to the code builder. What I am trying to accomplish is filling in several text boxes on my report using combo boxes that a user would select on a previous form. For example: DoCmd.OpenReport "Singlesourcedreport"...

I rewrote the entire on click event and added invisible text boxes to validate each value at each criteria and somehow that ended up fixing the data mismatch/syntax errors. I really have no clue as to why it is working now, but the line itself is not any different from what Doc Man gave. Sorry...

exist = DCount("[Field1] + [Field2] + [Field3] + [Field4]", "tblcatalog", "[Field1] = " & Me.txt1 & " AND [Field2] = " & Me.txt2 & " AND [Field3] = " & Me.txt3 & " AND [Field4] = " & Me.txt4 & "") Returns a missing operator in the final part of the expression. Is there something I'm missing?

I did make the four fields a composite primary key, but was concerned about how the error would produce itself while a user was on the form. Is there a certain line I'll have to introduce to exit the sub such that the VBA module doesn't open? Or if it is just a message box that appears, a way to...

I am having difficulties creating a line to determine if a certain record exists within a table. I have a form where a user put in numbers in four different text boxes and those will be stored in the table. And before they are inserted I wish to check if it already exists. From my...

I appreciate the concern and might go with this method in a future project but for now the project has gone far enough that it would be tedious work to replace relationships related to the links. The documentation this provided though has helped solve my issue. The solution for those curious...

The link will be some url pasted into a textbox (Me.txtlink) by a user. After a button click it will be transferred to the table. Something like https://www.google.com/. But on the table and through searches, it will only appears "Link" in the hyperlink field.

This doesn't work. It just generates Link'Url' and causes a missing parameter error. updatesql = "Update Drawing Set Links= link" & Me.txtlink & " Where [ID] = " & Me.cmboID & "" - for reference