Search results for query: *

I have a sales entry form for a small art business using Access 2003. My sales entry form is set up with "sales" being the whole sale, and "transactions" being a subform with individual transactions. The sales table contains the customer information, subtotal, sales tax, total, tender...

I am working on an sales/inventory program. I need to be able to stop the user from deleting inventory items in the Master Inventory that have matching sales transactions. I have placed a delete button next to the item in my inventory lookup form. This is the code I tried, and it didn't work...

I just upgraded from Access 2002 to 2003. In the new version some of my code is not working properly. I have a line of code: varfirst = DLookup("AuthorFirstName", "authors", "author= " & Chr(34) & varauthor & Chr(34)) The Chr comes up with "Compile Error: Can't find project or library". Is...

There are a number of reports in my database that I have programmed to print directly to the printer. However, if I begin distributing this program, other users may need to be able select different printers on their system for some of these reports. Is there a way to set up an interface...

I have a form that I use to lookup products. I have a combo box and the following code: strManuf = "'" & Me![cmbManufacturer] & "'" FilterOpt = Me!optFilterOpt Select Case FilterOpt Case 1 Me.Filter = "[Manufacturer] like " & strManuf...

I am working on an invoicing program. Since I am with a school district, some invoices are taxable, and some are not. I'm scratching my head as to how I should set this up. Should I create a 'tax' field in the table that would add taxes for each item (only if it is taxable - I have a boolean...

I am populating my "Invoice event" table from my master "Accounts" table. Everything works great EXCEPT for the boolean field [Transfer]. Dlookup looks up the field, but will not set the form field to that value. This is my code. Should I do something different with the...

I sent a copy of my database to someone running Access 2000 on their computer. It was in mde format created with Access 97. They were not able to open the file. I sent them an mdb copy, and it opened fine. I am hoping to be sharing this database with others soon. Is this going to be a...

I am re-designing an invoicing database. Currently the invoice number is in a long-integer field (the information was appended from a table with auto-number). I want to move all the current records into a table where the invoice number is in an auto number field. However, I can't figure out...

I have an invoicing form. My customer information is in table "Billing Address", and the details are in table "Billing Estimator". In my form, I have the option of adding catering items from three different tables using a pop up form. My difficulty is in getting the ID...

I am coding the way I always have, and formatting my date the same, but suddenly, this date (which is keyed into the field Me![dtDelDate] on my form), is converted to 12/30/1899 when I execute the following code: Dim dtDelivDate As Date dtDelivDate = Me![dtDelDate] DoCmd.RunSQL "UPDATE...