Search results

UHM well let me take a stab. This is just a bit of quick referencing I picked up for you to start with. I'm going by memory here lol Theres something called set/get windowlong. With that you can capture the Access instances hwind and set the window's properties. See here for Set Window Style...

There are people who maintain the organization and clarity of posts on this form. Yes they may often do it in a rude way sometimes, but it takes a certain kind of character to administrate lol

Select Pre-Existing dates within your database's records. or Select from a date-time picker?

My simple argument to this simple one sided argumentative post is this? Who created your creator, where do they come from and why is it that you believe in this single creator? Where does your mind go what I ask you this question. Does it come to a terrifying stop and immediately find defensive...

Will it fire if the record he is currently filling is a new record???

Could you explain your planned process here? I'm not seeing it. With that said, and with my limited understanding of what is going on here. Here is my stab at it. If Len(Me.EmpNo & vbNullString) > 0 AND Me.NewRecord Then DoCmd.OpenQuery ("A2EmpNoSalaryMasterA") End If

Exactly the kind of long it depends answer I was looking for :) Thank you!

Also, I thought using ODBC would handle these indifferences?

Would this not change true values to false when -1 is not recognized? This question is more for my education lol :P

Thank you all for the suggestions, I'll apply them all and let you know how things work out! :)

all buy username is indexed, though there is a users.id that is

Do you see anything that would make it slow to process? This information will inflate quickly.

Thank you namliam, this more compact suggestion worked great. :) CJ, your suggestion also worked! Thank you

With code or by eye? lol

Thank you I'll give it a shot! :D

Here is an example of the current output. and its use:

So i have developed an application that schedules lockout / kick times for maintenance / updates for our Access databases. I have a query that collects the general duration each user is spending on each application, on each day. In my efforts to gather the information, I believe I may have went...

Also based on this query, it looks like you need to normalize your tables.

I've a hunch this is a more simple than it appears to be. SELECT DISTINCT Baseline.MDS, Count(Nz(Baseline.[Lesson Type])) AS CBI FROM Baseline GROUP BY Baseline.MDS, Baseline.[Lesson Type] HAVING Baseline.[Lesson Type] = 4 ORDER BY Baseline.MDS; Also if you're using Nz([field]) then placeing...

UPDATE billing_temp, random_temp SET billing_temp.audited = -1 WHERE billing_temp.people.id = random_temp.peopleid;