Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mbcmike
  • Content: Threads
  • Order by date
  1. mbcmike

    Pocket PC database

    I am trying to create a SQL database on a Pocket PC device with Windows Mobile 5.0. I found this link http://msdn.microsoft.com/en-us/library/aa454892.aspx, however my problem is that I am using Visual Studio 2003. That page is using Visual studio 2005. My end all goal is to be able to write...
  2. mbcmike

    Pocket PC database using Visual Studio 2003

    I am trying to create a SQL database on a Pocket PC device with Windows Mobile 5.0. I found this link http://msdn.microsoft.com/en-us/library/aa454892.aspx, however my problem is that I am using Visual Studio 2003. That page is using Visual studio 2005. My end all goal is to be able to write...
  3. mbcmike

    making labels

    Is there a way to change the mailing label type after creating the report? I set it in the beginning and now want to change it.
  4. mbcmike

    Page stuck in loop

    I'm using the javascript within my ASP page to pause for a few seconds before I call a function. When my page loads, it calls this: function Pause(iSeconds) { window.setInterval("GoUrl();", iSeconds*1000); } I seem to be getting stuck in a loop where GoUrl can never...
  5. mbcmike

    Page stuck in a loop

    I'm using the javascript within my ASP page to pause for a few seconds before I call a function. When my page loads, it calls this: function Pause(iSeconds) { window.setInterval("GoUrl();", iSeconds*1000); } I seem to be getting stuck in a loop where GoUrl can never take me off of the...
  6. mbcmike

    Problem linking tables for good.

    I am using Access 2003. Someone sent me an Access mdb file through email. When I open it on my end and try to get into one of the linked tables, it says connection failed. So obviously I use the linked table manager and put my username and password in and I'm good to go. However, when I exit...
  7. mbcmike

    Problem with linking tables

    I am using Access 2003. Someone sent me an Access mdb file through email. When I open it on my end and try to get into one of the linked tables, it says connection failed. So obviously I use the linked table manager and put my username and password in and I'm good to go. However, when I exit...
  8. mbcmike

    Problem returning values in a select

    I have a procedure that is being called by a crystal report. The report sends a value to the procedure which is either "NEW" or a date. If the value is new, then I want all new records returned and also to update them as "Printed". Other wise show records that have the date selected. If a date...
  9. mbcmike

    page footer for a sub report?

    I have a sub report in which I need a page footer on. I know sub reports don't usually have page footers, or page headers for that matter, but I found a work around for a page header. Is there any such thing for page footers in a subreport? Thanks
  10. mbcmike

    Trying to execute a procedure within another procedure

    I want to execute a procedure depending on whether or not a paramater is in a particular table: execute procedure where not exists (select * from table where ssn = @p_ssn ) Obviously I am doing something wrong here...
  11. mbcmike

    exporting sql table to .txt document

    I haven't actually started writing this yet because I'm not sure where to start or if this is possible. If anyone can point me in the right direction as far as what possible function(s) I would need to do this I would greatly appreciate it. Then I will research it further, try it out, and if I...
  12. mbcmike

    not showing every part of group

    I grouped my data and put a total in the report footer. However, I only want the total to show for certain sections of the group. Example: Group Name A Total: #### B Total: ### C (No Total) Is there somewhere I need to enter a formula for...
  13. mbcmike

    problem with parameter max length of 128

    I have a parameter that I am trying to pass to a stored procedure. It happens to be a very long parameter. I get an error saying it is too long and can be a maximum length of 128. Is there a way around this?
  14. mbcmike

    inserting into a table using a cursor

    I need to insert specific records from a cursor into a table depending on whether or not that record is already in the table based off of an employee number. I have my cursor set up, but I can't figure out how to insert from that cursor into a table. I was trying to use a normal insert with...
  15. mbcmike

    Change margins for printing

    I have an asp page that partly cuts off when printing (on right side). I was thinking about using onbeforeprint and onafterprint to adjust the margins while printing and have it set back to normal after print(adjusting margins will make it fit). However, I'm not sure if this is possible. I have...
  16. mbcmike

    locating a "tab" in a field

    Anyone know what the syntax is for a tab? For example char(13) + Char(10) would be "enter". I need to replace all the tabs in a field. Thanks.
  17. mbcmike

    Finding all fields with "enter" as their value

    I have a table of data where apparently whoever entered it, happened to hit the enter key in a particular field as opposed to leaving blank. How can I select this field. EX: Where field ="ENTER" ENTER of course being what I'm trying to figure out
  18. mbcmike

    Keeping information together

    I have information that is displayed through a group on the screen. When a new page starts, it begins wherever it left off on the other page. So I may have a group with half its info at the end of page 1, and the rest of its info at the beginning of page 2. I want the group to just display...
  19. mbcmike

    Searching for data that has an int

    I have a table, where I only want to select the sets of data that contain an integer. I thought about using CONTAIN, but that wouldn't work because it is for data with characters. Also, I don't want to search for specific integers, just if the data has any int in it at all. For example: (a)...
  20. mbcmike

    "Trimming" end of a function

    I have a particular function that when shown in IE, takes up alot more space in the explorer then when I see it in the Crystal Report preview. So basically I want to limit this to a certain amount of characters. For example, functionX will only show the 1st 20 characters...even if it is 25...

Part and Inventory Search

Back
Top