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 wOOdy-Soft 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: Bobnz
  • Content: Threads
  • Order by date
  1. Bobnz

    error 438 object doesnt support this property or method

    gettting the aforementioned error 438.... when this code runs Private Sub cmdLoadOLE_Click() Dim MyFolder As String Dim MyExt As String Dim MyPath As String Dim MyFile As String Dim strCriteria As String MyFolder = Me!SearchFolder...
  2. Bobnz

    problem creating materialized view

    I have a select query script that runs fine. I am trying to create a mview with it but when I try to create the view,it runs and runs and never creates the view; I have to cancel. I let it run for an hour without success, the actual select query takes about 5 seconds. create materialized view...
  3. Bobnz

    new m/board + new cpu pc wont start/no post

    I have installed new motherboard and cpu. New cpu is intel celeron D 2.4ghz processor m/board is foxconn 865a01-pe-6ls RAM is 512 mb ddr pc2100 I hit the power on button and the cpu fan starts up but nothing else happens no beep so post isn't happening. Any help much appreciated.
  4. Bobnz

    fill drop down list

    I have a dropdown list in a cell on a spreadsheet where the user selects a name and then all jobs associated with that person are displayed. I want to display only the jobs currently being worked on/ not completed. Completely new to excel although have done some access programming. I imagine an...
  5. Bobnz

    Check to see if email has been sent

    Hi, I have an email sub procedure that sends an order as an attachment. However if the company does not exist in outlooks contacts then outlook opens and asks the user to select the recipient. I want to be able to test to see if the order was sent or cancelled and output an appropriate message...
  6. Bobnz

    upgraded to xp pro from win 2k and can no longer access my other

    I have just upgraded my pc to xp pro from win 2k and can no longer access my other drives (win 2k). other drive(e:) shows in bios and in my computer but cannot open. c: drive is raid array 0 using 2 drives and hot rod 100 pro card, e: drive is also connected via raid card rather than m/board...
  7. Bobnz

    problem reconnecting to domain for standalone pc

    Hi I have a win 2k server + home network; one of the local machines running win2k pro is used a lot as a standalone pc but is also able to connect to the domain. However after it has been used as standalone for a while it will not reconnect to domain, gets as far as applying computer settings...
  8. Bobnz

    textboxes 'can grow' problem

    I have columns of text boxes in a report, They are set to 'can grow' which they do, but they grow behind the text box below?? or some actually show the text but superimposed over the text in the textbox below?? any help with this much appreciated
  9. Bobnz

    Problem using zero height and can grow in report

    I need to remove rows that hold no data from a report. I thought if I used zero height for the controls on the report and set can grow to yes that the controls would only be visible and take up space if they held data but.... This is what the report looks like now with 0 height and can grow...
  10. Bobnz

    change report controls datasource programatically?

    is it possible to change a reports controls datasources programatically? If so how? B
  11. Bobnz

    hiding controls in report programatically

    Hi I want to be able to hide controls on a report depending on the value of a global variable. like... if mode = "dc" then prodname.visible=false .... .... end if is this possible? would I use me.prodname? B
  12. Bobnz

    mapping drive to computer not in domain

    I have tried mapping a drive to a folder on the server from a pc that is on the network, but not in the domain. The user logs on to the local machine not the domain. I set it to reconnect at logon and to logon as another user. The other user being a user in the domain with rights to the folder...
  13. Bobnz

    Win 2k server (domain controller) unable to connect to internet via ro

    Hi, I have a small test network with one server running win 2k server. The server is a domain controller, the server cannot access the internet via the router ( dynalink RTA300 ). Yet users on the local machines can when logged on locally or on the domain. I have limited networking experience...
  14. Bobnz

    creating a new domain

    Hi I have a small home network with a HP Netserver LC3 I want to create a domain and setup active directory, more just to explore and learn than for any practical purpose. The server and network pc's come off a switch which also has a adsl router connected to it. Do I have to have a real domain...
  15. Bobnz

    date on insert not following regional settings

    I have field in a table that is date/time shortdate my regional settings for date (short) are dd/mm/yyyy when I perform an insert on this field the date gets inserted as mm/dd/yyy could someone tell me how to correct this. the date field is used in parameter query the user enters start/end...
  16. Bobnz

    how to: check to see if query returns value

    have a query that runs and need to check to see if it returns a value strSQL = "select ..........." if not isnull (strSQL) then ........... else .......... end if will this work
  17. Bobnz

    "no signal input" when server is booted

    Hi, I have a server (HP netserver LC3) that was switched off during a reboot sequence and since then there has been no input signal to the monitor. When switched on the fan starts :) and lights come on, on the cd drive and the main scsi drive. they then go out and the monitor never comes out of...
  18. Bobnz

    DoCmd.OutputTo acOutputReport values not showing

    I,m having trouble with a report that is based on a query. In the query the criteria for each field is a function that returns a value(this value changes) from a global variable. when I run this code... DoCmd.OutputTo acOutputReport, report_name, acFormatRTF, "C:\Documents and Settings\Bob\My...
  19. Bobnz

    using variables in reports, runtime error: 2147352567

    using variables in reports, runtime error: 2147352567 I get the above error when I try to preview a report, also says "cant assign value to object". I have a report with controls that I want to assign values to using variables. the variables are global so... txtcontrol = variable in open...
  20. Bobnz

    click in property window field highlights all text to the right,

    When i click in a field in the properties window I cant insert cursor without all text to the right being selected. clicking on the 'u' of the control name "txtuser_id" will result in all the text 'user_id' being highlighted. I want to be able to click on the 'u' and be able to use backspace or...

Part and Inventory Search

Back
Top