Search results

If you have two simultaneous visitors, the two visitors may read the valeur in, let say, Table D. Both receive 6, and both update the total to seven. Since it happens in a split second, the total may be ok in other tables. Can you show us some code or give more details?

Try this : Public Function WorkingHours(datBegin As Date, datEnd As Date) As Double ' Beginning and end of the day Const tmecDayStart As Date = "7:30:00" Const tmecDayEnd As Date = "18:00:00" Dim datTotalTime As Date ' Running total of time worked datTotalTime = 0...

I might be totaly beside the track, but I would try turning Name Autocorrect off (Tools>Options>General>Track name autocorrect info). Maybe it runs the query to verify that all the names are correct in it.

If there are dates in the faulty queries, try checking the syntax. I think that if you don't format the dates in VB, it can be misinterpreted by Access. Try format(your date , "mm-dd-yyyy") It's the format Microsoft Jet prefer. If you still have problems, wrap it with two # . Ex...

You have several syntax and structure errors in the one above! Try this: DCount("[CallType]", "dbo_tbl_DailyCall_Log", "[CallType]='Inbound' AND [CallDate]>=#" & format(Forms!Retriever![txtDate],"mm-dd-yyyy") & "# AND [CallDate]<=#" & format(Forms!Retriever![txtEndDate],"mm-dd-yyyy") & "#")...

if [CallType] is a date, why do you do [CallType] = 'Inbound'???

Try formatting the date to dd-mm-yyyy, or mm-dd-yyyy, Microsoft Jet's date format. I'm not sure which one it is. IntC = DCount("[CallType]", "dbo_tbl_DailyCall_Log", "[CallType] = 'Inbound' AND [CallDate] >= #" & format(Forms!Retriever![txtDate],"dd-mm-yyyy") & "# AND [CallDate]<= #" &...

More details? Can you give us an example fo a query that cause a bug, or the code used to build the query, including the connection string? That would help. Error 3343 unrecognized database : sounds like a conenction string problem to me. I think that when upgrading Access, it upgraded...

See below see modified reply below

use "#" When using a date in a Domain function, use # before and after your date. Example : IntC = DCount("[CallType]", "dbo_tbl_DailyCall_Log", "[CallType] = 'Inbound' AND [CallDate] >= #" & Forms!Retriever![txtDate] & "# AND [CallDate]<= #" & Forms!Retriever![txtEndDate] & "#")

Or you can vote for Bush and end up with a puppet

Election is not about voting for the best one, it's about voting for the "least worst". :D

It's not surprising you vote Bush. :cool:

Hi, I need to Sum the values in a detail section of a Form. My form should look like this : Name Monday Thursday ... Sunday Total --------------------------------------------------- Jack Tremblay 10 2 ... -4 125 Pierre Wilson 0 -5 ... 5...

Very dear LaBelette... Are you a moron, LaBelette? :D Seriously, I found the problem, so you can now all return to your normal occupations and stop working on it. ;) NEVER use combobox.Recordset("fieldname").value . Use combobox.Column(index, [row]) . The recordset does not always...

Hi! I have a Form FRegulier containing a subform SFRegulier. The form is bound to a query, the subform SFRegulier is bound to another query. In the details section of SFRegulier, I have a combobox lstEqNaturelle, who have the RecordSource REquipeNaturelle2, which has 7 fields. The combobox is...

Stfu STFU :eek:

Very addictive stuff... for the bubble-wrap lover in you! For those who like Badgers, Mushrooms and Snakes. And this amazing Japanese drum machine! And finaly, the Amazing Sticks Fight!

Lol, :D I used to play that a lot when I was young. I used to imagine I was playing TRON motorcycle races!

Weel, this works when the client does not know Access, but this one knows it, and he don't want a report. I will prefer it, but he want a form. I guess discussing about problems printing forms is just beating a dead horse. :D We knows it's useless, but...