Search results

My SQL is beginner level, and company = all the Clubs I’ve written it another way, this may make it clearer. In this case I get all the results I want, but not in the format I want. The format I want is to have the club names on the left, with the each of the following as columns along the...

Ok, I kind of figured that was what was going on...I'm still without a solution though. Any ideas? Do I have to use a different recordsource on the second form or is there an easier way to get around this? -rjd.

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

Thanks pcs...worked perfectly. I have another question though. Right now I have a form that I can input information into and it also updates a 'table' on the same form with a bunch of fields that are updated with control sources similar to the following: =DCount("[Ticket]","Tickets","[Site] =...

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

That last code won't make the user enter the fields in any particular order though will it? I need something like Geoff suggested where the user CANNOT skip fields at all (whether it's using the mouse or tabbing). The other option is to write a function that checks all of the fields when the...

That's actually a really cool idea...I'll try it out Thanks.

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.

I want to have it though so that the user has to start in the first field and can't enter another field until that one is finished...how would I do something like that (i.e. what would there vb code look like and where would it go?)? -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).]

It won't work Alex...here's what I have codewise: <% Dim dbBand Dim rsBand Dim oneRec Dim Form_Amount Dim Form_Plan Dim Form_Sex Dim Form_Age Form_Amount = Request.Form("Amount") Form_Plan = Request.Form("Plan") Form_Sex = Request.Form("Sex") Form_Age = Request.Form("Age") Set dbBand =...

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

OK Rich I see what you are saying. How do you hide the data if it is equal to 0 though? Also, how can I set all of the 'empty' strings to 0? Ryan.

Pat: see post where jwindon and I were trying to figure out code...it's from 2 days ago in this forum.