Search results

Ahaaaa...well my mistake, i thought the refresh done by the db was for the whole form (recodset).. And then i started thinking what would happen if it was a user instead of me inputting data in the form so i started to run worst case scenarios....and so on.. Okey now i get that the db will not...

To the rescue again :D. Your solution takes care of the F5 problem, not to seem ungrateful....again, but what about having a general solution to the refresh..uhhmmm...lets call it symptom. Having a general function catching the refresh and checking if the user or db is doing the refresh or/and...

Hi thanks for welcoming me :) Hi i ran the compile and didnt find anything. What i am after is more of some pointers on whats missing like: Error handling (i know that one) and maybe how i set up the code if there are some obvious mistakes etc...Im not a native VBA coder, im more of a flash...

Hi All, For some reason the code i have in my main form caused access to crash when doing almost anything in the form...i re arranged a few things and it works fine again....but. Could anyone with some experience have a look at my code and point out any shortfalls as im sure there are many...

Hi thanks, I played around with the onCurrent event but i still see a problem... If the user is on record 5 and the db does a refresh it jumps back to record 1. If i use the bookmark method on the onCurrent i can only set the bookmark to that record not load the form to the record bookmark..so...

Ok looks great but where do i put the code if i want to have it run when somebody clicks F5 or the db automatically refreshes...on the onLoad of the Form? But then i need to change the bookmark everytime i step through records in the form to...right? Is there a "Change records" type event on a...

Hi all, How do i make Access stay on the current record if you press F5 for refresh or when the db refreshes automatically thx

Well...well....how easy was that :D Thank you so much for easing my aching brain. My keyboard sends its regards and thanks you for making me stop taking out my frustration on it. thx Zozew

Hi all, I have a Date related problem... Im running this code: myRecordSet.Open "SELECT tblInmatesProfile.InmateID,tblInmatesProfile.LastName ,tblInmatesProfile.FirstName ,tblInmatesProfile.MiddleName FROM tblInmatesProfile WHERE (((tblInmatesProfile.Archived)=False))" With myRecordSet Do...

Well there you go! Im blind. I came across the Dcount method but I must have forgot to test it.. :D Thank you so much!

Hey there all, Im trying out something that should be the easiest thing in access i presume, but for me.....im going nuts! I got a INSERT INTO SQL in VBA, the result is populated an existing table. Then..tata...i want to COUNT the records in that table, use the COUNT to loop through them and...

Well im not sure what to say except thank you, not that im the least ungrateful but you did to much for me :) The concat function you made is perfect. To be honest trying to code in a language im new to i feel so handicapped. Simple things like building a function to call from anywhere or...

Thx ill do my best...i check it asap.. Yeah the escorts are grouped per hearingdate and then sub group per branch i did copy all changes to my current db but then a similar problem came saying there was an invalid or something like it on an onCurrent event...so i started to outcomment...

I've tried but there is some unique identifiers missing so i cant check the referential integrity boxes... Its in tblInmateHearings... Im sorry but i still dont see how the users selected Escorts will be added to the report this way...i know im a bit thick but doesnt the data in...

Ok, i kinda get what you are suggesting... So used my old sheduleQuery as a base i added the two new tables to get the EscortsName field into the Query and it looks like this: And running it i get nothing...which is expected....Because the tblBranchEscorts is empty. So i need to populate...

Sorry.....:o Yep i get that...but still i dont get how to link the EscortId really... Link or a junction...im trying to think of ways to do that but how....I think i get what you are suggesting...but how... So the tblInmateCases.BranchID i link to the Link table and then I link the...

ok i think this is ok....now the data is linked to the tblInmateHearings.... So i was thinking when the user makes the selections of escorts for a specific date in the schedForm it is written to the three new tables i made. And if i manage to add the tblHearingDateEscort.HearingDateID to all...

ok well that makes sense, so either the BranchID or the date could be linked, probably the BranchID is best. Ill try to structure make a new table save the data and link it..... and get back with it working...hahaha had to say it it felt good just saying it :D thx again.....

Yeah i am with you on that point, but for simplicity reasons and if you knew who will administer this DB when im done, you'd advice me to keep everything in one file... Thx for the link ill read it and adapt :)

Im not really sure but i changed to the code below and it works as before, I get almost the same error '3021' but without the '<Unknown error/message> HRESULT : &H800A0BCD' Is there another way of getting the fildData written to a file from the attacment field?? Without instantiating the...