Search results

Ah! Genius! That was very helpful. I now have a query like so: SELECT Format(Sum([WorkTimeOut]-[WorkTimeIn]+Nz([AdjustmentHours])),"Short Time") AS TotalWork, TableWorkTime.PayrollNumber FROM TableWorkTime LEFT JOIN TableAdjustment ON TableWorkTime.TimeControl = TableAdjustment.TimeControl...

I've been running around with this for the past 2 days but I really don't think I have the query chops I should to unravel it. The background: 2 Tables, first holds PayrollNumber, WorkTimeIn, WorkTimeOut, and WorkDate. The second holds any adjustments to those entries called AdjustmentHours...

I've used the above function to try and do the same thing, count the number of days excluding weekends, however I've been getting inconsistent results, especially with small differences between the two dates. If the 2 dates are the same, I'm still getting a 1 day difference and if they are 1...

Thanks for the replies and the FAQ, both have been very helpful.

I'm using SQL linked tables in my Access program and just came across an interesting statement in this old thread: http://www.access-programmers.co.uk/forums/showthread.php?t=44095 Now this is my first time working with SQL server in any meaningful way, so I may be missing something, but what...

Success! I never knew you could just type in a Control in the Master Link Field rather than a field (since if you try to do this after clicking on the "..." it gives you an error), that really opens things up a lot. Thanks for the help everyone, i really appreciate it. As always, you guys save...

Thanks for the replies. This looks most like what I want to do, but how do you link a subform to another subform and not to the parent form?

Except the first subform is a continuous form so it can't contain another subform. I'm really just curious how people represent these sorts of nested relationships on the screen, cause I can't seem to find a way that makes a ton of sense.

I have a new database that I'm trying to design an interface for. It tracks a series of plumbing job, and each job has several tickets (1 for each day a plumber is on the job) and each ticket has several lines of materials. What I want is a screen where you open a job and it lists all the...

Hello all - I have a program that I am mildly modifying (I did not write it) and everything is gravy except they want to be able to see the navigation pane only while a certain form is open. I was pretty easily able to hide the pane via VBA when the program starts and when the maint. form...

I currently have a main form and subform about a work ticket, the main containing the header and sub containing the lines. The two are linked via the ticket number and everything is cool, but they want to be able to filter the lines based on status. What is the *right* (I know there are...

Got it, turns out you can pass parameter values. Thanks for the function, it works great!

Ah...crap. Since I know what the ControlNumber is at runtime I could assign the parameter through VBA...if I had any idea how to do that of course. I wish you could call a query with a "where condition" like you can with forms.

Bringing this topic back from the dead. I tried using the above function as stated however I'm getting an error that I don't get when I just export a single Query to a single sheet. On the line rs.Open vQueryName, CurrentProject.Connection I get error -2147217900 "Invalid SQL Statement...

Ah yes, the single quotes! Of course it's something silly, thanks so much, it works now.

This is (for me) a fairly complicated SQL statement and it has a problem that I can't track down. Access, however, only gives me the generic "Too few parameters (expected=1)" error. PaymentSource = "SELECT [tTransPayments].[PaymentAmount] FROM [tTransPayments] " & _ "INNER...

Hello all. I have a new project to build and it's significantly bigger than my other ones. It's replacing an old VB program so we were thinking of developing in the new VB.net environment, but I'm finding making the switch from VBA to full VB a lot tougher than I had anticipated. So it's gotten...

For anyone following along or for anyone else with the same problem as me, I found the solution in a very old thread: I had the cycle property (something I had never heard of before) set to the default, which is "all records" so when I tabbed out of the field I had just inserted (which was of...

Bit of an update. I noticed someone that all my properties on the main form got reset back to default (Allow DataSheet View, Allow PivotTable View, etc..) including AllowAdditions. So I set AllowAdditions back to No but when I tried that I got an error (2455) when trying to reference the...

Ok, perhaps it's deficiency on my part, but I have not been able to solve the problem. The thing that is driving me nuts is this form has other controls in it also based on the same table, and I can update any of those just find, it's only with this new one that I have added that I have a...