Search results for query: *

I have a table with the names of suppliers listed in alphabetical order. I have several forms which use a combo box from the suppliers table which for some reason I have not set up at the start in alphabetical order.I made the mistake of selecting the ascending order on one of the forms and then...

I have a calculated control on my report.The next control multiplies the previous control by 20%. If the value of the first control is negative I want it to return Zero. Can someone show me how to do this? Thanks

I want to add drag and drop between two forms on my db. I thought I would run through Microsoft Knowledge-233274 using the sample db Northwind as practice. I have followed every step but when I come to try drag & drop on the example, I keep getting the message 'Object does not support this...

I have 3 tables Invoices,details & Clients. I have a query that gives me a list of dates, invoices & amounts spent during a given period. I want to have the query give me a list of the total amount spent by each client during this period. Each client has several invoices I could specify each...

I have three databases on my computer. The first is the main, the second uses linked tables to the first and the 3rd is independant of the other two. I was working on the first designing a report when the screen went blank. Now I can not access the 1st database because it opens on to a blank...

I have an invoice form that prints a invoice report that is based on a query.It works fine except that the report settings for page set up keep returning to default every so often. It does not do it every time and I do not alter or change anything in the query or the report just add invoices to...

I am making a query based on an invoice form that will give me the sum of individual products sold for a given period. On opening you are promted to give the name of the product you want info for, the problem is that I have to give the Product ID instead of the Product name, otherwise the query...

I have a form order details with three combo boxes; cbocategoryselect, cboproductselect and cboitemselect. I want to synchronize these so that product is dependant on the choice of category and item is dependant on the choice of product. The code I have is Private Sub...

I have an invoice report that lists invoices and their details between any given dates. It obtains its data from a query based on the invoice table. My problem is that three of the invoices are missing from the report even though they appear on the query and in the table. How can this be?

I have a caculated control on a sub form that converts my purchases from the currency I buy in to the currency I sell at.How can I alter the rate I convert at to allow for fluctuations in the exchange rate without altering data already entered? My calculation is ([unit...