New XP computer, installed my Microsoft Access 2000, imported my Access data base, Microsoft Access imported good, Microsoft Visual Basic fell to the...

I have a split database with 6 users, when running an update and append querys. while other users are looking at the data, the pc running the queries 'hangs'...

i have a query uses data from 2 tables table A and table B. i need one of the fields in table A to be requierd when the record is used in the query

I'm trying to create a macro that runs 3 action queries sequentially: An Update, an Append, and a Delete query. Problem is, when I copy the SQL code into a...

I need help in writing the expression to a SetValue function in an Access macro. I need to make certain forms to become either snapshot recordset type or...

Hello I want to run a macro and tell it to import a spreadsheet, then open a table in design view to change the data type of a field then after i have saved...

I have a query that finds if an employee's qualifications have expired and shows a form and alert at startup with a macro named as autoexec. Unfortunately it...

I created many forms and they are using the datasheet view. The question that continuously comes up is how do we create a key similar to the Cntrl D...

Is it possible to run a macro from a query, based on an if statement say?

Hi All, My skills are such that I need to do this with a macro if possible. Currently I have five virtually identical queries with slightly...

For discussion's sake.... I've just finished developing 9 or 10 queries, (makes, appends, deletes), that will take 14 imported ISAM files, normalize some of...

Hi there I am trying to write a simple macro to be able to send an email based on an emai address in a form. tblAgency Details has a field EmailAddress (data...

I need to import data from a text file. I would like to create a macro that would prompt the user for the file and then import it into an existing...

This macro suggested for my previous question is returning the error sub or function not defined. Can some tweak it for me. Sub Test() Dim NewStr As...

I have a form with several queries set to run by macros. The queries will run based on the criteria chosen from 1 of the various drop down boxes that are...

Hi there I am trying to write a simple macro to be able to send an email based on an emai address in a form. tblAgency Details has a field EmailAddress (data...

I have a macro I created to transfer text Transfer Type Export Word for Windows Merge qryname file name has field names no the problem is the qry has a date...

Hi, having followed the advice from 'Microsoft help' I can successfully run a query when the database is opened. The query updates a table. In the design...

I have created queries and most of them are working fine. Except when i select the rest of them they come up with a box showing the (name of the related...

Is it possible to call a Macro or Module from a Query?