In Access 2003, I would create a Query, and part of my critieria would be =Environ$("UserName"). The query would return stuff specific to that user. That's not working in Access 2007. Any ideas ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_227...
I just upgraded from Access 2003 to 2007. The queries no longer work where I used expressions to combine string-functions into new fields. Example: newfield: Right([year],2) & [LOC] & [MASTERBOOK.P...
http://www.experts-exchange.com/Microsoft/Applications/Q_22937921.html
I had posted this question before, but just found out the solution didn't work. Here's another attempt...
I am using Access 2007 adp to SQL 2005. During the conversion, we've discovered that t...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/ADP/Q_22985876.html
I have a Access Database that has a table with leads (prospects) and the state they are from. I want to be able to export the leads from the table into two different spreadsheets. Sometimes it m...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23068031.html
I have a form where users can select from a group of categories, or select an All Categories checkbox to use all categories. It then filters a set of temp tables based on the criteria to generate ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23070929.html
Access 2007
Hi I have:
1) table "AppendTable"
2) 4 append Queries with Prompts
3) macro that runs these append queries to create the "AppendTable"
The macro has two of the Append Querie...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_230...
I created an input form that has a dropdown box that contains valid NDC Codes. Then on the after-Update I perform a DLookup to pick up the associated Name. I should never have null in the NDC cod...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23074455.html
Zones:
MS AccessDate Answered: 01/10/2008 Grade: A Views: 8
I have a list of Purchase Order items that are being displayed in a form. I would like to add a check box so that users can select one or more rows that are to be inserted into another table. I c...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23076333.ht...
Zones:
Access FormsDate Answered: 01/11/2008 Grade: A Views: 0
I have a form that lists data in the main form where net amount is not zero. Then I have a subform under it that lists Purchase order data. I have a check box that will select records the user w...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23077209.html
Zones:
MS AccessDate Answered: 01/11/2008 Grade: A Views: 0
Is it possible to create a form that will allow users to change add and delete records if the source is a query? I had a maintenance form for a table and the user would like an additional field th...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_230...
