Search results

Hi all, I hope someone can help me here! I have the following fields in a table: Appointment% =100% (standard number) Appointment hours =39:00 (Date/Time field)?? WorkTime =32:00 hours (date/time field)?? PrepTime=7:00 hours (date/Time field)?? Now in my form I would like to enter 39:00 hours...

Thanks a million Marion

Hi there... here's hoping someone can help me! I have a form where I "collect" the criteria to print a report. The fields are as per the attachment, HHA (text), Date from - till, And a list field where one or more items can be marked. Now I need to print a report: I have tried the following...

Vielen Dank!! So Einfach kann es sein! I found it under "Commands not in the Ribbon" Marion

Good morning to everyone from an (at last) sunny Sunday in Germany! Can anyone tell me where they have hidden the "duplicate" command in form or report design, in Access 2007? It was much easier than copy and paste and usually placed the element directly under the duplicated element. I have...

Thanks Guys! The "Problem" appears to be that I was using the gotfocus instead of the onload. I have divided the sub into one setting the order on the Onload. Works fine now. Thanks for the prompt replies!

Hi All, I am trying to set the column order in a sub form. This depends on different settings in my options file. I have on "got focus" of the sub form a sub with Me.tblxx_Gemeinde_ID.ColumnOrder = 1 Me.vorschlag.ColumnOrder = 2:mad: Me.tbl_Auftrag_ID.ColumnOrder = 3...

Hi there, The data looks like this because I'm busy with a data conversion to be able to use my programm. The old data has been imported from a .dbf file, and I'm converting it into my "normalised" mdb. Thanks for the answers - I've solved the problem by writing the data out into a temp table...

Hi all, A I am trying in VB to sort a variable txtstring and return as a string the result. For example I have: txtstring="B,A,C" (or 1c,1a,1b or just numbers "3,7,2,1,4,5,6") And I would like to sort the string to read txtstring="A,B,C" I have tried the split function, but am not quite...

Thanks! As I said my backp runs at midnight every night onto a external drive which is well hidden - they didn't find that! Just didn't reckon anyone would steal my computer between 6 and 9 on a Saturday night! Thanks anyway Marion

Thanks a lot - what I feared! Seeing as it's "only" 1 days work I have lost it's cheaper just to redo it! Damn... don't you just hate thieves! Marion

Hi all, I probably know the answer to this question, but believe me I am desperate - so I ask anyway! I spent a whole day writing some VB code, creating new forms etc. - saved the .mdb, created and .mde which I sent to my customer. Then went out to party..... my backup routine runs at midnight...

Thanks for the tip - I appreciate all helpful comments!

Thanks for the tip - I'll check it out!

Thanks guys it works like this:- Set Gebuehr = db.OpenRecordset("SELECT * FROM tblxx_Gebuehr " & _ "WHERE tblxx_Gebuehr.tblxx_grabart_id= " & Grabart & " AND " & _ "tblxx_Gebuehr.tblxx_Gebuehrkategorie_ID= " & Kategorie & " AND " & _ "tblxx_Gebuehr.deleted=0 AND " & _...

Nope - sorry Aman - get the same message - won't compile Thanks for the trouble

Umm.. sorry attachment - try again

Hi branston - Thanks a mill but it still doesn't work. It wont compile. Attached the message (sorry about the German!) The variables are all dimmed as Long and have the values 1 , 1, and 5

Hi All, So sorry to be back with the same theme, but somehow I just can't get the hang of these SQL Statements! I hope the kind person who helped last time is still around! Set Gebuehr = db.OpenRecordset("SELECT * FROM tblxx_Gebuehr " _ & "WHERE tblxx_Gebuehr.tblxx_grabart_id= " & Grabart AND...

Anybody ever tell you you're a Star!!! Thanks again Marion