Search results for query: *

Hi, I have a very simple Access application: previewing a crystal report from a form, using an ActiveX control: CrystalReport I need to copy this application to another computer where I don't have that ActiveX. What do I have to do to make my application run on the second computer? What/how do...

Hello! Thank you for reading. I'm ok with this now. Gabriela

Hello! Is there a fast way to split the page header on the report or I have to create the new section and copy over all the fields I need? I have so many fields to move... and I cannot move the guidlines. Thank you, Gabriela.

Thank you, Yes, the formula works! And I will use TONUMBER because of the zeroes in front of the text (001 vs 1) I panicked for a minute because I didn't expect this different type issue... :-) Gabriela.

Hello! I've just realized that the field which I should link by my subreport to the main report is a different type than the field in the main report. I mean: both contain Line# information but in the table for the main report it is TEXT and in the table for my subreport it is NUMBER. I...

Hi! Can I use a parameter in a cross-tab which would prompt me for the field I want to have summarized? For instance, I created my report to see values for FISC_PRD1 and I don't want to create another one for FISC_PRD2 or to keep going and change the field in the Format Cross-Tab option. Thank...

Thanks for you answer Nigel! I've just found the problem was in another place but the Access message was confusing... Actually I was missing a field from a table... Work can be fun again ?! :-) Gabriela.

Hi All! I have an append query to which I'd like to pass as parameter the value of a combobox from a form. So in the query definition grid I put [strParam] for the ITEM field which I want to pass, in Query->Parameters I defined [strParam] as text. In the form I'm doing the following but it...

Hello! I'd like to know if there is a way to see when my computer is accessed remotely with RemoteAdmin(v2.1) I'm the "client" machine and have the RemoteAdminServer service running all the time, the OS is NT workstation. Thank you in advance!

Hi, what I did is I put the code in the "on click" event of my preview report command button. So first I created the strSQL string then I ran it DoCmd.RunSQL strSQL this works if your SQL in a maketable one and the report is based on that new table. If it's not a maketable I think...

you can try the above in a small sample table, to see how it works and to be sure you're not loosing your data!

Hi, If you just go and change the field's data type from yes/no in text, you'll have "yes" and "no" as values in your field. From there, if you want to have let's say "1" for YES and "2" for NO, you can run an update query. Doesn't have to be done in VBA...

hi! i did what you told me: i created a new form, inserted the crystal report control, but as soon as a start working with the control (just looking in the property window) i get a dr. wathson error and i'm kicked out access. i'm using access97, i have crystal reports 8.5 on my computer. which...

Hi, I have a report designed in CrystalReports 8.5 and I'd like to preview it with a mouse click on a button on a MS Access97 form. Could you please help? Thanks a lot! Gabriela.