Search results for query: *

Hello everyone! Ok, I made this program that is, mainly, a Clock that displays messages stored in a db. (it can also show a slideshow of images but this part works) My problem is: The scrolling speed is slow... The computer that will be used to run this is a 733 with 256mb ram and Windows 2000...

Hi, Ok, quick description of my troubles. I'm trying to link a SYBASE table by ODBC. Access makes the link with no problems. Now, the trouble is that the original table as a 2 field primary key. When access links it, it takes only one of the field as a primary key. What happens then is that I...

Hi, Some of my users start complaining about report creation being slowed down since we changed the server of our network. But no changes have been made in the application itself. we were using this type of paths before //ServerName/SharedFolder/App/Application.mdb Now we use...

Hi, I've been reading quite a few posts now but wasn't able to find the answer I was looking for. I want to find the Access 97 equivalent for Access 2K's CurrentProject.Connection I need that to access the current database with ADO from Access 97. Dim cnn As ADODB.Connection Set cnn =...

Hi, I'm looking to build a little tool that would allow me to find a value in all the tables of any database. I've done so using Tabledefs, Records and Fields. But it's slow. I'd like to know if there's a faster way to do it or if I have to endure the long process (Well it's quite long on big...

Hello, I would like to modify the ControlSource of a textbox with code. My problem is that I change the ControlSource of controls from another form opened in design view. I want these changes to be saved and permanent. It works fine to change the ControlSource expression but for the expression...

Hi, When I reply a message, outlook 97 deletes the original message from the inbox. How can I disable this thing? Thanks Salvatore Salvatore Grassagliata

Hi, How do I Use Crystal Reports with Access? I have a report witch is exactly what I need in CR and want to be able to print It from my Access 97 database Thanks a lot! Salvatore Grassagliata GrassagliataS@hotmail.com

Hi, I get this error when I change my form's record source. Run time error '2001' You canceled the previous operation What's wrong?? can anybody help Thanks RickBerem

Hi, Can one of you guys can tell me the name of the graphic DLL... I installed VB 6.0 on my computer and the install upgraded a DLL so now my graphics can be seen only on pc that have VB installed. Thanks Rick

Hi, I have a form where a lab operator inserts the results of some tests on the products. I also have a min and max for each result that the operator writes in. When the result isn't between the min and max the backcolor of the textbox turns red. It's ok for that... my problem is when the...

Hi, I'd like to call a query I've build with the query builder from VBA and then use the data the query returns in the code. is there anyway? thanks RickBerem

Hi, I've build a form that enables a user to "create" a query by selecting and entering the data he wants to see. My user can enter 2 dates (beginning and end) and my research query is supposed to return all the production data between this 2 dates. I use this line of code...

Hi, I was wandering if there was a such thing as a Access viewer that would let a user print an access report without having access installed. I want something like that because users just fool around with the pc and I'm tired of reinitialising the pc each week or two... any ideas? thanks...

Hi, I have a query that builds a report. The user of the report want me to add a field to it. The field is a memo. The report, contains all product made in one week. All these productions are grouped by UPC number. So if we made a product 3 times in a week, it's only one line in the report...

Hi, In an Access 97 vba code, I use a common dialog to show the "printer" screen where my users can select the printer they want to print their reports. my problem is that I can't handle the situation where the user presses the CANCEL button on the "printer" form shown by...

Hi, I have a quantum lm 30gig Hard drive in my computer at home(slave) and got a 4.3gig fujitsu as my master. Since I bought my quantum HD I have problems with it... first when I let my bios autodetect it, my system takes ages to boot. when I set it manualy only leaving logical block on, it's...

Hello, I was wandering if it was possible for a checkbox group to return more than one object checked. for example, My table relates to pieces of equipment used on different production lines... And some of these equipments are used on 2 lines or more. What I would like is that when the user...

Hello, I link a query with a form in the way that the query returns records with the criteria written in the txtboxes of the form. My problem is that the query will still prompt me if I write nothing in the text boxes. What I'd like it to do is if there's something in the text box then...

Hello, Is there any way to force a form to stay a certain size even if there is a maximized form opened just before? One if my form as a button that when clicked opens another form... the thing is the form is maximized and the form that needs to be opened opens maximized. but I want it to...