Recent content by Evenjelith

Hey, sorry it's taken me so long to reply. I havent been at work very much of late and i doubt i'll be in for the rest of the week but i wanted to let you know what was going on. Thanks to you and a few online tutorials i managed to rewrite my query into the vb code builder and using your...

Hey Tylar, I actually got the SQL out of the SQL view of my query which i built with Wizard. I'm not sure why ours look different then. Perhaps different versions of the software. Also yes i do have a number field but its not used to link the tables. The name of the well is the only constant...

Hey Tyler, that was really helpful but I'm having a problem. Firstly, if i set the name of the well specifically like you explained for debugging purposes e.g. 'Big Boy' then everything works perfectly. However, Access will not let me implement part of your code for referring to my textbox. I...

Hey, sorry I've been away for a few days. Thanks again for your help Tyler. In the end I decided it was a lot of hassel for very little gain to have the main form open with the most recently added entry. What I have implemented with your help is a great improvement on the original database...

Thanks for that spot Bob, I've made the change. Appreciate your help. :)

Hey, I have a form (SearchName) which is passed a name from a different form (MainForm) and then queries to find any matches. Any name that matches or uses the same initial characters (e.g. Nick, Nicholas, Nicole if Nic were passed) is displayed in a listbox who's rowsource is a query. I've...

Tyler you are just too good to me. Firstly, your fix for #1 works perfectly and I can now check if a duplicate well exists. There are two little things though that I'm still having trouble over. I'm having trouble getting the requery method to work though. As it stands nothing happens...

Hey thanks for getting back to me. Your answer to question 1 looks like exactly what I want but I’m getting an error at the moment on the Set namecheck line: Run-time error '3061': Too few parameters. Expected 1. I want to use your second option for question two as I don’t want to close the...

Thanks for your reply. I have no control over the names of the database unfortunately but i use brackets [Company Wells Database] to avoid any issues with spaces. To clarify (and also I’ve updated my above post with a new question), i have three problems: 1. I am not sure how to write the...

Great Help. One more question please. Hey thanks for that, it works great. There is a problem though. I have a primary form called Company Wells Database. You click the add well button on this form to take you to a second form entitled addWellName. This second form is where i perform the add...

Hi, my boss wants me to fix up the company database; adding a button which puts a new table entry provided by the user into the database. I have all the necessary forms I require but the problem is my VB code. I've pillaged some code from other threads on this site and tried to rework it for the...