Im trying to help my son with a school project his teacher assigned him so were both new and learning.
The assignment is that he is an employee for a bank and his boss wants him to create an access database for a simple check register so other employees can enter the check information. It has...
We are both on the 192.168.10.???/24 scheme, we are going to change to the 192.168.90.???/24 because we have less computers and printers and things so its easier for us to change everything then it is for the other company.
we are joining networks with another company and they are already setup on that network scheme, so in order to keep from having any conflicts with ip addresses they want to change to the 192.168.90.???/24 scheme. So I just wanted to make sure when I did this that I would get everything correct...
I'm stepping in for a guy who left, and im a bit new. My company wants me to change our internal ip address from a 192.168.10.X/24 scheme to a 192.168.90.X/24 scheme. My question is this. What all do i need to change. Do I change the scope on the server? Do I change the allowable addresses...
I have two tables: Property and Propman
They both have the following fields
PropertyID - Example 786
DeptNo - Example 01
IncdNo - Example 897
YearOf - Example 07
I'm trying to compare the two tables to find any records the have the same deptno, incdno and yearof but have different property id...
I want to run an update query on a field that has a value of "C" right now. I can do the query but not sure what to put as the new value in enterprise manager. I dont want to put "null" cause that is not considered blank. Any suggestions!
I will look into the pop up issue. My question would be since this is not a browser or internet issue would the internet settings still play a factor as far as popups being blocked in the browser settings. I disabled all the activex settings in my internet options to see if it would cause my...
Sure, but will that table be the only one thats effected. For example if I'm missing records from that table, will other tables in my database (483 tables in my database) be missing records.
Can someone please explain if an SQL database would have to rollback for some reason, does it roll back all the data or just some of the data in certain tables? Can it do both?
I have a database and a certain table is missing entries. There is a field in the table called RECID that basically...
A caption box does not appear. And I dont believe that this file is in version 11. I dont have it on mine and I looked at a few others the run the viewer just fine and they dont have that file either.
I have a couple of computers that have the activex viewer installed to view reports. When started up thru an application written in clarion it starts up then flahes right off the screen and quits. I have uninstalled/reinstalled. Double checked the permissions in the registry but this happens...
Hey this worked out perfectly. Can I change the order by in the statement to order it by month for that particular year.
So basically the user enters the year and it gives all those records for that year, then can I order by month for that year?
hh:nn:ss;;"Off";"Off"
This worked out great exept for times that started at midnight or 00:00
the other example =IIF([Arrive] Is Null,"OFF",[Arrive])
keeps giving me an error
I have a report that has a time field. If that value is not filled in or left blank, I want that value to be displayed at "Off" on the report. I have tried several statements but they dont work:
Nz([Arrive],"Off")
SELECT IIF(IsNull([Arrive]), 'OFF, [Arrive])
=IIF([Arrive] Is...
Ok, just so I understand where to put this.
This statement would go on a form by itself, the user enters the 4 digit date and then it would take that date and open another form "frmFindDates" and display it:
Private Sub Combo27_AfterUpdate()
Dim intYear As Integer
Dim strWhere As String...
I have a database that is basically a log book for recording flight hours. We enter the date like 01-jul-05 for example in the tables. I have a form that asks the user to enter the year to print out an annual report of flight times for that whole year, but I only want the user to enter for...
no i could not ping the other computer by ip, if thats what you mean.
I'm not sure if I did something right on initial setup, but when I was installing 2003 server on the server it asked about DHCP being static and I said no I wanted it to be dynamic. I thought this was right because I use a...
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.