Recent content by PeterL

ianbara I noticed you have developed an app using Visual CE. I am considering using it and was wondering what you thought of the program. I developed my app using SprintDB but am thinking about switching. I downloaded the trial version and find it a little confussing. SprintDB seems like a...

I have a crosstab report which works fine. I would like to add a group footer to the report but have not been able. All the objects from the crosstab are placed in the report header section. If I move anything from that section the report no longer works. Any thoughts?

Actually what I'd really like to do is us the DoCmd.Transfertext function where I decide the location to save the file but the file name comes from a field in the selection query. Any thoughts?

I have a macro which exports data as a comma delimited file to a directory. The file name and directory are hard coded. I would rather have the program prompt the user for a file name and location to save this file. I assume I would "filedialog" but am not sure how to construct this. Thanks

I'm sorry but I'm still confussed. My query has a current field which will be used in the new table. How do I change the name in the query prior to making the table.

I have a make table query which by default uses the field names from the query source as it's field names. Is there a way to define my own field names in a make table query? Thanks

The recordsource for the subform is a table, no query. The subform and mainform are linked via a customer name field. I display all customers in the main and if there is data in the subform it should be displayed else an error message.

Aceman The following code isnt working: Private Sub Form_Current() If Me!SubToCounterHistory.Form.RecordsetClone.RecordCount = 0 Then MsgBox "No records found!" End If End Sub I placed it OnCurrent in the main form. Any thoughts.

I have a subform which can potentially contain zero records. In this event rather then just display a blank screen I would like to display a message stating that no recods have been found. Any suggestions?

Anyone know of an FTP program for a Pcoket PC?

You are correct. This worked like a charm. Thanks

I don't understand. How does "Select Null," equate to a "," in my export statement.

I wrote an SQL statement which selects records for export to a flat file. I need to begin the flat file with a comma. This flat file is comma delimited. How can I add a comma to the beginning of the SQL statement so that the file appears correct. Here is a sample of the SQL statement: "SELECT...

Who's better then you folks. Thanks

Using this formula everything looks good except I get: YTD PYR +-% 150 0 1.00 This should read 100 0 150 -100 Perfect