Search results

that is what I have I was just wondering If it would be easier to learn in 2010 that seems to be the selling point in some of the things I read and heard.... either way I still have to learn LOL

LOL no so sure about that! thanks again for the link... What version of access do you use I keep reading how access and VBA is so much easier in 2010

ok I fixed it! file is being found now Thank you for the link

Yes please if you know a good tutorial! I don't know what happened now it says can't find file.... Boy oh boy is this frustrating.....

yes this code is from earlier in the post page 1, I have been reading on the basics and I am trying to learn and the person who wrote this code posted an explination for the code so I kind of understand this specific code and like I said i'm trying to learn the basics

can you define a variable as a quantity?

ok when I try to compile the code the following line gets highlighted Function GetRate(lngProdID As Long, lngQty As Quantity) As Currency

Yes i believe so I got the DAO reference added. and I compared it to the list on the website you gave me and made sure that they were the same Here is what is checked I attached a image of it in a word doc but I had to zip it to get the size right. It won't let me it just makes the dinging...

ok so now when I try to compile I'm still getting the following message "User-defined type not defined" now in the help it says "You can create your own data types in Visual Basic, but they must be defined first in a Type...End Type statement or in a properly registered object library or type...

ok I figured got that library added but i'm still getting the same message "Name conflicts with existing module, project or object library"

when I try to add the library from the reference window. thanks I'll take a look

ok it says "Name conflicts with existing module, project or object library" There isn't a duplicate of this code anywhere

still working on it does anyone have any ideas?

update I'm now getting this error User-defined type not defined I have no idea what that means :confused: but i'm trying to figure it out anyone have any suggestions?

ok so i have been messing with this for days now and I keep getting a variety of error messages I'm thinking the name of something is wrong but i'm not sure here is the VBA code Function GetRate(lngProdID As Long, lngQty As Quantity) As Currency Dim strSQL As String Dim rst As...

I understand I just started feeling very unorganized and thought it better to start over and be more organized from the start.

yes the Delivery Docket does make the most sense from what i'm reading, and seems to be the most efficient and the easiest. So I need to make the table and it would resemble like the following tblDelDoc (PK) - DelDocPK OrderDetailsPK SKU DelQty Address split into additional field and...

I'm not sure what you mean by Delivery Docket... Is that another table or form. I see the underlying idea of spliting the order which is something I had thought of but had no idea how to approch.

I ran into an issue where I have regular customers that either split ship or have a feww different addresses they have their orders shipped to so i created tblAddresses to hold all addresses for each customerID so I could easily choose which address the order is being shipped to. I could keep...

so I should update tblOrderHeader to include the field ShippingAddressID and BillingAddressID which I would do through a query specifying which AddressType for each one correct? I thought about that and have been doing some reading to try to determine the best method I keep thinking a...