Search results

I have a query, let's call it "Query1". I have a split form that I would like to add a button to, that when pressed will run "Query1". The reason is only because we like to have maximum screen space (we have many columns), so we keep the tables/forms/queries box on the left minimized. I...

Hello, I was hoping to get some suggestions on how to deal with our due dates. We have over 100 active jobs (records) at any given time, each with a due date we specify in a column called... well, due date. We want a more visual way of viewing jobs that are due within, say 2 weeks. I realize...

Perfect. This works great! Thanks for your help boblarson, appreciate it. :):):):)

Yes this is how it works now. But even after moving to a new record, the text box does not update. Where can I place this Me.Recalc to force a recalc after moving fields?

We have other dirty code that runs already upon any change to the form (changes background color etc.. we have probs with people not understanding when there editing :)) So this does not work in any case, it will only update the text box if you close the table and re open it.

See that's what I had but it doesnt work.. BUT I just tried replacing False with No and it works. :) It doesn't seem to update when you change a Jobs Invoiced status though... is there a after update code I can add to the Invoiced selection box?

Hey guys, I'm just writing a simple dsum, but I'm not sure how to continue. Im trying to have a text box display a sum of the field [JobValue]. But, there is a field beside that called [Invoiced] which is a "Yes/No" field. I want the new text box to display the sum of [JobValue] only for jobs...

Hello, I know it is possible to sync your outlook contacts into an access table. Now what I need to know is, if I sync a second users contact into the same table, will it sync for both users? So if one user makes a change in outlook, will the second users outlook pick up this change from the...

thanks for that. not getting anything yet but ill keep playing around with it! :D

There will be other fields in the new record that we would fill in later so not sure if this would work but it sounds like what we want to do. We are just trying to reduce the time from copying and pasting the fields in my original post to the Job Board.

But thats the thing, once we move a job from [2009] to [Job Board] it contains a completely different set of data. 2009 is quotes, job board is jobs we have won the contract for. So having a seperate table is needed. I cant start rearranging our database, I just want to create this button for...

You lost me after JobBoard is a query not a table... whhhaaaa? I dont want to just toggle them on and off, I just want to move the info in the fields, instead of doing the old copy and past from one table to another. Either way, I is confuse.

Gday. I am fairly new here I guess, I have managed to program some simple buttons on my form but this one I am in over my head and looking for some help. I need to create a button that moves the following fields of the record in view from table [2009] to a new record in table [Job Board]. The...

That is excellent. Where do you learn this? I have a lenghy book on access but it does not go into any of this. :) Where can I learn to code from scratch?

This one works, but on a second click is does not turn the filter off... I would hope I can program this into the same button? Not sure I would want to have a seperate button for this.

:confused: Does nothing. I is confuse.

Hello! We are using a split form, and the staff keeps messing up or clearing their filters and always has to reset it... I would like to place a button on the form that will do away with the need to always redo the toggle filter. A permanent button. I tried using the button wizard but I assume...

Testing this one for a few minutes now.. so far works great! It was actually funny before, I would update and be transfered to a completely random record, with absolutely no pattern. Very strange. Thanks again. This will save us so much frustration working with silly totals and date filter...

Yup that does is, I added it in the undo as well. When I update a value and it re-calculates, it brings me to a random record for some reason. I apologize for yet another question :o, but why would it not stay on the record that was just updated?

The only little bug I can see is that it does not update the total after adding a new job unless I restart access... is there an afterupdate i could do here?