Search results

@georgedwilkinson: In the very first sentence of my original post i wrote: "On the form there are 15 fields and a custom "SAVE" button for which the OnClick Event checks various things before storing the record." I do sincerely apologize if I was not clear enough in the approach to my question...

Yes dbDamo, thanks for understanding. That is EXACTLY what I want to do. Now we need to start looking at what code to behind the OnClick event, and that's where I draw a blank. I will play with some ideas and post here, but any input from your side is appreciated. @georgedwilkinson : My db is...

That is exactly the reason why I don't want to do it in table design. If we restrict he duplicates in table design, then it means this: - There can NEVER be more than 1 [John] [Doe] that works in [Logistics]. If we can use code to somehow check for > when the user captures a 2nd John Doe in...

Thanks everyone. I'm aware of the PK option for fields in table design, but I don't want to use that. As dbDamo said: "I wouldn't" (either). As an interim measure (for my own valid reasons), I WANT to do it with code in the button's OnClick. OK, from code, with a Msgbox, let's say I just...

CORRECT! I was just using an example. My DB has nothing to do with personnel.

Hi, On the form there are 15 fields and a custom "SAVE" button for which the OnClick Event checks various things before storing the record. There are 3 specific [textbox] fields which must not be duplicated in the table For example: PK=personnel_id Field1: John Field2: Doe Field3: Logistics...

SOS, Sorted now. The ".Form" part was clearly the issue. Thank you for pointing it out. Just for interest sake: What is the difference between [RecordSetClone] and [Recordset.Clone] ? Both does the same for me. Thanks again. Jamie.

Hi, (Sorry about a previous post with the same Title. There's no content for that post, don't know what happened there...) I am using Access2000. Scenario 1 - no problem, works as expected. Scenario 2 - Need your help here. Scenario 1: Mainform named [frmPatAuths] (no subforms). Based on a...

so simple... Thank You !

Hi, The application and form is setup so that the user can not close the form unless the custom 'SAVE' button is clicked. 'Save" button does various checks for valid field entries. I have 3 seperate (not grouped) check boxes (0=not checked, -1=checked) The user can check any one or two or...

OK, here's the progress I have made... not much, but something at least... In my original post you will notice that MY network range is 192.168.0.3 - 192.168.0.X And, in the LANDISK's web interface thingy I have assigned an ip of 192.168.0.15. It is also configured to belong to WORKGROUP. All...

Thank you for your reply... Yes, the enclosure can operate without a HDD, however I did install a 750gig HDD and it works perfectly when connected directly to a PC with either the LAN Cable or USB. With USB it simply functions as any normal external HDD; but ou cannot access it's internal...

Hello, I would like to move my access back-end to my new external Landisk, but I am having a few issues with it. I hope someone here can point me in the right direction. Here's the situation : I have this (no-name-brand) Landisk simply known as "Mobile Landisk" by Chronos. I have successfully...

Solved Clearly I have yet to learn alot more... You make it look so easy. THANK YOU VERY MUCH! Regards, Jamie.

Apologies for the previous double-post. Was doing too many things at once. Attached is a sample of the DB I am working on. I have put a note on the form and the report for you to look at. Thanks again. Jamie.

in the report footer, (see my initial post) : _________________________________________ Now, to get the GRAND TOTAL TIME, in the ID_User FOOTER, i have a textbox name txtGT_Time with the same code as the Time_Total column, ie: =Int(Sum([TimeOut]-[TimeIn])) & " day " &...

in the report footer, (see my initial post) : Now, to get the GRAND TOTAL TIME, in the ID_User FOOTER, i have a textbox name txtGT_Time with the same code as the Time_Total column, ie: =Int(Sum([TimeOut]-[TimeIn])) & " day " & Format(Sum([Timeout]-[TimeIn]),"h"" hr ""n"" min ""s"" sec""") The...

What I'm trying to do is to SORT the report BY FOOTER, having the user with the most TotalTime at the top, or, the way I see it, is that I want to sort the report by >>> SortBy(or OrderBy) the textbox named "txtGT_TIME" which is in group Footer. I've google'd around for ideas and tried some...

still having issues with this... What I'm trying to do is to SORT the report BY FOOTER, having the user with the most TotalTime at the top, or, the way I see it, is that I want to sort the report by >>> SortBy(or OrderBy) the textbox named "txtGT_TIME" which is in group Footer.

In the Query I did sort Time_Total in Descending (which is what I want), but in the Report, the ID_User (FOOTER), is not sorted at all. I've tried the Report's Sorting and Grouping as well. Any ideas, please.