Hi. I haven't used Access in a very long time, and especially nothing like the web app / sharepoint feature.
I have a table based around the "Employee" template. I have also created 4 very simple tables (ID & Value) that have various categories (based on previous experience and current skills)...
Welcome to the forum.
I think you need to combine the date and time fields. Like so:
combineddatetime: [mydatefield] & " " & [mytimefield]
and then run the full criteria. Does that help?
Are you using ODBC linked tables?
If so click on the "External Data" tab on the ribbon > "More" in the import section > ODBC Database > Link to the datasource
by the way when you put your where clause with an input field like that, be wary. If you dont spell it the same or have an extra space before or after the search string it wont return anything.
You could always modify the where clause to have a like operator, wildcard characters and a trim...
its not a problem, its because the names are in a different table. All you have to do is an inner join. So if you have a table:
employee | ManagerID
and another table with:
managerid | managername
to select the employee and managername it is:
SELECT tblemployee.employee...
here's another way
i think postcodes have to start with a letter and are either one or two letters for the postcode area.
IIf(IsNumeric(Mid([postcode],2,1)),Left([postcode],1),Left([postcode],2))
The following might explain why:
http://www.access-programmers.co.uk/forums/showthread.php?t=16389
You could try adding your delete query to a macro and calling that instead. The macro should show up in the wizard regardless of whats included in the macro.
a pretty good step by step guide here
http://p2p.wrox.com/access/5197-pass-through-query-input-parmeter.html
quite simple, only a couple small bits of vba to pass through the parameter and once you've done it once, its easy to duplicate for new stored procedures.
Im still not sure why your...
I forgot to ask. What version of SQL and Access are you using.
You should be able to use your original method if you'd rather do it that way, as long as you are using compatible versions. From memory I think the access version needs to be the same as or newer than the version of SQL if you...
Sure.
How to create a stored procedure:
http://msdn.microsoft.com/en-us/library/ms345415.aspx
SQL Delete Query:
http://www.w3schools.com/Sql/sql_delete.asp
in your example you would have the following to create the stored procedure:
CREATE PROCEDURE sp_yourdeletequery
@x as...