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 TouchToneTommy 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: homeguard
  • Content: Threads
  • Order by date
  1. homeguard

    OleDbDataAdapter control missing

    I was trying to go through this tutorial on how to connect access dbs with vb.net apps but when it says got to data and drag and drop my OleDbDataAdapter control it isnt on the data list of controls. http://support.microsoft.com/kb/821765/ i got to part 3 of "Retrieve data from the Access...
  2. homeguard

    Crystal Reports Graphs

    I need to make some graphs off of the information that Crystal Reports has made. I have Crystal xcelsious and love the dashboards you can make with it. I was wondering if there is something like Xcelsious for Crystal Reports that will be auto updating?
  3. homeguard

    sharepoint search box

    I chopped up the layout of a sharepoint site with designer 2007 and now my search box seems to have died, when you search it goes directly to the search page but doesnt search for anything then you have to type in again what you want to search for. Anyone know how to put a new search box on a...
  4. homeguard

    Scatter Plot Problems with Dates

    I am trying to make a scatter plot. I have a list of audits with a calculated field of how many days it took to complete the audit. I am trying to make a scatter plot that has the dates at the bottom with the days it took to complete the audit running up the side. but for some reason access...
  5. homeguard

    Calculating Date Field

    i put another column on a query to calculate the number of dates between dates. here is what i have: [Date]-[CompletedTime]+1 but if the record does not have a completed time then it will be blank, is there a way to say: if [CompletedTime] = 0 then [Date] - Date() else...
  6. homeguard

    prepopulating forms

    I am looking to prepopulate a form i made with ASP, i dont have control over the programming of the form but i do know what the fields are called that are on the form. Is there anyway to make this work without reprogramming the form? can i reference the field name somehow to get this done...
  7. homeguard

    Open Dialog box

    I need to use an Open Dialog Box with Microsoft Office 10.0 Object Library and am getting problems. Apparently some of the laptop users at my location dont have the Microsoft Office 10.0 Object Library object, is there a way i could install that on their computer? or is there a work around for...
  8. homeguard

    Disabling Action Queries Confirmation

    Hi, i have a line of code that goes something like "DoCmd.RunSQL "INSERT INTO tblEvent..." Does anyone know how to make it automatically disable the confirmation? i dont want to go around and change the settings on everyones computer everytime they use this database for the first time.
  9. homeguard

    XSLT Data view

    so XSLT Data Views seems like a very dynamic way to format your list webparts but i am have some trouble with it. I have a connection of a list filtering another list on a page and for some reason if i have the list that is filtering (the one containing the option buttons) and convert that into...
  10. homeguard

    showing and hiding sections of html based on the url

    I need to show / hide sections of html code on my page based on what the url says, has anyone done anything like this?
  11. homeguard

    Filtering a Query for lastest 100 Records

    I have a Query that has something like 800 records in it and have it sorted by date, i want to filter it for first 100 records that appear in the query. is there a quick command for this or is it more complex? I went into the query properties and changed max records to 100 but it didnt seem to...
  12. homeguard

    Determining the day of the week from a date.

    Does anyone have code to tell me what day of the week it is if i put in a date?
  13. homeguard

    Triggering an Event when new record is created

    Hello, I need to run a series of code when the user saves a new record. The problem is i only want this code to be run once when the user saves the record for the first time. anyone have any suggestions on how to do this?
  14. homeguard

    form view error?

    so i have a form that when i open it up it looks like a datasheet but when i make a button to open it up it looks like a single form. I disabled form view and everything but still get this problem. Anyone had this problem?
  15. homeguard

    Open Dialog Box

    I am trying to make an open dialog box that when you click the button it prompts you to select a file, and then has a message box staying what file you selected and the file path. for some reason i cant find the code to make it display the file name and path. Here is what i have: Private Sub...
  16. homeguard

    Saving Records to a table

    Hello, I have some unbound text boxes on a form and want to save the information to a table, how would i do that with a command button? also does anyone know any good calendar that auto populate off of a table? something like what a sharepoint calendar does. Thanks
  17. homeguard

    Showing/Hiding Webparts when filtering

    Ok so i have two lists on a webpart page One list (the upper) is a list of projects. the second list (lower) is a list of tasks for each project. I have list one with the projects filtering list 2 (tasks) with the project ID. I want make it so no tasks will show up unless the user uses the...
  18. homeguard

    excel button position

    Hello All, I am trying to get the position of a certain button on my excel sheet here is the code im using: Dim r As Range Set r = ActiveSheet.Buttons(Application.Caller).TopLeftCell MsgBox r.Row 'row number for the button MsgBox r.Value 'its value It keep telling me "unable to get...
  19. homeguard

    Advanced Tool Tips / Help Box

    Hey i need a way to make an advanced tool tips or say a help box. I need it to be able to be formated and or accept returns. Anyone done this before? Thanks
  20. homeguard

    Prepopulating a form by URL

    I am looking to prepopulate a form i made with ASP.Net, I used prepop function with my old reg ASP form and it works but i cant get it to work for my .Net form. Anyone know what i am doing wrong? ASP: Default.asp?prepop=yes&member_id=1235-456-7890&member_plan_code=United ASP.Net...

Part and Inventory Search

Back
Top