Search results

Seriously, what in the hell is wrong with the syntax of this statement? UPDATE 573_sae_data_new_aerpt INNER JOIN 573_sae_data_new ON 573_sae_data_new_aerpt.CSPCCID = 573_sae_data_new.CSPCCID SET 573_sae_data_new_aerpt.AERPT = 573_sae_data_new.AERPT Access gives the lovely error: Syntax...

It would only change if some one did something they're not supposed to do. And if that were to happen, thank God the correct numbers would be stored in that concatenated field so it could be fixed. ;) NEVER Okay. You got your point across. However, no one bothered to even tell me how to...

I understand your concerns. It's not up to me what data gets stored. I'm just the guy writing queries and isn't paid to ask questions. And those fields would NEVER get updated. Once those fields are assigned they're assigned for life. That's what I'm doing. Calculating it whenever I need...

I have an INSERT query like so: INSERT INTO table1 (column1, column2, column3, column4, column5) SELECT (field1, field2, field3, field4, field1 & "" && field2) FROM mastertable According to the format desired by a client, column5 from table1 needs to have field1 and field2 concatenated...

Your solution worked spikepl... I don't get why. But that's awesome. I'd love a technical explanation as to why.

How will that help my problem if MyString contains the single quote...? Like if ... MyString = "I don't get this" so the query string contains 'I don't get this' and it breaks because it thinks the string is 'I don' Get it? or am I not getting it?

I am looking for a good tutorial on parametrized queries in VBA. I am creating a query based on results of another query... but one of the strings contains a single quote and destroys my second query and it cannot execute properly. My code: Private Sub getUserLeaderInfo(ByVal record As Long...

No. The amount of records being returned will always be unknown.

and what ADO object can I use that will be like a VB.NET data reader?

Here is my VB.NET code: Dim listOfRecs As List(Of Integer) = New List(Of Integer) Dim queryStr As String = "SELECT DISTINCT recnum FROM t_User_Ldr" con.Open() cmd = New OleDbCommand(queryStr, con) Using reader As OleDbDataReader = cmd.ExecuteReader()...

The textbox's default value worked... but this is the error I get when running my insert code after clicking the submit button Run-time error '3705': Syntax error (missing operator) in query expression "'No'". This is the code that's used to grab the value in my query: queryStr = "INSERT INTO...

It's a long story... but basically I'm trying to fix his poor mistakes without taking over his "awesome" design. Politics.......... I'll try your suggestion.

NEVERMIND. I recreated everything in a completely new database file and my code magically works again. Stupid trash.

First of all, this is not my database design choice, it's just what I have to deal with.... The DB guy designed a table which has a field with a default value of 'No' (single quotes include). It's a textfield. I am creating a form to input data into that table. I want the textbox that is...

I have no idea why this is not working. This is ALL the code I have for the Form I've created. I didn't provide any field names in the query because I know they are all in order correctly. This code worked at some point. I added a new subroutine and everything stopped working. So I deleted...

Okay... but the table is not redundant at all. It just shoves too many things into one record. So I'm not sure how normalization is really the answer.

I need help putting this into technical terminology: Our database "admin team" designed database to house survey questions. The problem is they gave every single question its own column and every single answer its own column. Essential an entire survey for one person is stored in a single...

I don't even see that in the properties window. So I just skipped over your post. If I overlooked it, silly assed Microsoft didn't do me the courtesy of listing the controls' properties alpabetically to make it easier to find things.

So far this is ALL the code I have This is ALL the code I have. Option Compare Database Private Sub Form_Load() Dim strRowSource As String strRowSource = "SELECT DISTINCT [q_User_IDs].[User_ID] FROM q_User_IDs ORDER BY [User_ID]" cbx_UserID.RowSource = strRowSource End Sub...

I don't even know what that means, sorry. If you're asking if the combox is bound to a query, then yes. Its values are determined by a query I have in Access.