Activity Stream

You should have 2 fields, and . (Not 3 fields) a date field holds both date AND time, then you just get the difference to get the elapsed time:...

Access (and from memory the ODBC driver), is clever enough to alter a Where and a Having to produce the correct results in the most efficient way. ...

Hello again guys, I just have one question about this code and locking the old records. We are using it over a month and it works fine, but here is...

sounds like the original query plan that you would have created left certain elements in place based around the ODBC. If you copy the sql text from...

See if this is close to your requirements:

Okay the zipped copy is on drive, the way in is as a share with the email address: gearysonya@gmail.com and the password is: Jac94Qab95. have fun...

I have been unable to get the database small enough to post I have delete all records, ran the compact/repair it is still about 4 MB it seems the...

Table relationship window

Hello Ajax. You said: "mixing tables from different locations in a query will always be slower to some extent. Not something you mentioned before."...

(1) can you give me an example of a UDF (User Defined Function) that will do what I want (and where I need to put this UDF). I understand I just...

great!!! thank you so much, the solution for my report seems to work with: #;#;"";"" it looks much better/clearer , when I print out the account...

"Yes, I would do unique indexes to prevent double booking. Don't know if I would have a table for dates" I'd hate to overcomplicate your project,...

1-Post a copy of the database as Steve suggested. 2-Describe a day in the life of the business -at a high/30000 ft level so we understand the main...

You could use a custom number format in the control on the report. See Number and Currency data types (Format property) Look for the heading...

always helps to provide some example data. sounds like you have a record displaying say six fields 1..2..3..0..3..2 and you want to see ...

@ thearn Maybe you could post an image of the relationship window (if you have set up relationships) Better would be to make a copy of the dB...

Also note: "Exit" (Student Database), "Day & "Time" (Class Details) are reserved words in Access and shouldn't be used for object names. Should not...

Thank you Ajax, I totally get what you are saying, however in this environment, those issues are really irrelevant as they are not really tracking...

I think I would write a UDF to get the previous Lieu (hours) or total Lieu (hours). You could put the total in a control on a form/report. Not...

The one caveat to that method is if it's a shared database. Should 2 users be making selections at the same time they would cross with each other. I...

AND OR NOT are boolean comparison operators. Unless grouped their order of application can be something other than what you think is going on, plus...

Public Sub test() 'PopulateCalendarTable Date, 10000 End Sub Public Sub PopulateCalendarTable(StartDate As Date, NumOfDays As Long)...

I've never tried to add sorting functionality in Excel after the export. Did the macro recording not give usable code?

Been out grocery shopping so have been inactive here. Anything regarding functionality would be entirely based on the inputs and outputs desired....

So here's what I have up to now... Couple quick questions... Is there a way to populate the calendar dates or do I have to fill them in by hand?...

Can you show me form you're currently designing?