Search results

No nominee for you, but good try. We are in industrial gearboxes :D I will give this a try first thing in the morning, thanks !

This is gonna be a new part of our company so there are just 2 tables for this matter. VR with columns - VRID - Aankoop_lengte - Aankoop_datum - and others which are not important VRMUTSTAF with: - AF_lengte - AF_zaagbreedte - AF_datum - AF_ordnr - VRID Bound together with VRID...

Thanks! Tried but gives me even more headache, what I'm trying to do can be much simpler. I make new columns for - [sawed off] per order which is [saw width]+[saw length] - [total sawed off] which has to be the sum of all [sawed off] - current length would be [bought length] - [total sawed...

The query I'm trying to build is to keep track of the length of a stave. Let me explain the query: - Bought length is applied only 1 time at the start of the record. - First time I have to use the Bought length to calculate what is left - Saw off length and sawing width gives the total piece...

Can you provide me a sample database in Access 2003 format with the forms in question?

I will look into this on monday, I don't have any sparetime this weekend. Sorry!

Just design a new form that will be one of your subforms, and use that form on the mainform as a subform. Look in the workset there is a option for that.

Try Private Sub RefImageButton_Click() Application.FollowHyperlink [RefImage] End Sub notice that there is a space in between the JPG C:\Users\user\Pictures\Reference_Photos\IMG_1679.J PG

To follow the hyperlink it must have HTTP:// in front of the website. Use this code where website is the textbox with the URL that has to be followed. The If statement adds http:// if it isn't there yet. If Left(Me.website, 4) <> "HTTP" Then Me.website = "http://" & Me.website Else...

Forms![IK09:Subbestelbon]![IK09A:Prijsaanvragen].Form![AANVRAAG_ID] That was the one word I was missing, You don't wanna know how many varieties I tried :p. Thanks again!

I've been thinking and trying on this for over 6 hours and yet I think the solution is simple. Problem is that I have to print a PDF and use that file to email it to the corresponding email. Everything works fine except this one little thing. The thing is that the stLinkCriteria won't recognize...

I was again thinking it the hard way, thanks a lot

What I forgot to say is that when you start the application it first checks if it's True, if so then the app will close right away. After that the 30 min loop has to come into play.

Hi, I'm trying to build a sort of closing application so that my boss can kick everyone out of the Access program. I want to do this with a check button that can be put as true by the boss which will close everyone's open application. It must be done by some 30 min loop that checks if the...

I'm gonna look into this tomorrow, thanks for helping me!

http://msdn.microsoft.com/en-us/library/office/aa220736%28v=office.11%29.aspx Here is a link about Sendobject function. It will send the report as attachment and use the signature from Outlook.

That sounds more logic then mine :p

Yes like that, so am I just giving advice. Some will not look at your post with a huge wall of text, so that's why :D

Kinda late you probably got this fixed already but this should work: If you go by todays date minus 1 month use: >now()-31 as criteria in a query otherwise just use the date u want: #01-05-2013#-31 Hope it was something u could use. Martyn

Missingling do you think database design has something to do with it?