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 SkipVought 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: *

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

    table corruption in access database.

    You could have answered your own question there I am afraid, 150 fields is a great many for one table, have you tried splitting the table in seperate entites and joining the via relationships ? go to http://support.microsoft.com and do a search for JetComp.exe this exe is better at repairing...
  17. sixsmithc

    Need recommendation on a good VB Book!!!

    If you reference the windows common controls you will get a date picker which allows the user to pick a date from a calender, this is the easiest way to ensure you get the correct date format you require. You can also bind the control to your data source like a normal text box. The controls...
  18. sixsmithc

    SQL problem

    you need to encase your field name in square brackets eg "select * from [Table Name] where [field name]='String'" hope this helps Thanks Carl
  19. sixsmithc

    Save Buttom

    If my thinking is correct you want to replace the value of a field in a record in an access table with a combo box on a vb form ?? If so the just binding the datasource property of the combo box to your database, and your datafield to the field, this will save the information in the table
  20. sixsmithc

    Migrating To SQL Server

    Just after some advice really ..... I have a written a VB program for accessing an Access database - the main table in this database has roughly 300,000 records and 25 fields. I am thinking of moving to SQL server anytime soon - does anyone think there will be enough of a performace benifit to...

Part and Inventory Search

Back
Top