Search results for query: *

I'm not able to adequately search for previous posts with this because I'm not sure how to wordsmith the question. This will totally seem like a n00b ? too. TIA... I have a simple table with an index field, two fields that when combined make a reference number and a numeric field that...

I've been scoping out code from previous posts. I'm checking for a duplicate entry on the BeforeUpdate event of a subform. We want to make sure that a payment on a claim hasn't already been made. We're trying to do this by checking for entries in the tblBillAuditDetail table that have a matching...

I have a table reporting on Bureaus. There are some records where the Bureau column is NULL. I've put the following formula in the column heading on the crosstab. The results show the Bureaus as needed, but where the null values are all I get is a blank cell. Is there something wrong with my...

----this is cross-posted to the CR Data Access forum also--- If I have a SQL stored procedure providing data for a CR 9 report are the parameters in the stored procedure available for the report? The stored procedure calculates a date range. Let's say @StartDate and @EndDate. Then it...

If I have a SQL stored procedure providing data for a CR 9 report are the parameters in the stored procedure available for the report? The stored procedure calculates a date range. Let's say @StartDate and @EndDate. Then it retrieves records for the date range. It puts @StartDate and @EndDate...

Hello, long time no talk to. Y'all have helped me out so much in the past that I haven't had any problems lately...well, til this one. This SQL programming was written by someone else. I have the ability to change it - I just don't know what to do with it. This piece of a stored procedure has...

This is making me nuts. SELECT SUM(r.entry_amt)+SUM(r.entry_amt*.035) AS AMOUNT I can select SUM(r.entry_amt) and get the right result. I can select SUM(r.entry_amt*.035) and get the right result but I can't add them as in the statement above. What gives?!? Penelope

I have an Excel Template that exports data to an mdb. Even though I have the DoCmd.GoToRecord, acDataForm, "frmLPO", acLast in my Form_Open event, the form opens to the last saved record, not the record the Excel template just put in the table. Here is my Excel module: Sub mcrOpenAccess()...

All I need to do is pull the following from each file on another server BEGIN { print "Section 235" >"sec_235.txt"} /SECTION 235/ , /S570/ { print $0 >>"sec_235.txt" } I'm trying to use a batch file using this syntax: awk -f SEC235.awk "\\telecom\ROPS-DATA\ROP Archive 2005\Recent...

I have a button on an Excel template that pushes the worksheet data into a record in Access. Access then creates an "order number" for the record and I need that order number pushed BACK into the Excel file that's open so the staff can print, save and close the excel spreadsheet and be done...

TIA for this, I know someone out there will be able to help. I'm building a db to keep track of purchase requests. We have everyone using an Excel template to create a spreadsheet with their request. Currently, the storeroom enters this by hand into Access97. I'm trying to build a routine that...

This is driving me nuts. I've tried everything I can think of. My controls do not have the same name as the data...Please help. If the subform data is empty, I need to sum the report totals. =(IIf([Reports]![rptCostTotal]![qryInvoiceTotal...