Search results

Thank you both for your replies! fuzzygeek's solution was exactly what I was hoping for (never occured to me to just type the link in there). Everything's working well! Thanks again! -Sean

Hello, I've got a split db and I need for the link between the two to be: \\server\name\myBEdb.mdb instead of: S:\name\myBEdb.mdb The server name will not change - so I don't need anything dynamic. Will this need to be done via VBA and, if so, could someone point me in the right direction...

I only meant in your code because in the Project Explorer window it adds the prefix "Form_" even though you may have named your form without it (almost as if it has its own name for your forms) - this is probably why RoyVidar was asking. I believe that's why the quotes around the form name are...

Can't be sure, but try this (removing "Form_"): If CurrentProject.AllForms("VestigingenForm").IsLoaded Then VestigingenForm.opvullen_postcode End If -Sean

Hey jayke, here ya go: If CurrentProject.AllForms("frmMyForm").IsLoaded Then -Sean

Well, I don't really get how it's working - but it's working!:D Thanks to you both! -Sean

Thanks guys - this just might work (leaving to go home now - but I'll try this in the morning). The list is always in order, so I'll only need to look for the first. Cheers! -Sean

Hello, I get a field (called "range") from another database (which I have no control over) that gives me a list of numbers delimited by a comma (ie. 1,4,11). I need to query on these now and I'm not quite sure how to proceed. I didn't think it would be so bad because it's a list, but I just...

Hey Marsonk, Select "Query", "Make-Table Query". Afterwards, Access should prompt you wether or not you would like to replace the table. -Sean

Hey Mailman, I did try it this way: "tbl1 ==> tbl2 ==> tbl3" which did not fail but it didn't give me the null values I was seeking (i.e I would get nulls in records for which there were no people assigned to a certain group - but records for when nobody has been assigned to a certain group...

Solved! Well, I'm happy to say that I was able to solve it. SELECT t.GroupID, t.GroupName, t.LevelID, t.LevelDescription, r.PersonID FROM (SELECT GroupID, GroupName, LevelID, LevelDescription FROM tblLevel_LKP, tblGroups_LKP) AS t LEFT JOIN tblRecords AS r ON (t.GroupID=r.GroupID) AND...

Thank you for answering namliam, Unfortunately I have not been able to get it to work (I may have misunderstood your instructions...?). If I add the other join it won't work because I'll get the "ambiguous outer join..." error. I also tried creating a new query (subquery) and adding the join...

Outer join help please! - SOLVED Hello, here's the db structure on which I need to query (I didn't bother writing out the Person table): tblGroups --------- GroupID GroupName tblLevel -------- LevelID LevelDescription tblRecords ---------- PersonID GroupID LevelID By doing an outer join...

Thanks for the reply Vince! The steps you described are what I have been trying over and over again. Only the Managers and Administrators groups seem to be able to read it. After setting the read permission to the Employees group (and failing), I even tried setting read permission to a...

Hello, I have security set up for my application with users assigned to groups (Admins, Employee, Manager, Users). Everything was working well until I needed to add a lookup table. Only Admins and Managers can read from this table now, so my form won't load! I noticed that under "New...

Very nice Hayley - didn't even occur to me to search for something 3rd party! Let us know how it works for you gnc2004. -Sean

Hey gnc2004, my understanding is that you can't because you can only export as an rtf. The common suggestion is to create a pdf or snapshot if your users don't really need to have it in Word - if they do, then you have to make a tradeoff decision. Sorry! It might be do-able in 2003 though -...

Hey Steve, I know that there is a setting "Prompt for Adobe PDF filename" - but I imagine that this setting is set by individual pc, so what you're asking may be tricky if you're planning to do this for several users (but if it's just for you then you're set!). Printers and Faxes (or Control...

Check this out mixedguy: http://www.tek-tips.com/faqs.cfm?pid=703&fid=2533 Hope that helps! -Sean

Thanks everyone - it's now working great! -Sean