Search results

Thanks guy's! Mile-O-Phile, my deepest apologies! 9 times out of 10 i search the help then the forums before posting, guess i'm going to have to make it 10/10...

Does anyone know how I can reference the pathway of the database that i'm working in... The help mentions "object.path" but to use it the object has to be a reference to a file or folder etc. is it possible to get the full pathway without using this method? Thanks, Tom.

Thanks guys SforSoftware, i tried that and it didn't work (why though i've got no idea) Dgar007 that would work but I think it would actually open up the other Db whereas mine executes without the Db actually opening on screen. I got round it in the end by writing a function that called the sub...

Hi, I'm trying to run a sub called "Update_DB_Information" in a module in another database. The code refernces the DB fine (if I replaces the ###'s with a DoCmd it works) but I don't know how to call a sub this way. I've tried just putting the sub name, and putting the module name then sub name...

Thanks, thats great, i know it's wierd but it works!

Hi, i'm trying to write a module that creates a form to store notes about all the forms in a database. I need it so that i can import it into any database and it will work. So far it works but only stores the last form name that it finds because i haven't based the form i've created on a table...

So there's no way that I can convert a DB that i've written into something that doesn't need Access to run?

I'm using Access 2000 and don't know if i'm using ADO or DAO. I think i'm using ADO. How can I tell? And is it an important consideration if I want to create an app. I've been making DB's for a while now but have never tried to create a stand alone one before. I was hoping it wouldn't be too...

HI, i'm writing a DB which i'm going to turn into an app later on. It has a few fields which I want the user to be able define the first time he/she opens up the database. To keep all the queries and VB etc. working i'm not actually going to re-name the fields, just the labels of the fields on...

Ahh i didn't think of that. It must be in the sql view because the fields were there when the query ran. I re-built it again anyway only took a few mins. Thanks for your help mate, Tom.

Hi, In a query that i've designed, i have a number of hidden fields. Usually when i've done this before the hidden fields go to the rightmost columns when i save and close the query. With this particular one, some of the hidden fields are on the right and some are totally missing in design view...

Hi I have a Criteria based on an IF statement where the TRUE outcome requires a sub query to be run and the FALSE outcome requires there to be no criteria in the field. The statement i've got is below... IIf([Forms]![Search_Form_Titles]![Search_Form_Preferable_Skills]![NoOfSkills]>0,(SELECT...

I've probaly misled you with my field names... both the fields contain the same data (Skills) it's just that someone searching for a candidate will add the skills required to do a job to a continuous form (or datasheet- whatever). If I then try and pull candidates which match the skills out...

Hi, I'm trying to write an employment search engine which matches job descriptions to candidate skills. Vacancies and candidates each have multiple skills in fields [ESkill] and [Candidate_Skills] respectively. If I join the two fields in a query they match skills individually but i want to only...

Hi, i'm trying to reference a record on a subform because when i refresh the form it jumps back to record one. I'd like a bit of VB that refreshes then jumps back to the record number that it was before. I've tried a few combinations of the Recordset and RecordsetClone but the help around these...

Thanks mate, a small oversight on my part! I reckon 32,000 odd characters should do me.... :o) Tom.

Hi, I'm currently writing a db that i'm hoping to turn into an actual app later on. I have about 5 fields that I want the user to name when they first run the db. Firstly I have no idea how to do this (if it's possible) and secondly if i change the name's of the fields in the tables then all the...

Hi, is there any way that you can run more than 256 characters of SQL in VB? I read that using the DoCmd.RunSQL method this is the maximum number of characters you can use and it doesn't get you very far... Thanks, Tom

thank you, will take me ages but needs to be done!

Hi, I'm trying to make an MDE file from a database but I keep getting a message saying that Access can't create the file. I've password protected my VB, and don't think the DB qualifies for any of the restrictions outlined in the help file on MDE's but it still won't work. I thought it may be...