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

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

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

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

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

First off I don't think my subject line helps with my question but here it goes. I have a few specific parameter fields that I tend to use in all my reports. Is there any way to copy them and use them over and over again instead of having to constantly type them out and make them again.

I'm attempting to pulls in a number of records through my query into a form. However I have certain predetermined values that I would like to show up a certain way. As an example every time bob shows up in a particular field it replaces it with robert. Is there a way to write in VB code into the...

Once again I call on the vast experience of all of you on techtips. Here is my issue. I have a query that pulls in a number of fields some of them being date fields that are formated down to a 2 digit number representing the month. exp. Format(needlx.date,"mm") AS Needlx_date, needlx.n_in...

Ok, first off what I'm attempting to do is to take my calendar control and have whatever is selected on it stored in a variable called enddate and then pass that to the query. I can't seem to get past the VB part of the code for this. I'm going to paste the code below. What should happen is when...