Search results

:banghead::banghead::banghead:After doing a lot of research on how to Schedule a task ie. MS Access 2007 database, I have not found an answer on how to Schedule a task using MS Task Scheduler tool. In XP you use to have to include the msaccess.exe filepath with the start - in of the file path...

I have a Mainform/Subform(s), I need to include the option of show all records or limit the record to the select item from a combo. Each subform has a different recordsource, if the user selects "ALL" then I need for each subform's recordsource to display all records for each record...

I am generating a MDE file type of my development versions. I have the Nav window turned off, however, I do have a few linked tables that are refresh on demand via code from the user. the Nav window becomes accessible when these linked tables are being refreshed. How do I prevent this...

I need to compare two tables, data and determine differences and where different - update the first table with the new data. I am looking for the best approach - a simple update query will not sufficient due to the fact the second record set is not an updatable query, hence the need to use...

I am attempting to create a new database, then import Access objects into the newly created mdb from two different databases, while working in a third database. I need to recreate database so that I may push out changes to duplicate copies of the mdb where the data is different - I know many...

I want to delete/Replace only a portion of the text with the Memo field. ie. the auto update of the Memo field enters data from various fields on the form without affecting the original users comments with in the memo field. Here is my current code that updates my memo field- however when...

I need help with the attached code to prevent duplicate entry of data within a Comment field(Memo). I need to validate if certain data exists within the Comments, if so only modify the necessary data and not duplicate the data. The problem I am having in my code is with the replacement...

I am in the process of validating my Access 2003 database and the functionality working in the new Access 2007 environment w/o converting to 2007 - will have mixed environments for awhile. The forms within the AK3 version work perfectly, however not in Ak7. When I open the form with...

How do I create copy of database then link all tables from another database using vba. Will need to look through all tables. i am looking for code that will create a copy of a database, then link tables from another database. K

I am looking for code to create an array or function that will create a list of dates, including future dates based on a date range (Between Date() and DateAdd("M", 60, Date()) I am creating a crosstab query when I need to display future months as column headings for the next 5 years and I do...

I have a pfunction in updating the data of blank fields in a table that met a certain criteria - the current process is slow and I am looking for a way to improve the processing time. What I am attempting to accomplish - I have a list of employees and the training courses they are required...

I am attempting to update data in a table comparing the field names of temptable1 to the data in the temptable2. I have tried several renditions of a Do loop statement and neither return the correct results. I need to compare the BEMS(EmployeeNo) in both tables. Table1 = Has the...

I have a group of code that will update multiple Worksheets within an Excel Workbook and then format the cells according to data within the Excel Cells. from Access Vba The problem I am having is where to place the 2 function to update the formatting of the cells on the 2 separate worksheets...

I need to keep an audit trail of certain fields on different forms that will on before update of a field capture the original value - compare to new value if different create an audit trail of both the original value and the new values for different records on the Audit Trail log. I need to...

I am looking to modify the following code to replace a portion of a memo field w/o affecting the data within the memo field. I have tried numerous methods and this is the closes I got, unfortunately it only works partly. Say My comment field contains the following...

Looking for the best approach to updating/altering an Access table via DSN-less connection string. Situation: This process will be run nightly via MS Schedule tool Database 1 - contains 1 table which acts as a linked central datasource for numerous databases - this cannot be change. - in...

I am attempting to change the record source for a nested subform(datasheet), I tried using the expression builder, verified form names, verfified the query is accurate and still getting Invalid Object error. I know it has something to do with the fact that my subforms are both datasheet views...

I need a way to prevent a double quote placed where there should be a single (apostrophe) in the data value. See '>>>>>>>> INSERT INTO TL_FTEM ( FirstofEquipment_ID , NOMENCLATURE :) , Nomenclature_Modifier , EQPT_LOC_NO , SERVICE_ORGN_CODE ...

I have a Database and Spreadsheet that I am attempting to update the xls from mdb. and I need to be able to copy more than the 255 characters into 1 cell. I have found this code however I am running into a "Object variable or With block variable not set (Error 91)" issue on the following...

I am attempting to create a function that will convert a record id in a query to display a hyper link value. Not sure if this can be done. What would be the correct syntax to change the RecId in the query that will inturn be exported to an HTML output. Would the newly created hyper link...