Search results

I have an activeX spin button located on a form which increments a text box value from 45 to 1000 in increments of 5. This works fine, but if the user wants to put in the value 995, that's a lot of spinning. I have been trying to do the same with a slider control which seems a little more...

I am having problems setting two date time picker controls values on the load of my. I swear this used to work in another form but gives me an error that the control value is read only. Ideas? Private Sub Form_Load() On Error GoTo errhandler Me.ActiveXCtlBeginningDate.Value = Now()...

I’ve been building an application to do word searches in those puzzle grids for my youngest son. You know, the kind where words are placed backwards, diagonally, forward, vertical, horizontal? Well , the app works fine and locates everything. My dream was to have the app find the word and...

I have a report based on a query. 14 of the fields are text (Memo). Each of the text fields are actually comment fields associated with a subcategory of questions. In other words, if the person recording the data from question 12 to 20 needs to make any comments on that group of questions...

I just wrote some code which removes exact duplicate records from an imported table. In order for it to work properly, I need to add an autonumber field manually to the table, remove the duplicate records, then delete the autonumber field. Removing the field is easy via code. I need to know...

I have been developing a "survey wizard" for use in my company. There are three sections needed in each custom form as follows: 1) The form header contains general information for each survey. 2) The form detail holds the questions and answers for each survey 3) The form footer holds the...

I have developed the need to operate a third party app late at night. In order to do this, I am using SendKeys. Seems the app opens fine. Once I get through the intro screens which are all dialog boxes, I need to be able to get into some utilities via the third party app menu bar. All I...

Hi, I have spent the past few days working on a form on-the-fly which is a questionaire. I have been able to add labels, option groups, (what a challenge that was) and other controls with a little sweat. Now I'm stuck. I have been trying to assign a function or subprocedure contained in a...

I am trying to run through the tabledefs in a remote Access 2000 database. While experimenting, I had no trouble looking at the tables. I then Jet password protected the target db. I have fumbled with the help facility and as a loss how to code the connect parameter. My code so far: Sub...

Happy New Years everyone!!! I wrote following procedure (with the help of The Access '97 developer handbook) in Access 97 and is only a small part of the app. I converted the db to Access 2000 and it runs fine. Then I wanted to make things work a little different so I figured I would rewrite...

Hello all! I have a form with 58 question option boxes. I test whether the data entry person has filled out all the required information in the form header prior to allowing them to answer the questions. If the required info is not entered, I want to disable the question controls. If...

I know I've seen this somewhere before... What I need to do is test if a form is open (which could be true or false depending on the user's circumstances) and close programically it if a true is returned. I know how to test if a table exists in the tabledefs collection and then delete the...

I have exhausted my resources on this issue: In an error handling routine I capture the user's entire screen by having a message box appear instructing them to press the "Print Screen" button on their keyboard. I then invoke the clipboard via code and write the bitmap immage to table as an OLE...

I have a database which has a table containing two OLE fields: 1)Database 2)Shortcut Each record contains a database and a shortcut to the database. I would like to know how to copy the imbedded database to a file location such as D:\Data\My Documents. This should be executed by code. If I...

I have a module which produces staistical data which is then fed to a detailed report. I currently use a form filter on which a user selects custom criteria for their reports. Our upper management likes to have a report which shows the statistics for every unit, which is a total of as many as...

I have an auto grading examination form. Recently, I added a countdown timer which ultimately will warn the student when there are two minutes left and save and exit the exam when time runs out. For the two minute warning I have been using the "Beep" from Access. I would like to know how to...

I've been compelled to work on a data entry form our users have been using for quite some time. I have designed a cleaner version but our users do not want to use it. (It was based on ideas and help from Mr. Hartman--Thanks Tom!) My version uses continuous form with data entry occuring from...