Search results for query: *

I have a few Ignorant questions about the benefits of splitting my database. 1. Will it enhance performance? Or is performance in how I distribute the front ends? 2. If data is stored in the back end why do I still have my tables being populated in the front end? 3. I can think of a bunch...

OK first, I'm trying to learn how to use Access without any official training so please be gentle. I've created a bunch of 3D pie charts and have been asked to have each category drilled down by clicking the piece of pie. Would this called a sub report? I'm not sure where to start or what...

I am attempting to build a paredo chart and when I run my query I get the resulsts EXCEPT I am getting a blank value (Level1) with a Total of 0. Why do I keep getting a second value of nothing? Any help would be great Thanks!! Here is the code from the SQLView SELECT tblcomments.Level1...

I have an unbound microsoft 2.0 textbox (because it displays scrollbars without needing the focus) and was wondering if there was a way to only allow the user to view the text and not be able to change its contents. "Sort of like a label with a scroll bar (I don't know how to do that either)...

To anyone - I have a form where scrap is entered into a listview control on that form. I have made it so if the user dbl clicks the control he/she can edit the information. I can update the information no problem. My problem comes when I go to close the form I get a message saying Write...

When I click the button to activate my code I get a flash then it goes away. Why can't I get the file to stay open? Are there settings that need to be modified? Anyway here is my code. Any help would be great. Application.FollowHyperlink "C:\Documents and Settings\myname\My...

I was wondering how to right click a header on a ListView control and be able to search for a record? I have seen it used on some purchased software that uses Access and was wondering how the heck it works as it would be a nice feature on my form. I'm not sure what type of control would allow...

I have a Query that definitely contains information! I step through my code and the information is being retrieved but when I display the ListView control I have 4 fields with no values. I am not understanding what the heck is going on here. I'm sure it's something simple. I've recreated the...

I'm working on a db to collect data for our machining group and was wondering if there is a way to save the user settings for a ListView Control for diff users? I made the ListView so the headers can be rearranged so each person could have their information readily available without having to...

I am tring to look up/retrieve information information stored in an Access database. Everything is fine until the recordset returns a null value. I am trying to use an IIF statement but I keep getting an error saying "Either BOF or EOF is true or the current record has been deleted. Requested...

First off I'm not even sure if this is the right area to post so please advise if not correct. Second I just started trying to convert my Access DB to Visual Basic (Visual Studio). I created a form and a ListView. I can get the headers on the form with no problems. I created an ADO...

I've finally gottento the point (I think) where I can start tweaking things a bit and I've noticed the time it takes to count how many files I have in my recordset is quite long. Is there a quicker way to know how many files are in the recordset? Here is what I have so far. rst.MoveFirst...

OK this is about my 200th post in the last two days so I'm about ready to jump off a cliff. I'm pulling data from a Lotus Notes database(Domino Server). I have some dummy code that imitates exactly what I'm trying to do at work. The problem is the progress bar doesn't update and the label...

I'm attempting to pull information off a Lotus Notes db and have no idea what the format of the information looks like as it differs from line to line. When I run the SQL statement I get a Syntax Erro (missing operator) in query expression. This variable has "/" and "'" and ":" and "&' in...

I am attempting to pull in information from our Lotus Notes database into Excel and have been successful. Now I'm trying to pull in only the data based on certain criteria. In my code below I need to have the Entity = "AMK" I need to have the Line_Reject = "1" and the CQARNumber needs to have...

I have some pictures that I'm allowing the end user to view and was wondering if there is a control that would allow the viewer to scroll in order to view the entire picture(s). Any help would be great! Thanks.

I created an Access Report put some data labels on it and when I run the report the labels don't appear. Am I missing something simple here? Any help would be great!! Thanks.

I have a ListView control and am wondering if there is a way to click on the header Date Ented and have the List View sort ascending then descending. If not no big deal but right now I have two buttons at the top of my ListView for sorting by date and it might clean up the appearance a bit...

I'm trying to query some chemical records based on the user typing in what he/she thinks is the name of a product. I created a simple query but it's not returning any results when I use the following statement. I'm sure it's something simple but obviously I'm not sure what. This is some low...

On other forms/charts this code is working. For some reason this one keeps bombing out. I keep getting a 1004 run time error saying "Uable to Set the HasTitle property of the Chart class" This did work then it quit. I have Microsoft Graph 11.0 Object Libray selected in my references but...