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