Recent content by Canderel

Hi... I have an Access query, which gives me the "orphans", between two tables. They look like this tblSurveys tblJobs * * Grade -> JobGrade Paytype -> JobPayType Survey -> JobSurvey other... -> other (including jobcode) Linked as indicated...

Hi... I've searched the forums and found one or two vba answers to these questions. But in the days of those posts Access 2003 hasn't been in use widely, and hopefully they've addressed that (easy) problem by now. I want if I have a textbox on my report that has the "can grow" property set...

Concatednated primary key. You just need to set your postcode AND company name together as the primary key. On design view, click the two rows (either by clicking and dragging (if they are next to each other), or by holding down Ctrl while clicking the second one), and then make them the...

Hi... I have a query that when I run it normally (just click on it) then it runs fine. (It is a union query, getting it's data from 8 other queries (who has their dependancies) But when I want to run a report from it, Access gives me an error saying "query is too complex". I am flattered, but...

I got it to work eventually. I often find that just typing down my problem gets me thinking of what exactly the problem is. The problem that I had was that my 'players' tab would show #Name? or similar when I looked at the form. Most of my editboxes had the #Name? error going. But they were...

Hi... I have a database, which seems very simple at first, but now when I want to create a UI that's easy and simple, it's not working properly. Background: There is going to be used at a games convention. There can be players, and Game Masters (GM's). Each player and GM is assigned to a team...

Yes! This is exactly what I wanted to know. Thanks a million! :cool:

Am I right if I assume that each of the Import Specification files that I've defined are inside the actual .mdb file? Now I'd like to, through the use of VBA, display the list of the current Import Specification files, and let the user choose which is the applicaple (or none) to the file he...

sub btnClick() dim stDocName stDocName = "Job" DoCmd.OpenForm stDocName, , , , acAdd, acDialog DoCmd.Requery Me the acAdd creates it at a new record. That's nice... The requery me doesn't work, and gives errors.

It should go to new record on the newly opened (modal) form. Currently it goes in the one I call it from. But at least I know the code now. :)

Hi... I searched quick, didn't find anythign, but you guys are so responsive... :D Question: Part 1. On TimeSheet form, I want to click to "create new job", and the Jobs Form opens, at a new record. Currently it opens at record 1. Part 2. I foresee that when I return from the modal job...

Problem with whole GUI's is that most of these DB's that I have to do is just quick'n'dirty tools to extract data from the bigger oracle DB where I have no rights and access to. And we have to hire an external company to design every little thing we want if we want anything. The problem is...

Sorry Ken, yes, it sprouted from another thread. But this was getting way off topic, so I decided to rather start a new thread. Your advice seem to run along the same veins. Basically, I had this great idea... and it seems that it's not quite the route Access was designed for. I'm going to...

I think I understand what you mean... At the moment I want(ed) to do it this way. Guy Clicks on Query I open form with parameters He selects the parameters Query continues You are suggesting... Guy opens form... he specifies the parameters... he clicks 'query' button. Query runs...

Some of it yes. (I just posted a question about that...) But some of it has a direct impact on the import process. Eventually we'd like to mail different reports to different people... but that's like phase 99. :) This should become automated, and that's the dream we're going at. -Canderel