Search results for query: *

Try using Right and Mid, if these give an error too, maybe the follwing might help (I copied this from the Acces General Discussion forum on a problem using the Right function). The References window refers to object libraries available to you. An object file is a file with an .olb extension...

Q2: put in the commandbutton code (OnClick event): DatForm![datum] = Null Q1: Use DatForm![datum].SetFocus Q3,: What do you mean by Commandname, if it is the name of the control (like datum being the name of the field) it is in the Properties combobox on the Other tab, first entry (Name).

Q2: put in the commandbutton code (OnClick event): DatForm![datum] = Null Q1: Use DatForm![datum].SetFocus Q3,: What do you mean by Commandname, if it is the name of the control (like datum being the name of the field) it is in the Properties combobox on the Other tab, first entry (Name).

Gary, ReturnTheDate doesn't return a date, it just sets the value of a local variable.

Where do you try to display this string? On a report, in a text box?

Strange... Does does latest problem happen on both the Development and Production database? If you want to, create a new application by merging the relevant form(s) and tables (etc.) and mail it to me offline: westwind@euronet.nl and I'll have a look at it.

Execute Me.OpenBy = "" in the forms Open event.

Just a small remark: if StartDate=EndDate the employee is selected twice for the same day in Terry's solution. Depends on the reportstructure if this is a problem, but why not put [End date] + 4 in the last select? Nice solutuion though (and a nice challenge from Michael!).

Yes, I see what you mean. The time is displayed as soon as the field gets the focus. Access displays the "true content" then, including Time UNLESS there is no timepart. This explains why the other suggestions did work, they are based on Date() which does not contain a Timepart. My...

Sorry, no idea.. Is the Production database also Access or is it (e.g.) a linked SQL server or Oracle DB? Are there version differences between your development and production environment. What is the query code?

OK, but what's wrong with MyDate = DateAdd("h",-7,Date) In words: give me the date of seven hours ago.

What am I overlooking? You're not selecting from tblClientSelect so what's the comparison for? Please explain what you are trying to do. If it is just selecting all distinct ClinetId/DateOfTraining combinations from Training Details and create for each of them a record in tblClientSelect, just...

Dave, It loks great, but I do't get it to run (illegal option - --) and I don't understand it either Where did you find this? Philip

I'm afraid you're in trouble. Check articles Q105416 and Q213841 on support.microsoft.com. They describe a similar problem, it boils down to Excel 95 code being used in Excel97 AND EXCEL2000(!). In the first article (about Excel97) Microsoft acknowledges this to be a problem, but in the second...

Check the Table definition of the table the field you are trying to enter belongs to. I have a feeling that a Lookup has been defined to the table Action Types. Another possibility is that a relationship has been defined between the two tables.

Small addendum to Neddy's solution: I suppose you just want to replace multiple pagebreaks with a single one. Follow Neddy's solution, but replace ^m^m with ^m. You must repeat a "Replace all" until no more replacements are reported (to get rid of "triplets and higher").

Check out the DateDiff, DateAdd and DateSerial functions in the Access Help. They'll solve your problem (and many more)!

If you don't want the duplicates, make sure that the tabe properties do not allow them (a primary key is sufficient). Then use the wizard. It will NOT accept the duplicates, but it will accept all the other records. The records that were NOT accepted are put in the table ImportErrors. If the...

Ok, your SQL should look something like: SELECT CAT_LOOKUP.CATEGORY, COUNT(Maintman.someField) AS NmbOfCats,<otherfields> FROM Maintman RIGHT JOIN Cat_Lookup ON Maintman.category = Catlookup.category WHERE (Maintman.Date >= Begindate and Mainman.Date <= Enddate) or Mainman.Date Is Null GROUP BY...

Use ##\,##\,##\,##0.00