Search results for query: *

so the answer is, it's not possible. I was hoping for a better solution. I don't necessarily have control over the fields in the first query, so it sounds like I'd have to create a new query parse through it and change the names. Anybody know of a solution for this?

I have to write a query of queries to select aggregates from a query. the query may have spaces in the column names and qoq doesn't seem to like this. How can I do something like the following select sum(col with space) from qry1 using query of queries I've tried surrounding it in brackets...

I need to use coldfusion to dynamically build a cfm page. This requires the ability to output coldfusion tags without coldfusion evaluating them first. I've tried using the de function to accomplish this but can't seem to get it to work. Can anybody point me in the right direction? How can I...

MajP, your solution worked for me. I just passed vinta1.object and it worked like a charm. Thanks.

I have a form with an activeX control on it called VintaSoftTwain. I want to pass this control from an event on that form to a function so I can access its methods. My function is defined as follows: Function scan(vinta1 as VintaSoftTwain) When I pass the control it gives me a type mismatch...

amazing, thanks! It works like a charm.

I have one table called TableA with two fields for Partnumber and Serialnumber. I want to add another field called repairID and fill it as follows: In a second table called TableB, there is a repairID as the primary key and Partnumber and SerialNumber fields. these two fields, when paired...

Hi justjayne, for this project I ended up downloading a program called vintasoft twain, which is an activeX control that I put into my access form. With a little bit of coding I was able to almost fully automate the process of scanning. This program has an unlimited free trial that can be...

Ed, That object model looks handy, but doesn't do what I need. at the bottom it says "MODI automation provides powerful document management and OCR features; however, it does not automate the document scanning process itself or support image annotation." What I want to do is automate the...

I'd like to be able to automatically scan a document from an access form. I want to have a button that scans an image and saves it to a specific location automatically. I've been searching online for this and it seems that there are activex controls that can do this, but they all cost money...

CautionMP: Thanks, that little change made the difference. I started by just using statements like 1<= startPrice <=9.99 and that didn't work. So then I changed it to the code that I posted earlier and that didn't help but replacing & with 'And' seems to work. Thanks.

I am using some VBA in excel and I have a simple group of if/else if statements that isn't behaving properly. Here is my code: insertionFee = 0 If startPrice <= 0.99 Then insertionFee = 0.2 ElseIf startPrice >= 1 & startPrice <= 9.99 Then insertionFee = 0.35 ElseIf...

Thanks. Although in my particular situation it's not quite as simple as that, that's a great start. thanks.

Randy700: I tried it in current() but it only calls when you change the record. jebry: I tried it in datachange() but it looks like that is an event associated with pivot tables

I have code that I want to run every time a control on a form is updated. I'm looking for an easy way to do it where I can put it in one place rather than in the afterupdate methods of every control on the form. Is there one event that runs every time anything on a form is changed? My goal is...

OK, I fixed the problem. It was statusid instead of status.

I have the following lines of code and I get an error on the DCount line saying "You canceled the previous operation" Dim countRecords As Integer countRecords = DCount("[RepairID]", "[RepairData]", "[rcvddate]< #" & Date - 30 & "#") MsgBox countRecords I have tried different ways of writing...

A basic example would be this: maintenance table: repairID timestamp Status Rcvd Date Shpd Date 12 11/12/05 Repair 11/11/05 [blank] 12 11/14/05 Complete [blank] 11/14/05 ReplacedParts table: repairID timestamp removedPN installedPN 12...

They aren't linked directly. (By the way, by 'linked' I mean related, not linked like from different files) The tables don't have the same structure. Maintenance is pretty much a duplicate of repairdata to record changes to records in repairdata (when there is a change made to a record in...

5 lines would be blank for each record in the query because each record represents a line from either tableA or tableB, so if record 1 represents a record from tableA then the 5 fields in the query from tableB would be blank. my tableC, known as repairdata holds relationships to a replacedparts...