Search results

Thanks for the link mate but it is trying to get me to provide my credit card info for a "so called" 30 day free trial..... Do you have the actual answer?

Hi guys, I'm a newbie and have been having a great time building and customising a database application and would like to do the following. I am using Access 2007. I have an application that keeps track of automotive parts and accessories. I have a table called "PARTS" that contains...

Hi Smig Firstly, thanks for taking the time to do this. I'm confused as I don't understand what you are telling me to do when you say "Don't change anything in the form nor any other piece of code".......and "what you really need to look into is the UpdateSearchAsYouTypeList sub" Regards Greg

Hi Smig Thanks for doing that for me but I'm having problems understanding how it all works and how to retrofit it to my existing code. I have the following query attached to a Combox Box called "PartID": SELECT DISTINCTROW Parts.*, Parts.Web_Category, Parts.PartDescription, Parts.UnitPrice...

Hi guys, Smig, you're a legend! I look forward to hearing from you soon.. Thanks again guys for all of your help....I can feel that we are nearly there! Regards Greg

Thanks guys How do I take what is typed by the user in the Combo Box and insert it into a "like" statement that I have added to the SQL Query that is attached to the Combo Box? I have added the following Like statement to the PartName field and it manually run the query and it works perfectly...

Thanks again for the reply. Can you please be more specific (I'm a newbie :) )

Thanks for the reply. I'm already aware of what the limitations are. I need a solution to the problem I outlined. There must be a way to do this.

Hi guys Firstly, let me say that I have spent the last 3 hours searching this forum and Googling regarding "Search as you type" Combo Box functionality and it's giving me a headache! I am using Access 2007 and have a form that has a Combo Box that links to a Parts table (it has 10 fields) that...

Hi Plog, I was trying to use the Link Table Manager as I though that that was the most logical thing to use but it appears that I was wrong. I fugured out to use the "External Data" tab and link to the backend database and then select the Web_Parts table...all done mate. Thanks again. Regards Greg

Absolutely frigging wonderful!!! It works! Thanks Plog, I really appreciate this. All I need to do now is tidy it all up and add it to a Button on a form and I'm good to go! Oh, on a side note, the application is split (FE and BE) and when I created the Web_Parts table in the BE, the FE...

Hi Plog I just tried what you suggested and managed to get the first part working ie: displaying the correct new records that will be appended! So far so good. Have a look at the attached screen shots append001, 002,003. When I changed the query from Select to Append by clicking the Append...

Update: I now have the Update function working. It checks to see if the "Web_Product_Id" are the same between the Parts and Web_Parts tables and if so, it updates the records in the Parts table with the fields content from the matching record in the Web_Parts table. Now I'm pulling my hair...

Hi Plog, Sorry for the confusion. I'll try to explain it better. Some time ago I developed a desktop Access 2007 application based upon a a Microsoft Access Template (her is the link to the original template that I have modified)...

Hi Plog Thanks for that. It looks as though the Union function enables me to keep the data separate and simply concatenates the tables together which is good idea. I still have the issue of "updating" the Web_Parts table with new or modify data. Would I need to create an "Update" query to do...

Hi Reese I decided to create another Combo Box using the Wizard to see if if it allowed me to order the columns the way I wanted and it did! Problem solved.... Thanks for your help with this. Regards Greg

Hi Plog Because, the "Parts" table may have additional records added to it manually that I do not want to override and the PartId (Key) field needs to remain the same for data integrity as these records are reference by other tables.

Hi Guys I have an Access 2007 application that has a Parts Table that contains a list of automotive parts. I have attached a screen shot (parts.jpg) showing the structure. I have another table called Web_Parts that has exactly the same structure as Parts. The Web_Parts table gets its data...

Ok here is the update! I wasn't going to let this thing get the better of me so I have searched back in the dark recesses of my brain as I seemed to remember that I had a similar issue sometime ago and that in order to "see" the subreports correctly on the the main report, I needed to first...

Hi again Spikepl, I have absolutely no idea what the slider thing is...I think it is the link to the subreport? Regarding what I am doing? I am moving existing fields around on the form that was originally in Portrait mode and now I want the report to be in landscape mode as I have more data...