Recent content by iddqd

Actually, I've been wondering how to get rid of these pesky things myself. They don't bother me THAT much, but they just take up space in my Datasheed View forms. Setting 'Visible' to False doesn't seem to do anything as far as the UI is concerned, I'll have tab control footers whether I want...

SELECT Class.ClassID, Teacher.TeacherID AS Expr1 FROM Class, Teacher INNER JOIN Class ON Teacher.TeacherID = Class.ClassID; I think this is what you're trying to do? You might have to experiment with this a little. Now, I'm confused. The TeacherID and ClassID you're trying to compare are in...

Well, it turns out it didn't want to write to the table because I defined a field named 'Name', which is a reserved name. Apparently. Renaming the field did the trick.

bump... still haven't found a solution to this. :(

Well, I've got a multiple stage form structure. Data tables, in case it matters. The two stages that we're interested in right now, let's call them Stage1 and Stage2. Anyway, Stage1 is controlled by a query (Query1) of a table (Table1). And Stage2 used the be the subtable of the Table1. It...

Well, I was thinking I could use a parameter query to do this. I thought someone did this already and has the SQL code. But I guess not :(

I... don't see that option in the wizard. :confused: Edit: Well, I found another solution to the problem - creating an empty copy of the tables, and setting up the relationship, then copy/pasting the records in and seeing which ones will return errors.

Well, I'm trying to enforce referential integrity on one of my relationships. But it seems that there are 5 records in the Subtable that don't have a corresponding record in Table, so it won't work. I tried copy/pasting from Subtable to Table, and it says 'unable to make changes because this...

Not sure where to post it, though what I have in mind is similar to a query. Basically, I want it to look like a web search engine. You know, you enter a search phrase, and it returns a list of results where it finds matches. So, just like that, I want it to search through a table and return...

ah, thanks, this works perfectly! I have more noob questions about form design now, I'll try to compile them into one thread instead of posting them separately like some sort of an impatient gorilla.

It seems to work perfectly, but doesn't actually enter the value in the table. Am I doing something wrong? This is what my form looks like: But the corresponding field in my table remains blank :( :

I've tried =CurrentUser() first and it doesn't work. (The theme I use is a WindowBlinds theme called Rivet Rebellion, and you can find it at www.wincustomize.org).

it works perfectly in a macro... WTF?? this is the error I've been getting for =Access.CurrentUser() or =Application.CurrentUser()

hmm, =Application.CurrentUser() gives me a syntax error (Access kidly tells me that MAYBE, just MAYBE I misplaced a comma, never mind that I don't have a single comma anywhere in there). I guess I'll try to get this to work in a macro first.

Btw, apparently the correct syntax for CurrentUser() is expression.CurrentUser() which doesn't make sense to me... because what object is CurrentUser() a method of??? :confused: