Search results

I have a main form (frmClients) with a button called 'application'. When you push this button it opens a full screen pop-up with various buttons; one of which is 'print application'. When you press this button it saves the record (DoCmd.RunCommand acCmdSaveRecord). However, there is also...

Hi, Right now I have the following code in a module (which is called through the on_click event procedure of a button on a form): strPdfFile = "p:\tpg\forms\generic.pdf" 'Existing PDF form file strFdfFile = "p:\tpg\forms\" & strCompany & "App.fdf" 'FDF file to create [some code ommited...

Hi All, If someone could give me a hand with this SQL problem, I'd be most appreciative. The following code works, but it gives me totals for the company instead of the total per club name (cName) which is what I want. I need to know how to make it do totals by club name. Any ideas...

I have a form with 5 fields. No one field is unique, however, the combination of all 5 fields should never be listed twice. I want to have some error checking on the form so that when someone presses the 'Add Record' button it looks through the table and makes sure there is no record where A...

Hi, I have a form with a bunch of cells. These cells are currently unbound. I need them to be linked to a table through a querystring though... What I want to happen, is for each cell to have some sort of query string that looks through the main table (Tickets) and performs a query based on...

Is there a way to have a vertical scrollbar on a pop-up form? Right now it seems that I lose the bar when I change the form to a pop-up. -Ryan.

How do I set up a form so that there is some type of forced field checking wherein the user can't tab to field b until field a is completed? [This message has been edited by Little_Man22 (edited 03-09-2002).]

I need to use the value that is retrieved from one query in another query. Here's the first query: query1 = "SELECT * FROM AllBands WHERE RateInfoID=2 AND Plan="&Form_Plan&" AND MinAmount <= "&Form_Amount&" AND MaxAmount > "&Form_Amount&"" query2 = "SELECT Rate FROM Can_Life WHERE...

I'm trying to requery a subform and keep getting the message "you must save current field before running the requery action". This is happening because before I requery the subform I'm passing a value onto it within a field called "STATUS". How can I get around this error (i.e. get the field...

Hi...I have a main form (frmClients) that contains a few pages, one of them being a list of all of the client's policies (an embedded subform called frmpolicies). When a policy is converted I have code written that will add a new policy to the list whose status is set to 'new'. However, how...

This could get tricky... I have a main form (frmclients) which contains all of a clients info. Within this form there are various pages, one of which contains all of the clients insurance policies. This page is simply a subform (frmpolicy) inserted into the main form. You can navigate the...

I'm having trouble passing a couple of values because I think that they have zero-length strings. How can I change it so that if the value of the field of income = " " then set this value = to Null? Ryan.

I'm trying to copy a value from one field to another. It works through code like the following in the onload procedure of the second form: Me!Income = Forms!frmClients!Income I've got it to work, however, if the value is null I get the message 'Data type conversion error'. This only happens...

Right now I have it so that the following is in the afterupdate event procedure of the canadian status field: If canadian status = "other" Then Me.OtherStatus.Visible = True Else Me.OtherStatus.Visible = False End If This works great when you update the field and actually select 'other' from...

How can I send the value of field 'x' from a pop-up form to a field on the form underneath that is of the same name? In other words I need code in the afterupdate event prodecure of field 'x' that says something like: Copy value of Me!x to forms!frmclients!applicationdata!x However, my...

Hi, I have a pop-up form and call field values from another form using statements like the following under the default value of the field where I want the data to go: Forms!frmClients!Agent1! This works great, however, if there is nothing in the origional field then it plugs a '0' into the...

Hi, I'm curious as to whether you can have a textbox on a form that is still visible yet 'greyed-in' and only becomes completely visible if something happens (i.e. the user selects a certain value from a combobox). I know that you can do this with command buttons but haven't figured out a way...

Hi, We have a database that we use to store client information. Occasionally we have to run applications for these clients that make use of the data in our tables. One table in particular (application data) is where the application data is saved. Currenlty we re-enter a clients application...

Does anyone know how to cut and paste between tabs so that when you paste the data, fields, labels, etc. don't show up accross all of the tabs? In other words, I want to paste something on a tab without it showing up on the rest of the tabs...any ideas?

Hi, I have 2 questions with regard to a pop-up from that I have: a) How can I adjust the width of the form when it pops-up? It's popping up at a width that is too large for my purposes and I need to change this setting somehow. b) When the form pops-up the fields are still filled in from the...