Search results for query: *

Hi; I cant beleive that I cant solve this one!!! I have an update query and its going to update several fields based on parameters. Its all good and working fine except one field. Its the ID field, I just want it to update this field by adding the letter "R" before the ID number. EX: if...

Hi; I cant beleive that I cant solve this one!!! I have an update query and its going to update several fields based on parameters. Its all good and working fine except one field. Its the ID field, I just want to update this field by adding the letter "R" before the ID number. EX: if the...

Hello everyone; I have an append query that appends all the requested records to a table for processing. Here is my question. I have a feild called[AccType]for checking or savings, when running the append query I would like the data in feild[AccType] appear as follow:if checking=P and if...

Hi everyone; I feel so embaress for the question I'm going to ask. Its been a really long time since I worked with access querys. I have a feild in my customer table called[SaleDate]mm/dd/yy, now I need to display that feild in a query as followed yyyymmdd. Someone told me I'd be better off...

Hope someone could help me with this! In my customertbl, I have 2 fields that i use to run my query.. [OrderDate] & [BillingDate]. First payment is due 14 days from[OrderDate]and this will automatically update[BillingDate]with Date().From there I bill a customer every 30 days from the...

I have a feild "Amount" in my Customer tbl; Now in the customer EditForm i have a buttom called BackCom for commisions; the buttom opens up another form with the "BackCom" feild for input and the value inserted in this feild will be calculated as folow...

I have a feild "Amount" in my Customer tbl; Now in the customer EditForm i have a buttom called BackCom for commisions; the buttom opens up another form with the "BackCom" feild for input and the value inserted in this feild will be calculated as folow...

I have a report that pulls out all sales for certain dates, my problem is: i have a field "amount",i need to count how many are at 299.99 and how many at 229.99 in 2 unbound-text box. =IIF([amount]="299.99",count([amount]) Thanks...

I made an ADO connection from vb6 to my database in access2000. The connection works but when i'm trying to search for a specific record,i get no results. So i changed the connection string to a sample database "NWIND.mdb" and every thing worked perfectlly.So whats the problem,the...

I'm trying to retreive specific recods from access to vb through a connection i made; the users select from 3 choices in comboBox ("Last Name" or "Phone#" or "Genie#")to populate the feilds. Here is my code, could somebody tell me whats wrong with it: On Error GoTo...

I linked access to vb, and every thing work good, but my problem is that in access i have querys for finding a customer either by phone# or last name or by contract#. Would sommebody please tell me if i should use an SQLquery in the data environment or simply use input boxs to find a customer...

I have a data base in a perfect performance on a network and i need to secure the data base on VB6 by linking them because i dont want users to be able to browse through my tables and querys, i want them only to use some forms. I tried to link the DBase to VB by using the VB data wisard, and all...