Search results

the best way for you to do this is to base the subform on a query and the query based on the criteria in the query based on the combo box. for more help on this see my attachment PS I have posted here and not emailed you because every one has a simalar problem and a right to receive help.

SeanDelere: Hi Sean, I am designing a books database for a second hand bookstore and it works very well (except for problems mentioned here). the sales form is based around Temp tables (the tables is always there but the data is moved when I am finished with it) and action queries that copy...

Hi all I am having a problem with my data base relationship. the problem is if I have a two records with the same ISBN but different customer than it will not accept it. (See Attachment). It would be understandable if both had same ISBN and customer number, but that is not how I want it set up...

I am trying to make it automated and not be a manual process. I am now thinking I may need to create a web bot or a spider or something. If any one can point me in the right direction I would greatly appreciate it. PS I have emailed them and they are yet to reply.

Hi all I was wondering if it is possible to import certain parts of a web page and enter it into a database. This is the web page i want to get info from http://isbndb.com/d/book/linux.html In the general layout. I want to be able to enter a ISBN and the database will query the website for...

Thanks DB7, it was the Miscellaneous_Count = DCount("Customer_ID", "qry_Sales_Miscellaneous_Current", "[Customer_ID] =" & Cust_ID) that worked. Tryed the one without comma etc, but that was same as before. I am still learning which explains my mistakes. Thanks again!!!

Hi all I am trying to count the number of records a query is showing using VB & Dcount but the problem is it will count the source table and not the query. (Yes I have put the right criteria in as the query shows the right records at the right time.) here is the code...

Hi all 1) Is there a way to remove or adjust the delay that the control tip text appears? (this is for when you hover your mouse over a button you get a tool tip) 2) Is it possible to insert a picture or have picture appear when the tooltip appears? 3) is it possible to use html or bold tags...

Have you tried to import the form and table etc that is needed and will it work then?

Access_Person: the coding looks similar to what the wizard creates for a combo box. I had a similar problem when I tried to re-name the combo box and the name in the coding and all references to it. I have not tried this yet but it is worth a try: in the database window click on "Tools" >...

20,000 records (this is for a second hand bookstore) The user is going to use it on a laptop in the shop so he can take it home and plug it in at home and backup on his home computer each night. ***Edit*** After talking with bookstore owner, He has abandoned the idea of using the Australia...

Hi ken Wish I knew SQL. And I was hoping no one was going to mention SQL. I am just using the standard grid in query design. But I do know little titbits of it. 1) Would I need to have a nested SQL query? 2) Would I need Union, Pass though, or Data Definition? I am not sure where to start...

Hi all I was wondering if there is a way to have a query to change criteria as user enters a values in multiple text boxes Example: user enters a title for book that they are looking for, then enters a surname in different text box. I want the query to add to the criteria of the search to...

Hi Rich I would be interested why I would have problems I have changed the coding to this(in dialog box): Sub cmdCancel_Click() DoCmd.Close acForm, "dlg_print_conferm", acSaveNo DoCmd.Close acForm, "frm_Nest_frm_Books_Descriptions_in_Store_DatasheetView_Popup", acSaveNo If Previous_Form =...

Couldn't work out the OpenArgs but then had the idea of using a if statement and have the doCmd.openform and variable in that. Thanks for helping pat, I got it working.

Hi all I am trying to open the same popup dialog box form from different forms for the same purpose(Print confirmation), and I don't want to copy the same form and use different copies for different forms. The way I would like to get around this is to use a global variable and set the variable...

Hi Ken I think I overlooked the obvious. thanks for the help.

Hi all I am having a problem with the coding recordsource. I can change the record source once but after that I can not. (it won't do anything, without even giving an error code) I have to resort to closing and re-loading the form again which is too slow. Here is one of my coding to change a...

Hey Mile I found a site thanks to google (and you) about SelStart property at http://www.applecore99.com/frm/frm046.asp Thanks for your help Mile:) :)

after you mentioned SelStart, I had a look in Microsoft help(which did not tell me much more then that it would be the one I would be using). How would I go about using this? Thanks Mile :) Scott