Search results

Can't find a lot of info on this I have an example from MS but I can't work out what goes on. I have a tree view control listing items from a table. What I want is when someone moves the mouse over an item it displays additional information stored in the same table and some information from...

OK I've looked for this one and can't find any intelligent answers. 2 problems 1) Is it possible to create a web search facility from within an Access db? If so. How? 2) If this is possible, is it also possible to capture the web address of a found useful page and place a link to that site in...

I have a Public Function (call it MyFunction) that I need to call from a query but I keep getting 'Undefined Function in Expresion' :confused: Here is the relevent part of the SQL SELECT tblMember.String_Value, IsNumeric([tblMember]![String_Value]) AS Sort1...

I have a table (call it table ‘A’) Linked to another table ‘B’ I have a calculation query that runs on some other tables and produces calculated information on some 160 items. I want to add a lookup field to table ‘B’ that pulls the calculated information from one item in the above query. But...

Time to get my head round reports. I am building a db for the club my wife runs. As part of the db I have to account for inventory movement of bar stock and she would also like this to be able to produce the legal price list for display. No problem with a price list as such except for the fact...

I just picked this up on another forum and thought it may generate some interest. I've signed even though I'm not an American.----if they get this one through then we're all stuffed 'cause if its passed over there then it will go round the wourld eventually. :eek: Take a look Here

Accouonting in Access Dose anyone have an example of a simple accounting system in access I could look at? I'm getting bogged down in designing the table structure and reports. Much appreciated

I have a constantly expanding list looked up by a combo box. Is there anyway of getting the combo box to display the last item added to the list by default? Tried searching for this all day but can't find answer. Thanks

I have the following code trigered by an event on a form Dim CRLimit As String CRLimit = Me.CRLimit 'Get value for CRLimit If CRLimit <= Me.Total_VAT Then 'compare string to a value on form Forms!frmCompanies!AccountOnHold.Visible = True '...

I have a table of products. Some products are discountable, some are not. Discount levels are set for each customer account depending on how charitable I feel and the level of trade on each account. I would like to find a way of automating the application of discounts against product according...

Set paramiter from a displayed form I am running a parameter query to calculate the total of some values displayed on a sub form. The parameter used is the client ID for the main form in which the subform resides. Is there a way I can get Access to set the parameter based on the record...

I have a wierd problem I think the route of the problem is in the design of a lookup query but I am unsure. I have a tbl (Table1) that has a number of lookups to other tables. the lookup that appears to be causing the prob is a lookup to a tbl called "tbleHomeAddress" I split Table1 using the...

I have an order form that is poulated from a mixture of queries and user input. This form is used to collate the information necessary to colect a client from (a) and deliver them to (b) on a given day If they then want to return from (b) to (a) on a different day then a new job has to be...

Accouonting in Access Hi Having developed a db that my staf are pleased with I now need to develope this into somthing that helps me. I already have a way of working out what each client is charged for each job we do for them. And a way of entering payments they have made --- but only...

I would like to have a query, based on a table, displaying continuously, using the system date and displaying results based on 24hrs before & after the system date I'm sure, I think it must be posible but I don't know how. The reason for this is so that the user has a constant display of work...

I have tried puting an active X control into my system32 folder. I have tried regeristing it by 3 different methods ( including a third party manager that makes it "Fool Proof"!?) I have tried this with a number of different controls. It don't seem to mater what I do I can't find them in vb in...