Search results

Hi, I have a simple form. It has an unbound combo box. I use the selection in the combo box and the after update event to filter my database records, by business. When the form first loads it sets a default value and set focus to that combo control. I want to be able to just press 'enter'...

Help! I have some code which runs in the after update of an unbound text box. The user enters a number of questions required which is compared to the total number on the record set, also from a unbound combo on the form. The code works (kind of) but for some reason the 'IF' part isn't working...

Hi, I have a fairly basic database of exam questions I have put together. I have a form bound to a query with all questions. On that form I have a text box for the user to enter the number of questions they want. I generate the exam paper based on a combo selection, some options and...

Hi, I have been using this code to close all open forms when loading another form. I launch it form a command button and it keeps things tidy. However, now I would like to exclude one form - I want to keep one form open, but hidden, no matter what. How do I write that into the code? 'This...

Hi, Can anyone tell me if it is possible to force a memo field (rich text format) to use a specific font and font size by code? I'd like to ensure that whatever text goes in either by typing but crucially by edit - paste, goes in in the same format. It would help me out a lot. I'm using...

Hi, I am trying to add a new interim 'startup screen' on my DB. This new form is unbound and has a combo box on it, the record source of which is 'BusinessName'. In my database I have two main user forms that are used frmEmployeeDetails' and 'frmJSA'. I would like the DB to filter all of...

Hi, I'm after another short lesson again from somebody please. I'm trying to improve performance and as such have been 'retro-fitting' the phrase 'option explicit' to my code. I also enabled the option in tools. Only one form has caused a problem and this is the offending code: Private Sub...

Hi, I have an unbound text box which I am trying to get to return a value based on other text boxes. This is my expression: =IIf([F3]<=4,10,IIf([F3]>=15,30,IIf([F3]=Null,0,20))) [F3] is the field. Problem is I cannot get it to retun "10" if the F3 has no value. F3 may not have a vlue...

Hi, I have a form with a subform. On the subform I have a combo. In the not in list of that combo I trigger a second form as popup dialog to enter a new combo option, along with some linked fields. When the user clicks the 'close' command button it closes that form and returns them to the...

Hi, I woudl like to apply an input mask to a field to ensure the following: - All caps - Max 15 text characters - Max 4 numnerical characters at the end NO symbols, as this reference ultimately beomes part of a PDF filename. Caps is easy, > and I can sort of get what I want with the text...

Hi, Woudl anyone be able to point in the right direction please. Is there an easy way to automate information copying from one database into another database (both with the same structure) using Access or do I need an import tool? I have developed a database but I'm starting to requests for...

Hi, I have created a command button to open a report of a sepcific record, save/export as PDF and then close the report. This forum and Google were a huge help, once again. I'm stuck with the last part though. I would like to name the exported file using a unique reference in one of my form...

Hi, I have been (and continue to) trawl Google and the interweb, trying to seek out a nicely proportioned bmp file I can use on a command button for a 'Save as PDF' button on a form. So far none have fitted quite as nicely as the standard button dimension provided by Microsoft. Does anybody...

Hi, Wodul anyone be able to tell me how to force a user to select one combo before another, posssibly with a message telling them to do so. I want them to have to select the first combo in a cascade rather than another with an unfiltered list. Thanks, Fraser

I am trying to get a text box to be enabled or disabled according to one of five values in a combo box. Here's my code in the after update event of the combo box: Private Sub cboJD_lift_freq_AfterUpdate() If Me.cboJD_lift_freq.Value = "N/A" Or Me.cboJD_lift_freq.Value = "N" Then...

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...

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...

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...

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...

Hi, I'm trying to keep my database clutter free for the user and thought that it would be good to try and have forms close when the user clicks 'home' and jumps back to the main menu/switchboard. I have tried this with a macro but I can only seem to be able to set it to close one form and...