Search results

Hi guys. Thanks for the replies. - I realised the title might've caused some confusion. I don't mean double click. What I mean to say is, a click on an active control, whether the click be straight away or a minute later. And yes, the data type is numeric. - Only frm1 opens upon...

I've been trying to do this for hours; can't find a solution. I've got a continuous form, with a button (cmd1) on each record. Each record has a unique primary key, RecordID. cmd1 is clicked to open a form (frm1) based on the RecordID using the following code: DoCmd.OpenForm "frm1", , ...

I've already implemented a feature that lets users know whether it's in edit mode. See attached pic. I just thought a beep would be easy to implement. If you see the picture, you'll see that the 'Age' box doesn't get unlocked, even if it's in edit mode. That's because is it bound to an...

There's a button on the form that unlocks the textboxes, so the user can enter data.

Nothing else to explain really. How can I get my database to make a beep sound when something is trying to be typed into a locked textbox control? This is so that my users can know that it's locked (much like when the delete button is pressed on a new record). Thanks.

Thanks everyone for your replies. I've discarded the entire code snippet in on my first post and gone with the below: Private Function fctPositionForm() Dim intCm As Double Dim intDatabaseWidth As Integer Dim intDatabaseHeight As Integer Dim intLeftPosition As Integer Dim...

Sorry I probably didn't do a good job of explaining. I've attached a picture. Hopefully, it will explain it better. That wouldn't work since the popup form will not be centred vertically on different screen sizes. I want it centred according to screen size vertically (just as it is, when i use...

Okay will do. Please have a look at my other question related to this. http://www.access-programmers.co.uk/forums/showthread.php?p=1407196 Thanks again.

I am using the below code to centre a popup form, both horizontally and vertically. All my non-popup forms are 25cm wide. It looks weird that the popup forms appear on the centre of the screen, when the centre of the form is more towards the left. This is especially true in widescreens. How...

Thanks Gina, I read the page and found the solution. I changed statements like this... Private Declare Function apiGetClientRect Lib "user32" Alias "GetClientRect" (ByVal hwnd As Long, lpRect As typRect) As Long ...to something like this #If Win64 Then Private Declare PtrSafe...

I get the above error when using code to centre a popup form. I am using 64-bit Windows with 64-bit MS Office, but I want this code to work on both 32-bit and 64-bit (Windows / MS Office) and if it matters at all, on all versions of Windows above XP. How do I get it to do just that? Sorry for...

Hi guys, Is there an efficient way anyone knows of, to have default text in a textbox on my form (like a search box), but have it so that when a user focuses on the textbox (to type in a search term), the word should disappear. Just like the search box on windows 7 start menu. Then, is there...

I understand what you've done there, but I just don't get how to replicate it. It looks like too much effort - even if you explained it - and impractical for a workaround to what should've been really easy (using the filter query method). I'm just gonna exclude the phone number fields from...

I looked at it and understood some of it. I guess I'm asking just in case I miss a bunch of stuff out - wouldn't be good. I will look at it deeper tomorrow; don't go anywhere. Oh and since our replies tend to be quite far apart, please just for now, name the steps you took and I'll do my...

Wow, thanks JHB. Can you please briefly explain what you've done for both these forms and anything else I should know, so that I can reproduce it. Thank you P.S: My objective here is to have a search box beneath all the fields on the continuous form (e.g. Name, DOB, Email, Mobile, Telephone...

Thanks. I've read the content and understand why the error occurs. Here's the solution the page describes: But I don't understand step 5. What does "the name of the parameter or the form reference" mean? I can confirm that the crosstab query is the problem here - I did say earlier that if I...

Hi JHB, I can't upload the original and it's a big database that's not easy to understand at first even if I did. I've uploaded a sample database with the same conditions in the area of concern with sample data - the same error occurs when trying to set the search box as the query criteria.

Thanks, but where do I put that code? I've tried entering it into a single line in the query criteria and on two separate lines, but to no avail. FirstName="[Forms]![frmStudentDetails]![txtSearchFirstName]" Like "*" & FirstName & "*" (They gave no error, but no records show) Excuse my...

I've got a continuous form based on a query. Each of the fields have a search box below it (in the footer) which should ideally filter the query. I'm starting with the FirstName field. In the form's query, I've set the criteria to the following for the FirstName field: Like "*" &...

Wow thanks i didn't know you could do that. i thought it would be more complicated