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
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...
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...
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...
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
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...
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
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
...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...
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
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...
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
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...
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...
you need to encase your field name in square brackets
eg "select * from [Table Name] where [field name]='String'"
hope this helps
Thanks
Carl
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.