Search results

dk, sorry I was out for the rest of the day... So, I've done some searching and I'm attempting a change of tactic. I thought perhaps I could enact the filter option by code from a my popup search form. I'm using the same unbound form with unbound text and combo's but this time hopefully for...

dK, hello again. Thanks for your response, it looks like it makes sense only I not quite following. How do I create edit a dbl click event on teh datasheet of the query. If I go into design mode that takes me into the query builder and I don't think there are (or at least I can't see) any of...

Here's a picture to show the result of all your hard work...:)

Mike, you were spot on, once again. It seems so simple when you put it like that. Too simple for me it would appear. That works perfectly, and I can now trigger the form I created to tell the user they are at the end and they need to navigate in the opposite direction (I use the same form both...

;) Good work Mike, that's the annoying event that's messing my nice form presentation and navigation up! Removed it and it works fine. Hmmm. Now I have get both working together.

Mike, Thanks for that. My macro was setup as you explained. Previous is working perfectly, thanks. Next works on the others, but not this form. You are correct though, this particular form does have code in the OnCurrent event. It basically checks the status of a text box and then makes some...

Gents, Thanks again for all of your help, very much appreciated. I've been experimenting with all of your options. I have a mismash of code and macros now, so thank you. Mike, I like your suggestion about the pop up and self closing form and I'm messing with that just now. I have five forms...

Hi, I followed this guide: http://support.microsoft.com/kb/304428 to create a query by form example. I created a search form with unbound controls (frmJSASearch). I created a query with all of my fields (qryQBF_JSA) and used criteria as defined in the article above for the search fields on my...

Mike, Excellent stuff, the next button now loops perfectly. Also, the new record selector box was a useful bonus, thanks for that. However, I'm still having problems with the previous button. I have added the name of my text box (the one holding =[CurrentRecord]) into the criteria against...

Ken, thanks, but I would still need the ability of users to be able to enter new records it's just that I don't want the error when they are pressing next or previous and get the end of the recordset.

Ken, Yes, a number of 'fairly' basic forms. Some have subforms. Currently when the user presses previous or next in either direction within the recordset and gets to either end an error is triggered. I'd rather it just loops round so that the user doesn't think it's broken. I have buttons...

Hi, How do I stop the user getting teh end of recordset error when they try to navigate before the first or beyond teh last records on a form? I have looked for "supress end of recordset error" and "loop at end of recordset " plus various other combinations but I keep getting things a tad too...

Bob, Sorry, me again. Immediately after fixing that problem above, I closed the DB, copied it and opened the new version to make further major changes. Now my text box doesn't work. I didn't change anything else, the code looks the same as I left it in the standard module. Why would that...

Bob, Many thanks, that's it working now. I already had the standard module and the code in it but I appeared to be missing this part: Option Compare Database Option Explicit Thanks again.

Ok, I changed the module name to 'windowsusername' and then I changed my text box control source to =windowsusername(). However, I still only get '#Name' returned in my text box. Also, should the code in the module have a line through it after this line: Code: "GetUserNameA" (ByVal...

Ooops, that was accidental. I thought I had my tab with my post form earlier today but I must have been on my tab I was using to search the forum. Hence the reply in the wrong place. It should have gone here... http://www.access-programmers.co.uk/forums/showthread.php?t=163838 That was the...

Ok, I changed the module name to 'windowsusername' and then I changed my text box control source to =windowsusername(). However, I still only get '#Name' returned in my text box. Also, should the code in the module have a line through it after this line: "GetUserNameA" (ByVal lpBuffer As...

Hi, I have made a module (fOSUserName) using this code from my searches: '******************** Code Start ************************** ' This code was originally written by Dev Ashish. ' It is not to be altered or distributed, ' except as part of an application. ' You are free to use it in any...

Thanks. For anyone else interested in how to do this.... I setup a text box and changed the control source to =IIf([Subformname].[Report].[HasData],Null,"Whatever text you wanted displayed here") So if the subform/subreport in the master report contains data it returns null i.e. blank...

Hi, I'm not having mcuh luck but I have been trying to hide a subreport in a rport and idsplay a comment when it is hidden, but only when there are no values in it for that record. I have tried a number fo methods. My most recent uses an unbound text box to display a value and then I try this...