Search results

REASON FOR PROBLEM: I tried posting this once before and it didn't 'take', so will try again... It appears that the Access documentation about transfertext is wrong - unless I read it wrong. It indicates you can use a query to generate the data to be moved to a file. From my experience with...

Thanks - I will look at them. In the meantime, I found a connection: I changed the query back and now transfertext is 'seeing' the file. Strange. I'll have to play around with it from that angle.

Its 2003: 11.8166.8221 SP3 Our network guy couldn't find any recent updates (past 2 days), to terminal services (although I know we had a major upgrade not too long ago). Also, no updates for Access

Well, looks like accessing it from another mapped drive isn't working either!

I haven't tried that yet --- am taking a breather. This is very frustrating!

Actually, I'm IN the J: drive, doing all my processing from there.

Yes- which is what I had to do to match up the file with the new query output, since I thought that might be the source of the problem.

What's strange is that in Access, I'm having the problem, but I can see the mapped drive just fine via the Op Sys.

FileFolderName = "J:\Remote\Files_OtherUsed" 'Test folder DataDocFileName = FileFolderName & "\" & DocumentName & "_Data.txt" Document Name is passed to the routine that processes this. I've checked the name and it appears correct. I'm also finding that the following stmt isn't working...

Could someone please help me with this problem? :confused: I have the following stmt: DoCmd.TransferText acExportMerge, , SelectedQuery, DataDocFileName, True. Whenever I run it, I get an error msg that the Access engine could not find the DataDocFileName. I've checked it and know it is...

Dont know if this will help, but do you have the following anywhere to get correct count? Me.RecordsetClone.movelast

which read as follows....

Have you tried re-installing the ocx?

Your welcome. Happy coding...

The reference to [CustRef] should come from the first screen that HAS the value: instead of me!custRef, would be forms!frmName!custref

You have to create code under the current event (OnCurrent). Select the form. Click on the square box, upper left. Right-click & select properties. On Event tab, select "On Current". Select event procedure, then select ... Enter your code & debug.

In current event, change the fields default property: ie: if me.newrecord then field.DefaultValue= Me![CustRef] endif

So you originally had 2 tables:[Customer] and [Sales] and now you have a 2 more tables: [Salhed] and [Sales Today 0]? Confusing, since you said Sales Today 0 was a subform. Unclear how your screen(s) are laid out.

Trim(Len(Nz(Me.[qProductCost_subform].Controls("Cost")))) = 0 How is Cost defined? does it have a default value of 0? If so, should remove default. Also,try changing to something like this... 'Check if value is null or = 0 Trim((Nz(Me.[qProductCost_subform].Controls("Cost"),0)) = 0 I...

If you want users to pick from separate fields in subform: Private Sub cmdAppendProduct_Click() On Error GoTo Err_cmdAppendProduct_Click Dim qrydef As DAO.QueryDef Dim stDocName As String stDocName = "qryAppendProduct" 'DoCmd.OpenQuery stDocName, acNormal, acEdit If...