Search results for query: *

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?

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 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

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?

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...

I have 2 fields where either can be zero. I need to determine the percentage differance between the two. How can I avoid a zero divide error when one of these fields is zero.

Does anyone know how to add additional tabs to a form which currently has 2 tab controls. It seems that by default you are given 2 tabs.

Has anyone had a problem where all of a sudden SprintDB hangs when export a form to your Pocket PC. The form was fine then suddenly won't export. I have uninstalled and reinstalled the Desktop Companion without luck. HELP!

I am playing with SprintDB and like it, but.... Once I create the app using the SprintDB Desktop Companion does each iPAQ I install my app on require the iPAQ side of SprintDB? Can the app be compiled so that it doesnt require the iPAQ owner to first open SprintDB then open my app? If I place...

Here is a basic question. How can I customize the default parameter screen. I would like to make it more personalized for the user?

I downloaded a pocket access program which will allow me to create my own database programs on my iPAQ 5550. When I launch the program I get an error stating that I need evb installed. I download the cab file from msdn. When I double click it the file extracts to many files. How do I install...

I am trying to verify that a file exist. The file will always be named the same and in the same location. I am using the following code without much luck. Any thoughts as to my error. If FileSystem.Dir("c:\FromCounter.txt") <> "" Then DoCmd.Close acForm, "AboutForm", acSaveYes End If

I am trying to run a query on a table which has a text product field. The contents of the field might look something like "76050-17001". I need to run a query which limits the range of the product field. Something like >=76050-17001 and <=76050-54000. I thought Access supported a function...

I need to surpress printing of a page header on any page where a group footer page is printed. I can surpress printing when I moved the group footer section to the report footer but need to print this section each time the group changes without seeing the page header info. Thanks

I am trying to run a total on a value stored as text. I am using the following formula with no luck: Sum (ToNumber ({IM1_InventoryMasterfile.Weight})) Is this the correct method?

I was wondering if there is a way to surpress the page header on the last page of a multiple page report.

I have a PDF file which has been password protected to prevent printing by a former staff member. This person left my department without providing the password and now I need access to the PDF. Is anyone aware of password recovery tools for Acrobat? Thanks

I am creating an invoice. My problem is that when there are negative numbers they dont align correctly. The brackets around the value seem to move the value further to the right margin. How can I align all the values in the column so they are right justified regardless of credit or debit. Thanks

I don't know why this won't sink into my head but... I have a text box in my form which has a field called picture as its control. This field contains the path of my picture. I am image control also on my form. I don't understand how the image control knows to use the path of my picture. When I...