Search results

Hi again! I really would appreciate some help on this: I have a form where I enter a date:- Then I have an option group called day/week/month/quarter/year now I need to filter the subform to display all children who turn 2 on this date if day is chosen who turn 2 in this week if week is...

Thanks a million guys!

Hi all, Again I need a little help from my friends! Can someone tell me how I can copy just one field from the previous record into the next record? On the keyboard (German) this can be done by ctrl-hash. I want to put a procedure on double click that will copy the field from the previous...

I think I do need to store the working week (39 hrs) as I later need to subtract hrs. worked from this. I also need to split this time into 2 sections (actual work time and preparation time) and subtract worked hrs. from this to get a weekly overtime or - time report. Getting more and more...

Hi there, So in the table the field must be a numeric (double) field? So I store 39 or 19,50 etc. and just display it on the form as 19:30 in an unbound form?

OK sorry - I didn't explain that very well, did I! I want to enter 100 in the Appointment (%) is not part of the field name - just put it there for clarity:). Then the Appointment_Hrs should calculate 39:00. If I enter 75 then 75% of 39 Hrs etc. My problem is that I need to be specific in the...

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!