Search results for query: *

I recently posted a question on an Access Forum at Tek-Tips. So far, the response I have heard was that there was more value in learning ASP than in using the Access solution of Data Access Pages (DAPs). I was wondering if anyone has faced a similar decision and what the outcome was...

I am trying to create a GoTo record search for a form I have. This form has thousands of records so to find one or a group of records (sorted by a Category field) is a pain. My solution was to create a pop-up form that prompts the user to select a Category from a combo box - at this point, the...

I have developed a relatively robust database. It works great on a few machines and I have pushed it out to a server, but my boss wants more. He is interested having it be completely web-based and accessible by our intranet. I have dabbled with data access pages and trying to push my forms...

I have a form in which I want to do the following: 1. Select record ("primary") from combo box 2. Select one or many records ("secondary") in listbox (populated after selection in combo box). 3. Move "secondary" records selected to another listbox. 4. Click...

I have a report that includes a Group Header. I want that header to repeat for each page. Unfortunately, if I change the Repeat Section to "Yes" the report freezes and will not open (forcing me to do a CTRL+Break). I have tried recreated the report, but run into the same issue. I...

I am considering deploying our Access 2000 database as an MDE. My concern is that our users' needs are continually changing so I will need to develop and modify the existing database. I am unsure about how MDE and MDB files interact (if they do at all). I am pretty sure that you cannot modify...

I have a subform bound to a main form by a field called Category. The combo box which holds Category is the only item on the main form. The subform is set up as a datasheet and displays 6 fields of information. The format (datasheet) is such because users may need to go in and change one...

When I initially established my database, I had to import from excel. After some work, I was successful although I had to put the data into a new "temporary" table and then copy over to the primary table. Now, I find that my users will occassionally want to import data into a table...

I need to create code that creates an ID based on the current date. This is a maintenance log, so each day there will be a variable amount of jobs. The format I have is: FEB12_001 (for the first job of today). Within the ID field, I have created the following code (as a temporary solution)...

I am trying to add a Browse button on my form as my users will occasionally want to attach an associated Word or Excel file with a field. After reading about what is best to use, I believe that using Microsoft's Common Dialog Control, version 6 (ActiveX). Unfortunately, everytime I try and use...

I have a set of three forms that allow users to add and/or edit data. The forms have Add and Replicate commands built in. These work great except my client just told me that he may want to copy a record a number of times. So, he wants to click on the Replicate button, have a pop-up form ask...

I had a pop-up form that could be generated from double clicking on a field ("ID") in a subform. The purpose is to display additional pieces of data should the user want to see it. I am using the following code to do this: Private Sub txtTcID_DblClick(Cancel As Integer)...

In my code, I have a MsgBox that pops up after a field ("Category")has been changed. If the user didn't mean to change said field, then I have a Undo function. This works fine, but I want the cursor to reselect the initial field. I cannot seem to get this to work. Additionally, I...

I am trying to create a summary page that would summarize multiple pieces of information from a report. The report is usually quite long, so a summary would be beneficial to my users. I have the basic summaries of # of records run, # of records that meet "x" criteria, and so on. My...

I have a main form and subform joined by a field called Category. When I open the form, the Category field (which is an unbound text box) is empty, but the subform (in datasheet view) is populated with records from the previous use. I want to be able to open the form and not have the subform...

I have a report that will show information grouped by 2 fields: ID, Test# So the grouping will be: ID Test# Category, BuildID, Status, Notes I have two primary summaries that list in each group footer - number of records per Test# and number of records per ID (including % of total...

Is there a way that I can automatically generate an ID when "Add New" button is clicked? The twist for this problem is that there are multiple categories and the abbreviation for each category is part of the ID. Example Current record: Category: MAINT (this is a combo box which...

I have a button on a form that allows users to print it. As we have multiple printers and each user may have different printing needs, I coded the button to bring up the Print dialog box. It works fine except when someone clicks Cancel in the dialog box. Access says that there is a Run-Time...

I have a main form that has one field which looks up data in a subform. The data in the subform will be accessed by users that will either want to enter a new record (in the subform) or replicated the record's date (also in the subform). How do I do this? Here was the code I am working...

I am trying to figure out the best way to show two pieces of interrelated data in a table. Currently, I have one field that holds a Description and a Abbreviation - i.e. "Firewall - FW". Unfortunately, this is causing me problems with some of my work in forms and reports. What I...