Tag: vba

Access sometimes jumps to existing record on save new record – Access2k FE/SQL2005 BE

database ms-access sql sql-server-2005 vba

I am really posting this out of desperation after searching around a lot for an answer and trying a few different things with no success. I have an Access database where I have recently migrated the tables to SQL 2005, Access continues to function to the users as a front-end providing forms, reports, and queries. However, since moving to the

SQL as Control Source for Access Form field

ms-access sql vba

Is there any way populate an Access Form’s text feild’s value using SQL? I have read that it is not possible to simply enter SQL as the Control Source. Is this true? thanks for any halp 🙂 –edit– I need to perform this query; Answer Pretty sure that is true SQL, but you could use the function: =DLookUp(“field_name”,”table_name”,”any_fieldname = ‘value'”)

Export all MS Access SQL queries to text files

ms-access sql vba

I have to document an MS Access database with many many macros queries, etc. I wish to use code to extract each SQL query to a file which is named the same as the query, eg if a query is named q_warehouse_issues then i wish to extract the SQL to a file named q_warehouse_issues.sql I DO NOT WISH TO EXPORT

DCount vs. SQL SELECT COUNT(*)?

ms-access sql sql-server vba

I am trying to get a count of all items sent to a supplier based on the purchase order they are assigned to. But I can’t seem to get the control to show a number of items based on the purchase order instance – it keeps throwing either a #name? or #error! message in the text box when the form