Search results for query: *

I have a Mainform and Subform. The subform is driven by 2 combo boxes that filter records in subform. If I right clik in the subform and "filter for" a value then try to use the combo boxes to filter the combo's do not work. I have to use one filter method or the other. Is there a way to use...

I have a tblA.Id, tblA.Tot and I want to insert records into tblB without using a FOR or WHILE and fetch. Can this be done? The number of inserted records for each Id should equal the tblA.Tot. For example. tblA Id Tot 1 2 2 3 tblB Id 1 1 2 2 2 Thanks, vmon

How do I select records using a passed parameter that may have a valid value or be null. If it is null then I want to select all records. This is what I tried without sucess. Thanks, vmon SELECT * FROM tblItem WHERE tblItem.LocId = ISNULL(@cboLocId, %)

Can I run an adp or ade with Access Runtime? There seems to be some confusion on this. What are my options? vmon

I am using Access 2002 in an ADP. I have a subtotaled column in a datasheet that is displayed on the mainform. If I filter subform using combo boxes on mainform the sutotal updates correctly. When I right click and filter by selection the subtotal is not being updated. What am I doing wrong...

I have a sum calculated on a main form that is set from a text box in the footer of a subform. I have trained people using forms to use the right click and filter by selection for narrowing records in a datasheet. Problem is the calcualated value on main form is not being updated with the sum...

I want to search a combo box list of values for a specific value. Something like: For I = 1 to X cboMarkId(I) = "YOU FOUND IT". Next I I can't find the right syntax to get this done. Thanks, vmon

I get ODBC -- Call Failed. [Microsoft][ODBC Visual FoxPro Driver] Error Reading File. (#104). The linked table connections work for a while and then just stop with the message above. Help, vmon

I am creating a text file (csv) and writing text to the file. Is there a way to export text without having my data enclosed in double quotes? Here is what I am trying. Open "c:\john.txt" For Output As #1 Write #1, Trim(rstExport.Fields("RecTyp"), _...

I use the following code to load a combo box, which is a column on a subform datasheet, with the reports in my DB. It works great but I want to limit the values in the combo box to reports that have not been used as a report name for records already in the subform. Any ideas on how I might do...

I need some direction on how to set this SQL up. I have a temporary table for a report. The table has three columns and for example two records, there will actually a lot more. I want to insert a new record with a calculated difference between the amount the two records for a specific...

I want to update a flag on all records in a table based on the MAX(DateCalc). Seems like I have something wrong. I am not sure if I should be using the WHERE EXISTS. Key to table is ID and DateCalc. Some guidance would be appreciated. Thanks, vmon UPDATE tblDos_History SET...

I have three tables A, B, and C. Columns are Key1, Key1+Key2, and Key2 respectively. I want all C records that are not in B for A.Key1 = 'X' only. I am somewhat close but no cigar yet. Here is what I have so far. SELECT C.Key2 FROM C LEFT OUTER JOIN B ON C.Key2 = B.Key2 WHERE (NOT EXISTS...

I am trying to load a list box using a parameterized stored procedure with no luck at all. The procedure runs fine but rows are not loaded into list box. My statement looks like this. Forms!frmEmailMaint!lstReports.RowSource = "EXEC procEmailMaintReportListBox '" & (Me.ID_Group) &...

How would I do something like this in a T-SQL statement? I have only done a little SQL and it was in Access. I want to update a column in a temporary table called BegBalance to AmountSent if PreviousCollected is Null otherwise calcualte it as [Amount_Sent]-[PreviousCollected]-[PreviousAdjusted]...

Just starting to use ADO and I cannot find a way to delete * from tblName. I used to use Docmd.RunSql strSql How is this done with ADO. thanks, vmon

I want to hide columns in a subform datasheet based on a checkbox on the main form. The visible property does not work with datasheets. Can I do this with vba? I found the runcommand hidecolumn but don't know how to make it work. Thanks, vmon

I need to get data from a Paradox database. I linked to the tables I want and can read the data fine in all but two tables. The two problem tables popup "Record is deleted" when I try to access the data in them. No matter how I try to access the data (table, query, sql) I don't do...

I am looking for DDF files to support an ODBC connection to Macola 6.2 I have Pervasive V8 and was told that with a DSN and DDF files I could get information into MS Access from a btrieve database. A single user is on $25. Also if you have any comments on this approach I would like to hear...

I have been tossed into an environment that is using Macola 6.2 and I have never worked with it or btrieve. Can someone tell me how to get customer order data into an MS Access 2000 database for reporting purposes? I would like to link to the data directly if possible using an ODBC driver...