Search results

Hi, On my form I have an option group with 4 radio buttons. Depending on the button selected certain fields become visible. This works all fine. Problem is though that I don't know how to store the selected value. At the moment, every time you open the form you have to select the same button...

Hi all, I'm building a db to catalogue my prints collection. I'd like to group them in categories. With the examples I found on this site I've been able to include cascading comboboxes in a form and they cascade beautifully (3 categories: maincategory, Subcat1 and Subcat2). Problem is though, I...

Hi All, I'm working on a crosstable qry that should compare records of various companies in a variable (but defined) period The form has 2 text fields to define the period (txtdate1 and textdate2). That works fine. I can also combine the period criteria with a company criteria by manually...

Hi, I have a form with a button that I'd like to be visible or not depending on the text in a field on that form. I only want the button to be visible when the field txtwhere on the form reads EP. This doesn't work: If me.txtwhere.txt = ep then me.btnShow.visible = true else...

Hi all, I have a report that generates 3 different charts of the same data on 3 different pages. It may seem a bit much but some of the users prefer one type over the other and I'm trying to please them all :) I'm not happy with it though, hate the fact that all 3 pages are always printed...

Hi all, I'm trying to include some graphs into my forms and reports and came across this problem. When I'm selecting a certain period to view data I use the following criteria for forms: WHERE (((Year([PriorityDate])) Between [forms]![frmFormsAndReports_Period]![txtdate1] And...

G'Day all, I'm having trouble with a query (or maybe with the SQL) that refuses to accept names that have an ' in them like e.g. M'R or van 't XX If I look at the qry results the names with the ' are found. However, I have a button on the form that opens a subsequent form linked by the sirname...

I have a form with two subforms. Each of the subforms is based on a different query. After clicking the record selector in the subform a second form opens in which I can add data for that record. This works fine but is not ideal as the ‘new record’ selector (the one with the *) is not always...

Hi All, I'm using Stephan Lebans' nifty code for automatically resizing text fields to the size required to show (almost) all text in that field (CanGrow3, thanks Stephen!). In general this function works great. However, I sometimes have a problem with the last text line. Often the last...

I wonder if anybody could help me getting the sample code CD that comes (came) with Access 97 programming for windows for dummies book. The book is only for sale on the used market and I've been unlucky enough to buy with the sample CD missing. I'd really like to have that CD as I'm sure the...

I am having HUGE problems with achieving the following and I’m hoping someone is able to help me out here. I’ve spent weeks trying to getting this right and I just cannot work it out. Please bear with me as I’ll try to explain the situation. I have a PriorityDocument (PD) that branches out into...

Hi all, Are there particular advantages/disadvantages for the use of the various on current, on open, on load, on activate etc. events for a form? To me it seems as if there is not much difference between them but that's probably plain ignorance from my site, why else would the different...

Users of my DBs get view/edit privileges on forms based on their loginname. If fPrivileges("E") = True Then Me.AllowEdits = True Else Me.AllowEdits = False End If Works fine except that when somebody is not allowed to edit the form the comboboxes to quickly...

Hi, I'm trying to open a new record form from another form. This is the code I came up with that dosn't work DoCmd.OpenForm "frmSingleNoteOnPatent", acNormal, , , "PublicationID = " & Me.PublicationID DoCmd.GoToRecord , , acNewRec I get error message "type mismatch" I don't...

I’m trying to create a report from a cmdButton on a form with 2 subforms. The main form has the linking filed. Using the code below I get a pop-up that asks for a criteria value and has the wanted value (the IDnumber in the form) above the input field. If I manually enter that number I get the...

Hi all, Today I've made a few new forms in my DB that use a query as a source. Forms work fine except for one little (?) thing: I cannot create a new record on any of these forms!! I get the following error message: "You can't go to the specified record. You may be at the end of a record...

Hi, I'd like to get a msgbox when closing a form that gives me the option to either save or not save the record, but only if changes have been made to the record. I've got this so far but that doesn't work: If Me.Dirty Then MsgBox(StrMsg, vbQuestion + vbYesNo, "Save this Record") = vbYes...

Hi All, I have a problem with opening a secondary form from the main form. Tha main frm is called frmPatents and it’s based on a tabel. I need to open a secondary form (frmAllOfficialAction_Patents) by clicking a button (bAddOffAction). This secondary form is based on query...

Hi all, I've got a form with a subform (table). Subform has a field ApplicationNum. By clicking on that field a subsequent form opens with application details (frmApplication). The linking field is AppID. Works fine, no problem. However, a problem occurs when there is no application detail form...

Hi, I've struggling wity this issue for some time now. What I have is a form with key field SearchID (autonumber) and a button that opens a secondary form with notes attached to the record on the first form. The 2 forms are linked by the SearchID number. This works without a problem when the...