Search results

I'm looking for an expression or SQL for use in a query that will count the number of columns in another query. I do not need to count the records, I just need to know how many columns. I can't seem to locate a reference to a column count - everything points me to record count. Thank you for...

If you split a database and distribute the front end, do the selected VBA libraries stay with the front end or do the users have to reselect the appropriate libraries? (i.e. are the selected libraries used in a file a function of the file or the application).

I have a form bound to a dynamic query. It is similar to a search function, the user enters a keyword and the query is updated, however the continuous form does not show the updated query results unless the form is closed and reopened. Requery methods do not work. It's something simple but I'm...

I am a beginner user in MSAccess and VBA code. I'm developing a form for data entry. I'm using a combo box to select a Task from a table and a cascaded list box to select the Elements from a query based on the selected Task. I have a text box to enter Standards for the selected Element. When...