Search results for query: *

Thank you both! Import? as far as I know one can export. Anyway, this will mean having two objects that, when modified, will need to be modified in both sides. In this case I have some variables defined as global on dbsource but not in dbtarget so will have to change code on the exported form...

Do anyone knows if its possible to run a form that resides on a different mdb? Will apreciate any help. Have two different databases that share some tables but are needed to keep apart. There are a couple of procedures that need to be executed on DB1 but results will be used on DB2. Thnx Patricia

Tony, No chinese settings at all! And I'm seeing the contents activating the clipboard task pane in remote as well as local aplications (being this Access, Word or Excel). I've done some research and found something about chinese characters shown in MS applications when there are corrupted...

I think the problem resides in the clipboard rather than the content... it doesn't matter what or where I'm trying to paste, the clipboard shows chinese characters. Thnx

Well, usually I'm runing Access and Excel... what takes me to the conclusion this may be an Office issue. Patricia

Hi, Usually my working environment is switching between several remote sessions and my local computer. I need to copy form/to remote into local, somehow there are times when clipboard stops working and either I got nothing to paste or it carries chinese characters. Please, help!! [bigcheeks]...

I found this useful: Try setting the datatype for the SQL Server side of it to a varchar(38000) Good luck! (-: Patricia

I know this could be annoying! Go to: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acfctNZ_HV05186465.asp You'll find the answer to your problem... of course you'll have to include this function whenever you make numeric calculations! (-: Good luck! Patricia

I'm writing code for interface with an EDI application. When importing/exporting data I run several queries one after the other and need to somehow track the results of each. I will like to continue executing code only if the previous qry was successful not only because it didn't fail but also...

Tamrak, first, let me ask you: do you need to print a hardcopy of your report for each (or selected) records in a table or you want to view an on screen report?

Thnx Jim Access 2003 or 2000 have same issue. Crashes when using ImportFile Wizard, halts every action within access even if it's a process runing on a different instance. Done some research, and found many with the same problem !? Actually I bought a third party to solve this while looking for...

When using the advance feature for importing a file. Acces constantly crashes. Anybody knows how to solve this? Advanced thanx

Don't know if you want to do this repeatedly. If so, try this: Select the records using a make-query, for the first time export the new table to a text file and use the advanced features to create an export specification in which yo set the formatting you need (string qualifier, field...

[morning] I was so immersed in the idea to solve the parameters passing that i literally forget there are more than one way to solve a problem. Thank you! [2thumbsup]

The Data for the report comes from a query that selects from 8 different queries + one table. The 8 queries select the orders for each different Distributor Center for a certain date ([date] in criteria for each query), so whenever I run the report the user is asked to enter the parameter...

Thanks Stephen, but the format MUST be one table per sheet :-( , in fact I'm writing code as this should run transparent for the user (who happends to know almost nothing of Access) and it won't bother me to go through something more sophisticated. Patricia

Working with a form in which the user select files to be exported to a single spreadsheet using TransferSpreadsheet action. In help I noticed that "if the file name is the same of an existing... exporting to an Excel version 5.0 or later Access copies the exported data to the next available new...

I'm taking data from text files using a variable=ImportFileName found through a FileSearch that looks for *.txt on a directory. Run TransferText to import data and even though they are "import errors" every time (the field types are set in such way to descriminate data that doesn't has the...

I must have a Form from which I select different actions... one of which is to import a text file to a Access table. Can anyone help? Thank you :-)