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...

Thanks I have searched High and low on the web for this solution. That seems to have done the trick. You should submit this to MSDN for a work around with this bug. Karen

Yes, the table need will come from different mdb every time. Depending on the user Selection of a dropdown. ie. User1 selects ID 12345 from dropdown - mdb location may be c:\Access\12345.mdb User2 selects ID 34564 from dropdown - mdb location may be c:\Access\34564 .mdb User3...

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...

Turns out I was mistake the code runs, however, the current code returns the same employee info for all the employees, replacing every record with the same - what am I missing? K

Here is my final solution. Thanks for your input. Private Sub cmdValidateGeneralInfo_Click() On Error GoTo Err_cmdValidateGeneralInfo_Click Dim F As DAO.Field Dim rs As DAO.Recordset Dim rs1 As DAO.Recordset Set curDB = CurrentDb() If Me.DateModified = Date Then 'Adds new employees...

Ok, I got most of the recordset update working except for the field type issue, ie. Dates. While Not rs1.EOF For Each F In rs1.Fields If F.value <> rs(F.Name) Then rs.Edit If IsDate(F.value) Then...

Thanks for your quick response. However, you got it backward - tblEmployee is the good/revised data and primary data, I need to update TT_GeneralInfo with any changes in TblEmployee. There is a Primary key value in TT_GeneralInfo that is used in multiple databases - so I can not just...

I was not having any success with an Update query. I need to replace only that data where it is different, since the BEMS has a counterpart in both tables how do i get it look at each field. Here is my latest attempt at code, as you can see by the commented out code I have tried various...

Still looking for assistance with the issue. Still getting invalid object not found, even with the adding the ,fields. K

Thanks for the input, however, there seems to be an issue with If F.value <> rs(strThisField) Then If datahaschangedflg = False Then if F.value = "Jim Jones" and strThisField= "Name" then it errors. seems that the strthisfield is returning the name of the...

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...

Ok here is a sample mdb to illustrate my problem with the updating of the comments - that duplicate a portion of the data. See attached doc that illustrates the steps and problems I am currently having - Please note that the screen shots may not look the same as sample but the steps are the...

It is definitely a MEMO field. Thanks, K

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