Search results

I inherited the database and the three date fields were already in use.

I am trying to create an INSERT statement from a form to put unbound fields in a table. The challenge that I am a getting is that I am getting a Run-time error '3075' Syntax error in date in query expression '#' What is really perplexing and perhaps something that may guide in identifying...

pr2-eugin, it worked!! Thank you, thank you and to the others that replied thanks for leaving me a little wiser than when I started this thread. Cheers!

Thanks TJPoorman. I copied and pasted the code you provided, but everything displays in red (as if there were ticks at the beginning of the line). Do I need to modify what you provided for it to work?

I guess I'm not too adept at using the DeBug.Print and Intermediate Window. I entered the DeBug.Print strlSQL and reran the code, but it now tells me I have duplicate alias.

It's been quite some time since I ventured onto the Forum. I would be most appreciative if someone far wiser than me might enlighten me on the following: I'm flummoxed over how to do an UPDATE using VBA on a form to update a specific record on the table using an unbound field on the form to...

I'm finding that I'm in over my head on this as I don't believe it's possible to do with a query what I describe below. I'm sure that someone far wiser than me out there on the forum will know of a module or some other trick that can help me with the below dilemma. I have attached a sample...

Thank you Kiwiman!! You were right on both counts. This site is hands down the best Access resource on the web. Everyone is so kind, patient, and mentoring. Thanks for helping not only with this question, but with expanding my understanding of how the UPDATE statement works.

I'm getting a message: Run-time Error '3144' Syntax error in UPDATE statement. I'm not sure why it won't run - I'm sure the error is taking place somewhere between the keyboard and my chair. When I run this from an On Click event, I get this error and when I go to the code, the last line...

I have a table with an equal join to a query. I would like to take a field from the query and update the table, but I get an error message indicating that this is not an updatable query. The field from the query is an expression based on a diffferent table. I'm not quite sure why this...

I'm having a problem when an apostrophe shows up in an unbound field (it's for either the first or last name of the person of record) on a form that: 1. creates a single record in 1STARTRequestLogAll for the individual whose name is selected in from the combo box. 2. creates multiple records...

Got it!!! Like the saying goes: "The devil's in the details". PBaldy, your attention to detail in drawing my attention to the sSQL that was missing the trailing "1" prompted me to take a closer look at the others. I found it... There was an rs not far frmo the sSQL you pointed out that was...

Hmmmm... I made the change, but it still only sends out e-mails where the criteria of the first Select statement are true.

Thanks for your "few points" recommendations - especially regarding the use of Null. I'm a bit stumped as I would think it would execute them both. All I'm getting to work are e-mails for the first Select statement, nothing for the second Select statement, but all of the records update the...

I’m trying to run two Select statements from one event (a button on a form without fields) where the “WHERE” criteria are different. If I was doing this from a form where I could use the value of a field to do an "ELSE…Then…End If" statement, it would be no problem, but basically I’m trying...

I want the current date to display (see Date in Red below). I have tried the following, but can't seem to get it to work: '#Date()#' #'Date()'# '#Date#' #'Date'# sSQL = " SELECT [LastName] & ', ' & [FirstName] & ' ' & [MiddleName] AS [FullName], [1STARTRequestLog].[LastName] & ', ' &...

SteveSchapel and vbaInet, thank you both for your feedback. I definitely see how the code could certainly benefit from a good tidying up. The SQL statement runs fine when I run it by itself (without the code to see if a record already exists), the code gets a little more complicated because...

I’m kind of stuck on my Dim statements and was hoping you might be able to give me a little nudge. The first thing I’m trying to do is see if a record (by employee ID) already exists, if a record does exist, I want the “Save” button to Update the related record in the table with the unbound...

I'm trying to concatenate a name so it is Last name, First Name using the following: SELECT 1STARTRequestLog.LastName & ", " & 1STARTRequestLog.FirstName AS [LNameFName] Of course, it doesn't like the comma between the quotes: & ", " &. My question is how to get around that??? Thanks much...

Ah I got it! The Select part of the statement I left off the "& _" (the line just before the " From..." part of the statement where the error was occuring. Cheers...