Recent content by csprop

That did the trick, I just changed the name of the field to DateOf instead. Thanks a million.

That was definately a step in the right direction. I changed that and did a Debug.Print on the SQL string and the intermediate window showed: INSERT INTO Transactions (TenantID, Date, Amount, Category, Notes) VALUES ('1','11/5/2004','10','Late Fee','note') .. which looks ok to me. But I still...

I am trying to use a SQL string to INSERT INTO a table. My sub reads as follows: Private Sub makeTrans_Click() Dim SQL As String SQL = "INSERT INTO Transactions (TenantID, Date, Amount, Category, Notes) " & _ "VALUES ([TenantID].Value, [Date].Value, [Amount].Value...

I did Month: format([birthdate], "mm/dd") and that worked great. Thanks a lot for your help.

I have a query which lists the names and birthdates of all the people in the database. I need to sort these by month, but Access sorts dates by year. How can I get Access to sort this list by month, then day and ignore the year? (i.e. 1/1, 1/2, 2/1, 2/2, etc.) Thanks!

Nevermind, I got it. Thanks!

Which criteria are you referring to?

I have a form with a command button I use to print a report. The report I print gets its data from a query which requires a parameter. That parameter can be found in a field on the form. How can I tell access to use that value as the parameter without the user having to enter it when I try to...

You were correct. I was using a Private sub instead of a Public sub. Nine out of ten problems I come across are caused by mundane details which I should have known better. Thanks for the wake up call!

Right now I have a lot of redundant code in three or four different subs. I've tried to create another sub with that code in it, and the new sub in the others to avoid having to write the same code in multiple subs. How can I tell VB to run the sub contaning the common code from the other...

I've tried it as a text field and a number field and had the same results.

I have this one query in my database which is sorting a field containing numbers only by the first digit (i.e. 16 comes before 9, since 9 > 1). This query gets its data from a table which is created by two append queries. This table has the same problem, which I assume is creating the problem...