Search results for query: *

This should be a simple deal but I can't seem to figure it out. Any help is appreciated. I have 2 queries- productionWork: SELECT production.productionDate, employee.name, clProduction.hours FROM production INNER JOIN (clProduction INNER JOIN employee ON clProduction.employeeID =...

My question to the community is, what is the best practice reguarding queries and reports. To explain- you can set up queries, then use the query as the record source of a report. Or, you can just build the query directly in the report. I have just built the query into the report, unless I...

Alright, this is a little hard to explain but I'll do my best. I'm also not sure this is the forum for it, so please advise if a better forum is available. I have 2 Access database files: sales\sales.mdb accounting\po.mdb Important users: me- read\write all directories shop & sales- read to...

I've been struggling with getting my internal frames to show and found the problem to be bigger than my code. Any ideas on what the problem really is is appreciated. My code has one class for the JFrame with a JDesktopPane (desk). This class appears and seems to work fine. I have another...

Greetings. Back when I was in school- say 5 years ago, the professor seemed to like to write his code using a non-static main() method. I forget how he did it and all, but now that I'm actually using JAVA its perking my curiosity as he said it was a common practice. I know that the book...

Greetings. I have an order form in which the sales force can see their open order and see the production done so far. The production is listed in a list box which simply lists what machine, the feet, and the labor hours, then avg(feet/hours). This is simple and works fine. At the bottom I...

OK, I know this is probably the disasterously wrong way of doing it, so I need a pointer in the right direction.... Everything works, but not well. (I know, if it ain't broke....) I have a form to collect data about invoices recieved. This form is in datasheet and has the following open...

Greetings Y'all! I have a network database on the file server with multiple users. If I set up a global variable to store the username, is the global variable residign on the server or is that on each users computer. In other words, if User A opens the database, and the global variable is A...

Has anyone seen this message: "couldn't find file System.mdw. This file is required for startup." I recieved this message when trying to open a file over the network. All other computers in the office can open the file and everything works fine except on this one computer. The file server...

I'm working with multiple databases that do not have linked tables. I do not view linking tables as a viable solution as performance will be an issue in the future. My file server has the following directories: Accounting (viewable by all, writeable by accounting staff- me) Sales (writeable by...

Hi all- We're back with another installment of the single quote/double quote problem. I have been reading posts for a while now on this, but none quite fit the problem... sqlst = "INSERT INTO saleItem...

I work for a MFG company. I am in the process of updating a sale database... I have the saleItem for all the items on a sale. Each saleItem has parts assigned to it, and work assigned to it. What I need to do is create a way to copy sale items since 2 sale items can be very similar, and later...

I've been searching this forum with no luck... Any help is appreciated. I have a Winblows XP Pro computer that acts as a file server using advanced file sharing. I would like to find out which computers are in fact connected to that server at any given time. Is this possible? Thanks in...

I have a database for sales to use for quotes. On one form, I have some tabs where they enter details about the quote. The last tab is a totals tab. If they close the form then reopen it, the totals are all filled in. How can I get the totals to calculate without the salesmen having to close...

I have a form to look up a part. So I have a text box where the user enters part of a part number to limit the list. On this text box, I have the following code on the onkeypress event: Dim sqlst As String sqlst = "SELECT part.partNumber, part.partDesc " _ & "FROM part " _...

I have a file server that has Windows XP Pro with SP2 on it. I have Norton Antivirus 2005 and Spybot S&D 1.4 with the latest updates on both. Since this is a file server no one directly uses the computer. I just ran Spybot to find 2 registry entries come up under the title of "Windows...

I have a Windows XP Pro computer and I want to do some advanced file sharing so I can limit access to some directories. That's simple enough, so here's the meat and 'taters of it... The computers I want to share files with are in a domain. They are all either Windows XP Pro, or 2000Pro. The...

This one is bugging me.... I have this code: dim dbs as dao.recordset dim rst as dao.recordset so = InputBox("Enter the sale number.", "Sale Number") sqlst = "SELECT workAssign.workCoID " _ & "FROM workType INNER JOIN (workCo INNER JOIN ((sale INNER JOIN saleItem ON...

I have a form in datasheet view which is linked toa partassign table with assigns parts to sales items. On this form, I have a combo box that has part numbers which is populated by a part table... When the combo box loses focus, it looks up a part description and populates a text box with the...

Is it possible to treat forms as objects and load forms multiple times? I'm building a Purchase Order database in Access 2003. So I have a po form for entering po's. What I would like is to be able to look at 2 po's at the same time, so I want to be able to open the po form multiple times...