Search results

Thanks for your help.

Is it possible?

Hi I have a form with three calulations to get the final amount. Fields 1. Start Time 2. End Time 3. Calculates the Time inbetween (Start Time & End Time) 4. Pcs Made 5. Calculates Pcs Per Hour I can enter up to five of these fields so I can get an average 6. Total Pcs / Hour Made 7. Average...

Here it is: SELECT [Vender Sort Query].[Vendor Name], [Vender Sort Query].[Phone Number], [Vender Sort Query].Fax, [Vendor Name].Address, [Vendor Name].City, [Vendor Name].State, [Vendor Name].[Zip Code] FROM [Vender Sort Query] INNER JOIN [Vendor Name] ON [Vender Sort Query].[Vendor Name] =...

At the time there is only me and one other person in the Database. Its rather low traffic. At first the form didnt load as fast, even after restarting the computer to make sure it wasnt my system. I tried about 3 times and it loaded really slow. But now the last couple of tries have been okay...

Yes the tables are linked. 5 computers have a copy of the FE and the BE is on the Server.

I have created a Purchase Order Program with Access 2K and everything is going well until today. I updated a query for a combo box. Its not a complex one. But now when I go to open the program it takes about a minute to open versus about 5 seconds. Any input on this would be appreciated...

Got it to work with DBL's help in a private message. The posts wasnt working at the time. Thanks Pat. Youre post would of pointed me in the same correct direction. :)

I have an inventory form, that includes the Product Name, then I have a subform that shows records of when things are taken out of and put back in. Each record in the subform has a new entry to show what date it was entered. I want to make a query to pull up the Product Name and QUantity On...

Ty

Not exactly, I'll try to clarify. Lets say I wanted to print up a report for the month of April. I need to set something up so that when I print it out I can tell it to put "April" in a field somewhere. I dont know if this is possible or not. I was curious because it would help the reports...

Okay, I have a Report that works off of a Query. I can input 2 dates and I get the results of a month, year or week. What I would like it to do is: Before I print out a report, enter in a field to specify Month. So if i wanted to print records from 6/01/02 to 6/30/02, I could enter in...

Okay I doubled checked something. I opened two DB's. One the right clicked worked and the other it did not. So I know its not the mouse. I cant seem to find the contextual property to tell if its false or not. Thanks. John

It only stops working in Access. Now whenever I go into the DB, I cant right click combo boxes or text boxes. I do this to usually select color or size the box to grid. That kind of stuff. Ill check the contextual control and see if that will do the trick. Thanks john

Thanks for the reply. I checked what you said and its set to Yes. And its still not letting me right click on anything. Could it be something else?

I have Access 2000 and sometimes the right click feature turns off of me. Is there a setting for this or an icon not selected. Its really wierd. Thanks.

Okay in my References only these are checked: Visual Basic For Applications Microsoft Access 9.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1 Library All the others are unchecked. Is this okay or is this why Im having the problem with the other computers getting the...

I did a search in my Access Help and it pointed me in the direction of Tools->References I have Access2K and am missing this option. I did a search in the Access Forum and couldnt find my problem. Any help on this would be appreciated. Thanks. John

Hi Jerry, I split the database so I can run the program on our network. I put the Front End on the computers in the office and the backend is on the server. They are linked to the same *.be file. For the "UnitsReceived, UnitsSold" formula, it is only working on my computer. Everyone else is...

Dude!! It works! Just so I know can you explain that formula a little. Thanks again! John