Search results

input formats are irrevant as all date/times are stored as a number. You can use the BETWEEN keyword in your criteria, but you are only using one text box for simplicity BETWEEN txtStartDate AND txtStartdate, so only recordswith that one date will be retrieved.

there is a limit of 255 columns per table not rows

if there are not too many, then delete by hand.

I ALWAYS budget 3 months for an Access database.

VBA is part of Access, so to run VBA you require Access. If your db is huge, have you split it into FE/BE, keep your data only in the BE (Backend) and your Queries in the FE (Front End).

I don't think you can. On error goto is only applicable within the module where it is specified. I copy and paste my error trapping into every sub before I add any other code.

create a before update event for each text box. Then in each event call a function to validate your time and return true or false. if the time is False (in error) then set cancel = true the function should check if both fields are not null, if so the perform your compare FunctionName = True...

your reps will not be able to email a form as such, but they could email the db containing the form and I presume data. When you receive this data do you mannually type it in or have you automated this, You could either link to the table in the emailed db or open it then update the main dataset...

commom functions are held in a library usually called Visual Basic For applications, and is usually the first reference in the list. So, Open a code module and click references, if VBA for Apps is not in the checked list, scroll down until you find it then check it.

Create a new query then select totals from the view menu, this gives you an extra row to select various types of agregates, counts, sums, groupby etc

split it into two queries, one for the count, then use that as the recordsource in another query to use the DISTINCT Clause

It's one of the properties of a form. Set the Centre property to true

with DAO you need to update the table TempTable.Update. what are you using the with for. this is how it is used With TempTable .(Product_Code").value=Prod End With

Try SELECT LAST(InvoiceID) FROM Invoice

you seem to have far to many quotes and to test for null in use the following recommended technique IF Not IsNull(rstP("V") ) then is not null is only used in queries. If you want to substitute the contents of a combo box (or text control) then use a single quote txtV.Value = DLookup("V"...

Have you tried setting the extra fields to total type 'expression'. If that does not work, then the technique I use is to link the result set back into original table to pick up the additional data. However this may not always be posible.

use a DISTINCT union query, This will give you a list of all the unique rows SELECT * FROM [Employee List] UNION SELECT * FROM [March Connected]

take you warnings off and single step through each line to find the line in error. Any routine that that executes SQL statements should use .Execute method, this allows you to use a DBFailOnError Constant which would be used with an error traping routine in the sub.

why not create a table of Months in French and give each row the default Month Number (1 - 12). Then create a function that return the French version of the month based on the month number (obtailed from the Month() function.)

try the spreadsheet forum and not the Access database forum