Search results

I have a database that has the basic tables of products, accounts and orders. I need to figure out how to deal with returns. Do I create a separate table and link that to the orders table for returns? I haven't made such a large database file so I was curious if anyone had any information...

I have created the tables and module following the instructions on microsoft's page. http://support.microsoft.com/kb/210064/en-us The Module is: Function OfficeClosed(TheDate) As Integer OfficeClosed = False TheDate = Format(TheDate, "dd/mm/yyyy") ' Test for Saturday or Sunday...

Just need some quick help in clearing up something.... I have a form with the follwing....... OrderDate default value =Date() InvoiceDate control source =[OrderDate]+2 DayoftheWeek control source =Weekday([InvoiceDate]) ActualDateofInvoice control source...

I am creating a database for a company that sells a product with a variety of options. They have all their previous orders in a works spreadsheet file. Each customer has their own file with every order for the past 15 years. There are probably about 1.5 million records. The company wants all...

I have a form that allows employees to enter the width and height for a product on a form. The width and height are then combined with the type and sizing to make a unique id. That unique id is then looked up in the table to get the price for that specific product. The product is blinds which...

I keep getting a "0" on a DLOOKUP and cannot figure out why..... =[OnGotFocus]=DLookUp("[Price]","Price1","[WidthxHeight_ID] = Form![WidthxHeight_ID]") This is the control source of a text box called PriceForm. The lookup goes out to the Price field in the Price1 table. WidthxHeight_ID is...

I have a question on my form: I have one text box that combines several items in an expression to make a specific ID. Then, I have a second text box that I want to take the ID from the first text box and lookup the price on a table. (I have a table with the IDs and the prices for each ID...

I have a form called "Add Product Details" in which there are areas where I have SQL statements that lookup a value based upon a previous box on the form. The SQL statements are [Forms]![formname]![boxname] For some reason on the Price...... I can add the formname to the SQL statement but each...