Search results

Hi Bob, Since my post I have been banging this around and came up with an AfterUpdate event on DateTrained using the NZ function. It seems to be working. Would you Look at this and see if I am creating my self a problem. Private Sub DateTrained_AfterUpdate() RetrainDate.Value =...

Thanks for responding Ken Yes! that is true, it does show in the form but it never gets to the table. Do you know what I should do to get it to the table?

I have a form to record employees training progress to a Log table. I am in the midst of updating this entire process and at one time had this problem solved (I thought). The user selects and employee id from a combobox list then selects the Training policy number from a combobox list and enters...

Right on Brian! Good catch...it works perfectly now. Thanks to all of you for your help on this. This is the greatest forum on the net.

Thanks DCrake, I copied your nz function in and got a halt indicating [Intv] in the From statement could be ambiguous so I changed t0 the followiing: IIf(Nz([tblTrainingLog].[Intv],0)=0,Null,DateAdd('yyyy',[tblTrainingLog].[Intv],[DateTrained])) It didn't give me a halt, however, it didn't...

I have two tables TrainingPolicies and TrainingLog. Each policy has an invertal of 1, 3, or 0 indicating years to establish a retrain date in the TrainingLog. We occasionally have to change the interval and need to update the Trainglog with the interval and change the retrain date to match...

I ended up breaking up the module and using Code: If rs.BOF and rs.EOF Then MsgBox "This record has no lines" Exit Sub Else rs.MoveFirst ...... Loop End If

GoTo didn't solved the problem. I am going to break them up into seperate modules.

Thanks for responding to my problem. Unfortunately this is one of 14 strings of code and if I insert Exit Sub it does so and bypasses all the following code. I may have to breake these up into individual subs. I was trying to be slicker about it and save me some typing but maybe thats my only...

I have a function with 13 sets of the following code to clear Excel files to prepare for the next period. My problem comes when the linked file has no records. This process destroys the column headers of an empty file. Could some one advise me on getting past the do loop when there is no records...

Bob, This answers my problem as well only I want to save a backup of the file with a mm-yy added to the end of the file name and save as an .xls. Can I just & the date some way?

Try this. I believe you have not defined objXL as Excel. Sub RunMacro() Dim objXL As Object Set objXL = CreateObject("Excel.Application") Set xlWB = objXL.Workbooks.Open("P:\ROC Reports\Network OSP Reports\QAM64 Migration\files\Formatting_macro.xls") objXL.Application.Run "P:\ROC...

I have a linked Excel workbook "CurrentStatement" with monthly credit card transactions that get parsed into several different cardholder transaction "CurrentCardholder[name]" Excel spreadsheets that are linked to Access. Each cardholder must verify the transactions and assign GL codes to...

Forget it I posted. I had created a report from clicking on the standard Report toolbar and it must have created a report with an image in it. I got rid of it by changing the Picture property to no picture. Sorry if I wasted anyones time.

I have an option box to preview or print a simple one page report. I am using code that I have been using for this purpose for several different databases. All the other data bases send the report to the defaul printer from this code. Case 1 produces the desired result but Case 2 doesn't. It...

Thanks for the help.

I have a linked Excel file that has to be cleared at month end and updated with a .csv file downloaded from a credit card company. I have all of that covered but currently start the process from Access and I manually run a macro while in Excel to import the .csv file do a bunch of formating and...

Thanks RG, you saved me again.

I am opening a form form an option control and the form is suppose to open in datasheet view but will not. I need the orginating opton form to go away while I viewing this linked spreadsheet table. The form properites have all but Datasheet View as no and its set as Modal as help tells me to...

Thanks for the advice. These are linked tables so no changes can be made anyway but it's best to follow good practices.