Search results for query: *

my bad, i meant VBA

I am doing this in VB, using the openreport cmd, i tried your formula above but it asked for a startdate, and even entering that it still returned all of the records

What I want is a report to return orders between certain dates, I can get the criteria to work if it is = to something, but as soon as I try to use > or < it doesn't work at all. I have TxtStartDate and TxtEndDate, I want the criteria to be something like this: TxtStartDate < Order_Date <...

For instance, I have a switchboard made for my reports, and users can select which reports they want to view. Furthermore, I want to make it so that when a user selects a start and end date, the report will only show orders or sales that fall within this range. How do I do this?

ahhh nevermind i think i've got it now, can't believe it was so simple, thx man

that works, but i can't get it to populate the unbound fields (if that's possible) or the bound fields in the subform

I am extremely knew to VB so I need a bit of a push in the right direction. I have an order form, and this order form has various customer information. What I want to do is in the header have a combo box for the order number, so that upon selecting the order the rest of the information will...

I've tried a number of things and sometimes the field gives me only one record, while sometimes it gives me a list of a tonne of others that aren't even supposed to show up, I've no idea what's goin on.

I set it as a datasheet. It does not show or say there is more than one record. I am linking it through the customer number, and I've checked the table, and there are multiple records for the same customer number

For instance, I made the subform so that upon entering a customer number that customer's address will show in the subform. The problem is sometimes customers use more than one address. However when I select a customer who has more than 1, the subform will only show one, how do i make it so that...

I want the values to be the same, not different. For instance I am using the field CustomerID as a primary key in one field (autonumber), what I tried doing is creating that field in another table to create a foreign key and enforce referential integrity. The problem is the values in the related...

I used to be able to do this (or at least I think I did). What I did was I added a field to a table. I named this table the same as the primary key in another table, and then enforced referential integrity. Everything works...but the problem is the new table does not have the values that exist...

For instance. There is a default selling price, but under circumstances a discount may be applied. So in a query I have set up an expression for this. However, I can't figure out how to link the query to the table so that the new discounted selling price will formulate everytime I enter a new...

I want to make a command button, but upon clicking it, it should perform an action (X, /, -, +, etc.) among two text boxes. How can I do this?