Search results

Replication The Master is one of the replicas, and if you synchronized it, you can throw the bad replica and make a new one. Why do you use replication? If no spacial reason - drop it!!!!!!!!!!!!! :o

Replica James Don't start with replicas, it's not a good idea. Replica is only for data not forms etc and it's a pain. try this to logoff your users: http://www.rogersaccesslibrary.com/download3.asp?SampleName=LogUsersOff.mdb :)

Hi Tried it in another forum and didn't got an answer. I'm transfering a record from Access to Word with this code: Set objword = New Word.Application Do Until rst.EOF With objword .Visible = True .Documents.Add Template:=("\\Server\a.dot") .Selection.GoTo...

Thanks !!! :)

Hi everyone I have a query. The parameter to this query is forms!FromName!Field that contains a number. The value is built from code. Now I want to use this query to retrieve more then a number like: 1 or 2 or 3 In this case no record is retrieved, if I take the string from the field (1 or 2...

Add to sorting and grouping the group header of competitor and in the detail - the class data

docmd.OpenReport "XXXXXXXX", acViewPreview docmd.RunCommand acCmdZoom75 docmd.Maximize The values of acCmdZoom can be: 100,75,50 .I remember those but you can try it.

Try to change fonts and font weight. it helpd me.

Yes, it is. Ken I build a report based on the crosstab query that runs nicely but when use it as subreport, with the crosstab as record source - no data displayed, and without record source - only one row is displayed without Row Heading.

That is the best way (I know) to display a crosstab query.

In fact, the Listbox was in a subreport and that was the same. But thinking again, you apparently mean - a report without listbox? That might be the solution. Thanks!!! :) :)

Hi len The report is produced as a document to the customer. The user works in the field with farmers and makes a fertilizing plan. Then he prints it, or work at home and send it to the cust with E-mail. In both cases he needs to add details that we don't keep in the DB. About the Acrobat, not...

Thanks for Replying! Some users wants to mail the report as rtf or to send it to Word and Edit the report.

I sent this message to couple other forums and didn't get any answer, hope to get some help here. Have a report with a listbox based on a query. When send it to Word (Publish with Word), the listBox doesn't appear. Is there a way to pass the query, or better to say, the listBox to Word...

Thanks Amy That the way I did it and it works in other reports but not in this one, or to be more precise, this is a subreport. The report is transfered OK but from the sub report I can see the label but not the field with the CrossTab query.

Hi I try to send report from Access to Word. The Report has one unbound field that his row source is a crossTab query. The data from the query is shown in the Access report but not in Word. Is there any way to fix it? Thanks

Hi Pat Thank you for replying I acually got the dialog to choose a key, but the reason is that the DB is a test Db and there wasn't any key field defiend. When I define a key, the table is updatable no matter how I connect it and it suitms me.

Hi I used to link Oracle table manualy to Access DB, but somtimes the table becomes read only when the app is moved to another PC, so I want to refresh the link through code evry time the user open the app. My string connection : strConn = "ODBC;DSN=test;PWD=MyPass;DBA=W;" if the table...