Search results for query: *

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

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!

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

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

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

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

I have 2 computers. I is acting as the server with admin rights and all that. The other computer i can log on to the domain and everything. My problem is that on the server I have a shared folder for document. The server cant see the other computer and the workstation computer cant see the...

I have 3 fields in a table. Current Rate, Market Rate, and Renewal Rate. The current rent could be higher or lower than the Market rate. But I want to make the Renewal rate automatically calculate based on this formula. The Current rate cant go higher than 20 dollars, and it cant go over the...

Ok,here it goes. I have a form that a user inputs two date ranges on. Once entered it runs a query based on those two dates and returns records of expiration dates between the dates, and then generates a report. This is just a general report (list) with their name and address and the date...

I've tried using expression, code and macro, but I'm doing something wrong. I have a form that you enter payments on. Customer has a starting balance. Customer makes a payment. I want to subtract the payment amount from the starting balance to come up with a current balance. And each time...

Im having problem with the IF function to return a value or 1 or 0. If a certain cell has a value no matter what the value I want it to be "1" if that cell has nothing typed in it I want the value to be "0". I tried several things but nothing works or I get an error...

I have a database for college basketball. I have a conference table, then a table for the teams within that conference, and then the schedule for each team. When I set up the report to show all the games broke down by day, it shows the two teams playing each other twice. How can i stop this?

I know this is probably easy to answer, but I've having a problem with this code. I have a command button. I want it to open a form called Cruiser. What am I doing wrong??? Private Sub Command1_Click() On Error GoTo Err_Command1_Click Dim stDocName As String Dim stLinkCriteria As...

Ok, this is what I want to happen. On a form, in single form view, I want to be able for the user to type in their information and when they are done, hit a button that will add/update the records. After that I want the records to be displayed in datasheet view on the same form. I know this...

I have a report that will print out info from a query. That query is based on 4 tables that are linked together. Basically, I have a table with name and address and so-on. The next table that is linked to it is for property accociated with that person. So their is one person, but that person...

I want to autofill several records if the information is the same. For example: I have serveral fields from a table such as name, address, city and so on. I want the user to click a check-mark box if the billing address information is the same as the shipping information and have the shipping...

I want to have a main form with several sub forms based on a query. The only problem I have is the query is based on several linked tables and the query has lots of fields from these table. When I try to design the form, I open up the field list and it says too many fields defined, I guess you...

I have a form with one text box on it. I would like the user to enter a social. If there are any matching socials from tbl suspects, I want it to display the information from that table, if not I just want it to display "No Records Found" I tried using the after update event...