Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Jun 1, 2009 1:09 pm
73119
Hearding cats??? That sounds interesting :) How many did you have to round up? I have uploaded the zip file to Files / Attendance.zip I think it's the...
Thank you for your assistance. Where do i find the current event of the tabbed form? The northwind db is showing as sub-forms not tabbed. thanks also for all...
Hi tLarkin (what is your name?) The Current event can be found in the FORM properties -- the fact that the form is on a tab makes no difference; the Tab...
TL- The tab control is just a display mechanism. When you put a subform on a tab page, it's no different that putting multiple subforms on one form. The tab...
Joe I garbbed your file. Now I need specific issues you are having so I don't have to spend time analyzing the entire project. What is not working and what...
John I beg to differ with you. I don't have any Oracle DBs to test, but I have loads of SQL Server DBs. SQL Server 2000 and 2005: This fails with the error...
Bill- Yup, you're right. Must have been thinking about MySQL: A select_expr can be given an alias using AS alias_name. The alias is used as the expression's...
I am having a senior moment "Insert into temp_docname2 select * from DC where ( DC.dc_dav <> temp_docname.dc_dav )" I need to select all records from table DC...
Terence- Well, you haven't included the table temp_docname in any FROM clause anywhere, so the query engine doesn't know where to find temp_docname.dc_dav. Is...
John, In all the SQL logic you have been so kind as to help, 90% of the time my problem is I forget (what i call) "nested selects". From now on , I think I...
Terence- Doesn't always have to be a "nested" select (subquery). Could also solve your problem this way: INSERT INTO temp_docname2 SELECT DC.* FROM DC LEFT...
John my dc_dav is not the prim key, hence NOGO BUT I am looking over your sql join statment.....if i read correct you are using the NULL as a way to select...
Exactly. I call it a "frustrated Outer Join." John ... From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On...
Pros, Is there a vba function to format a variant to barcode font? Respectfully, Liz, Data Base Administrator, Methods Engineering ... This email (and all...
Hi Liz, you would set the FONT when it is printed or previewed ... a Barcode is a Font that can be changed or set like Arial, Times New Roman, Wingdings, ... ...
I am experiencing a rather frustrating problem with Access 2007. I have SP-1 loaded. I haven't loaded SP-2 yet. From time to time my users (using an accde with...
Tom- Do they tell you what they're doing when they get the crash? You could try decompiling your orginal accdb, then compile, compact and THEN make a new ...
John Try as hard as I can, I can’t determine why they are getting the messages. Happens with different forms on the database, never seems to be the same...
Tom- Do all the users have SP-1? Can you upgrade all to SP-2? John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access...
All have SP-1. I will give SP-2 a try tomorrow and see what happens. Thanks for your help. I'll let you know. Tom Davis "Change is inevitable, except where...
you're welcome, Liz ;) happy to help Warm Regards, Crystal * have an awesome day :) * ... Thanks Crystal! Respectfully, Liz, Data Base Administrator, Methods...
What am I trying to do ? I want table called ZED The table has 2 fields, one is the autonumber ID, the other is Doctor_name The table ZED is populated via a...
Terence- If you're not inserting all the columns in a table, you must name the ones that you are inserting: mysql = "INSERT INTO ZED (Doctor_name) SELECT...
Hi Bill, Joe, This problem has already been solved. Have a look at message 72931 (Clive) and message 72933 (A.D.Tejpal). The solution consists of a simple...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
