Search results

This worked for me and required minimal thinking. http://support.microsoft.com/kb/209963

Thanks much John BB. Just starting to deconstruct the process employed for the import for the sample db. I was wondering if the sample db is supposed to be functional. It isn't for me- I'm using Access 2007. I've looked at the code behind the welcome form etc.-assuming the db is supposed to...

Hello- I have been trying to import an excel data worksheet to Access where the worksheet data gets split up to related Access tables. I have success doing this using the Access excel import function followed by the table analyzer (to split and relate the tables) if all the Access tables have...

Thanks (again) vba. That works. I wasn't sure if I should continue that first thread with this question. It's best to keep one's displays of ignorance separated as much as possible I suppose. I'll never get to code anything at this rate.

Access 2007 has right-click drop down filtering for Report View. However that method doesn’t seem to provide for Boolean expressions in the filtering. For example: If I want all records from Leeds AND Portsmouth it doesn’t seem to provide a solution with the drop down filtering options. The...

Well, actually I do get the filtering function in my report now. I should have spent more time fumbling with my application and less searching the internet for a "solution". thanks!

Does the Access 2007 enhancement item #3 in the following linked article actually exist? http://www.techrepublic.com/blog/msoffice/10-key-enhancements-in-access-2007/134 I can't find any other reference to this functionality and it doesn't work in my reports. Thanks.

OK. Resolved it in a not so elegant way. Created the exact same form with the proper fields included (using Wizard again) and then replaced the SQL code in the old broken form with the RecordSource SQL code from the new form. The broken form is fixed. Thanks tons for the help.

Actually the RecordSource looks more like this: SELECT [tbl_QA Job].*, tbl_Program.Program_Name, tbl_ContractingCompany.Company_Name, tbl_Zone.Zone AS Zone_tbl_Zone, tbl_Major.[Error Description], [tbl_QA Specialist].L_Name_QA AS [L_Name_QA_tbl_QA Specialist], [tbl-Minor].[Error Description]...

I see this line under Recordsource for the form: SELECT [tbl_QA Job].*, tbl_Program.Program_Name, tbl_ContractingCompany.Company_Name, tbl_Zone.Zone AS Zone_tbl_Zone, tbl_Major.[Error Description], [tbl_QA Specialist].L_Name_QA AS [L_Name_QA_tbl_QA Specialist], [tbl-Minor].[Error Description]...

I am hoping the database is attached. ?????

Arsenal! Go Gunners! Is anyone better than Fabregas?

I heard the is the I-Phone killer. Thoughts?

super helpful, thanks.

Thanks for the information. Found it enlightening!

Hi- Pretty green to Access but this is a great forum. Thanks, look forward to answering someday as well as asking. Ken

helpful thanks!

OK. I think that would be great. I'll zip and post it.

Hi- The data entry is set to No. Three things: 1) I am using the same form for both adding and editing (the form is called by command 2 (for adding) and command 3 (for editing) using the switchboard. 2) Even when I open it from the quick access toolbar the thing opens in Add mode (ie...

Thanks. When I open the form from the quick access tool bar rather than from the switchboard it does the same thing- opens like it's in Add mode not Edit mode. (it should open with all the records loaded when the from is started from the quick access toolbar but it doesn't) I'm not sure...