Search results for query: *

Hi all, I want to populate a combobox recordsource with a query result, by using recordsets. I have done this using a query but is too slow. Me.AddressCombobox.RowSourceType = "Table/Query" Me.AddressCombobox.RowSource = "SELECT DISTINCTROW [Query3].[field1] FROM [Query3];" The user enters a...

Hi guys, I have 2 forms say form1 and form2. Now in form1 the user enters a code in a textbox say EnterCodeTxt, now if that record is already present in a table say table1 then a command box is activated and the user can press it to view the existing record. The command box opens form2 and some...

Hi Guys, I Can't seem to get my IIF statement correct i am working with 4 fields Say field1, field2, field3, field4. What i want to do is display field1 and field2 together seperated by a comma if both are not null and field3 or field4 are not null, if field1 is not null and both field3 and...

Hi all, I needed to filter a combobox value list by a user entry in a textbox, like the way when a user enters values in the combobox which filters through the value list by the user entry. Also noting that the user does not need to enter the full value like a wildcard entry. Thanks in advance...

Hi all, I have a command button on one form: form1 that opens another: form2. Form1 opens in a maximized window, now i want form2 to open in a restore window i.e. which is the size of form2, but leave form1 in maximized window. Also is it possible for form2 to open up on the bottom right hand...

Hi guys, I have one main form: ma_search2 which is unbound. Which has an unbound textbox: EnterPostcode, which is for user entry. When the user enters a post code (string), i want it to filter a table called: ma_dbo_uk, with field: POSTCODE. Now i have a command button which opens up a 2nd...

Hi all, My select query is too slow i need a way to speed up the process. Please bare with me while reading through. The query uses table: dbo_uk_homes with fields: POSTCODE(text) PRMF(memo) STRD(text) STR(text) LOCDD(text) LOCD(text) PTN(text) CNT(text) WCD(text) Now the query has a...

Hi all, Not sure how to do this but what i want to do is update a record, which would add a value to a field from a textbox to an existing record. I have a command button on the form which when pressed should carry this out. The table i want to update to is called: Address. The field i want...

Hi all, I have a code which checks in a textbox called: Name_input if it is null if so it exits procedure if entry has been made runs it. The procedure puts the entry into proper case. I want the procdure to have an added condition to the isnull one, i want it to check if entry is already in...

Hi all, I have a search and append form, for one or 2 textboxes i am calling a module which puts a value entered in them, into proper case. The code in the textbox on exit calls the module but only prompts the user with message if they want there entry into proper case if or not (vbyesno), if...

Hi all, i have a command button that appends a record on a form when pressed. I have a condition before it which prompts a user if compulsory fields are not filled in, to fill them in or append is not carried out. The problem with my code is i cannot seem to display all the text and comboboxes...

Hi all, I have code on the on exit of a textbox called Name_input, which takes the inputted name getting rid of any middle characters or strings to leave first string and last string which is copied to another textbox called SAL input (short for salutation). e.g. Mr M D Donald will result Mr...

Hi all, I have a textbox called SAL (short for Salutation) that copies the value of another textbox called Name, but displays it so that all middle initials or names are gone leaving title and lastname. e.g. Mr T Brown becomes Mr Brown Mrs J L Andrews Becomes Mrs Andrews Mr John Smith becomes...

Hi all, I don't know if i will be able to do this but i want to have a hotkey shortcut for my form. For example if F7 is pressed my form opens up. Is it possible to do this if database is closed before pressing the button? If this is not possible is it possible to have an icon on my window for...

Hi all, I have an IIf statement which combines 2 fields together to create field Expr2. The statement seperates the fields by a comma "," it also gets rid of the comma if the first field length is less than 4, it also checks if values are null. What i want to do is add an extra field to this...

Hi all, I downloaded this piece of code from the microsoft site which capitalises first letter of every name and places small caps on the rest of the name. But it seems to have one problem if the word "withe" is enterd it gets rid of the "e", i don't know why that is it seems to work in all...

Hi all, I want a query that first takes into consideration Null values in field WCD (this is a code) but displays parts of the code due to each circumstance. The condition i want is: if is null then display WCD (show all records even if null), else if the first 2 characters of WCD = 95 then...

Hi all, I was wondering how i may restrict a result to 4 characters. The query reads in a postcode and displays a code like so: 38UCFZ i want to display the first 4 characters so displaying: 38UC. Any help appreciated, thanks in advance, M-.

Hi all, I can't seem to get my IIF(IsNull(...)) statement correct here it is IIF(IsNull([Forms]![Ma_search2]![Expr1]), ([Forms]![Ma_search2]![Expr1])) AS Expr1, IIF(IsNull([Forms]![Ma_search2]![Expr2]), ([Forms]![Ma_search2]![Expr2])) AS Expr2...

Hi all, I have a search input form, which has a command button which runs an append query in sql like so: Private Sub Append_Click() Dim strSQL As String DoCmd.SetWarnings False strSQL = "INSERT INTO ma_enq ( A1, A2, A3, A4, NAME ) " & _ "SELECT [Forms]![Ma_search2]![Expr1] AS Expr1...