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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sixsmithc

  1. sixsmithc

    Firewire port onto network

    I have a notebook with an inbuilt Firewire 1394 port, how can i connect it to my ethernet network (RJ45 Cat 5 cabling). Do i need to purchase a special adapter ? I am running Windows XP home edition, any help would be greatfully appreciated
  2. sixsmithc

    Background Image

    you could try setting the size at runtime
  3. sixsmithc

    Checking Date on a network

    The entire point of my question was that the Net Time doesn't syncronise the Date, it only does the time
  4. sixsmithc

    Checking Date on a network

    I'm afraid i have been clear. Basicly at the moment my form looks at the date on the users computer when booking an appointment. The rule is that the appointment must be within 30 days or it is not classed as an appointment. This works fine except the users can change the date on there...
  5. sixsmithc

    How do I limit view of certain form fields for certain users in Access

    The following code returns the network log on name once you have a user name you can then set the controls visibility based on who they are. hope this helps --------------------------- Private Declare Function apiGetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal...
  6. sixsmithc

    Checking Date on a network

    Hi there, I've got a little problem. I need to check everytime a user enters a date that it is within a certain time (ie 2 weeks maximum) but the trouble is you can easily get arround this by changing the date and time on the local computer to fool the code. One option is to have a table in...
  7. sixsmithc

    Database Corruption - PLEASE HELP !!!!!

    Hi, My Access database has crashed, it won't repair all the way but I can see the tables but can't read or copy them. Is there any way I can change the permisions to be able to read them so I can get my data back, I would be most gratefull !! I am using office 97. Thanks Carl
  8. sixsmithc

    Office programs very slow to close

    Hi I am running Office 97 on Windows 98 Second Edition PC. The problem I have is that when you close Word or Excell when you have had a document open it takes an age to close. If you close any other program the computer is fine. I have tried a couple of things to sort this out without success...
  9. sixsmithc

    Setting the focus to a Listbox item

    hmmmmm Two thing could be going on here... add Forms!MainForm.List1.setfocus If that aint working what I would do is this ... dim STR as string STR = Forms!MainForm.List1.Selected(itm) Forms!MainForm.List1 = STR That should work Cheers
  10. sixsmithc

    How do I Delete a file that is currently in use

    You could try opening the database exlusively and then closing it again to see if that clears the problem. If you are using NT server you could check to see if anyone is accessing the LDB or MDB file and if they are kick them of it. Cheers Carlos
  11. sixsmithc

    Resize the desktop

    Is there any way to resize the users resolution through VB code, I have a program that needs to be run at 1024 x 768 and most of our computers run at 800*600. All the machines can handle the resolution it would just save me the hassle of resizing every computer running this program. Thanks In...
  12. sixsmithc

    Right Mouse Menu's

    Can anyone tell me how to create custom right mouse button menus for use on my forms? Is there a simple way of doing this or does it involve API calls and such ? Thank you Carl
  13. sixsmithc

    User Information VIA API calls

    Hi I can get the current user name and computer name by using the relevant API calls but is there any way of determining if the user is a member of a certain NT Group (like domain users) At the moment I have a seperate table with relevant user options but everytime I add someone to the NT...
  14. sixsmithc

    Help!!! How to allow user changable recordset through textbox entry

    you need to split the SQL and variable because VB doesn't know which is which EG dim strSQL as string strSQL = "select * from [table name] where [Field Name]='" & me.text1.text & "'" EnvData.Open strSQL
  15. sixsmithc

    Subtract a time from a time and get the number of hours different

    you can use the datediff() function

Part and Inventory Search

Back
Top