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...
one option is to create a stored procedure on your sql database with the delete query and then for the passthrough you'll have "exec sp_storedprocedurename"
That's the proper way of doing it if you have an sql server backend and access as the front.
Can you change the table structure? If so, you might want to look at changing it. Is the number (N) in DateN relevant or do you just add the next date into the next available field? If so, you could have a separate table with:
FID | FDate
and change your current one to:
FID (Autonumber) |...
sorry I cant answer all questions, but here's my 2 cents
Not necessarily but sql is alot more efficient, especially with stored procedures and I've never seen corrupted data, even with our databases which are a few GBs and are hammered all day long.
Almost certainly
I dont think so...
Oh I forgot, then you'll need to populate your listbox or however you want to display it. For a listbox it mwould be something like this:
dim i as integer
for i=0 to ubound(sString())
list1.additem sString(i)
next i
No, sorry I dont. I just found a great little function though, but I've never tried it before. I used to use a dynamic array and the instr function to do exactly what this does.
Dim sString As Variant
sString = Split(YourString, ",")
That'll basically build a dynamic array with all...