Search results

Hello Adam! I checked your DB and I found why it was giving you the error, the error was in the Sub ImagePath1_AfterUpdate() in this part of the code: showErrorMessage(errormsg) This function that you created doesn't accept any variable, so I just remove the (errormsg) from this line and...

Right click over you ComboBox--> Properties -->Events Tab--> After Update You should read a MS Access Tutorial for beginners if you can't find it. There are plenty of them all over the web. Have a nice day. Cheers!

Hello lscheer. How HiTechCoach suggested you can create a query that limits your data to the ones you want. You wrote that you want the Unmatched results to start with the last record in T2. So this query should look like this: SELECT * FROM T1 WHERE ((T1.ID)>(SELECT MAX(ID) FROM T2)); And...

Thanks Banana, for that interesting data model you brought to me. I gave it a brief look, but I will read it more carefully, if my girlfriend allows me to do so... lol. I stick with the XML Files for now, they work fine for me. But I will document myself on the model you wrote about. Thanks...

When I saw this post I thought in XML file structure as well, but I avoided to post cause I was not sure if it can be done other way than using recursive functions. I am working with XML files but using PHP, it should be the same just other language. I'm using the XML files to store information...

That's good. I'm glad that worked for you. Have a nice day. Cheers!

I like DCrake suggestion!, I have learned a new trick today. Next time I will give it a try. I think you should go for it Bill! Thanks all. Cheers!

I didn't see that khawar just posted before me!... I guess I won't need to see it. Cheers!

Hello Fozi! If you can't achieve this before I will take a look at the db you uploaded tomorrow. I have to go to sleep cause it's getting late. Cheers!

Go to Google and write: "macros in excel tutorial". That will gives about 153,000 Results. Follow a tutorial, that's how I started. Have a nice day. Cheers!

It's kind of hard for me to read that SQL also but if I understand well what you want to do, the SQL statement for your query should look like this: SELECT [2008_NSLSP_NF_P_RATES].NSLSP_id, [2008_NSLSP_NF_P_RATES].Postal_Sector, [2008_NSLSP_NF_P_RATES].Postal_Sector_Population...

That video is real funny, and a good satire as well. Jardi A.M.J.

Not real work but I'm doing something. I like what you studied (Molecular Biology), I don't know so much about it though! I also like Phytopalogy and Soil Science. I like so many things...lol

You can call any function from an event property. For example if you want a function called myCustFunction to run when the user clicks a command button, you type =myCustFuntion() as the setting of the On Click property in the Property window of that command button. Or you can call it by code...

It sounds interesting! I haven't done this kind of beauties in Access but I have an idea. I have built a Database in MySQL for a website where I keep track of different versions of the pages in the site by storing them in a table called MySite_Versions. So every time a user edit and save a page...

Hello Tessapitchford! (which a Nick Name hu!) I kind of understand what you are trying to do! but it's a bit hard for me to figure it out without a full picture of your data and your criteria. If you really can't post you db, could you at least post how the data looks like and the SQL statement...

I don't really understand what you are doing. What you are trying to do should be very easy. Can you post an example of your database with the form that filter your records its source and the report you want to show the records? I will take a look at it. Cheers!

Hello Pbaldy! I don't know so much about performance efficiency. And as always there is more than one solution to the same problem, I know how to build the query as you said, it just seemed easier for me to use a subquery. I will see where I can find information to read about efficiency. Thanks...

I have done this with a MySQL database, with another Ms Access database it should be just easier. Add to your database a table linked to the table in the external database that you want to update, and build and update query to update the records in the linked table just as you do with any other...

Hi again! Rabbie is right, I didn't pay so much attention to that, but yes! the Customer details shouldn't be stored in the Order table but in a separate table linking to the Order table by a unique ID (Primary key). And I'm not sure if the order you populate the tables matters but I would...