Search results for query: *

Hi everyone. It's been several years now since I've used Access and I've forgotten almost everything I used to know about database design. I'm trying to create a very simple database to track some statistics and I've run into a block that I hope is simple for most of you. I have a table...

Hi There, I'm currently working on a trivia contest and I'm hoping someone in this forum can help me. The trivia question is "The original designation of cores of apples per Motorola"? I'm afraid I don't know much about computer hardware, but Tek-Tips has helped me solve a lot of...

Hi there, I'm a total UNIX newbie with what I hope is a simple question. What is the command to determine which operating system I'm running on? We are currently on HP 11.0, however our system had massive problems last night and I suspect that sometime during the mess we switched to a...

Hi there, I feel like this should be an easy thing to do, however the answer keeps eluding me. I have a query and this is one of the fields being calculated and displayed: Group Info: IIf(IsNull([Form1]),Null,100-[Form1])/100 Form1 is an average which is being calculated in a another crosstab...

Can someone please help me figure out the correct syntax for this module. I've been struggling with it for the past hour an it's about to drive me crazy. I have the following Subroutine defined in my form... Private Sub ControlDisable(ctl As TextBox) ctl.Locked = True ctl.Enabled =...

In a multi-select listbox is there a simple way of determining which item was just clicked. Here's the situation. I have a listbox on my form with about 10 items in it. The users have asked that if a certain item is selected then no other selections in the box are allowed and vice versa...

Hi there, I hope there is a simple solution to this issue. I have a report which is formatted with 3 columns. There is also a subreport in the Report footer section which I have used as a totals section (don't ask, trust me it's necessary to use a sub-report). Everything works fine, except...

Can anyone tell me why this code does not work properly? Here it is in it's simplest format. My table contains about 4,000 records, however the textbox on the form always displays a count of 1. Dim strSQL As String Dim dbs As Database Dim rs As Recordset strSQL =...

Hi, I hope someone can help with this. I don't know if it is a simple question or not. I'm developing a database for a set of users and for every report in the database they have requested an accompanying graph. I have never used charts or graphs in Access before, so I'm just now learning...

Hi there. I'm hoping someone can tell me what would be the best way to accomplish this. I have a report which needs to display a date range in it's header. The problem is that this report will be called from several different forms. (It will never be opened directly from the database...

Hi there. I hope this is a simple question which someone can answer. I originally posted this question in the Microsoft Office forum a few weeks ago, but didn't receive any responses. At my company we use Office 97 and many times I use Access and Excel to display and manipulate text files...

I really miss that keyword search feature. I hope Tek-Tips has it up and running soon. Anyways, I hope this is a simple question for someone out there. When I import a text file into Excel using the Wizard, Excel will display all my .txt files and all my .prn files in the open file dialog...

Hi there, I hope someone can help me debug this issue. I created a database with a command button that automates importing a text file. The command button code is fairly straightforward, just a TransferText statement and an append query. When I run the code, it imports the file just fine...

I'm hoping this is a simple problem for someone. I'm trying to display a phone number on my report. The number is stored in a table with no formatting at all, just numbers. I've applied an input mask to my report in order to display the phones correctly, but it isn't working quite right...

I don't think this can be easily accomplished, but since there are some very smart people hanging out in this forum I figured I would throw out the question and see what ideas are out there. I have a request from my users to design a form which would include a combo box. However they want the...

Hi there. I'm sure this question has been answered before, but I tried doing a keyword search in all the Access forums and I couldn't find an answer. I need to be able to reference a control on a form/report by using a variable. How do I do that? What is the correct syntax? Here's some...

Hi there, I think this should be a fairly simple question, however I went to a big luncheon this afternoon and my brain is basically fried for the rest of the day. [sleeping] I have a multi-user database and I want to add an application icon to it. The problem is that my users are in different...

Hi hope someone out there can help me. I've already tried doing a keyword search on this issue and I didn't find any helpful answers. I have an Access97 database with linked SQL server tables. When I try to delete a row in the SQL table I get the famous "You and another user are...

Hi there, I'm really hoping someone can point me in the right direction here. I'm trying to create a Word merge document (Word 97) with a plain ASCII text data file. I have everything set up and the merge works perfectly. Here's the kicker. I would like to also have the ability to have...

In Access 97, is there a way to turn off the auto correct typing feature. I've hunted through the menu options and couldn't find it. Here's my problem in a nutshell. I'm typing words directly into a table and for my project I need to make sure that these words only contain the 26 letters of...