Search results for query: *

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

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

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

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

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

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

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

I have two tables (tableA and tableB) which I need to pull data from. They are indirectly linked through a repairID field of a third table (both are linked to repairID of tableC). In my query I would like to have fields from both tables, so that if it pulls 5 fields from each table, there...

I have a UNION query grabbing information from two tables. Does anybody have any ideas on how to identify which rows came from which tables?

I am trying to refer to a report from some code attached to a form. I'm using the normal method of reports!reportname. My problem is that I want reportname to be a string variable holding the name of the report. When I do that it gives me a type mismatch error at runtime. Does anybody know...

I have a query being used for a report and it is not returning all the rows that I want it to. Here is the sql statement: SELECT repairdata.*, products.*, contract.*, customer.* FROM Products INNER JOIN (RepairData INNER JOIN (Customer INNER JOIN Contract ON Customer.OwnerName =...

I have a form with a button that, when pressed, opens another form with a filter based on the record from the first form. The problem is that the filter doesn't seem to be working. Instead of showing only certain records, it's showing all records. I have checked at various points to make sure...

I'm trying to secure my database using a workgroup. I'm a little new to this and I've been reading about it in a book "Inside Out: MS Access 2003". When I go through the whole process of making a workgroup and adding users and passwords, it applies these settings to all databases on the...

I am importing data from an access database into columns A through G. Then, columns H through U all have formulas that are based on the data in A through G, in the normal way where formulas in row X are based on data in row X. The problem is that when data is added to the database and the next...

I have vba code that runs when a form opens. It checks how many records are included in the form. If there is 0, then is does something specific. The problem is that the code isn't executing. There is the code: Private Sub Form_Open(Cancel As Integer) MsgBox Me.RecordsetClone.RecordCount If...

I have two tables, a repairdata table that has a field for statusID and a status table that has an autonumber statusID and a status. I'm trying to create a query that shows all entries from repairdata where the status isn't equal to "shpd" or "comp". The problem is that if I specify any...

I have a form with about 40 controls on it in the form of text boxes, combo boxes, and check boxes. In the afterupdate event of the form I want to identify which fields have been changed and write the new values of those fields to a table that keeps track of changes. I don't want to have to...

I have a form with about 40 controls on it in the form of text boxes, combo boxes, and check boxes. In the afterupdate event of the form I want to identify which fields have been changed and write the new values of those fields to a table that keeps track of changes. I don't want to have to...

I have a table storing productID, part#, description, and NSN. I have a second table with a field called productID that is linked to the first tables productID. In a form that stores data to the second table, I want to have two text boxes that display the description and NSN when the productID...