Recent content by kfschaefer

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