Search results for query: *

I'm looking to create a table that fills in with data from other tables however I have to fill the first field with an incrementing value. I have posted my current statement below that does not work. It seems to put in different numbers in each field instead of 1-30. INSERT into...

It does work with 'program' = curprog and thank you for the help Olaf.

Actually Danfreemen that worked out perfect. I understand that I need to get away from using the filter command and that is what I'm doing one section at a time thanks to your help. I was using the filter command in 4 spots and now I'm down to 1. My final and last set filter is below. What...

My kettle is the second kettle you talked about. What I'm attempting to do is filter out a bunch of records while every record will be different in one way shape or form there is still this one field called TC_ID that can duplicate. There may be 2000 records once filtered however there are only...

danfreeman thanks for that. Is there a way to count unique records based on a particular field within that record by chance?

Thanks for all the help everybody. I ended up going a different direction to get the same results. IF INLIST(curservcat, "00015", "00016", "00017", "00018", "00019", "00043", "00044", "00047", "00048") = .F. then USE ai_enc SET FILTER TO 'program' = curprog .and. serv_cat = curservcat .AND...

This is the sql I'm trying to replicate Olaf. I'm trying to start off small with the one If statement and then once I have that working replicate to the others that I have. declare @curid int, @maxid int, @curprog varchar(5), @curservcat varchar(5), @curconno varchar(10), @cur1yrstartdt...

I'm very new to foxpro so please be kind. What I'm attempting to do is select a group of records and count on a particular field within those records. Then update a particular field on a particular record within a table. All of this sits inside of a do while loop with a counter to go through...

It does help a little Mike, but I'm still a bit unclear on a few things. the table I'm using does exist and is called era_proj_actuals within my foxpro database. You say to put in curid = 123 (put in an actual id here) Select era_proj_actuals locate for curid curprog = prog_id curservcat =...

I'm trying to duplicate some code I currently run in sql into foxpro. I currently declare some variables in sql and within a select statement set those variables to a value. example: select @curprog = prog_id,@curservcat = serv_cat, @curconno = [5yr_conno], @cur1yrstartdt = [1yr_startdt]...

I currently have a crosstab report in crystal 11 that has a grouping along the top by month. Within crystal it works great without any issues and it groups perfectly. However when I try and view the same report in the viewer for my vb.net application it can not perform the grouping at all...

I'm looking at being able to write a vbs login script that will first check to see if certain drives have been mapped if they have not then map them. Once that has been done check to see if certain shortcuts are currently on the desktop for the user that is logged in. If they are not I want it...

PHV, The AbsolutePosition seems to work however the recordcount is something I have already tried and it doesn't work (I did try it again per your advice). Because I'm in form view it just gives a value of 1 because that is all that is being displayed at the time. It does work in datasheet...

PHV, I'm not sure what the AbolutePosition is. Is it supposed to be listed under me.forms. ? If so I don't have that particular reference libray installed. If you wouldn't mind putting in the actual code to set lets say variable X = the total records in the form and how to set Y = the...

I'm attempting to access the record navigation buttons that normally sit at the bottom of a form. Specificly the current record and the total number of records that a give form has open. I'm not sure if there is a reference library that I need to install or some other command that I'm just...

I have actually figured a way around it already. Yes I have the multiple columns selected to save on room and that was the problem. I didn't want to get rid of it or the report for just one group would have grown from 11 pages to 55 pages with a lot of blank empty spake. The can grow probably...

I currently came up with a report that due to its massive amount of data decided to use the option to have multiple colums in the details section. This part worked great however it also shrinks all your headers down to the same size. This wouldn't be a problem if the information in the details...

If your getting your data from a table like this. Field1 Field2 Field3 a 1 3 a 3 6 b 23 43 c 3 4 c 7 s c 8 2 Then what I would do is set the second list boxes control source...

I currently designed a new data base in access that has a crystal reports activeX control on it. It runs fine on my computer and for my boss. However any time anybody else goes to run it they get the following error. "Your report viewer database or project contains a missing or broken...

Thanks LB, That will help to reduce how much I will have to type by a lot. I didn't know about being able to export the pick list into a text file and import it into any other one that I wanted. As far as your warning about certain things being used in formula fields and such I have already...