Search results

Hi there. Maybe this is belonging to the Modules/VBA forum, don't know. I would like to hear what all you hard-core programmers are doing ;) In my applications the users shall specify a numbers of criterias (or parametres if you like) and based on those criterias I'm creating reports. I've...

Hi Truth... A good idea is always to use the Wizards to do all the "borring" work, then later you can edit the reports, so they fit to your labels. Eventhough the Access is in German, the wizards are using a lot of illustrations - and U know - a pic. says more than a 1000 german words ;) so I...

Hi AppleEater ?¿?¿? (don't U like meat??) :D Have a look at this link. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=31701&highlight=EXE What U want to do is smth. a lot of people want to do but it's not so easy :mad: Best regards Søren Herman Krebs

Hi Lawrence. Your right - it's an easy question and the answer is very short = NO !! :) U cannot convert your DB into an EXE file, but you can download a runtime module from MS. Read more here: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=31701&highlight=EXE Best...

Hi joeyreyma Thanks - so it's called SetWarnings - guess I should have told myself that loooong time ago :o Regards Soren

Hi. When you are running a Append- or Delete query, Access ask you "You want to append 8 row(s) bla. bla. bla. Do you want to proceed? YES / NO" I'm running my queries from VBA and to make life a little easier for the end-users I want to get rid of those check-boxes, but I really don't know...

Hi Harris. You are not giving us many info's eh? :-) Since there are many ways of access a program remotely pls. explain more about what you want to do. Regards Soren

Hi Rich. Well that's an option to, but you know what .... sometimes you can't see the forrest for the trees :o Since I have the invoicenumber for each line I just made a report using the group-function and then I put a pagebreak after each group, wola - there I have a perfect invoice on each...

Hi Rich. Yes, it's what I've done to select the invoices and I'm ending up with a database with all the selected invoices. I'm going to send that database to another company who will print out the invoices, pick the things from a warehouse and send it to the customer. So I'm trying to make that...

Yes I've done that already, but maybe I'm complicating my life too much. I better give some more info. I'm want to print an invoice. We are using a system with a SERIE (A-V or A-D) and then a number (XXXX) There can of course only be 1 combination of SERIE and NUMBER but you see, it's two...

Hi there. I have been reading a looooot of posts regarding these subjects but I can't find a good ex. who helps me. I've seen that Pat is allwas saying that "if you can - use Stored QueryDefs (SQ)" and I would love to - but I'm in doubt about how. If I have understood SQ correctly then it's a...

GOT IT...!!!!! Don't reply this mail. It was it - I was missing the ' around the path and DB-name. I put them into the initialization of the var's, like this: Path = " '\\Fujitsu\users\...." DBname = "Transgesa.mdb' " It's not pritty but it works :D Thanks everybody for your input. Soren

Thanks Pat it's working now even if I'm not using the ; at the end of the line. Based on my new experience, and with a lot of selfconfidence I wrote a new SQL, but still I get the errormessage: Syntax error in "INSERT INTO" statement.... I tried to use the Debug.Print and it seems correct...

Bonjour Jean-Pierre. Have you found a solution on your problem? Regards Soren

Hi DBL. Yes I have tried that, but I still got the problem with the other VAR which is a string. It's driving me nuts.... I've read so many places that when using strings the syntax is: ' " & VARNAME & " ' but it doesn't work with this VAR, is it because it's an Object?¿?¿ Regards Soren

This is what I got: Public VarSerie As Object Public VarNumero As Object Private Sub SeleccionarCategoria_AfterUpdate() Set VarSerie = Me!SeleccionarCategoria Me!SelectAlbaran.Enabled = True Me!SelectAlbaran.Requery End Sub Private Sub SelectAlbaran_AfterUpdate() Set VarNumero...

Thanks Brad. It was some of the problems, others was that I didn't used a filter and the REQUERY command. It's amazing what you can use the demo-bases for :-))))) Regards Soren

Ehh, well a case is basically like this: Select Case ZIPCODE Case "28000" To "28099" CITY = "Madrid" Case "41000" To "41099" CITY = "Sevilla" End Select Depending on how your users are typing in the data, I would use the AfterUpdate property of that field and then...

Hi Courtman. I don't have a final solution on this, but I would write a function where I'm running a Case on the result of the IIF and depending on the result I would change the property of the textbox. Hope this is a help. Regards Soren

Hi there. Just can't find the right syntax... I got two listboxes. The first contains 2 catagories and the second is supose to contain the records of the catagories. I'm using a simple SQL in box2 to select the records, and I want to use the value from Box1 in my WHERE clause - but I can't...