Search results

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

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

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